|
Problem IC97246
|
Status: Closed |
DB2CLI VALIDATE -DSN DATABASE RETURNED "MESSAGE : NO CHARACTER DATA IS ALLOWED BY CONTENT MODEL" |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* All DB2 CLI users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to v10.5.3 and later *
**************************************************************** |
| Local Fix: |
Modify list of affinity tab as below.
<list name="list1"
serverorder="server1,server2,server3" />
<list name="list2"
serverorder="server3,server2,server1" /> |
| available fix packs: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Fixed in v10.5.3 and later |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.10.2013
09.09.2014
09.09.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
