Posted: Thu Apr 09, 2009 4:05 pm Post subject: resource unavailable..table is not accessible
I have executed a select qury on the table,its giving -904 error, showing the resource unavailable. the resource its saying the related tablespace partion datasetname.now i checked for the datset on 3.4 on ispf its not available.I checked for the related tablespace and database and associated storagegroup name too, all are present but that dataset is not available.What reason can it be there?can anyone please help me?
Thanks in advance....
You will get this error , if the table(s) is locked by some other process. You may need to restart your job. If you are getting that error conistently, use the following db2 command to know more details.
-DISPLAY DB(database name) SPACE(table space name) LIMIT(*)
Use below command to start database again.
-START DB(Tdatabase name) SPACENAM(table space name) ACCESS(FORCE)
I advise you to contact your DBA, before doing all these. _________________ Natarajan
Joined: 09 Aug 2008 Posts: 1631 Location: Mumbai, India
Posted: Fri Apr 10, 2009 2:42 pm Post subject:
What reason can it be there?
You've already give the explanation. The SQL statement could not be executed because resource resource-name of type resource-type was not available at the time for the reason indicated by reason-code. Suggest you get in cotact with you DBA/support. Any solution from Forum would not help you much . . . _________________ Regards,
The OP posted this same question in another forum, and eventually provided the reason code:
Unavailable Resource Reason 00d70024, TYPE=220 ....
And in the other forum, the appropriate answer:
means DB2 Table Migrated.
suggest that this thread be locked.
In the future, anyone posting a -904 problem without the reason code
should be ignored until the reason code is provided,
so that we can do the research,
since the OP can not do his own. _________________ Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
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