DB2 - Problembeschreibung
Problem IC97147 | Status: Geschlossen |
DB2CLI VALIDATE -DSN DATABASE RETURNED "MESSAGE : NO CHARACTER DATA IS ALLOWED BY CONTENT MODEL" | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
db2cli validate -dsn sample returned as below. Message : No character data is allowed by content model Use the following driver cfg. Based on http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2 .luw.apdv.cli.doc/doc/c0056272.html Omitted comment. <configuration> <dsncollection> <dsn alias="SAMPLE" name="SAMPLE" host="v33ec065.svl.ibm.com" port="446"/> </dsncollection> <databases> <database name="SAMPLE" host="v33ec065.svl.ibm.com" port="446"> <acr> <parameter name="enableAcr" value="true"/> <parameter name="maxAcrRetries" value="1"/> <parameter name="acrRetryInterval" value="2"/> <alternateserverlist> <server name="server1" hostname="v33ec067.svl.ibm.com" port="446"> </server> <server name="server2" hostname="v33ec066.svl.ibm.com" port="446"> </server> <server name="server3" hostname="v33ec065.svl.ibm.com" port="446"> </server> </alternateserverlist> <affinitylist> <list name="list1" serverorder="server1,server2,server3"> </list> <list name="list2" serverorder="server3,server2,server1"> </list> </affinitylist> <clientaffinitydefined> <client name="client1" hostname="appsrv1.svl.ibm.com" listname="list2"> </client> <client name="client2" hostname="appsrv2.svl.ibm.com" listname="list1"> </client> </clientaffinitydefined> <clientaffinityroundrobin> <client name="client3" hostname="appsrv3.svl.ibm.com"> </client> <client name="client4" hostname="appsrv4.svl.ibm.com"> </client> </clientaffinityroundrobin> </acr> </database> </databases> </configuration> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade DB2 UDB to version 10.1 fixpack 4. * **************************************************************** | |
Local-Fix: | |
Modify list of affinity tab as below. <list name="list1" serverorder="server1,server2,server3" /> <list name="list2" serverorder="server3,server2,server1" /> | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 UDB Version 10.1 FixPack 4. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC97246 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.10.2013 30.06.2014 30.06.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.4 |