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