A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS' Tools Customizer panel CCQPDB2 'DB2 Parameters' field heading 'DB2 Admin Tool - Create Catalog Copy Version Table' is misleading as the field 'Owner name' is also used to specify what the owner is for an existing object. Failing to supply a value will cause the Global Setting to be used ( which has a default value of ADB ) which can result in a DSNT408I SQLCODE = -204, ERROR: ADB.ADBCATVT IS AN UNDEFINED NAME error is the subsystem uses a different schema.
Local fix
Specify a value for the field.
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * and IBM Tools Customizer for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: On IBM Tools Customizer panel CCQPPRD * * 'Product Parameters' and panel CCQPDB2 * * 'DB2 Parameters', additional field- * * level help information has been * * provided for parameter 'Owner name' * * under task 'Create Catalog Copy * * Version Table' to better describe / * * explain its usage. * **************************************************************** * RECOMMENDATION: * **************************************************************** The following field-level help information will now be displayed when the cursor is positioned on the parameter input field and F1/Help is entered: This parameter is used to set the owner name to create the Catalog Copy Version table ADBCATVT. Enter a valid value of 1 to 128 characters. The parameter is also used by DB2 Admin Tool's Primary Menu option 'CC - DB2 Catalog Copy Version maintenance'. If the Catalog Copy Version table ADBCATVT already exists, the specified parameter must be the same as the owner of the table. Otherwise, SQLCODE=-204 will result when option CC is used.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PI08424
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-18
Closed date
2014-04-14
Last modified date
2014-05-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB$$PRM ADB$$SEQ
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:
02 May 2014