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

SQLCODE = -904, REASON 00C90082,TYPE OF RESOURCE 00000201?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Oct 22, 2008 12:58 pm
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
www-03.ibm.com/systems/z/os/zos/bkserv/index.html#other_pubs

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

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

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

and ... bells and whistles ... the resource page
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Reorg abended with REASON=X'00E40347' DB2 2
No new posts REASON 00D70014 in load utility DB2 6
No new posts SMF record type 30 JCL & VSAM 8
No new posts SQLCODE = -122 while using the scalar... DB2 4
No new posts Selective extract of multi-record-typ... SYNCSORT 4
Search our Forums:

Back to Top