|
Problem IC73625
|
Status: Closed |
DB2 LOAD COMMAND MAY RECEIVE SQL2044N ERROR WITH RC=1 ON WINDOWS SERVER |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
In some instances, LOAD process may create duplicate message
queues during the table scan stage but for Windows server, it
prohibit creating duplicate queues, causing the LOAD to fail
with SQL2044N. This apar only applies to DB2 v97fp3 and v97fp3a.
Similar db2diag.log entries will be like the followings:
2010-11-19-12.15.49.059000+480 I5594423F562 LEVEL: Error
PID : 4548 TID : 2712 PROC : db2syscs.exe
INSTANCE: INST1 NODE : 000 DB : DB2DB
APPHDL : 0-22048 APPID: *LOCAL.DB2PINST.101119041446
AUTHID : DB2AUT
EDUID : 2712 EDUNAME: db2agent (DB2DB) 0
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 121 bytes
LOADID: 2712.2010-11-19-12.15.47.996001.0 (9;11)
, -2029060035, 0000000000000000, Detected in file:sqluvld.C,
Line:10512
2010-11-19-12.15.49.059000+480 I5594987F1036 LEVEL: Error
PID : 4548 TID : 2712 PROC : db2syscs.exe
INSTANCE: INST1 NODE : 000 DB : DB2DB
APPHDL : 0-22048 APPID: *LOCAL.DB2PINST.101119041446
AUTHID : DB2AUT
EDUID : 2712 EDUNAME: db2agent (DB2DB) 0
FUNCTION: DB2 UDB, database utilities, sqlulInitOneEDU,
probe:10519
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 48 bytes
LOADID: 2712.2010-11-19-12.15.47.996001.0 (9;11)
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2044 sqlerrml: 1
sqlerrmc: 1
sqlerrp : SQLUVLD
sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Windows *
****************************************************************
* PROBLEM DESCRIPTION: *
* In some instances, LOAD process may create duplicate message *
* queues during the table scan stage but for Windows server, *
* it prohibit creating duplicate queues, causing the LOAD to *
* fail with SQL2044N. This apar only applies to DB2 v97fp3 and *
* v97fp3a. *
* *
* Similar db2diag.log entries will be like the followings: *
* *
* 2010-11-19-12.15.49.059000+480 I5594423F562 LEVEL: Error *
* PID : 4548 TID : 2712 PROC : db2syscs.exe *
* INSTANCE: INST1 NODE : 000 DB : DB2DB *
* APPHDL : 0-22048 APPID: *LOCAL.DB2PINST.101119041446 *
* AUTHID : DB2AUT *
* EDUID : 2712 EDUNAME: db2agent (DB2DB) 0 *
* FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 *
* DATA #1 : String, 121 bytes *
* LOADID: 2712.2010-11-19-12.15.47.996001.0 (9;11) *
* , -2029060035, 0000000000000000, Detected in file:sqluvld.C, *
* Line:10512 *
* *
* 2010-11-19-12.15.49.059000+480 I5594987F1036 LEVEL: Error *
* PID : 4548 TID : 2712 PROC : db2syscs.exe *
* INSTANCE: INST1 NODE : 000 DB : DB2DB *
* APPHDL : 0-22048 APPID: *LOCAL.DB2PINST.101119041446 *
* AUTHID : DB2AUT *
* EDUID : 2712 EDUNAME: db2agent (DB2DB) 0 *
* FUNCTION: DB2 UDB, database utilities, sqlulInitOneEDU, *
* probe:10519 *
* MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT *
* "SQLCA has already been built" *
* DATA #1 : LOADID, PD_TYPE_LOADID, 48 bytes *
* LOADID: 2712.2010-11-19-12.15.47.996001.0 (9;11) *
* DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes *
* sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2044 sqlerrml: 1 *
* sqlerrmc: 1 *
* sqlerrp : SQLUVLD *
* sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000 *
* (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 *
* sqlwarn : (1) (2) (3) (4) (5) (6) *
* (7) (8) (9) (10) (11) *
* sqlstate: *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2 version 9.7 fix pack 4. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The fix will be included in db2 version 9.7 fix pack 4. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.01.2011
09.05.2011
09.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
