View previous topic :: View next topic
|
Author |
Message |
rohanthengal
Active User
Joined: 19 Mar 2009 Posts: 206 Location: Globe, India
|
|
|
|
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,
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 |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Did Load process fail? If so, find out why it failed. |
|
Back to top |
|
|
rohanthengal
Active User
Joined: 19 Mar 2009 Posts: 206 Location: Globe, India
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
rohanthengal
Active User
Joined: 19 Mar 2009 Posts: 206 Location: Globe, India
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
|