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 IC66483 Status: Geschlossen

ATTEMPTS BY ZOS CLIENT TO CONNECT TO DB2 LUW V9.5 SERVER RANDOMLY FAIL WITH
SQLCODE:-30020, REASON CODE:124C

Produkt:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problembeschreibung:
When a multi-threaded DB2 for z/OS application attempts to 
connect to a DB2 LUW V9.5 server, not all threads connect 
successfully. Some threads get the error sqlcode -30020 with 
reason code 124C. 
 
Below messages are written at the db2diag.log file. 
------ 
2010-01-07-10.36.31.726000+540 E1583909H718       LEVEL: Error 
PID     : 1976                 TID  : 3360        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000 
APPHDL  : 0-60240              APPID: 
JPINKA01.FDS43.C55A0ED92D36 
EDUID   : 3360                 EDUNAME: db2agent () 
FUNCTION: DB2 UDB, DRDA Application Server, sqljsParseConnect, 
probe:10 
MESSAGE : DIA5000C A DRDA AS token "RECOVERABLE" was detected. 
The 
diagnostic 
          data returned is (SRVDGN): "FUNCTION ID = 0183 , PROBE 
POINT = 0010 , 
          TRACE POINT = 0010 , SUBCODE1 = 804B008A, SUBCODE2 = 
00001055, 
          SUBCODE3 = 00000009, ERROR MSG = AGENT: DDM command 
not valid until 
          RDB is accessed". 
. 
2010-01-07-10.36.31.757000+540 I1584629H612       LEVEL: Error 
PID     : 1976                 TID  : 3360        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000 
APPHDL  : 0-60240              APPID: 
JPINKA01.FDS43.C55A0ED92D36 
EDUID   : 3360                 EDUNAME: db2agent () 
FUNCTION: DB2 UDB, DRDA Application Server, sqljsParseConnect, 
probe:10 
MESSAGE : ZRC=0x804B008A=-2142568310=SQLJS_INVRQST 
          "INVALID SQL REQUEST FOR CURRENT STATE" 
DATA #1 : DDM Object, PD_TYPE_DDM_OBJECT, 12 bytes 
 
   data length : 5 
   codepoint   : 0x1055 ( SYNCCTL ) 
   length      : 9 ( COMPLETE ) 
-----
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.8 FP3 or Subsequent Fix Pack                * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux

Lösung
Problem First Fixed in DB2 Version 9.8 Fix Pack 3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
18.02.2010
10.12.2012
10.12.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.8.FP3
Problem behoben lt. FixList in der Version
9.8.0.3 FixList