MVSFORUMS.com

syedfasi · Posted: Sat Feb 05, 2005 5:01 pm Post subject: SQLCODE = -904 Error

Hi All

Iam trying to run a simple query, but iam keep getting an error RESOURCE UNAVAILABLE. When I DEBUG the program it was showing SQLCODE = -904.

Please let me know why iam getting this error and how to resolve this issues.

Thanks in advance
Friend

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

syedfasi,
Check with the DBA's. The table maybe in a copy pending status after mainentance.

arunkumar_e · Posted: Wed Mar 09, 2005 11:34 pm Post subject:

Syedfasi,
I Guess its due to large amount of data being fetched from your querry.Try to use
Partitions and run the querry.
_________________
Arun
"Genius is one percent inspiration and ninety-nine percent perspiration." -- Thomas A. Edison

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

There are lots and lots of reasons, why an "unavailable ressource" condition can occur. Associated with this sqlcode there are valuable informations in the SQLCA:
- a reason code (usually in the pattern 00E12345)
- a ressource type (is it a tablespace, a table, a package ?)
- a ressource name

ONLY with these informations you are able to analyze the error situation.

regards
Christian