PH25949: ABEND04E 00C90105 AT DSNIASFP 0CA4 DURING INSERT WORKLOADS USING INSERT ALGORITHM 2 - IAG2

Obtain the fix for this APAR.

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 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.