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 IC65913 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 / 950 - 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:                                              * 
* DB2 UDB Version 9.5.                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error description field for more information.            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.5 FixPack 6.                            * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
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

Lösung
Problem was first fixed in DB2 UDB Version 9.5 FixPack 6.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC66482 IC66483 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
28.01.2010
10.09.2010
10.09.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP6
Problem behoben lt. FixList in der Version