A fix is available
APAR status
Closed as program error.
Error description
The customer's zparm SPRMRRF is DISABLE. There is a PBG tablespace which has RRF as the row format in the current partitions. During a SHRLEVEL REFERENCE REORG on the entire PBG, a new partition growed. The REORG completed without abend, but the newly grown partition contains mixed row format: - The header page says it is BRF. - SYSTABLEPART.Format says it is BRF. - The first row in each data page is in RRF, the rest rows are in BRF. Some days later, when a REORG run on this PBG, it abended with RC00C9010 on DSNIDM.DSNIRFNX 5362.
Local fix
Before running REORG on a PBG, modify the zparm SPRMRRF to match the row format in the current partitions, then change it back after REORG completes.
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 for z/OS users of REORG * * TABLESPACE utility. * **************************************************************** * PROBLEM DESCRIPTION: REORG TABLESPACE SHRLEVEL REFERENCE * * failed with ABEND04E RC00C90101 * * DSNIRFNX:5362 due to PBG growth. * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available. * **************************************************************** User has an existing partitioned by growth (PBG) table space with all partitions defined in Reordered Row Format (RRF). With the zParm RRF=DISABLE, a REORG TABLESPACE SHRLEVEL REFERENCE was run on this table space. During the RELOAD phase of REORG, a new PBG partition was created in mixed row format with the first row in Reordered Row Format (RRF) and the rest of the rows in Basic Row Format (BRF). A subsequent REORG TABLESPACE SHRLEVEL REFERENCE failed with ABEND04E RC00C90101 due to the inconsistent row format. A similar problem can occur with REORG SHRLEVEL CHANGE.
Problem conclusion
Code has been modified so that REORG TABLESPACE SHRLEVEL REFERENCE and CHANGE will keep newly created PBG partitions in RRF format when the output table space format is RRF, regardless of what the RRF zParm value is.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM68133
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
2012-07-03
Closed date
2012-08-28
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:
UK81346
Modules/Macros
DSNURLOG DSNURWIR
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK81346
UP12/09/12 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":"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:
01 October 2012