PH66668: PREVENTING V13 LOSS OF DATA INTEGRITY FOR PARTITION-BY-RANGE RPNTABLESPACE RUNNING IN A CO-EXISTENCE ENVIRONMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Db2 Data Sharing users of V13 Partition-By-Range ( PBR )
  Relative Page Numbering ( RPN ) table space running in a
  co-existence environment, may encounter a loss of data integrity
  for a PBR RPN partition opened on a Db2 member that is now at
  V13R1M100. Since the tablespace was not previously REORG'd in
  V12 with V12 PTFs UI92688 and UI97574 applied, prior to the
  member being migrated to Db2 V13.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 for z/OS data sharing users at       *
  *                 function level V13R1M100 with                *
  *                 partition-by-range (PBR) table spaces        *
  *                 defined with PAGENUM RELATIVE (RPN)          *
  *                 attribute                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Potential loss of data integrity for    *
  *                      PBR RPN table spaces on activation      *
  *                      of a function level higher than         *
  *                      V13R1M100 from V13R1M100 if             *
  *                      the instructions in the prior red       *
  *                      alert have not been followed            *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  A locking issue for partition-by-range (PBR) with PAGENUM
  RELATIVE (RPN) tablespaces in data sharing was identified
  and resulted in red alert (7158065) being issued in 2024.
  Not following these instructions can result in loss of
  data integrity when migrating from V12 to V13R1M100 or
  activating a function level higher than V13R1M100.
  

Problem conclusion

• In order to ensure that the actions specified in the red alert
  are followed and to prevent data loss, Db2 code is modified to
  block Db2 at V13R1M100 from accessing a PBR RPN data set if
  the data set indicates the new hash algorithm is used. In
  addition, a resource unavailable message with a SQLCODE -904
  and DSNT501I console message with a new reason code of
  00C90125 will be issued. This is to prevent two incompatible
  hash algorithms from simultaneous access to the same pageset
  from different data sharing members.
  
  Users must follow the steps described in the
  Red ALERT document 7158065.
  

Temporary fix

Comments

• ×**** PE25/08/25 FIX IN ERROR. SEE APAR PH67878  FOR DESCRIPTION
  

APAR Information

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

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

  UO04009

Modules/Macros

• DSNIPPHO
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UO04009

     UP25/07/17 P F507 ¢

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.