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

Global Moderator


Joined: 14 Mar 2007
Posts: 10375
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 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
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm

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