PI56531: DB2 ADMIN TOOL BIND PLAN(ADB) STMNT WITH WRONG PKLIST PARAMETER "ENABLE ALLOW CHANGE DELETE" NOT CONSIDERED IN BIND-JOB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• With Parameter "Enable Allow Change Delete" to YES in Tools
  Customizer, the generated BIND-Job must be manually changed:
  PKLIST for plan ADB from (*.ADBL.*) to (*.ADBL.*,*.ADBCDCH.*)
  so that the parameter becomes operative.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS and IBM Tools Customizer for            *
  *                 z/OS who use Change Management               *
  *                 to delete a change.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: The 'Enable Allow Change Delete'        *
  *                      option allows the user to delete        *
  *                      a change when it is set to 'No'.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the product / DB2 parameters 'Enable Allow Change
  Delete' is set to 'NO' via the IBM Tools Customizer for
  z/OS,  the user can still delete a change via the 'DEL' line
  command on panel ADB2C11 'CM - Changes'.
  

Problem conclusion

• Problem has been resolved.
  
  1- The message ADBC104E/msgadbc104e 'Delete not enabled'/'The
  delete change command is not enabled.' will be issued when the
  'DEL' line command is executed against a change on panel ADB2C11
  
  2- When the option 'Enable Allow Change Delete' is
  set to NO in IBM Tools Customizer for z/OS, error message
  msgadb9964e / ADB9964E 'Delete change function is not enabled'
  will be issued when specifying parameter action_delete_change
  in the Change Management Batch job to delete a change.
  
  3- If the customization table library specified during the IBM
  Tools Customizer for z/OS process is not specified under DD
  ISPTLIB in the CM Batch JCL procedure, error message
  msgadb9965e / ADB9965E 'The customization table is unable
  to be opened to verify whether Delete change function is
  enabled.'will be issued when specifying parameter
  action_delete_change in the Change Management Batch job to
  delete a change.
  
  When the status is not "CANCELED", DB2 Admin Tool previously
  supported the deletion of a change directly when the delete
  change function is enabled.  This is working as designed.
  

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:

  UI43606 UI43607

Modules/Macros

•    ADBCCM   ADBCMBAT ADBCMBSS ADBEAPI0 ADBR
  ADB2C11  ADB9000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI43606

     UP17/01/05 P F701

• RB20 PSY UI43607

     UP17/01/05 P F701

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.