A fix is available
APAR status
Closed as new function.
Error description
New COPY subcommand CHECK-INDEX-KEYS(y/n). This command make additional checks on index compatibility. LIMITKEY is always checked and is normally sufficient. In some cases, a mismatch is missed unless the keys are read and checked also. If using index cacheing, run once with CHECK-INDEX-KEYS(Y), change any indexes to correct the mismatches and then run with CHECK-INDEX-KEYS(N) or the default. This has been added as a command since it can cause a performance penalty especially when there are many indexes to copy or cacheing is being used to access the catalog. Cacheing is not supported for index keys.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Cloning Tool. * **************************************************************** * PROBLEM DESCRIPTION: New COPY subcommand * * CHECK-INDEX-KEYS(y/n). This command * * make additional checks on index * * compatibility. LIMITKEY is always * * checked and is normally sufficient. * * In some cases, a mismatch is missed * * unless the keys are read and checked * * also. If using index cacheing, run * * once with CHECK-INDEX-KEYS(Y), change * * any indexes to correct the mismatches * * and then run with CHECK-INDEX-KEYS(N) * * or the default. This has been added as * * a command since it can cause a * * performance penalty especially when * * there are many indexes to copy or * * cacheing is being used to access the * * catalog. Cacheing is not supported * * for index keys. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
Temporary fix
Comments
APPLY the PTF.
APAR Information
APAR number
PM20410
Reported component name
DB2 CLONING TOO
Reported component ID
5655N1000
Reported release
220
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2010-08-11
Closed date
2011-03-23
Last modified date
2011-04-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK66073
Modules/Macros
CKZ00501 CKZ00510 CKZ00532 CKZ00535 CKZ00547 CKZ00613 CKZ00628 CKZ00629 CKZ00631 CKZ00632 CKZ00634 CKZ00635 CKZ00652 CKZ00653 CKZ00654 CKZ00655 CKZ00656 CKZ00657 CKZ00670 CKZ00671 CKZ00675 CKZ00678 CKZ00679 CKZ00728 CKZ00729 CKZ00731 CKZ00732 CKZ00734 CKZ00735 CKZ00752 CKZ00753 CKZ00754 CKZ00755 CKZ00756 CKZ00757 CKZ00770 CKZ00775 CKZ00778 CKZ00779
Fix information
Fixed component name
DB2 CLONING TOO
Fixed component ID
5655N1000
Applicable component levels
R220 PSY UK66073
UP11/04/03 P F103
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.2.0"}]
Document Information
Modified date:
30 March 2021