Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 10.1 Fix Pack 6 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 FixList