PI68511: PROVIDE FUNCTION TO VERIFY OBJECT STRUCTURE PRIOR TO DOING AN ANALYZE IN CM BATCH.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Provide function to verify object structure prior to doing an
  analyze in CM Batch.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Three enhancements for the object type  *
  *                      verification mask function is           *
  *                      delivered:                              *
  *                                                              *
  *                      1.  Exclude DB2 generated checks        *
  *                      from VER,CK masks.                      *
  *                                                              *
  *                      2.  Avoid calling the VER,UQ exit       *
  *                      when processing primary keys            *
  *                                                              *
  *                      3.  Provide VER,TP/IP/FL                *
  *                      verification masks.                     *
  *                                                              *
  *                      Also included in this APAR is a         *
  *                      fix for an error with ADB2CMM that      *
  *                      occurs when using VB version of         *
  *                      the EXEC lib. See ++HOLDDATA for        *
  *                      instructions on how to implement        *
  *                      the fix.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Three enhancements are needed for object type verification
  mask function:
  
  1.  Exclude DB2 generated checks from the VER,CK mask - this
  includes the business time period and system time period
  checks.
  
  2.  Do not call VER,UQ exit when processing primary keys and do
  not call VER,PK when processing unique keys.
  
  3.  Provide three new verification object type masks:
  
  TP to verify SYSTABLEPART fields,
  IP to verify SYSINDEXPART fields,
  and FL to verify SYSFIELDS fields.
  
  
  The following error is observed when running the ADB2CMM
  EXEC from the VB version of the EXEC lib.
  
  IRX0041I Error running ADB2CMM, line 169: Bad arithmetic
  conversion
  * ADB2CMM macro error
  * ADB2CMM macro set a return code of 20041
  

Problem conclusion

Temporary fix

Comments

• Enhancements have been delivered.  Problem has been resolved.
  

APAR Information

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

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

  UI42373

Modules/Macros

•    ADBHC2L  ADB2CMM  ADB2C2L  ADB2C21  ADB2MASK
  ADB2MSK
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI42373

     UP16/11/09 P F611

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.