IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SQL -904 Error


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kumar1234

New User


Joined: 06 Nov 2007
Posts: 84
Location: bangalore

PostPosted: Tue Oct 18, 2011 4:49 pm
Reply with quote

Hi,

Here is the Error while running a DB2 Cobol program,

SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D70014, TYPE OF RESOURCE 00000200, AND
RESOURCE NAME GIWHS$01.WHSX02$$
SQLSTATE = 57011 SQLSTATE RETURN CODE
SQLERRP = DSNXRUID SQL PROCEDURE DETECTING ERROR
SQLERRD = -110 13172746 0 13230791 -674693120 0 SQL DIAGNOSTIC
INFORMATION
SQLERRD = X'FFFFFF92' X'00C9000A' X'00000000' X'00C9E2C7'
X'D7C90000' X'00000000' SQL DIAGNOSTIC INFORMATION


I checked the table GIWHS$01.WHSX02$$ is not there in test,prod or QA. Could you please let me know why is it giving this message when this table is not used anywhere in the program.

Thanks.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Oct 18, 2011 4:55 pm
Reply with quote

suggest you look in sysibm.systables for ddname and tsname eq to those values.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Oct 18, 2011 6:31 pm
Reply with quote

DB2 for z/OS Codes
-904 => publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2z9.doc.codes/src/tpc/n904.htm

00D70014 => publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2z9.doc.codes/src/tpc/00d70014.htm

resource types => publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2z9.doc.codes/src/tpc/db2z_resourcetypes.htm
Back to top
View user's profile Send private message
kumar1234

New User


Joined: 06 Nov 2007
Posts: 84
Location: bangalore

PostPosted: Wed Oct 19, 2011 11:44 am
Reply with quote

But why is it giving sql -904 error for table GIWHS$01.WHSX02$$
when it is not used anywhere in the program ?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Wed Oct 19, 2011 12:45 pm
Reply with quote

maybe because GIWHS$01.WHSX02$$ is not a table, but a tablespace
Back to top
View user's profile Send private message
kumar1234

New User


Joined: 06 Nov 2007
Posts: 84
Location: bangalore

PostPosted: Wed Oct 19, 2011 3:18 pm
Reply with quote

Any ways we can solve this issue ? Please let me know on this...
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Oct 19, 2011 4:23 pm
Reply with quote

dbzTHEdinosauer wrote:
suggest you look in sysibm.systables for ddname and tsname eq to those values.


you can determine the object by the above,
and using the link that Guyc provided for the 00D70014
you will see that something is running out of room.

would also suggest a career change
if you are going to do nothing to increase your problem solving skillset.
Back to top
View user's profile Send private message
kumar1234

New User


Joined: 06 Nov 2007
Posts: 84
Location: bangalore

PostPosted: Wed Oct 19, 2011 4:54 pm
Reply with quote

Thanks for showing your concern about my career change....... let me know if there are any openings..
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Oct 19, 2011 5:04 pm
Reply with quote

Sure, there is a need for ditch-diggers everywhere.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Wed Oct 19, 2011 5:10 pm
Reply with quote

do you understand these sentences ?
Quote:
An attempt to extend a data set failed

Quote:
System programmer response:
Notify the database administrator if appropriate. Otherwise, check the packs available to the data set. They may merely be full or the data set may have reached its maximum allowable extents
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Oct 19, 2011 5:13 pm
Reply with quote

the concern is not for Your career, but for our sanity icon_cool.gif

it pretty pissing to post continuously the links to the manual pages
where things are clearly explained and
see that people keep asking dumb questions
...
You were pointed to the manual
Quote:
resource types => publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2z9.doc.codes/src/tpc/db2z_resourcetypes.htm

the manual explained that the resource type 200 is a tablespace
Quote:
00000200 Table space DB.SP

why in &heaven You kept asking about which table
Back to top
View user's profile Send private message
kumar1234

New User


Joined: 06 Nov 2007
Posts: 84
Location: bangalore

PostPosted: Wed Oct 19, 2011 5:13 pm
Reply with quote

Thanks for the info........ This is a technical queries forum and people might have easiest to toughest technical queries in Mainframe. We must have patience to answer or if not do not answer.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Wed Oct 19, 2011 5:18 pm
Reply with quote

did you forget that you had the same issue 2 months ago ?
ibmmainframes.com/viewtopic.php?p=149050&highlight=#149050
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Oct 19, 2011 5:21 pm
Reply with quote

Quote:
We must have patience to answer or if not do not answer.

but the people who expect good help should have the decency of doing a bit of homework themselves
and do not have any right/reason to expect to be diapered/spoon fed

and since we do for free (*) some of the work You are getting paid for we have the right to comment in <any>way we feel appropriate

(*) yess, also helping is doing part of Your job
Quote:
did you forget that you had the same issue 2 months ago ?
ibmmainframes.com/viewtopic.php?p=149050&highlight=#149050

care to comment about our lack of patience and Your <any derogatory attribute>
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania

PostPosted: Wed Oct 19, 2011 5:26 pm
Reply with quote

Kumar,

Lets read between the lines on your comments. This is my interpetation.

Be honest (only with yourself) if this translation is true.

Quote:
Any ways

Translation: Table or Tablespace, I do not care (do I even want to know the difference)

Quote:
we can solve this issue ?

Translation: I said we, but I really mean you are to solve the issue.

Quote:
Please let me know on this...

Translation: I am not going to solve this, so please tell me the answer.

Quote:
Thanks for the info........

Translation: Not really, just give me the answer already, not where to look for it myself.

Quote:
This is a technical queries forum and people might have easiest to toughest technical queries in Mainframe.

Translation: This stuff is too hard for me, that is why I am posting here.

Quote:
We must have patience to answer or if not do not answer.

Translation: Either give me the answer or do not post at all. All this help my career stuff is a waste of my time.
Back to top
View user's profile Send private message
kumar1234

New User


Joined: 06 Nov 2007
Posts: 84
Location: bangalore

PostPosted: Wed Oct 19, 2011 5:31 pm
Reply with quote

This is the first time I am posting such issue.... May be someone would have posted....
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Oct 19, 2011 5:35 pm
Reply with quote

current topic
Quote:
Could you please let me know why is it giving this message when this table is not used anywhere in the program.


Your previous linked topic
Quote:
The table name mentioned is not used any where in the prog


maybe it was Your clone who posted that icon_evil.gif
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Wed Oct 19, 2011 6:12 pm
Reply with quote

kumar1234 wrote:
This is the first time I am posting such issue.... May be someone would have posted....

The alleged skills are not yours, then, but are claimed by the person that you stole this ID from?
Back to top
View user's profile Send private message
kumar1234

New User


Joined: 06 Nov 2007
Posts: 84
Location: bangalore

PostPosted: Wed Oct 19, 2011 6:17 pm
Reply with quote

Both the Quotes are mine but not 2 months back, I had posted it only today.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Oct 19, 2011 6:21 pm
Reply with quote

icon_redface.gif You are right we misquoted ...

the post is not two months old it is quite older
Quote:
Mon Aug 18, 2008 3:12 pm
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Wed Oct 19, 2011 6:38 pm
Reply with quote

Wow, I didn't even look at the year. I assumed that anyone with more than 1 year experience ... yada yada yada
Back to top
View user's profile Send private message
kumar1234

New User


Joined: 06 Nov 2007
Posts: 84
Location: bangalore

PostPosted: Wed Oct 19, 2011 6:54 pm
Reply with quote

Finally, I tried testing pointing the DB2 tables to QA and now it is not giving -904, but only when pointing to TEST DB2 tables it is giving -904.

I guess it is some table space issues in test.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Error while running web tool kit REXX... CLIST & REXX 5
No new posts Getting Error while trying to establi... DB2 3
Search our Forums:

Back to Top