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

SQLCODE = -904 help


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Rameshkumar.R

New User


Joined: 15 May 2008
Posts: 9
Location: chennai

PostPosted: Fri Jul 24, 2009 4:38 pm
Reply with quote

SQLCODE = -904 error with type = 210 can anyone help me out with this abend
Thanks in advance[/img][/Search]
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri Jul 24, 2009 5:02 pm
Reply with quote

Just post using cut and paste. The amount of resource you have used up you must be using cut and waste icon_evil.gif .

Look HERE to see what the error code means.
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Fri Jul 24, 2009 7:03 pm
Reply with quote

The partition which you are trying to access is not available / archived .. try recalling the datasets or else do a REBUILD ....
Back to top
View user's profile Send private message
satyender

New User


Joined: 05 Jan 2008
Posts: 50
Location: Olympia, WA, USA

PostPosted: Tue Jul 28, 2009 9:12 pm
Reply with quote

Rameshkumar.R,


The dataset DBINVDEV.SCLTS00.00000001 might be archived.

Do HRECALL on the dataset and try again.

Tip:

Before doing any REORG, LOAD etc. do HRECALL.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Jul 29, 2009 11:29 am
Reply with quote

Best approach is to get in touch with your DBA and follow-up his instructions. Not every shop will allow to REORG/REBUILD the table to an application engineer...
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 SQLCODE = -122 while using the scalar... DB2 4
No new posts SQLCODE = -16002 when using XMLEXISTS DB2 1
No new posts Is SQLCODE -811 possible while fetchi... DB2 1
No new posts SQLCODE=-204 SQLSTATE=42704 DB2 4
No new posts Getting sqlcode 805 while executing R... DB2 10
Search our Forums:

Back to Top