Sunday, September 27, 2009

Pending Status - DB2

COPY pending status - COPY
How to reset?: Take image copy.


REBUILD pending – RBDP
How to reset?: REBUILD, RECOVER, LOAD REPLACE, REPAIR SET INDEX with NORBDPEND, Start ACCESS FORCE, REORG INDEX SORTDATA


RECOVER pending – RECP
How to reset?: For TS: Run RECOVER or LOAD REPLACE, REPAIR SET TABLESPACE with NORCVRPEND
-For index: REBUILD INDEX, RECOVER INDEX or REORG INDEX SORTDATA, REPAIR SET INDEX with NORCVRPEND
-For both: START ACCESS FORCE (data will not be fixed)


REORG pending – REORP
How to reset?: Run LOAD REPLACE, Run REORG with SHRLEVEL NONE,


REFRESH pending – REFP
Whenever DB2 puts an object in REFP status, it also put that object in Recover pending (RECP) status as well.
How to reset?: Run RECOVER and LOAD REPLACE.


Group BP RECOVER pending- GRECP
How to reset?: Recover the object, or use START DATABASE


Restart pending: RESTP
The restart pending status is set on if an object has back-out work pending at the end of DB2 restart TS, IX
How to reset?: Objects in the RESTP status remain unavailable until back-out work is complete, or until restart is canceled and a conditional restart or cold start is performed in its place.

No comments:

Post a Comment