home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC78701 Status: Geschlossen

LOAD JOB FAILS WITH ERROR MESSAGE SQL2044 RC=1 ON THE WINDOWS PLATFORM.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
The load job fails  with sql2044 rc=1 on the windows platform. 
You may see the following message in the db2diag.log file. 
 
 2011-03-13-10.52.25.312000-300 I29566014F1032     LEVEL: Error 
PID     : 5432                 TID  : 2444        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 001         DB   : SAMPLE 
APPHDL  : 0-6170               APPID: 
10.30.10.25.19462.110313154947 
AUTHID  : db2inst1 
EDUID   : 2444                 EDUNAME: db2lload 1 
FUNCTION: DB2 UDB, database utilities, sqluCreateMsgQueue, 
probe:15478 
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT 
          "SQLCA has already been built" 
DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes 
LOADID: 5968.2011-03-13-10.52.22.831000.0 (274;7) 
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) 
0x00000001 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
If the db2 trace is taken the SQLO_QUE_DUP token  will be dumped 
into the formatted trace file. 
sqloMLNique exit [rc = 0x870F003D = -2029060035 = SQLO_QUE_DUP]
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* all user running LOAD on Windows platforms                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The load job fails  with sql2044 rc=1 on the windows         * 
* platform.                                                    * 
* You may see the following message in the db2diag.log file.   * 
*                                                              * 
* 2011-03-13-10.52.25.312000-300 I29566014F1032    LEVEL:      * 
* Error                                                        * 
* PID    : 5432                TID  : 2444        PROC :       * 
* db2syscs.exe                                                 * 
* INSTANCE: DB2                  NODE : 001        DB  :       * 
* SAMPLE                                                       * 
* APPHDL  : 0-6170              APPID:                         * 
* 10.30.10.25.19462.110313154947                               * 
* AUTHID  : db2inst1                                           * 
* EDUID  : 2444                EDUNAME: db2lload 1             * 
* FUNCTION: DB2 UDB, database utilities, sqluCreateMsgQueue,   * 
* probe:15478                                                  * 
* MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT           * 
*           "SQLCA has already been built"                     * 
* DATA #1 : LOADID, PD_TYPE_LOADID, 49 bytes                   * 
* LOADID: 5968.2011-03-13-10.52.22.831000.0 (274;7)            * 
* 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)        * 
* 0x00000001                                                   * 
* sqlwarn : (1)      (2)      (3)      (4)        (5)      (6) * 
*                                                              * 
*           (7)      (8)      (9)      (10)        (11)        * 
* sqlstate:                                                    * 
*                                                              * 
* If the db2 trace is taken the SQLO_QUE_DUP token  will be    * 
* dumped                                                       * 
* into the formatted trace file.                               * 
* sqloMLNique exit [rc = 0x870F003D = -2029060035 =            * 
* SQLO_QUE_DUP]                                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 9                        * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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
Problem was first fixed in DB2 Version 9.5 Fix Pack 9
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC79973 IC84161 IC84186 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
15.09.2011
13.03.2012
13.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP9
Problem behoben lt. FixList in der Version
9.5.0.9 FixList