A fix is available
APAR status
Closed as program error.
Error description
During insert workload using Insert Algorithm 2(IAG2), ABEND04E RC00C90105 at DSNIASFP:0CA4 takes place as well as below messages for the header page of a PBG's (MEMBER CLUSTER&APPEND YES) 2nd partition: . DSNI011I -PL3 PAGE TEMPORARILY UNAVAILABLE 663 TYPE 00000302 NAME VAOR2001.OSMOTS32.X'00100000' MODNAME DSNIASFP ERQUAL 0CA4 DSNB212I -PL3 DSNB1CFC - RECOVER PAGE STARTING 664 DSNAME=EPSDBLP1.DSNDBC.VAOR2001.OSMOTS32.I0001.A002 PAGE NUMBER=X'00000000' DSNB215I -PL3 DSNB1CFC - ONLINE RECOVERY FOR AN 665 INCONSISTENT PAGE HAS BEEN COMPLETED FOR DSNAME=EPSDBLP1.DSNDBC.VAOR2001.OSMOTS32.I0001.A002 PAGE NUMBER=X'00000000' . DSN1PRNT shows the header page is fine. While DSNIASFP:0CA4 is where Db2 fails a sanity check for SPACE MAP(SMAP) page. Db2 incorrectly assume the header page is a SMAP page here. Additional Keyword: DB2IAG2/K
Local fix
BYPASS/CIRCUMVENTION: Disable the IAG2 function.
Problem summary
**************************************************************** * USERS AFFECTED: * * DB2 12 for z/OS users of Insert Algorithm * * 2 (IAG2) on Universal Table Space with * * Member Cluster defined. * **************************************************************** * PROBLEM DESCRIPTION: * * ABEND04E RC00C90105 AT DSNIASFP:0CA4 * * during insert workloads using Insert * * Algorithm 2 (IAG2). * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** When running insert workloads with Insert Algorithm 2(IAG2), it reached the end of the current partition and there was no more page to be added to the IAG2 page pipes. But this "partition full" information was ignored and a space map page was calculated with the number outside the current partition's boundary limit. This caused an abend in DNIASFP:0CA4.
Problem conclusion
Db2 code is modified to avoid calculating the wrong space map page number when the partition is full.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PH25949
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-06-01
Closed date
2020-12-11
Last modified date
2021-01-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI73092
Modules/Macros
DSNISFRO DSNICMT2 DSNISGSP DSNISEGD DSNIASFP DSNISFRC DSNISRTI DSNISFAS DSNISFPI DSNITCUS
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI73092
UP20/12/17 P F012 ¢
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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"12.0"}]
Document Information
Modified date:
05 January 2021