PI07358: GEN 'COMMIT STATEMENTS PER D' / COMMITFR = 'D': PLACEMENT OF COMMIT STATEMENT NOT CONSISTENT WITH DOCUMENTATION/HELP PANEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' GEN function option
  'Commit statements per D'  / COMMITFR = 'D' results in a
  COMMIT statement being added to the DDL output. The positioning
  of the statement in the DDL is not consistent with the
  information presented in the help panel, the documentation or
  the message in the job output:
   Insert COMMIT statement only after all definitions for a
  database.
  when more than one database has been requested i.e. the GEN
  command was issued as a command line command rather than a
  line command.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) function     *
  *                 to generate a database and specify 'D' for   *
  *                 the field 'Commit statements per' on         *
  *                 panel ADB2GEN 'Generate SQL from DB2         *
  *                 catalog'.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The GEN function option 'Commit         *
  *                      statements per D'  / COMMITFR = 'D'     *
  *                      results in a COMMIT statement being     *
  *                      added to the DDL output. The            *
  *                      positioning of the statement            *
  *                      in the DDL is not consistent with       *
  *                      the information presented in the        *
  *                      help panel ADBHGEN 'HELP: DB2           *
  *                      catalog', the documentation or          *
  *                      the message in the job output:          *
  *                                                              *
  *                      'Insert COMMIT statement only           *
  *                      after all definitions for a database'   *
  *                                                              *
  *                      when more than one database has         *
  *                      been requested.                         *
  *                                                              *
  *                      For example:                            *
  *                      Use the GEN function to generate DB2    *
  *                      database database_name and specify 'D'  *
  *                      for field 'Commit statements per'.      *
  *                      The generated DDL is below and is       *
  *                      missing a COMMIT statement after        *
  *                      the 'CREATE DATABASE' statement:        *
  *                                                              *
  *                                                              *
  *                        CREATE DATABASE >database_name<       *
  *                          BUFFERPOOL BP0                      *
  *                          INDEXBP    BP1                      *
  *                          CCSID      EBCDIC                   *
  *                          STOGROUP   >stogroup_name<;         *
  *                      --                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The GEN function did not generate a COMMIT statement for each
  'CREATE DATABASE' statement when setting field 'Commit statement
  per' to 'D' on panel ADB2GEN.
  

Problem conclusion

• Problem has been resolved.
  After the fix is applied, using this example:
  
  Use the GEN function to generate DB2 database database_name
  and specify 'D' for field 'Commit statements per'. The
  generated DDL has the COMMIT statement after the 'CREATE
  DATABASE' statement:
  
    CREATE DATABASE >database_name<
      BUFFERPOOL BP0
      INDEXBP    BP1
      CCSID      EBCDIC
      STOGROUP   >stogroup_name<;
  --
    COMMIT;
  --
  

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:

  UI19977 UI19978

Modules/Macros

•    ADB2REM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI19977

     UP14/07/30 P F407

• RB10 PSY UI19978

     UP14/07/30 P F407

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.