PH36092: PARSER IMPROVEMENTS FOR CREATE/ALTER DATABASE COMMANDS; APPLCOMPAT FIELD INCORRECT ON MAIN MENU PANEL ADB2

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR addresses two issues:
  
  1) Enhances the parser to add checks for CREATE and ALTER
  DATABASE statements used as input to Admin Tool.
  
  2) Fixes an issue where the ApplCompat field displayed on the
  main menu was incorrect after being updated by the Admin Tool
  APPLCOMPAT command.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides enhancements to      *
  *                      improve parser support for database     *
  *                      DDL. It also fixes a problem where the  *
  *                      ApplCompat field on the main menu is    *
  *                      not updated correctly.                  *
  *                                                              *
  ****************************************************************
  Some processes in Db2 Admin Tool accept DDL
  as input. The DDL is parsed to identify the keywords and values,
  but currently the syntax, semantics, and values are not
  verified. Therefore, errors will not be detected until the DDL
  is applied to Db2 much later in the process.
  
  The parser is being enhanced in stages to detect and report
  basic errors in the parsed DDL. This APAR adds the following
  checks specifically for CREATE and ALTER DATABASE statements:
  
  Check whether an attribute is specified more than once.
  Verify the value for the buffer pool name
  Verify the value for the CCSID
  Verify that the AS WORKFILE clause is not specified for
    ALTER DATABASE
  Verify that the database name is a valid data set qualifier
  This APAR also fixes an issue of displaying the correct Db2
  ApplCompat value on panel ADB2 'Administration Menu' when
  its value is changed by using the Db2 Admin Tool command
  APPLCOMPAT.
  (This command issues the SET CURRENT APPLICATION COMPATIBILITY
   statement.)
  

Problem conclusion

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:

  UI74912

Modules/Macros

• ADB2     ADB2PA3  ADBEDIAG ADBMAIN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI74912

     UP21/04/15 P F104

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.