PI47753: IMPROVEMENTS WHICH WILL CLARIFY APAR PI39861'S DELIVERABLE PANEL FLOW ISSUE FOR DDL AND GEN LINE COMMANDS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' APAR PI39861 Abstract
  'PANEL FLOW ISSUE FOR DDL AND GEN LINE COMMANDS.' introduced
  changes to the DDL and GEN commands panel flows. This APAR will
  seek to clarify the changes and amend some panel content.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the ISPF panels.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: When options 1, 3 or 4 are used on      *
  *                      panel ADB2PSTM 'Statement Execution     *
  *                      Prompt', the user can specify an        *
  *                      'A - all' suffix on the options,        *
  *                      such as 1A, 3A, or 4A to indicate       *
  *                      'all' commands.  The usage of this      *
  *                      suffix is not clear. This APAR          *
  *                      clarifies the description of the        *
  *                      options.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The usage of the 'A - all' suffix when using options 1, 3, or
  4 in panel ADB2PSTM is clarified.
  

Problem conclusion

• This APAR delivers enhancements which will clarify how the
  ADB2PSTM panel and EXECUTE command works:
  
  1. The options list on panel ADB2PSTM to mention:
     DB2 Admin is about to execute the statement below. You
     have asked to be prompted before DB2 Admin executes
     this type of statement. What do you want to do now (Add
     an A to process all DDL statements. A is supported for
     options 1, 3, and 4.  For example 1A - Execute all
     statements).
  
  2. The options list on panel ADB2PSTM, 'Statement Execution
     Prompt', is changed:
  
      a - If there is only one SQL statement pending, the user
          will see:
  
          CAN - Cancel execution of this statement.
  
      b - If there is more than one SQL statement pending, the
          user will see:
  
          CAN - Cancel execution of this and any remaining
                statements.
  
  3. Help panel ADBHPSTM 'HELP: Statement Execution Prompt', is
     changed:
  
          CAN - Cancel execution of this and any remaining
                statments. Any statements that have already been
                executed are not undone.
  
  4. Help panel ADBHEDD2, 'Edit/Run DDL Statements', is
     changed to mention:
  
      a - Use the CANCEL editor command to leave the edit panel
          without saving or running the SQL statement.  Any
          statements that have previously been executed are
          not undone.
  
      b - Use the EXECUTE command to run the set of DDL
          statements.  When the EXECUTE process is complete or
          is cancelled, the panel ADBPEDD2 'Edit DDL Statements'
          is shown again. This will allow you to perform
          additional editing actions, such as changing the object
          names and executing again or using ISPF editor commands
          to save the DDL in a data set.
  

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:

  UI32202 UI32201

Modules/Macros

•    ADBHEDD2 ADBHPSTM ADBPEDD2 ADB2GEN  ADB2PSTM
  ADB222E
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI32201

     UP15/10/23 P F510

• RB20 PSY UI32202

     UP15/10/23 P F510

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.