A fix is available
APAR status
Closed as new function.
Error description
The DB2 Administration Tool for z/OS' does not provide a default for the CLONE LOBTEMPLATE.
Local fix
Add a specific template to the 'LOBCOLDDN' keyword via panel ADB25TU4 'Specify UTILITY TEMPLATE Usage' for 'Template type' 'CLONE' and specify 'Generate templates' 'YES'.
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration and DB2 * * Object Comparison Tool for z/OS who use * * the 'ALT Alter Table' (ALT) function on * * a table that contains LOB/XML columns * * and also has a CLONE table. * **************************************************************** * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS * * does not provide a default template * * name for the CLONE LOBTEMPLATE in the * * ALT/OC process and the panel title * * 'SSID Specify UTILITY TEMPLATE Usage' * * on panel ADB25TU4 is misleading when * * the 'Template type' of CLONE was * * specified. * **************************************************************** * RECOMMENDATION: * **************************************************************** Program misses logic to generate the default template statement for LOB/XML columns in a CLONE table and displays a misleading title for panel ADB25TU4 when the 'Template type' of CLONE was specified.
Problem conclusion
Temporary fix
Comments
Problem has been resolved to generate the correct default template statement for LOB/XML columns in a CLONE table and panel ADB25TU4's title is changed to 'SSID Specify CLONE TEMPLATE Usage' when a 'Template type' of CLONE is specified.
APAR Information
APAR number
PI08659
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-12-23
Closed date
2014-03-19
Last modified date
2014-04-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBTUNL ADB25TU4
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 April 2014