IBM Support

PI04942: 00C90218 DSNISGSC ERQUAL5001 ABEND AND INSERT PERFORMANCE DEGRADATION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer had a classic partitioned tablespace which contained
    550 million rows and it was converted over to UTS
    REORG was used to materialize the alter statement
    
    After the reorg, customer started to hit 00C90218 DSNISGSC 5001
    abend. They also noticed performance degradation for insert
    statement. Each insert statements are running significant
    getpage counts for spacemap pages.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 10 and 11 for z/OS users who performed   *
    *                 insert operations to segmented tablespaces   *
    *                 (including UTS type) with large volumns of   *
    *                 data on the table.                           *
    ****************************************************************
    * PROBLEM DESCRIPTION: Insert performance seriously suffered   *
    *                      which observed an average of 40K-60K    *
    *                      numbers of getpages per insert.         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When an object table contains larger quantity of data rows under
    a segmented table space (including a UTS table space), DB2
    mistakenly calculated a wrong segment number due to the use of
    smaller integer fields.  This wrong segment calculation would
    degrade the overall insert performance.
    

Problem conclusion

  • DB2 code is fixed to adopt long integer fields to calculate
    the segment number.
    
    Additional keywords: PERFM
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PI04942

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-10-29

  • Closed date

    2013-11-18

  • Last modified date

    2014-04-14

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

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

    UI12648 UI12649

Modules/Macros

  • DSNICMT2 DSNIDILS DSNIDLDS DSNIDLDU DSNIDLEO
    DSNIFOD  DSNILAST DSNILPG  DSNINXPG DSNINXTP DSNIPREP DSNIRELF
    DSNIRSET DSNISEGD DSNISEGF DSNISGNS DSNISGPI DSNISGRT DSNISGSC
    DSNISGSS DSNISGSU DSNISHPI DSNISNPG DSNISRID DSNISRTW DSNISUPI
    DSNITLPE DSNITNPG DSNIWLPG DSNIWNRF DSNIWSET DSNIWTTD DSNIZLDL
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

[{"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":"10.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":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
14 April 2014