PH19082: GOC - LOCKMODE FOR IDAA TABLE LOAD.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• GOC - lockmode for IDAA table load.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison 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:

  UI66625

Modules/Macros

• GOCCMP   GOCGCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RC10 PSY UI66625

     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.