Joined: 01 Mar 2006 Posts: 278 Location: Basel, Switzerland
hy stly,
check first, which kind of resource is in an unavailable state.
if it is the table space or the table itself, then this tablespace
might be in status 'check pending.
issue a 'START TABLESPACE..' with 'FORCE..'
note: it can be the index space as well.
maybe someone reloaded the tables in this tablespace...?
hi amrtin,
can u expalin m ein clear that how to find out teh the unavailable resouces and how to solve it.can u give teh clear expanation how to proceed
Joined: 01 Mar 2006 Posts: 278 Location: Basel, Switzerland
hy stly,
use the DISPLAY DATABASE command...
-DISPLAY DATABASE (*) SPACE (*) LIMIT (*) RESTRICT
DISPLAY DATABASE command
If a table is loaded without enforcing referential constraints on its
foreign key columns, it can contain data that violates the constraints.
The table space containing the table is placed in the check-pending
status. You can determine which table spaces are in that status by using
the DISPLAY DATABASE command with the RESTRICT option. You can also
display table spaces with invalid LOBs. See Chapter 2 of DB2 Command
Reference for information about using this command.
