View previous topic :: View next topic
|
Author |
Message |
kumar1234
New User
Joined: 06 Nov 2007 Posts: 84 Location: bangalore
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
suggest you look in sysibm.systables for ddname and tsname eq to those values. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
Back to top |
|
|
kumar1234
New User
Joined: 06 Nov 2007 Posts: 84 Location: bangalore
|
|
|
|
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 |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
maybe because GIWHS$01.WHSX02$$ is not a table, but a tablespace |
|
Back to top |
|
|
kumar1234
New User
Joined: 06 Nov 2007 Posts: 84 Location: bangalore
|
|
|
|
Any ways we can solve this issue ? Please let me know on this... |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
kumar1234
New User
Joined: 06 Nov 2007 Posts: 84 Location: bangalore
|
|
|
|
Thanks for showing your concern about my career change....... let me know if there are any openings.. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Sure, there is a need for ditch-diggers everywhere. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
the concern is not for Your career, but for our sanity
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
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 |
|
|
kumar1234
New User
Joined: 06 Nov 2007 Posts: 84 Location: bangalore
|
|
|
|
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 |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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
care to comment about our lack of patience and Your <any derogatory attribute> |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
Kumar,
Lets read between the lines on your comments. This is my interpetation.
Be honest (only with yourself) if this translation is true.
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 |
|
|
kumar1234
New User
Joined: 06 Nov 2007 Posts: 84 Location: bangalore
|
|
|
|
This is the first time I am posting such issue.... May be someone would have posted.... |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
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 |
|
|
kumar1234
New User
Joined: 06 Nov 2007 Posts: 84 Location: bangalore
|
|
|
|
Both the Quotes are mine but not 2 months back, I had posted it only today. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
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 |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
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 |
|
|
kumar1234
New User
Joined: 06 Nov 2007 Posts: 84 Location: bangalore
|
|
|
|
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 |
|
|
|