home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC93975 Status: Closed

CLIENT REROURE FAILS TO ZOS SERVER WITH ERRONEOUS MESSAGE "ENSURE APAR
PM24292 IS INSTALLED ON THAT SYSTEM."

product:
DB2 CONNECT / DB2CONNCT / 970 - DB2
Problem description:
Client reroute error can occur if gateway reconnects to recover 
from stale outbound connection. You can see following erroneous 
messages in the db2diag.log on the gateway: 
 
2013-04-24-11.41.04.020857-240 I85377A796         LEVEL: Error 
PID     : 10879056             TID  : 18763       PROC : db2sysc 
INSTANCE: ddcsenv              NODE : 000         DB   : LOCDB2E 
APPHDL  : 0-46095 
EDUID   : 18763                EDUNAME: db2agentg (LOCDB2E ) 
FUNCTION: DB2 UDB, DRDA Application Requester, 
sqljrParseMgrLvls, probe:489 
MESSAGE : Downlevel member cannot be used for transaction-level 
workload 
          balancing or automatic client reroute. If you are 
accessing a DB2 for 
          z/OS sysplex, ensure APAR PM24292 is installed on that 
system. 
DATA #1 : Hex integer, 2 bytes 
0x2407 
DATA #2 : String with size, 8 bytes 
DSN09015 
DATA #3 : unsigned integer, 2 bytes 
10 
DATA #4 : String with size, 21 bytes 
DSN09015............. 
DATA #5 : unsigned integer, 2 bytes 
8 
 
2013-04-24-11.41.04.021407-240 I86174A465         LEVEL: Warning 
PID     : 10879056             TID  : 18763       PROC : db2sysc 
INSTANCE: ddcsenv              NODE : 000         DB   : LOCDB2E 
APPHDL  : 0-46095 
EDUID   : 18763                EDUNAME: db2agentg (LOCDB2E ) 
FUNCTION: DB2 UDB, DRDA Application Requester, 
sqljrDrdaArShouldDoCR, probe:998 
MESSAGE : ZRC=0x8037006D=-2143879059=SQLJR_CABLT "CA BUILT" 
DATA #1 : String, 22 bytes 
Client Reroute failed. 
 
Client application might report SQL1224N.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to fp9 or above                                       * 
****************************************************************
Local Fix:
available fix packs:
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
First fixed in v9.7fp9
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC94088 IC95461 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.07.2013
23.12.2013
23.12.2013
Problem solved at the following versions (IBM BugInfos)
9.7.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.9 FixList
9.7.0.9 FixList