PH29571: ADD FIELD TO "OPTIONS FOR CHANGE FUNCTIONS" PANEL ADB2PCO GENERATE DATACHANGED OPTION FOR IDAA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Add a field to the "Options for Change Functions" panel to
  generate DATACHANGED option for IDAA
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and IDAA.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1) Users do not have a way to control   *
  *                      the detectChanges option that is        *
  *                      passed to the IDAA stored               *
  *                      procedure SYSPROC.ACCEL_LOAD_TABLES.    *
  *                                                              *
  *                      This APAR provides an enhancement to    *
  *                      specify the detectChanges option.       *
  *                                                              *
  *                      2) CMBATCH allows incompatible IDAA     *
  *                      options to be specified.                *
  ****************************************************************
  1) Users cannot control the IDAA option detectChanges by using
  ADMIN ACCELERATOR LOAD statements in Db2 Admin Tool.
  Admin Tool always sends 'DATA' for this field when calling the
  SYSPROC.ACCEL_LOAD_TABLES stored procedure.
  
  This APAR provides an enhancement to specify the detectChanges
  option.
  
  Panel ADB2PCO, "Options for Change Functions," has been updated
  with the new field "Load accelerated tables DETECTCHANGES."
  This field is described in the help panel:
  
  Specifies the value of detectChanges for the
  SYSPROC.ACCEL_LOAD_TABLES procedure for accelerated tables.
  Possible values are: DATA, PARTITIONS, or NONE.
  
  DATA is the default value. For a description of DATA and
  PARTITIONS, see the information about SYSPROC.ACCEL_LOAD_TABLES
  in the Db2 Analytics Accelerator for z/OS documentation.
  
  NONE indicates that detectChanges is not used when calling
  SYSPROC.ACCEL_LOAD_TABLES.
  
  CMBATCH has also been enhanced to support the new option
  load_accelerated_tables_detect_changes,which accepts the same
  values.
  
  2) Additionally, when using IDAA related options in CMBATCH,
  mutually exclusive values were allowed, causing some changes
  to fail when applied later.
  
  CM Batch now checks the values of IDAA related options,
  similar to panel ADB2PCO. The following rules are enforced:
  
  If either enable_accelerated_tables or
  replicate_accelerated_tables is set to YES, then
  reload_accelerated_tables must also be YES.
  
  If reload_accelerated_tables is set to YES,
  recreate_accelerated_tables must also be YES.
  
  These options default to YES when not specified, so if either
  reload_accelerated_tables or recreate_accelerated_tables is to
  NO by the user, the related options must explicitly be set to
  NO as well, otherwise CMBATCH will issue an error, for example:
  
  ADB9969E ADBCCM  The enable_accelerated_tables action parameter
                    is enabled. This action parameter is conflict
                    with at least one other parameter that is
                    enabled.
  ADB9730I ADBCCM   The following are the values for the action
                    parameters:
                    reload_accelerated_tables = 'N'
  

Problem conclusion

• The problems have been resolved.
  

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:

  UI73710

Modules/Macros

• ADB2000  ADB27AC  ADB28MC  ADB2CID  ADB2CM3  ADB2CME  ADB2CMF
  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2FMT
  ADB2MSK  ADB2MSQ  ADB2PA   ADB2PA3  ADB2PA4  ADB2PA5  ADB2PA6
  ADB2PA7  ADB2PCO  ADB2REG  ADB2REH  ADB2WCL  ADB2WIN  ADB2WVL
  ADBASP   ADBASW   ADBCCM   ADBCCMM  ADBCDTS  ADBCEST  ADBCHST
  ADBCRCR  ADBCSPG  ADBDAT   ADBDK    ADBEAA   ADBEALT  ADBEMTAR
  ADBEZLAT ADBHPCO  ADBLI    ADBNSPB  ADBPA    ADBPA1   ADBPZAT0
  ADBPZLT0 ADBSALT  ADBTEP2  ADBTEPI  ADBTEPR  ADBTEPU  ADBV99
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI73710

     UP21/02/02 P F102

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.