IBM Support

PK96048: DSNSLD4.DSNSVSVB+0886/DSNX9CCM.DSNSVSVB+06C WE ADD SANITY CHECK THE 0 LENGTH SP NAME IN RDS MODULES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During DB2 shutting down, SPCTs being freed. Below abends occur:
    .
     DSNSLD4.DSNSVSVB+0886
     DSNX9CCM.DSNSVSVB+06C
    .
    because SPCT_SPACHAINPTR being overlaied. Add sanity check the 0
    length name of SP(STORED PROCEDURE)
    additional key words:
    ABEND0C4 DSNSVSVB 0886 088E OFFSET0886 OFFSET088E
    DB2OVRLAY/K
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 v8 and v9 users that issue           *
    *                 a CALL statement with all blanks as          *
    *                 the procedure name.                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABND0C4 RC00000038 at DSNSVSVB could    *
    *                      occur during DB2 shutdown if a CALL     *
    *                      statement was previously issued with    *
    *                      all blanks as the procedure name.       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    If a CALL statement is issued with all blanks as the
    procedure name, DB2 incorrectly processes the name. This leads
    to an overlay that is mostly undetected during the statement.
    Later on during DB2 shutdown, DB2 is trying to clean up storage
    pointed by areas that have been overlaid and ABND0C4 RC00000038
    at DSNSVSVB could occur.
    

Problem conclusion

  • DB2 is modified to handle procedure name with all blanks
    correctly.
    
    Additional keywords: ABND0C4 RC00000038 IN DSNSVSVB DSNX9CCM
    SMCOVERLAY
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK96048

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-09-14

  • Closed date

    2010-01-19

  • Last modified date

    2011-02-15

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

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

    UK53678 UK53679

Modules/Macros

  • DSNXOSTP DSNX9CCM
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R810 PSY UK53678

       UP10/02/04 P F002

  • R910 PSY UK53679

       UP10/02/04 P F002

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 February 2011