PI55361: MASKING SUPPORT NEW STYLE CHK OBJ CHGS AND VERIFY PNLS IN MASK TABLE.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• MASKING SUPPORT NEW STYLE CHK OBJ CHGS AND VERIFY PNLS IN
  MASK TABLE.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following enhancements are          *
  *                      delivered:                              *
  *                                                              *
  *                      1. User can perform overwrite and       *
  *                      verification masking on the following   *
  *                      attributes:                             *
  *                                                              *
  *                      EDITPROC, VALIDPROC, LOGGED,            *
  *                      LOCKSIZE,MAXROWS,                       *
  *                      GBPCACHE, VOLATILE,                     *
  *                      APPEND, PADDED                          *
  *                                                              *
  *                      2. User can perform verification        *
  *                      masking on the following attribute:     *
  *                                                              *
  *                      PARTITIONS (with TSPARTS mask)          *
  *                                                              *
  *                      3.  Add the object name and schema      *
  *                      to the verification message and         *
  *                      display a return code 4 / RC=4          *
  *                      for the verification message            *
  *                      output.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following enhancements are delivered:
  
  1. New overwrite/verification masks have been added and the
  mask names are as follows (with help for each):
  
  EDITPROC           string,REXX exit (tables only)
  VALIDPROC          string,REXX exit (tables only)
  LOGGED             YES,NO,
                     REXX exit (table spaces only)
  LOCKSIZE           TABLE,TABLESPACE,PAGE,ROW,
                     LOB,ANY,REXX exit
                     (table space only)
  MAXROWS            n,REXX exit (tables only)
  GBPCACH            SYSTEM,CHANGED,ALL,NONE,
                     REXX exit
                     (table spaces and indexes)
  TSGBPCACH          SYSTEM,CHANGED,ALL,NONE,
                     REXX exit
                     (table spaces only)
  IXGBPCACH          SYSTEM,CHANGED,ALL,NONE,
                     REXX exit
                     (indexes only)
  VOLATILE           YES,NO,REXX exit (tables only)
  APPEND             YES,NO,REXX exit (tables only)
  PADDED             YES,NO,REXX exit (indexes only)
  COPY               YES,NO,REXX exit (indexes only)
  
  2. New verification mask for attribute PARTITIONS is named
  
  TSPARTS               n,REXX exit (table spaces)
  
  3.  The message used for verification masking output is
  msgadb3346e / ADB3346E.  It has been updated to show the
  object schema and name of the object where the attribute
  does not satisfy the verification operation.   Also, a new
  warning message,  msgadb3347w / ADB3347W, is added for the
  verification masks that have return code 4 / RC = 4.
  
  For example: if a user has a new verification mask specified
  as VER,AUDIT:EQ,ALL,RC=8, the job fails with a return code 8 /
  RC=8, and an object being compared has AUDIT CHANGES.
  Another verification mask is specified as VER,AUDIT:EQ,NONE,
  RC=4, the following report will be shown in DD VALOUT:
  
  VERIFICATION MASK LIST REPORT
  ===========================================
  Prepared on SSID (DB2 Release >db2_release<) by >userid<
  at  >date_timestamp<
  ADB3346E RC=8 For Table >schema.table_name<:
  Error processing AUDIT attribute.
  Value is CHANGES.  Verification failed for operation EQ,ALL
  ADB3347W RC=4 For Table >schema.table_name<:
  Warning processing AUDIT attribute.
  Value is CHANGES.  Verification failed for operation EQ,NONE
  
  ADB3346E error message updated:
  
  ADB3346E: RC = return_code For object_type object_name:
  Error processing mask_name value is attr_value
  verification failed for operation verify_oper.
  Explanation:
  Attribute value does not conform to verification mask.
  User action:
  Correct the attribute value and try again.
  After the corrections are made, resubmit the job.
  System action:
  Processing is discontinued with return code 8 or 12.
  
  ADB3347W warning message added:
  
  ADB3347W: RC = return_code For object_type object_name:
  Warning processing mask_name value is attr_value
  verification failed for operation verify_oper.
  Explanation:
  Attribute value does not conform to verification mask.
  User action:
  Correct the attribute value and try again.
  After the corrections are made, resubmit the job.
  System action:
  Processing continues.
  

Problem conclusion

Temporary fix

Comments

• Enhancements delivered.
  

APAR Information

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

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

  UI37325

Modules/Macros

•    ADBASW   ADBCCM   ADBCCMM  ADBCDTS  ADBCEST
  ADBCRCR  ADBCSPG  ADBDAT   ADBDK    ADBHC2L  ADBLI    ADBNSPB
  ADBPA1   ADBRPTL  ADBTEPI  ADBTEPR  ADBTEPU  ADBTEP2  ADBV99
  ADB2CID  ADB2CME  ADB2CMF  ADB2CMM  ADB2CMO  ADB2CMP  ADB2CMR
  ADB2CMS  ADB2CMT  ADB2CMU  ADB2CM3  ADB2FMT  ADB2MSK  ADB2MSQ
  ADB2PA   ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6  ADB2PA7  ADB2REG
  ADB2REH  ADB2REM  ADB2WCL  ADB2WVL  ADB27AC  ADB28MC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI37325

     UP16/04/28 P F604

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.