Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SQLCODE = -904, REASON 00C90082,TYPE OF RESOURCE 00000201?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
itjagadesh

New User


Joined: 05 Dec 2006
Posts: 89
Location: chennai

PostPosted: Wed Oct 22, 2008 12:39 pm    Post subject: SQLCODE = -904, REASON 00C90082,TYPE OF RESOURCE 00000201?
Reply with quote

Hi All,
i am getting SQLCODE = -904 ,REASON 00C90082,TYPE OF RESOURCE 00000201 while submitting Job.
Can anyone please tell me which resource it is refering .
for example
TYPE OF RESOURCE 00000201 - is it for tablespace or indexspace or which resource it is refering?

How to resolve that above error? i am not able to find which resource it is refering.
For your reference im attaching error below


DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90082, TYPE OF RESOURCE
00000201, AND RESOURCE NAME J9INVMAT.XINVREF3
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR

Please advice me how to resolve the above error.
Thanks in advance
Jagadesh
Back to top
View user's profile Send private message

enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10479
Location: italy

PostPosted: Wed Oct 22, 2008 12:58 pm    Post subject: Reply to: SQLCODE = -904, REASON 00C90082,TYPE OF RESOURCE 0
Reply with quote

if You had cared to look at the manual You would have seen that the
DSNT408I message description has everything You need to find that info

start from
http://www-03.ibm.com/systems/z/os/zos/bkserv/index.html#other_pubs

use the lookat facility
http://www-03.ibm.com/systems/z/os/zos/bkserv/lookat/

the message page
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNM1J12/2.16.134?SHELF=&DT=20061207174325&CASE=

appendix1.1.... problem determination
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNM1J12/APPENDIX1.1?DT=20061207174325#HDRAPPX

and ... bells and whistles ... the resource page
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNM1J12/APPENDIX1.1.2?DT=20061207174325#HDRRT
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
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts UNIX System Services Resource Busy Martin Wickenden All Other Mainframe Topics 3 Thu Jun 14, 2018 5:51 pm
No new posts SQLCODE 518 while executing DB2 module. abdulrafi DB2 8 Wed Feb 07, 2018 10:46 am
No new posts SQLCODE=100 and SQLSTAE 02000 pshongal DB2 12 Fri Jan 19, 2018 10:14 am
No new posts Setting Font Type for XMIT satish.ms10 All Other Mainframe Topics 3 Fri Sep 15, 2017 10:01 pm
No new posts Finding IMS resource blocker after se... Hooman24 IMS DB/DC 1 Wed Aug 16, 2017 9:17 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us