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
 

 

Need suggestions on SQLCODE -904

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

New User


Joined: 05 May 2006
Posts: 12
Location: Pune

PostPosted: Tue Oct 31, 2006 9:44 pm    Post subject: Need suggestions on SQLCODE -904
Reply with quote

Hi,

Can any one suggest me what are the possibilties for getting
SQLCODE -904 and how can we resolve that.

I am facing the below error , while executing COBOL-DB2 component.

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABL RESOURCE 00000210, AND RESOURCE NAME TSHRT .SSHTRME .00000015
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE.

Thanks,
Ramesh.
Back to top
View user's profile Send private message

MFRASHEED

Active User


Joined: 14 Jun 2005
Posts: 186
Location: USA

PostPosted: Tue Oct 31, 2006 9:49 pm    Post subject: Re: Need suggestions on SQLCODE -904
Reply with quote

This is previosly discussed topic, just search forum with -904 and you will get information, one such link is

http://ibmmainframes.com/viewtopic.php?t=14960&highlight=904
Back to top
View user's profile Send private message
ramsfm

New User


Joined: 05 May 2006
Posts: 12
Location: Pune

PostPosted: Wed Nov 01, 2006 4:04 pm    Post subject: Re: Need suggestions on SQLCODE -904
Reply with quote

Thanks for reply.

I want to check whether that table is exiting in dev region or not,
is it possible to know by excuting any sql or by seraching any catalog tables.

Please help on that.
Back to top
View user's profile Send private message
harry

New User


Joined: 27 Mar 2006
Posts: 31

PostPosted: Wed Nov 01, 2006 4:12 pm    Post subject: Re: Need suggestions on SQLCODE -904
Reply with quote

Hi,

After each load we have to firstly take the imagecopy of the database.If next time you will try to load the data or you want to do any operation with Db-2 it will give you the sql return of -904.

Here in your case PART 210 OF YOUR DATA BASE IS CREAING THE PROBLEM SO YOU HAVE TO TAKE THE IMAGECOPY BY FOLLOWING COMMANDS:

INCLUDE TABLESPACES TABLESPACE DATABASE.TABLESPACE PARTLEVEL (210)

Hope it will resolve your problem.

Regards
Harry
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 SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am
No new posts -81 SQLCODE returned when Remote Stor... kameswaramanoj.Akella DB2 1 Wed Dec 03, 2014 5:36 am


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