MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

-904 Sqlcode??

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
Narsimha
Beginner


Joined: 03 Dec 2002
Posts: 27
Topics: 14

PostPosted: Tue Feb 04, 2003 7:38 am    Post subject: -904 Sqlcode?? Reply with quote

Hi,

When I am selecting rows in a table from fileaid browse option, It is throwing the error -904(Unavailable resource). There is an online transaction which is accessing this table and performs some updates in the table. How to find exectly where the error is coming? I don't have access to DB2 commands option to display database. Or any transaction is holding the table? Please find the following info from Fileaid.

SQLCODE: -904
ERROR : 00C90081.00000200.DAOMS03T.MP44001T
Explanation:
The SQL statement cannot be executed because a resource is
not available. Your program has timed out. Check with other
users and refer to the IBM DB2 Messages and Codes manual.

Thanks,
Narsimha
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Tue Feb 04, 2003 7:53 am    Post subject: Reply with quote

Narsimha,

A -904 abend usually caused by an UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE

Here in your case you also have the exact error message pertaining to -904.
Code:

Error:reason-code,resource-type,resource-name

In your case it is
Code:

Error:00C90081.00000200.DAOMS03T.MP44001T


Check this link for reason-code 00C90081

Check this link for resource-type 00000200


DAOMS03T.MP44001T is the table name.

From the error messages I see that your table space DAOMS03T is STOPPED. So the table MP44001T cannot be accessed.

So check with your DBA as to why the tablespace is stopped.

Hope this helps...

cheers

kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group