View previous topic :: View next topic |
Author |
Message |
Narsimha Beginner
Joined: 03 Dec 2002 Posts: 27 Topics: 14
|
Posted: Tue Feb 04, 2003 7:38 am Post subject: -904 Sqlcode?? |
|
|
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 |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Tue Feb 04, 2003 7:53 am Post subject: |
|
|
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 |
|
|
|
|