IBM Support

IC73625: DB2 LOAD COMMAND MAY RECEIVE SQL2044N ERROR WITH RC=1 ON WINDOWS SERVER

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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:
    

Local fix

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.                       *
    ****************************************************************
    

Problem conclusion

  • The fix will be included in db2 version 9.7 fix pack 4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC73625

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-01-04

  • Closed date

    2011-05-09

  • Last modified date

    2011-05-09

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC73625

Modified date: 09 May 2011