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 after loading the tables

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rohanthengal

Active User


Joined: 19 Mar 2009
Posts: 181
Location: Globe, India

PostPosted: Thu Oct 13, 2011 11:41 am    Post subject: SQLCODE = -904 after loading the tables
Reply with quote

Hi, We loaded few tables in different tablespaces by using load utility from File-Aid for DB2 but after loading when we try to browse them, it is giving below error ---
'SQLCODE=-904 i.e. unavailable resource'

We tried few DB2 commands like --
-START DATABASE(XYZ)
-STOP DATABASE(XYZ)

but still we are facing the issue, icon_redface.gif

Can any DBA or any experienced person help to resolve this issue ?

I feel that while loading the tables, somewhere COPY remained pending.

Please correct if i am going wrong somewhere.

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

Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 788
Location: Chennai, India

PostPosted: Thu Oct 13, 2011 11:47 am    Post subject:
Reply with quote

Did Load process fail? If so, find out why it failed.
Back to top
View user's profile Send private message
rohanthengal

Active User


Joined: 19 Mar 2009
Posts: 181
Location: Globe, India

PostPosted: Thu Oct 13, 2011 11:51 am    Post subject:
Reply with quote

No Gnana, Load did not fail. Actually all the rows are loaded properly in the table when i compare them with load file.

But when we tried to edit the TABLE, it said SQLCODE=-904, i guess somewhere COPY is pending.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Thu Oct 13, 2011 11:51 am    Post subject: Reply to: SQLCODE = -904 after loading the tables
Reply with quote

Quote:
SQLCODE=-904 i.e. unavailable resource

You are not giving too much to work on !

did You care to read the full message and research Yourself a bit
the message should look something like
Quote:
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90096, TYPE OF RESOURCE 00000302, AND
RESOURCE NAME <resource name> .X'503D68'

the actions willbe different depending on which resources is unavailable
the reason and the resource type will tell the actions to take

why not have Your DBA involved?
instead of waiting for somebody else to do the job for which they are getting paid.

topic edited to add a comment after having looked at the TS profile
IBM certified DB2 associate
tells something about the value of certifications

I wonder how somebody can get certified without even having the skills of doing a bit of research on his own
Back to top
View user's profile Send private message
rohanthengal

Active User


Joined: 19 Mar 2009
Posts: 181
Location: Globe, India

PostPosted: Thu Oct 13, 2011 12:03 pm    Post subject:
Reply with quote

involving DBA may be a too much time taking or a longer process.
So i tried in our forum to dig out the solution for this.

I was loading the tables first time. We used 3.7 option in File-Aid for DB2, to load the tables. So i guess i might have gone wrong somewhere while loading.

I want to reset those table spaces in which tables are present so that i can delete all the rows again and load the data again.

Please let me know any solution that you have tried previously.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Thu Oct 13, 2011 12:06 pm    Post subject: Reply to: SQLCODE = -904 after loading the tables
Reply with quote

Quote:
involving DBA may be a too much time taking or a longer process.


nothing that You could not do Yourself!
a forum is not a remedy for laziness and/or poor organization

topic locked

any further topic/discussion/whining/complaint with/about this subject will be mercilessly deleted
and a warning issued , is that clear?!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    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 Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 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 Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts loading a Modified Mapset Susanta CICS 2 Tue Mar 14, 2017 5:43 pm

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