PI73085: SUPPORT FOR DATACHANGED AND LOCKMODE ON THE ADMIN ACCELERATOR LOAD.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Support for DATACHANGED and LOCKMODE on the ADMIN
  ACCELERATOR LOAD.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and IBM DB2 Analytics Accelerator       *
  *                 (IDAA) for z/OS.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: This enhancement adds support to        *
  *                      allow users to filter and carry         *
  *                      out accelerator operations, based       *
  *                      on specific change types of tables.     *
  *                      Support is also added to allow the      *
  *                      user to specify wild card characters    *
  *                      for table names in batch.  This         *
  *                      enables more user control on what       *
  *                      type of tables are included in          *
  *                      accelerator operations in both          *
  *                      online and batch modes, thereby         *
  *                      greatly enhancing usability             *
  *                      and performance, especially for         *
  *                      high latency bulk operations            *
  *                      (like LOAD).                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This enhancement adds support to improve usability and
  performance of accelerator operations (viz. ADD, DELETE,
  ENABLE, DISABLE and LOAD tables) in both online and batch
  modes, by allowing users to specify table change filtering
  criteria and wild card characters.
  
  ONLINE mode:
  ISPF panel interface allows a user to filter and display
  tables based on the change attributes. This can be achieved
  using new DISOPT primary command on panel ADBPZAT 'Display
  Accelerated Tables' and specifying change filter
  attributes as below.
  
  Change category:
    NONE, RELOAD_REQUIRED,
  RELOAD_RECOMMENDED, UNKNOWN
  Change Type:
    DataChange, DataChangeInReplicatedTable
  
  Note: Both change type mentioned above falls in
  "Data changed" panel filter option.
  
  BATCH mode:
  - Additional keywords can be specified in the LOAD
  statement for a more granular operation:
  
  LOCKMODE  NONE|PARTITIONS|ROW|TABLESET
  CHANGE FILTER  NONE|RECOMMENDED|
  REQUIRED|UNKNOWN
  DATACHANGED  YES|NO
  
  - Double quoted wild card characters can be specified in
  ADD, DELETE, ENABLE, DISABLE and LOAD statements:
  
  eg. ADMIN ACCELERATOR LOAD TABLES ON ACCEL1
      LOCKMODE TABLESET
      DATACHANGED YES
      INCLUDE SYSADM."TB%"
  

Problem conclusion

Temporary fix

Comments

• Enhancements have been delivered.
  

APAR Information

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

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

  UI45181

Modules/Macros

•    ADBASP   ADBASW   ADBCCM   ADBCCMM  ADBCDTS
  ADBCEST  ADBCRCR  ADBCSPG  ADBDAT   ADBDK    ADBEAA   ADBED
  ADBEZLAT ADBE1ARC ADBHZAT  ADBHZTOP ADBLI    ADBNSPB  ADBPA
  ADBPA1   ADBPZAT  ADBPZAT0 ADBPZDT0 ADBPZED0 ADBPZED1 ADBPZLT0
  ADBPZMAT ADBPZRE0 ADBPZTOP ADBP1AR0 ADBTEPI  ADBTEPR  ADBTEPU
  ADBTEP2  ADBV99   ADBXAT   ADB0     ADB2CID  ADB2CME  ADB2CMF
  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2CM3
  ADB2FMT  ADB2MSK  ADB2MSQ  ADB2PA   ADB2PA3  ADB2PA4  ADB2PA5
  ADB2PA6  ADB2PA7  ADB2REG  ADB2REH  ADB2WCL  ADB2WIN  ADB2WVL
  ADB27AC  ADB28MC  ADB5000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI45181

     UP17/03/07 P F703

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.