Home

Neueste Versionen	FixList
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren
Kontaktformular

DB2 - Problembeschreibung

Problem IC73538	Status: Geschlossen
THE -332 ERROR CAUSES MANY MESSAGES IN DB2DIAG.LOG AND GENERATES MANY DUMP FILES
Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
When customer's client codepage did not match the target database codepage, customer would receive -332 error. It causes DB2 generating a lot of dump file information in db2diag.log and dump files under db2dump folder. The similar db2diag.log entries will look like the followings: 2010-11-25-14.52.46.775357+480 I21470A624 LEVEL: Severe PID : 13986 TID : 30 PROC : db2sysc 0 INSTANCE: inst1 NODE : 000 DB : SAMPLE APPHDL : 0-9 APPID: LOCAL.inst1.101125065246 AUTHID : inst1 EDUID : 30 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, base sys utilities, sqeApplication::SetupCodePageInfo, probe:200 RETCODE : ZRC=0x800F005B=-2146500517=SQLO_NOTABLE "No conversion table exists" DIA8102C Conversion table not loaded. Source code page "", Target code page "", method "", handle "". 2010-11-25-14.52.46.775582+480 I22095A525 LEVEL: Warning PID : 13986 TID : 30 PROC : db2sysc 0 INSTANCE: inst1 NODE : 000 DB : SAMPLE APPHDL : 0-9 APPID: LOCAL.inst1.101125065246 AUTHID : inst1 EDUID : 30 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, base sys utilities, sqeApplication::SetupCodePageInfo, probe:200 MESSAGE : Conversion table not available. Source code page = 1051, Target code page = 1114 2010-11-25-14.52.46.821548+480 I24405A488 LEVEL: Error PID : 13986 TID : 30 PROC : db2sysc 0 INSTANCE: inst1 NODE : 000 DB : SAMPLE APPHDL : 0-9 APPID: LOCAL.inst1.101125065246 AUTHID : DB2ISPM EDUID : 30 EDUNAME: db2agent (idle) 0 FUNCTION: DB2 UDB, DRDA Application Server, sqljsPostProcessingConnectAttach, probe:150 MESSAGE : ZRC=0x804B0095=-2142568299=SQLJS_VALNSP "VALUE ERROR" 2010-11-25-14.52.46.821660+480 I24894A177 LEVEL: Error PID:13986 TID:30 NODE:000 Title: * DRDA ASCB Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin 2010-11-25-14.52.46.822019+480 I25072A182 LEVEL: Error PID:13986 TID:30 NODE:000 Title: DRDA CMNMGR CB Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin 2010-11-25-14.52.46.822109+480 I25255A179 LEVEL: Error PID:13986 TID:30 NODE:000 Title: DSS SEGMENT Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin 2010-11-25-14.52.46.822254+480 I25435A182 LEVEL: Error PID:13986 TID:30 NODE:000 Title: RECEIVE BUFFER Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin 2010-11-25-14.52.46.822368+480 I25618A180 LEVEL: Error PID:13986 TID:30 NODE:000 Title: SEND BUFFERS Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin 2010-11-25-14.52.46.822454+480 I25799A185 LEVEL: Error PID:13986 TID:30 NODE:000 Title: CONNECTION HANDLE Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin 2010-11-25-14.52.46.822571+480 I25985A183 LEVEL: Error PID:13986 TID:30 NODE:000 Title: DRDA ATTRIBUTES Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin 2010-11-25-14.52.46.822659+480 I26169A182 LEVEL: Error PID:13986 TID:30 NODE:000 Title: AS UCINTERFACE ** Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin
Problem-Zusammenfassung:
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * When customer's client codepage did not match the target * * database codepage, customer would receive -332 error. It * * causes DB2 generating a lot of dump file information in * * db2diag.log and dump files under db2dump folder. * * * * * * * * The similar db2diag.log entries will look like the * * followings: * * * * * * 2010-11-25-14.52.46.775357+480 I21470A624 LEVEL: * * Severe * * PID : 13986 TID : 30 PROC : * * db2sysc * * 0 * * * * INSTANCE: inst1 NODE : 000 DB : * * SAMPLE * * APPHDL : 0-9 APPID: * * * * LOCAL.inst1.101125065246 * * * AUTHID : inst1 * * EDUID : 30 EDUNAME: db2agent (SAMPLE) 0 * * * * FUNCTION: DB2 UDB, base sys utilities, * * * * sqeApplication::SetupCodePageInfo, probe:200 * * * * RETCODE : ZRC=0x800F005B=-2146500517=SQLO_NOTABLE "No * * conversion * * table exists" * * * * DIA8102C Conversion table not loaded. Source code * * page * * "", Target * * * * code page "", method "", handle "". * * * * * * * * 2010-11-25-14.52.46.775582+480 I22095A525 LEVEL: * * Warning * * PID : 13986 TID : 30 PROC : * * db2sysc * * 0 * * * * INSTANCE: inst1 NODE : 000 DB : SAMPLE * * APPHDL : 0-9 APPID: * * * * LOCAL.inst1.101125065246 * * * AUTHID : inst1 * * EDUID : 30 EDUNAME: db2agent (SAMPLE) 0 * * * * FUNCTION: DB2 UDB, base sys utilities, * * * * sqeApplication::SetupCodePageInfo, probe:200 * * * * MESSAGE : Conversion table not available. Source code page = * * * * 1051, Target code * * * * page = 1114 * * * * * * * * 2010-11-25-14.52.46.821548+480 I24405A488 LEVEL: * * Error * * PID : 13986 TID : 30 PROC : * * db2sysc * * 0 * * * * INSTANCE: inst1 NODE : 000 DB : * * SAMPLE * * APPHDL : 0-9 APPID: * * * * LOCAL.inst1.101125065246 * * * AUTHID : DB2ISPM * * * * EDUID : 30 EDUNAME: db2agent (idle) 0 * * * * FUNCTION: DB2 UDB, DRDA Application Server, * * * * sqljsPostProcessingConnectAttach, probe:150 * * * * MESSAGE : ZRC=0x804B0095=-2142568299=SQLJS_VALNSP "VALUE * * ERROR" * * * * * * 2010-11-25-14.52.46.821660+480 I24894A177 LEVEL: * * Error * * PID:13986 TID:30 NODE:000 Title: ** DRDA ASCB ** * * * * Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin * * * * * * * * 2010-11-25-14.52.46.822019+480 I25072A182 LEVEL: * * Error * * PID:13986 TID:30 NODE:000 Title: ** DRDA CMNMGR CB ** * * * * Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin * * * * * * * * 2010-11-25-14.52.46.822109+480 I25255A179 LEVEL: * * Error * * PID:13986 TID:30 NODE:000 Title: ** DSS SEGMENT ** * * * * Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin * * * * * * * * 2010-11-25-14.52.46.822254+480 I25435A182 LEVEL: * * Error * * PID:13986 TID:30 NODE:000 Title: ** RECEIVE BUFFER ** * * * * Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin * * * * * * * * 2010-11-25-14.52.46.822368+480 I25618A180 LEVEL: * * Error * * PID:13986 TID:30 NODE:000 Title: ** SEND BUFFERS ** * * * * Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin * * * * * * * * 2010-11-25-14.52.46.822454+480 I25799A185 LEVEL: * * Error * * PID:13986 TID:30 NODE:000 Title: ** CONNECTION HANDLE ** * * * * Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin * * * * * * * * 2010-11-25-14.52.46.822571+480 I25985A183 LEVEL: * * Error * * PID:13986 TID:30 NODE:000 Title: ** DRDA ATTRIBUTES ** * * * * Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin * * * * * * * * 2010-11-25-14.52.46.822659+480 I26169A182 LEVEL: * * Error * * PID:13986 TID:30 NODE:000 Title: ** AS UCINTERFACE ** * * * * Dump File:/home/inst1/sqllib/db2dump/13986.30.000.dump.bin * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V9.5 Fix pack 8 * ****************************************************************
Local-Fix:

verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
Lösung
The fix will be included in DB2 V9.5 fix pack 8
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung:	27.12.2010 30.06.2011 30.06.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP8
Problem behoben lt. FixList in der Version
9.5.0.8