A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS Catalog Copy function does not create its tablespaces as per the User's Guide and Reference or help panel ADBHCCJ "HELP: Create Catalog Copy and Bind Batch Jobs": Table spaces are created of the name CCnnKxx, where nn is the page size required and xx is the plan suffix for this catalog copy set. and issues DROP TABLESPACE commands for CC4Knn,CC8Knn, CC16Knn and CC32Knn. ADDITIONAL SYMPTOM: SQLCODEN616
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS Version 10 who use Catalog Copy. * **************************************************************** * PROBLEM DESCRIPTION: The Catalog Copy table spaces * * documented in the help panel ADBHCCJ * * and in the DB2 Administration Tool * * User's Guide are incorrect. * **************************************************************** * RECOMMENDATION: * **************************************************************** The DB2 Administration Tool User's Guide and help panel, ADBHCCJ were not updated to reflect the changes to the way Catalog Copy creates table spaces.
Problem conclusion
Catalog Copy has changed the way it creates table spaces in DB2 Administration Tool User's Guide Version 10. It now creates table spaces with the same name as the DB2 catalog, but in the database provided on panel ADB2CCJ 'Create Catalog Copy and Bind'. The help pael and the DB2 Administration Tool User's Guide will be changed to reflect the new processing. In addition, LOB table spaces will be dropped last and fixed in panel ADB2CCD 'Display Catalog Copy Versions' so that a processing error does not appear when sorting fields or pressing the enter key when in the panel. The DB2 Administration Tool User's Guide which describes the table space names created by Catalog Copy will be changed.
Temporary fix
Comments
APAR Information
APAR number
PM38254
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-05-03
Closed date
2011-07-19
Last modified date
2011-08-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK69922
Modules/Macros
ADBHCCJ ADB2CCD ADB2CCM
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK69922
UP11/07/22 P F107
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.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 August 2011