A fix is available
APAR status
Closed as program error.
Error description
When UNLOAD from an image copy for a table that has a clone, the unload from the image copy when the instance number on the image copy matches the instance on the tablespace (SYSIBM.SYSTABLESPACE), receives error DSNU1408I. When the instance numbers are different, get message DSNU1227I.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 9 for z/OS, and DB2 10 for z/OS * * utility users. * **************************************************************** * PROBLEM DESCRIPTION: MSGDSNU1227I RC=8 or MSGDSNU1408I RC=4 * * and no rows unloaded with UNLOAD * * FROMCOPY of an object involved with * * cloning. * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available. * **************************************************************** With clone tables a base and clone table have identical object identifiers except for the high order bit which identifies which data set contains the data for the object. As EXCHANGEs are done the instance numbers change making it look like the data was physically moved. Data set header pages do not change during the EXCHANGE process but they do contain object identifier information. Because the header page information does not change but the object identifiers do change (the object identifier high order bits are toggled) during the EXCHANGE process it's possible to have the UNLOAD utility fail because of object id mismatches as reported: 1 - MSGDSNU1227I is issued and the job terminates with RC=8. Message text: DSNU1227I csect-name - THE CONTENT OF THE IMAGE COPY DATA SET IS INCONSISTENT WITH TABLE SPACE table-space 2 - MSGDSNU1408I is issued and the job terminates with RC=4. Message text: DSNU1408I csect-name - SOURCE DATA SET dsname DOES NOT MATCH obj-type obj-qual.obj-name DSNUM n In the cloning cases we will now no longer halt UNLOAD processing if the only difference in the object identifiers is the high order bit. This also means that the DSNU1227I and DSNU1408I messages will no longer be issued in these cases. Caution: it should be noted that the removal of this restriction will now allow clone and/or base table data to be UNLOADed using image copy data sets from the other table in the clone relationship as follows: 1 - UNLOAD from base table using a clone table image copy. 2 - UNLOAD from clone table using a base table image copy.
Problem conclusion
UNLOAD FROMCOPY utility code has been modified so that it will now continue in cases where it would previously fail with the DSNU1408I or DSNU1227I messages when the only difference was in the object identifier high order bits.
Temporary fix
Comments
APAR Information
APAR number
PM50006
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-10-13
Closed date
2011-12-28
Last modified date
2012-02-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK75124 UK75125
Modules/Macros
DSNUULCA DSNUULCB
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
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":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 February 2012