|
Problem IC73538
|
Status: Closed |
THE -332 ERROR CAUSES MANY MESSAGES IN DB2DIAG.LOG AND GENERATES MANY DUMP FILES |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| 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 |
| Problem Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
The fix will be included in DB2 V9.5 fix pack 8 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.12.2010
30.06.2011
30.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
