IBM Support

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

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

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

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to fp9 or above                                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in v9.7fp9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC93975

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-08

  • Closed date

    2013-12-23

  • Last modified date

    2013-12-23

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

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

    IC94088 IC95461

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC93975

Modified date: 23 December 2013