PI88940: ENHANCED METADATA SELF-DESCRIPTION CAPABILITY TO MINIMIZE PROBLEMS RELATED TO SCHEMA DEFINITION CHANGES CONTINUATION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ENHANCED METADATA SELF-DESCRIPTION CAPABILITY TO MINIMIZE
  PROBLEMS RELATED TO SCHEMA DEFINITION CHANGES CONTINUATION
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Additional minor changes to complete                         *
  * the new function for metadata changes.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  REPAIR CATALOG TEST error reporting was changed to
  report all RC=8 errors instead of stopping the process
  when the first RC=8 error is encountered.
  
  REPAIR CATALOG detects and fixes inconsistencies between the
  page set and catalog, but there is insufficient detail in the
  messages indicating what is changed.
  
  ABEND04E RC00C90101 DSNIVGET:5003 was received during
  REORG TABLESPACE SHRLEVEL NONE LOG YES of an empty table
  space. It can also be received for a REORG TABLESPACE with
  an inline FlashCopy image copy.
  
  REORG TABLESPACE, COPY TABLESPACE, or LOAD with a
  FlashCopy image copy has an invalid OLDEST_VERSION
  value of 0 In the SYSCOPY entry describing the full image
  copy (i.e. ICTYPE=?F?, STYPE=?T?).
  
  The table definition description for a table residing in
  the table space with hash attribute was inserted into
  the system page prematurely. This incomplete table
  definition saved in the system page does not contain
  the internal table description structure and can
  further result in DSNIHDUP+112F8.
  

Problem conclusion

• REPAIR CATALOG TEST will issue all messages for
  inconsistencies found between the page set and the
  catalog before ending with an RC=8.
  
  If REPAIR CATALOG modifies the catalog to be
  consistent with the page set, an appropriate message
  will be issued describing each change made to the
  catalog.
  
  The method used to determine the lowest version of
  data rows in a page set has been modified to avoid
  processing and set a -1 for OLDEST VERSION if the
  page set is physically closed and the real value
  cannot be determined.  In many cases of REORG
  TABLESPACE and LOAD REPLACE, the OLDEST_VERSION
  is  determined from the existing high version for
  the page set.  SYSCOPY entries generated to track
  Flash Copy image copies will now have an
  appropriate value for OLDEST_VERSION instead
  of always being 0.
  
  Db2 code is changed to ensure the internal table
  description structure is built for a table definition
  of a table residing in the table space with hash attributes
  prior to inserting the system page.
  

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:

  UI52941

Modules/Macros

• DSNISGNS DSNURSYC DSNUGUVR DSNIPPHO DSNUCBVR DSNIFOD  DSNUBINS
  DSNUBASI DSNUGRST DSNIVGET DSNISCHV DSNURWT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI52941

     UP18/01/12 P F801 ¢

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.