IBM Support

PM68478: ABEND 04E 00E20002 AT DSNXOCU DSNSVSVB OFFSET 06CC BECAUSE CAT OVERLAY

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ==Dump title
    DB2DUMP.PM06818.FTPAUTO.D120629.T025424
    "DBL1,ABND=04E-00E20002,U=V4498BI ,M=(N),C=910.RDS
     -SQL     ,DISTRBUTED,LOC=DSNXOCU .DSNSVSVB+06CC"
    
    
     abend of 00E20002 occurred in routine of "Check input
    parameters." ,and for the block address of  x'49_429DB800'
    
    In both dumps, RDS control block CAT's BLKSIZE in SM block
    prefix was overlaid.  overlaid block BLKPSIZE=x'00000001' should
    be x'00000D10'
    
    DB2DUMP.PM06818.FTPAUTO.D120629.T025424
    
    _29DB7E8                         FFFFF908   00000001   |
    ..9..... |
    _29DB7F0   00000000   2665CA47   777B0048   00000000   |
    .........#...... |
    _29DB800   20200000   00000D08   C3C1E340   00010000   |
    ........CAT .... |
    _29DB810   00000010   00000000   00160000   46160000   |
    ................ |
    _29DB820   00000000   01C60001   00000000   00000000   |
    .....F.......... |
    _29DB830   00280900   01000000   00000000   599A6F0A   |
    ..............?. |
    _29DB840   00000000   599A6EE0   00E20000   00000000   |
    ......>..S...... |
    _29DB850.:49_429DB86F. LENGTH(X'20')--All bytes contain X'00'
    
    _29DC500   00000000   00000000   03030303   637115A9   |
    ...............z |
    _29DC510   00000D10   00000FC8   00000000   2558B1A7   |
    .......H.......x |
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 for z/OS who have queries   *
    *                 that have a LIKE, range, or BETWEEN          *
    *                 predicate containing a column expression,    *
    *                 where the column in the column expression    *
    *                 is from a table with a partitioning index    *
    ****************************************************************
    * PROBLEM DESCRIPTION: A query that has a LIKE, range, or      *
    *                      BETWEEN predicate containing a column   *
    *                      expression--where the column in the     *
    *                      column expression is from a table with  *
    *                      a partitioning index--can cause an      *
    *                      abend ABEND04E RC00E20002 at            *
    *                      DSNXOCU.DSNSVSVB+06CC                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    A query that has a LIKE, range, or BETWEEN predicate containing
    a column expression--where the column in the column expression
    is from a table with a partitioning index--can cause an abend
    ABEND04E RC00E20002 at DSNXOCU.DSNSVSVB+06CC.
    
    For example,
    SELECT ...
    FROM T1 ...
    WHERE UPPER ( T1.COL1 ) LIKE 'A%' AND ...
    T1 has a partitioning index on it.
    
    Such a predicate can cause a zero to be used as an index
    into the CAT array, resulting in two bytes of storage at '1A'x
    before the 'CAT' eyecatcher to be overlaid.  This overlaid
    storage is referenced later, resulting in the abend.
    
    Additional Keywords:
    SQLLIKE SQLRANGE SQLBETWEEN SQLSTORAGE DB2OVRLAY/K
    

Problem conclusion

  • Code is updated to avoid indexing into the array mentioned
    above with a zero.
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM68478

  • 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

    2012-07-10

  • Closed date

    2012-08-21

  • Last modified date

    2012-10-01

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

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

    UK81223 UK81224

Modules/Macros

  • DSNXOPRS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK81223

       UP12/09/05 P F209

  • R910 PSY UK81224

       UP12/09/05 P F209

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:
01 October 2012