PI93390: ABEND04E RC00C90101 DSNKUNR2 ERQUAL5063 DURING COPY WITH FLASHCOPY CONSISTENT AND OTHER FLASHCOPY ISSUES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This apar addresses 4 symptom scenarios with copy 'flashcopy
  consistent' :
  1.
  An abend04e rc00c90101 in dsnkunr2 erqual5063 occurred while
  running 'COPY LIST LDGIRFC FCCOPYDDN(CPYCPYFC) SHRLEVEL CHANGE
  FLASHCOPY CONSISTENT FULL YES'
                                                                 .
  Abend title:
  DSN ,ABND=04E-00C90101,U=uuuuuuuu ,M=N  ,C=111.DMC
   -DSNKUNR2,M=DSNTFRCV,LOC=DSNIDM  .DSNKUNR2:5063
                                                                 .
  Messages from the flashcopy portion of the utility joblog
  indicate rc00c9001c, abend during log apply of recover.
  DSNU017I    ..  DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY
                  EXECUTION ABENDED,
                  REASON=X'00E40106' CAUSE=X'00C9001C'
                                                                 .
  2.
  The consistency processing in the LOGAPPLY phase for COPY
  FLASHCOPY CONSISTENT takes a very long time when the objects
  being FlashCopy'ed have many partitions and very many
  SYSIBM.SYSLGRNX records.
                                                                 .
  3.
    COPY with FLASHCOPY CONSISTENT failed with ABEND04E RC00C9007F
  RC00C20040 RC00E4010A in DSNUCALZ when processing a non
  partitioned table space during consistency processing in the
  LOGAPPLY phase.  Earlier, the table space had been ALTERed with
  the COMPRESS YES attribute and a dictionary had been built by
  compression on insert.  During the COPY utility, the open of the
  first piece failed when it tried to access the dictionary pages
  residing in the second piece, which had not been opened yet.
                                                                 .
  4.
   COPY with FLASHCOPY CONSISTENT failed with ABEND04E RC00C200F7
  in DSNB1GET+1C7C during LOGAPPLY phase for a multi-piece 4G NPI
  when attempting to apply logs to the second data set. Db2 MSTR
  showed message:
  
  DSNB226I  DSNB1GET - BUFFER MANAGER PAGE GET ROUTINE DETECTED
  AN INVALID PAGE IN
  DBNAME=dbname
  SPACENAME=spacename
  INSTANCE=i
  DATA SET NUMBER=2
  PAGE NUMBER EXPECTED=X'nnnnnnnn'
  PAGE NUMBER FOUND=X'mmmmmmmm'
  
  where the expected page is x'100' more than the page found.
  
  DSNB1GET OFFSET1C7C
  MSGDSNB226I
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 11 for z/OS and Db2 12 for z/OS      *
  *                 users of the COPY utility with FLASHCOPY     *
  *                 CONSISTENT on multi-piece non-partitioned    *
  *                 table spaces and/or NPI index spaces, and    *
  *                 objects with many partitions and             *
  *                 SYSIBM.SYSLGRNX records.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00C90101 in csect DSNKUNR2   *
  *                      during the COPY utility with FLASHCOPY  *
  *                      CONSISTENT on a multi-piece             *
  *                      nonpartitioned index(NPI).              *
  *                      Other symptoms can include:             *
  *                      - Excessive time to FlashCopy objects   *
  *                        with many partitions and many         *
  *                        SYSLGRNX records                      *
  *                      - ABEND04E RC00C9007F RC00C20040        *
  *                        RC00E4010A in csect DSNUCALZ during   *
  *                        the COPY utility with FLASHCOPY       *
  *                        CONSISTENT on a nonpartitioned        *
  *                        table space.                          *
  *                      - ABEND04E RC00C9007F in csect          *
  *                        DSNB1GET during the COPY utility      *
  *                        with FLASHCOPY CONSISTENT on a        *
  *                        multi-piece NPI index space           *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  ABEND04E RC00C90101 was received for COPY utility with
  SHRLEVEL CHANGE DSNUM ALL FLASHCOPY CONSISTENT FULL YES against
  NPI index spaces. This issue occurs when NPI index spaces have
  multiple pieces.
  
  The following problems may occur running COPY utility with
  FLASHCOPY CONSISTENT:
  - ABEND04E RC00C9007F RC00C20040 RC00E4010A in DSNUCALZ running
    COPY on a nonpartitioned table space
  - ABEND04E RC00C9007F in DSNB1GET running COPY on a multi-piece
    NPI index space
  - Excessive time running COPY on objects with many partitions
    and many SYSIBM.SYSLGRNX records.
  These problems occurred because the FlashCopy utility driver
  invoked consistency processing for table spaces and index
  spaces at the partition or piece level even if DSNUM ALL was
  specified. This is not efficient for objects with a large number
  of partitions or pieces.  In addition, for NPIs the consistency
  processing is not supported at the piece level.
  

Problem conclusion

• Code in the COPY utility for FLASHCOPY CONSISTENT with
  DSNUM ALL has been modified to correctly copy multi-piece
  nonpartitioned table spaces, NPI index spaces and objects
  with many partitions and SYSLGRNX records at space level.
  

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:

  UI56284 UI56285

Modules/Macros

•    DSNUCALC DSNUCALZ DSNUCBLA DSNUGUCA DSNUGUTC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI56285

     UP18/06/20 P F806 Ž

• RC10 PSY UI56284

     UP18/06/20 P F806 Ž

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.