Latest versionsfixlist
11.1.0.6 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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.