A fix is available
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 number
PI07358
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-12-03
Closed date
2014-07-25
Last modified date
2014-08-04
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 August 2014