IBM Support

PM05218: ABND04E RC00C90101 DSNIZMOS 5002 ERQUAL5002 DURING BIND WITH UK53070 (V8) / UK53071 (v9) APPLIED 10/01/15 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • During abend, DB2 was trying to insert a record into a catalog
    table SYSIBM.SYSTABAUTH. According to the DDL of SYSTABAUTH,
    the first column is VARCHAR (128), the length is x'80'. But the
    length trying to move is x'400', thus DB2 abend.
    Additional Symptoms:
    ABEND0C4-00000004 DSNXAANC + 1C9A
    

Local fix

  • remove UK53070
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users that have applied PK92315.             *
    ****************************************************************
    * PROBLEM DESCRIPTION: V8:                                     *
    *                      - ABEND04E RC00C90101 at DSNIZMOS:5002  *
    *                      - ABEND04E RC00E50001 at DSNSVSGM+0334  *
    *                      - ABEND04E RC00E70005 at DSNXAAPC:P120  *
    *                      - ABEND0C4 RC00000004 at DSNSVSTK+05D8  *
    *                      - ABEND0C4 RC00000004 at DSNXAAPC+1D96  *
    *                      V9:                                     *
    *                      - ABEND04E RC00C90101 at DSNIBNRF:5002  *
    *                      - ABEND04E RC00E70005 at DSNXAAPC:P120  *
    *                      - ABEND0C4 RC00000004 at DSNXASPC+090C  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    With PK92315 (UK53070 V8, UK53071 V9) applied, during an
    authorization check an abend occurred with dump titles like the
    following:
    
    V8:
    
    XXXX,ABND=04E-00C90101,U=YYYYYYY ,M=(N),
       C=810.DMC -DSNIISRT,M=DSNTFRCV, LOC=DSNIDM  .DSNIZMOS:5002
    
    XXXX,ABND=04E-00E50001,U=YYYYYYYY,M=(N),C=810.LOCN=ZZZZZZZZZZZ
    ,LOC=DSNSLD4 .DSNSVSGM+0334
    
    XXXX,ABND=04E-00E70005,U=YYYYYYYY,M=(N),C=810.LOCN=ZZZZZZZZZZZ
    ,LOC=DSNXAUTH.DSNXAAPC:P120
    
    XXXX,ABND=0C4-00000004,U=YYYYYY  ,M=(N),C=810.SCC
    -SHUTDOWN,M=DSNTFRCV,LOC=DSNSLD1 .DSNSVSTK+05D8
    
    
    XXXX,ABND=0C4-00000004,U=YYYYYYY ,M=(N),C=810.RDS -SQL
    ,M=DSNTFRCV,LOC=DSNXAUTH.DSNXAAPC+1D96
    
    V9:
    
    XXXX,ABND=04E-00C90101,U=YYYYYY  ,M=(N),C=910.DMC
     -DSNIISRT,M=DSNTFRCV,LOC=DSNIDM  .DSNIBNRF:5002
    
    XXXX,ABND=04E-00E70005,U=YYYYYY  ,M=(N),C=910.RDS -SQL     ,M=DS
    NTFRCV,LOC=DSNXAUTH.DSNXAAPC:P120
    
    XXXX,ABND=0C4-00000010,U=YYYYYB  ,M=(N),C=910.LOCN=ZZZZZZZZZZ
    ,LOC=DSNXAUTH.DSNXASPC+090C
    
    The V9, 0C4 at DSNXASPC+090C occurred because the authid type
    (user or role) was not included in the building of the package
    and routine authorization caches. This resulted in an overlay of
    the next cache entry.
    
    The rest of the abends are related to the use of an invalid
    length for a varchar field. It is invalid because it was not
    initialized on entry to the module.
    

Problem conclusion

  • Code has been changed to initialize the length field and to
    include the authid type in the V9 package and routine
    authorization cache builds.
    
    If you are using an external security system other than RACF
    (DSNXRXAC) to perform authorization on DB2 resources using the
    access control authorization exit (DSNX@XAC), contact its vendor
    to ensure it uses this exit's interface as documented in the DB2
    Administration Guide.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM05218

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-01-15

  • Closed date

    2010-04-08

  • Last modified date

    2010-10-12

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

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

    UK55934 UK55936

Modules/Macros

  •    DSNXAANC DSNXAAPC DSNXAPAC DSNXA02  DSNXINIT
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R810 PSY UK55934

       UP10/04/24 P F004

  • R910 PSY UK55936

       UP10/04/24 P F004

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.



Document information

More support for: DB2 for z/OS

Software version: 8.0

Reference #: PM05218

Modified date: 12 October 2010


Translate this page: