PI56506: THE OLDEST_VERSION = -1 IN SYSIBM.SYSCOPY AFTER THE FULL IMAGECOPY WITH SHRLEVEL CHANGE TAKE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The OLDEST_VERSION changed to -1 in SYSIBM.SYSCOPY after the
  FULL imagecopy taken against a tablespace with
  multi-table defined. This happened in the imagecopy taken
  right after the REORG.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of the             *
  *                 COPY TABLESPACE utility.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: COPY TABLESPACE results in an image     *
  *                      copy entry in the SYSIBM.SYSCOPY        *
  *                      table having a value of value of -1     *
  *                      for the OLDEST_VERSION column.          *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available.         *
  ****************************************************************
  The user had a segmented table space with over 200 tables,
  and many of the tables were ALTERed to create new schema
  versions.
  
  When image copies are taken by the COPY TABLESPACE utility,
  it is summarized by inserting a SYSIBM.SYSCOPY entry in the
  catalog table.  These entries contain the lowest version of
  any data row detected within the image copy. This information
  is obtained from the header page of the copied table space.
  
  There are only a fixed number of table version entries that
  can be held on the header page. If there are a lot of tables
  in the table space with versioned data (i.e. system pages),
  then they all cannot be summarized on a single header page,
  so the information overflows into other pages.  In this
  case, a value of -1 is set for the OLDEST_VERSION column
  of the SYSIBM.SYSCOPY row indicated "I do not know" the
  lowest version.
  
  A -1 value keeps the MODIFY utility from updating the
  OLDEST_VERSION in SYSIBM.SYSTABLESPACE, and this constrains
  the number of version changing ALTERs that can be done before
  being blocked.
  

Problem conclusion

• Instead of just looking at the header page, the code has
  been changed to search all existing system pages in all
  tables to determine the lowest version within the table space.
  

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:

  UI39305

Modules/Macros

• DSNUBASI DSNUBINS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI39305

     UP16/07/26 P F607

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.