A fix is available
APAR status
Closed as program error.
Error description
Note, resolving PTF will be for DB2 Cloning Tool r220. There will not be a fix for r210. Performance issue when copying tables, when badly clustered catalogs or when it must use the SQL STRIP function (without any indexes). Catalog reads can take a considerable amount of time. This change applies only to SYSTABLES.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Cloning Tool. * **************************************************************** * PROBLEM DESCRIPTION: Note, resolving PTF will be for DB2 * * Cloning Tool r220. There will not be * * a fix for r210. Performance issue * * when copying tables, when badly * * clustered catalogs or when it must use * * the SQL STRIP function (without any * * indexes). Catalog reads can take a * * considerable amount of time. This * * change applies only to SYSTABLES. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM02349
Reported component name
DB2 CLONING TOO
Reported component ID
5655N1000
Reported release
210
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-11-30
Closed date
2010-03-29
Last modified date
2010-05-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK55671
Modules/Macros
CKZ00500 CKZ00501 CKZ00510 CKZ00535 CKZ00536 CKZ00544 CKZ00545 CKZ00547 CKZ00560 CKZ00563 CKZ00613 CKZ00627 CKZ00629 CKZ00630 CKZ00632 CKZ00652 CKZ00653 CKZ00654 CKZ00655 CKZ00670 CKZ00671 CKZ00673 CKZ00678 CKZ00679 CKZ00727 CKZ00729 CKZ00730 CKZ00732 CKZ00752 CKZ00753 CKZ00754 CKZ00755 CKZ00770 CKZ00773 CKZ00778 CKZ00779 HCKZ220J
Fix information
Fixed component name
DB2 CLONING TOO
Fixed component ID
5655N1000
Applicable component levels
R220 PSY UK55671
UP10/04/10 P F004
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":"SSAUUE","label":"IBM Db2 Cloning Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021