PM56808: DSNB204I XXXX OPEN OF DATA SET FAILED. DSNAME=YYYY

Obtain the fix for this APAR.

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 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.