View previous topic :: View next topic
|
Author |
Message |
stly Warnings : 1 New User
Joined: 25 Jul 2005 Posts: 93
|
|
|
|
i got -904 abend unavailable resources.how to see the resources that r unavailable n all other rseouces related n how to solve that problem |
|
Back to top |
|
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 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...?
martin9 |
|
Back to top |
|
|
stly Warnings : 1 New User
Joined: 25 Jul 2005 Posts: 93
|
|
|
|
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 |
|
Back to top |
|
|
stly Warnings : 1 New User
Joined: 25 Jul 2005 Posts: 93
|
|
|
|
can any one clarify me how to resolve -904.how to look out teh resouces available nr the unavailable resources |
|
Back to top |
|
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 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.
martin9 |
|
Back to top |
|
|
stly Warnings : 1 New User
Joined: 25 Jul 2005 Posts: 93
|
|
|
|
thank u very much |
|
Back to top |
|
|
|