IBM Support

PM86225: ABEND0C4 FROM DSNTBAP DUE TO WRONG LENGTH IN THE SIBBGENERICL FIELD.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using the STEPLIB to include the V10 SDSNLOAD for the TSO
    BIND job with the V9 DB2 following abend occur.
    ABEND0C4 from DSNTBAP due to invalid SIBBGENERICL length field.
    Other ABEND0C4 from various modules are possible.
    DSNWVAPR DSNSVBK DSNSVSTK
    ABEND04E RC00E2000E from DSNSFBK
    .
    RCIBGENERIC_LEN length field was also incorrect causing more
    overlay.
    DB2OVRLAY/K
    

Local fix

  • Use the same release TSO with DB2 code.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 for z/OS executing a            *
    *                 REMOTE BIND/REBIND across different          *
    *                 subsystem versions.                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: THE PROBLEM THIS FIX ADDRESSES HAS THE  *
    *                      FOLLOWING REPORTED SYMPTOMS:            *
    *                                                              *
    *                          ABEND0C4 RC00000010                 *
    *                           CSECT DSNSVBK OFFSET0E16           *
    *                                                              *
    *                          also possible is                    *
    *                                                              *
    *                          Incorrect error messages when       *
    *                          using a new V10 function on a       *
    *                          previous version subsystem          *
    *                          like V9                             *
    *                                                              *
    *                      PROBLEM SCENARIO:                       *
    *                                                              *
    *                      The reported error occurred when        *
    *                      attempting a REMOTE BIND from a V10     *
    *                      subsystem to a V9 subsystem. An         *
    *                      overlay can occur causing the said      *
    *                      abend.                                  *
    *                                                              *
    *                      Additionally, an incorrect error        *
    *                      message can occur when using a new      *
    *                      V10 bind parameter with a previous      *
    *                      version subsystem.                      *
    *                      Here is an example:                     *
    *                                                              *
    *                      Binding from a V10 subsystem to a       *
    *                      V9 subsystem using the 'APCOMPARE'      *
    *                      parameter might give you an 'invalid    *
    *                      keyword' error instead of message       *
    *                      DSNT263I - csect-name bind-type FOR     *
    *                      object-type = object-name FAILED        *
    *                      BECAUSE THE bind-type DEPENDS ON        *
    *                      FUNCTIONS IN A LATER DB2 RELEASE        *
    *                      WITH MARK release-dependency-mark       *
    *                      OR HIGHER.                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    SUMMARY OF DB2 EVENTS:
    When executing the BIND from a V10 subsystem, DB2 used storage
    in a control block that was not a compatible size with the V9
    DB2 subsystem and subsequently overlaid other storage causing
    the abend.
    Additionally, DB2 could use the wrong message handler when
    a new bind parameter from V10 is passed to a subsystem on a
    previous DB2 release.
    

Problem conclusion

  • DB2 V9 is fixed so that the control block used for the
    BIND/REBIND is now a compatible size across subsystems.
    Also, in V10, the error messages have been changed to display
    the correct message when a new V10 bind parameter is used on
    a subsystem running a previous release of DB2.
    
    ADDITIONAL KEYWORDS:
    BIND REBIND SQLSTORAGE DB2COEXIST/K DB2OVRLAY/K DB2MIGV10/K
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PM86225

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-03

  • Closed date

    2013-05-20

  • Last modified date

    2013-07-15

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

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

    UK94460 UK94461

Modules/Macros

  • DSN@CP68 DSNECP00 DSNECP08 DSNECP10 DSNECP12 DSNECP13 DSNECP14
    DSNECP16 DSNECP17 DSNECP18 DSNECP19 DSNECP20 DSNECP21 DSNECP22
    DSNECP23 DSNECP24 DSNECP25 DSNECP26 DSNECP27 DSNECP28 DSNECP29
    DSNECP30 DSNECP31 DSNECP40 DSNECP41 DSNECP42 DSNECP44 DSNECP45
    DSNECP46 DSNECP47 DSNECP50 DSNECP51 DSNECP54 DSNECP55 DSNECP60
    DSNECP61 DSNECP62 DSNECP63 DSNECP66 DSNECP67 DSNECP68 DSNECP69
    DSNTBAP  DSNTBAP1 DSNTBAP2
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK94460

       UP13/06/05 P F306 ½

  • R910 PSY UK94461

       UP13/06/05 P F306 ½

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
15 July 2013