IBM Support

IC91029: DIA5000C "INVALID DDM REQUEST" AND SYNTAX ERROR REPORTED WHEN DB2 FOR ZOS ATTEMPTS TO SWITCH ID ON A TRUSTED CONNECTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 for zOS reports an error like this:
    
    STC29848  DSNL031I  -DBT3 DSNLZDJN DRDA EXCEPTION CONDITION IN
    990
              RESPONSE FROM SERVER LOCATION=NRDAIRD4 FOR THREAD WITH
    
              LUWID=WZYZ.ABCDEF.AB0712341234=0
              REASON=00D351FF
              ERROR ID=DSNLZRPA0001
              CORRELATION ID=USERIDA
              CONNECTION ID=TSO
              IFCID=0191
              SEE TRACE RECORD WITH IFCID SEQUENCE NUMBER=00000001
    
    While messages similar to these are written to the db2diag.log:
    
    2013-03-08-10.31.36.035000-360 E22635645F759      LEVEL: Error
    PID     : 5756                 TID  : 140         PROC :
    db2syscs.exe
    INSTANCE: DB2INST1              NODE : 000         DB   : SAMPLE
    APPHDL  : 0-62679              APPID: WXYZ.ABCDEF
    AUTHID  : TRUSTUSER
    EDUID   : 140                  EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, DRDA Application Server,
    sqljsParseRdbAccessed, probe:8
    MESSAGE : DIA5000C A DRDA AS token "RECOVERABLE" was detected.
    The diagnostic
              data returned is (SRVDGN): "FUNCTION ID = 0185 , PROBE
    POINT = 0008 ,
              TRACE POINT = 0010 , SUBCODE1 = FFFFFFFF804B008D,
    SUBCODE2 =
              0000000000002001, SUBCODE3 = 00000000000000F4, ERROR
    MSG = AGENT:
              Invalid DDM Request".
    
    2013-03-08-10.31.36.035000-360 I22636406F620      LEVEL: Error
    PID     : 5756                 TID  : 140         PROC :
    db2syscs.exe
    INSTANCE: DB2INST14              NODE : 000         DB   :
    SAMPLE
    APPHDL  : 0-62679              APPID: WXYZ.ABCDEF
    AUTHID  : TRUSTUSER
    EDUID   : 140                  EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, DRDA Application Server,
    sqljsParseRdbAccessed, probe:10
    MESSAGE : ZRC=0x804B008D=-2142568307=SQLJS_SYNTAX "SYNTAX ERROR"
    
    DATA #1 : DDM Object, PD_TYPE_DDM_OBJECT, 16 bytes
    
                    data length : 240
                    codepoint   : 0x2001 ( ACCRDB )
                    length      : 244 ( COMPLETE ) P
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 for zOS users establishing a Trusted Connection to DB2   *
    * for LUW                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.7 FP9                                       *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in DB2 9.7 FP9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC91029

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-21

  • Closed date

    2013-12-16

  • Last modified date

    2013-12-16

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

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

    IC91805 IC95227

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 December 2013