A fix is available
APAR status
Closed as program error.
Error description
In DB2 Administration Tool for z/OS, when Tablespace is altered leaving the tablespace in REORG PENDING state, optional COPY utility fails or if COPY not specified, REORG utility fails with RC=08 and message DSNU212I. . Additional Symptoms: rc08 msgDSNU212I
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: Background utility REBUILD for an index * * can fail if the table space containing * * the table to which the index is * * attached is in a restrictive state. * * DSNU212I csect-name - REORG PENDING ON * * TABLE SPACE database.index-name * * PROHIBITS PROCESSING error will occur * * in this situation. Background utility * * REORG for a partitioned table space * * can fail if there is an index attached * * to the table in that table space in * * PSRBD-pending state and the entire * * table space is not reorganized. * * DSNU204I csect-name - PAGESET REBUILD * * PENDING ON obj-type obj-qual.obj-name * * PROHIBITS PROCESSING will occur in * * this situation. Background utilities * * are run by ADBTEP2 to take objects * * out of respective DB2 states (i.e. if * * a change puts an object into check * * pending status (CHKP)), the result * * will produce SQLCODE162 which will * * cause ADBTEP2 to run a check data * * against the relevant table space. * * We run the equivalent utility if an * * object gets put into reorg-pending * * (REORP) as well. Same with rebuild * * pending. * **************************************************************** * RECOMMENDATION: * **************************************************************** The ADBTEP2 logic has now changed to check for and resolve table space restrictive states before the index background utilities are attempted. Currently the table space is not always checked and, even if it were, it would not always run the utility for the table space first. Additionally, if a table space is in REORG-pending state and it has an index in PSRBD-state, the REORG of the table space will be escalated to reorganize the entire table space.
Problem conclusion
Problem has been resolved. Existing Work Statement Lists (WSL) will not be affected.
Temporary fix
Comments
APAR Information
APAR number
PM26759
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-11-15
Closed date
2011-06-27
Last modified date
2011-07-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBTEPR ADBTEP2
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK69177
UP11/06/30 P F106
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":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
05 July 2011