IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

-904 abend


IBM Mainframe Forums -> ABENDS & Debugging
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
stly
Warnings : 1

New User


Joined: 25 Jul 2005
Posts: 93

PostPosted: Sat Apr 01, 2006 11:09 am
Reply with quote

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
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland

PostPosted: Sat Apr 01, 2006 3:00 pm
Reply with quote

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
View user's profile Send private message
stly
Warnings : 1

New User


Joined: 25 Jul 2005
Posts: 93

PostPosted: Mon Apr 03, 2006 11:43 am
Reply with quote

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
View user's profile Send private message
stly
Warnings : 1

New User


Joined: 25 Jul 2005
Posts: 93

PostPosted: Tue Apr 11, 2006 11:48 am
Reply with quote

can any one clarify me how to resolve -904.how to look out teh resouces available nr the unavailable resources
Back to top
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland

PostPosted: Tue Apr 11, 2006 3:18 pm
Reply with quote

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
View user's profile Send private message
stly
Warnings : 1

New User


Joined: 25 Jul 2005
Posts: 93

PostPosted: Wed Apr 19, 2006 3:30 pm
Reply with quote

thank u very much
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> ABENDS & Debugging

 


Similar Topics
Topic Forum Replies
No new posts ISAM and abend S03B JCL & VSAM 9
No new posts Abend S0C4 11 (Page Translation Excep... PL/I & Assembler 16
No new posts WER999A - UNSUCCESSFUL SORT 8ED U Ab... SYNCSORT 5
No new posts the system or user abend SF0F R=NULL COBOL Programming 0
No new posts Need to get an DLI abend like U0200 IMS DB/DC 2
Search our Forums:

Back to Top