PH09049: ADMIN TOOL PANELS ALT TBLOPTS ALTER ENABLE ARCHIVE YES ADBP1TAL NEXT INVALID CMD NO CHANGES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using the ALT line command to alter a table, if one
  executes primary command TBLOPTS on panel ADB27C ('ALTER
  Table'), and changes ENABLE ARCHIVE to YES on panel  ADBP7TOP
  ('ALTER - Table Options'), one can specify the ARCHIVE TABLE on
  panel ADBP1TAL ('Enable Archive').  However, there is no way to
  generate the JCL for the ALTER.    Executing the primary
  command NEXT on panel ADBP1TAL results in the message 'Invalid
  cmd', while hitting PF3 to return to panel ADB27C loses the
  change.  In the latter case, if one selects NEXT on panel
  ADB27C and NEXT again to generate the job, the message 'No
  changes' appears, and no JCL is generated.
  

Local fix

• Use the 'AL' line command instead of 'ALT'.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: User of the Db2 Administration Tool          *
  *                 for z/OS who use ALT to change the           *
  *                 archive status on a table.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the ALT and TBLOPTS          *
  *                      commands to enable a table to be        *
  *                      archived, the change is not saved,      *
  *                      and a 'No changes' message is issued.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a user uses the ALT command, and then the TBLOPTS
  command, to enable a table for archive, panel ADBP1TAL
  ('ssid Enable Archive') does not save the specified change.
  As a result, when the user hits PF3 to return back to
  panel ADB27C, and enters NEXT, the 'No changes'
  warning statement appears, and no JCL is generated.
  

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:

  UI64049

Modules/Macros

•    ADBP1TAL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI64049

     UP19/07/08 P F907

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.