PH52110: REPLICATION PRODUCT COULD GET DSNIOPNP ERQUAL 500B ABEND AFTER REROG DROPS EMPTY PARTITION OF A PBG TABLESPACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 has PI81535 to address the scenario that a REORG of a PBG
  table space with a table with the DATA CAPTURE CHANGES attribute
  will not drop partitions to avoid DSNIOPNP ERQUAL500B abend.
  But user could alter DATA CAPTURE to NONE before REORG, and run
  REORG to drop the empty partitions intentionally and then alter
  DATA CAPTURE CHANGES again. After that, replication tool could
  hit DSNIOPNP ERQUAL500B ABEND04E when it tries to access old
  log records of partitions which have been dropped by REORG.
  

Local fix

• BYPASS/CIRCUMVENTION:
  stop the subscription prior to the REORG and then reinit the
  subscription after CDC is altered back on.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 and 13 for z/OS users of                          *
  * IFCID 306.                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * An Abend04E in DSNIOPNP ERQUAL500B                           *
  * could be issued because the IFCID 306                        *
  * thread tried to decompress a log                             *
  * record of a part that no longer                              *
  * exists.                                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  An Abend04E in DSNIOPNP ERQUAL500B could be issued because the
  IFCID 306 thread tried to decompress a log record of a part
  no longer exists.  For instance the thread tries to decompress
  a log record of part 2; but the PBG only contained 1 part at
  that time.
  Db2 has PI81535 to address the scenario that a REORG of a PBG
  table space with a table with the DATA CAPTURE CHANGES
  attribute will not drop partitions to avoid DSNIOPNP ERQUAL500B
  abend.  But a user could alter DATA CAPTURE to NONE before
  REORG, and run REORG to drop the empty partitions intentionally
  and then alter DATA CAPTURE CHANGES again. After that, the
  IFCID 306 could hit DSNIOPNP ERQUAL500B ABEND04E when it tries
  to access the partitions (containing the data in the log),
  which could have been dropped by REORG.
  Instead of abending, Db2 will now issue an error message
  with reason code 00C90064 which states that the decompression
  dictionary version is not valid.
  

Problem conclusion

• Db2 has been modified to issue an error message with reason
  code instead of abending.
  Additional Keywords: ERQUAL500B 00C90064 Compression
                       Replication IFCID306
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI90891 UI90892

Modules/Macros

• DSNIDCML
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI90891

     UP23/03/17 P F303

• RD10 PSY UI90892

     UP23/03/17 P F303

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.