Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SQL -904 Error
Goto page 1, 2  Next
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: SQL -904 Error
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    Post subject:
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: 1278
Location: Belgium

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

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

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

resource types => http://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    Post subject: Reply to: SQL -904 Error
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: 1278
Location: Belgium

PostPosted: Wed Oct 19, 2011 12:45 pm    Post subject:
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    Post subject: Reply to: SQL -904 Error
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    Post subject:
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    Post subject: Reply to: SQL -904 Error
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    Post subject:
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: 1278
Location: Belgium

PostPosted: Wed Oct 19, 2011 5:10 pm    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Wed Oct 19, 2011 5:13 pm    Post subject: Reply to: SQL -904 Error
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 => http://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    Post subject: Reply to: SQL -904 Error
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: 1278
Location: Belgium

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

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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Wed Oct 19, 2011 5:21 pm    Post subject: Reply to: SQL -904 Error
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 ?
http://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: 645
Location: Pennsylvania

PostPosted: Wed Oct 19, 2011 5:26 pm    Post subject:
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    Post subject: Reply to: SQL -904 Error
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Wed Oct 19, 2011 5:35 pm    Post subject: Reply to: SQL -904 Error
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: 1738
Location: Bloomington, IL

PostPosted: Wed Oct 19, 2011 6:12 pm    Post subject: Re: Reply to: SQL -904 Error
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    Post subject: Reply to: SQL -904 Error
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Wed Oct 19, 2011 6:21 pm    Post subject: Reply to: SQL -904 Error
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Goto page 1, 2  Next
Page 1 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm
No new posts IDMS/DC-COBOL program - SNAP error wh... rakeshsekar1987 IDMS/ADSO 5 Tue Sep 13, 2016 8:28 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us