PH15035: NEED A METHOD TO SET LOCKMODE PARAMETER ON IDAA LOAD.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Customer is requesting a way to change the
  LOCKMODE parameter for IDAA load.  It is always generated as
  LOCKMODE TABLESET.
  
  I want LOCKMODE TABLE for example.
  
  ADMIN ACCELERATOR LOAD TABLES ON TDB2AC02,TDB2AC01 LOCKMODE
  TABLESET INCLUDE HACA02.EMP3;
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who use the SYSPROC.ACCEL_LOAD_TABLES        *
  *                 procedure.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The load tables function for            *
  *                      accelerated tables always uses LOCK     *
  *                      MODE TABLESET but user wants to use     *
  *                      LOCK MODE TABLE instead.                *
  ****************************************************************
  Need a way to load accelerated table with LOCK MODE TABLE
  instead of TABLESET that is always used.
  Option is added to allow user to chose which LOCK MODE
  for the SYSPROC.ACCEL_LOAD_TABLES procedure when it is called
  for in a change or in a panel. Two ways to chose the LOCK MODE:
  
  1- Using the panels, the lock mode option is added to the
  common options panel ( ADB2PCO) that can be accessed
  by 'CO' primary command in both compare panel and change
  management panel. TABLESET will be the default option if
  no choice is made in the common options panel.
  
  2- Using new CM batch parameter,
  LOAD_ACCELERATED_TABLES_LOCK_MODE.
  The new parameter has this definition:
  
  load_accelerated_tables_lock_mode
      Specifies the lock mode for the SYSPROC.ACCEL_LOAD_TABLES
  procedure for accelerated tables. For details on the possible
  values of lock mode, see the information about
  SYSPROC.ACCEL_LOAD_TABLES in the DB2 Analytics Accelerator for
  z/OS documentation.
  
      Values:
  
          TABLESET
               This is the default and the recommended option.
          TABLE
          ROW
          PARTITIONS
          NONE
  
      Default:
          TABLESET
  

Problem conclusion

• Problem has 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:

  UI66505

Modules/Macros

• ADB2000  ADB2C11A ADB2CMP  ADB2PCO  ADBASP   ADBCCM   ADBDAT
  ADBEAA   ADBEALT  ADBEMTAR ADBEZLAT ADBHPCO  ADBPZAT0 ADBPZLT0
  ADBSALT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI66505

     UP19/11/30 P F911

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.