PM79602: DOES NOT PROVIDE AN INPUT FIELD TO ALLOW CUSTOMERS TO SPECIFY THE BUFFERPOOL'S TO BE USED FOR TABLESPACE AND INDEXES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADMIN/OC Does not provide an input field to allow customers to
  specify the BUFFERPOOL's to be used for the tablespaces and
  indices, ADBCHKX1 has a hard coded BP1 while other statements
  did not have any BUFFERPOOL specified.
  The following Change Management options
  are not mutually exclusive:
  / Upgrade the Change Management database
  / Create Change Management database
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 IBM Tools Customizer (TCz) for z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following issues have been          *
  *                      resolved:                               *
  *                                                              *
  *                      1. No input fields available to         *
  *                      specify BUFFERPOOL for tablespace and   *
  *                      index on panel CCQPPRD 'Product         *
  *                      Parameters' and panel CCQPDB2 'DB2      *
  *                      Parameters'.                            *
  *                                                              *
  *                      2. The following Change Management      *
  *                      options on TCz panel CCQPPRD            *
  *                      'Product Parameters' are not            *
  *                      mutually exclusive:                     *
  *                                                              *
  *                      / Upgrade the Change Management         *
  *                      database                                *
  *                      / Create Change Management              *
  *                      database                                *
  *                                                              *
  *                      3.  Order and description of            *
  *                      parameters for the following tasks      *
  *                      on panel CCQPPRD 'Product               *
  *                      Parameters' were not consistent         *
  *                      with parameters on panel CCQPDB2        *
  *                      'DB2 Parameters':                       *
  *                                                              *
  *                      - Create Checkpoint table               *
  *                      - Change Management database            *
  *                      - Create Catalog Copy Version Table     *
  *                      - Create Profiles History database      *
  *                                                              *
  *                      4. Input field context-sensitive help   *
  *                      information has been improved for       *
  *                      panel CCQPPRD 'Product Parameters'      *
  *                      and panel CCQPDB2  'DB2 Parameters'.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following issues have been resolved:
  
  1. No input fields available to specify BUFFERPOOL for
  tablespace and index on panel CCQPPRD 'Product Parameters' and
  panel CCQPDB2 'DB2 Parameters'.
  
  2. The following Change Management options on TCz panel CCQPPRD
  'Product Parameters' are not mutually exclusive:
  
  / Upgrade the Change Management database
  / Create Change Management database
  
  3.  Order and description of parameters for the following
  tasks on panel CCQPPRD 'Product Parameters' were not
  consistent with parameters on panel CCQPDB2 'DB2
  Parameters':
  
  - Create Checkpoint table
  - Change Management database
  - Create Catalog Copy Version Table
  - Create Profiles History database
  
  4. Input field context-sensitive help information has been
  improved for panel CCQPPRD 'Product Parameters' and panel
  CCQPDB2  'DB2 Parameters'.
  

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:

Modules/Macros

•    ADB$$PRM ADB$$SEQ ADBBIND  ADBCATVT ADBCHANG
  ADBCHKPT ADBMCMA  ADBPRHIS ADB2CUST ADB2SYS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK91912

     UP13/02/26 P F302

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.