resource unavailable..table is not accessible

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
Posts: 9
Joined: Thu Apr 02, 2009 2:58 pm

resource unavailable..table is not accessible

Post by srilata83 » Thu Apr 09, 2009 4:05 pm

Hi All.
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 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....

User avatar
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai

Post by Natarajan » Fri Apr 10, 2009 2:41 pm

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.

Anuj Dhawan
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Fri Apr 10, 2009 2:42 pm

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 . . .

Anuj Dhawan
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Fri Apr 10, 2009 2:44 pm

Oh..Natrajan - you were just too fast. I asked them many times to change my keboard, but they don't . . . :P
Last edited by Anuj Dhawan on Fri Apr 10, 2009 3:43 pm, edited 2 times in total.

User avatar
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Fri Apr 10, 2009 2:58 pm

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.

Post Reply


Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Mainframe Interview questions

Other References
Mainframe Tools and others