A fix is available
APAR status
Closed as program error.
Error description
After cloning the target DB2 system is trying to access source data sets. DSNB204I xxxx OPEN OF DATA SET FAILED. DSNAME=yyyy Where yyyy is a source data set name. The DB2 directory LOB space DSNDB01.SYSDBDXA has multiple data sets and DB2 Cloning Tool is not updating all the data sets.
Local fix
Run REPAIR DBD REBUILD against all databases excluding DSNDB01 and DSNDB06. After the REPAIR DBD REBUILD has run the databases may be in UT mode and a START DATABASE(database-name) ACCESS(RW) command will be needed. All trigger packages that are associated with tables in the database are invalidated and a rebind will be needed those those trigger packages.
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Cloning Tool. * **************************************************************** * PROBLEM DESCRIPTION: After cloning the target DB2 system is * * trying to access source data sets. * * DSNB204I xxxx OPEN OF DATA SET FAILED. * * DSNAME=yyyy Where yyyy is a source * * data set name. The DB2 directory LOB * * space DSNDB01.SYSDBDXA has multiple * * data sets and DB2 Cloning Tool is not * * updating all the data sets. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM56808
Reported component name
DB2 CLONING TOO
Reported component ID
5655N1000
Reported release
220
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-01-26
Closed date
2012-02-16
Last modified date
2012-03-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK76297
Modules/Macros
CKZ00224
Fix information
Fixed component name
DB2 CLONING TOO
Fixed component ID
5655N1000
Applicable component levels
R220 PSY UK76297
UP12/02/22 P F202
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.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021