I think the last person that replied showed you exactly how to see the
status of the tablespace. If you dont want to list it to
see whats wrong you could just drop it and create it again. Of course this
would remove all the data.
Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]
"Vasan
Subramanian "
<db2udbdba-ezmlms To
hield-x22996714.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc
11/17/2004 01:59 Subject
AM Re: Table Space Error
can you please tell me how to see the status of the tablespace. No where
I could guess what has happened. Moreover, the database is also not
huge. It was a test database which I created in the begining of my
learnings in DB2.
Please advise me about how to overcome this problem.
>>> "Paul_Murphy"
<db2udbdba-ezmlmshield-x711031.[Email address protected] 11/16/04 8:40 PM
>>>
So far, I've only seen wrong answers. The reason for the error is
because
the state of the tablespace is such that access to it is prohibited. If
you execute DB2 LIST TABLESPACES SHOW DETAIL you will see the value for
the state in hex format.
If you are using the DB2 Control Center, select the database, then
choose
tablespaces and finally select the tablespace for the table in question.
It may be that it is in backup pending or load pending status. Did you
have a failed load to the table? Once you check this out, you will be
able to resolve the situation and access will be restored.
You may have a difficulty if you have all your tables in one tablespace.
If that is the case and you do not know which table is having the
problem,
your problem resolution has multiplied.
"Vasan Subramanian "
<db2udbdba-ezmlmshield-x47316604.[Email address protected]
11/16/2004 02:59 AM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
Table Space Error
Hi,
When I try to execute a stored procedure, Iam getting the following
error.:-
"SQL0290N Table Space Access is not allowed.SQLSTATE = 55039"
Moreover, when I try to alter the tablespace size, by adding one more
containers to the table space, Iam getting the following error:-
[IBM][CLI Driver][DB2/NT] SQL0290N Table space access is not allowed.
SQLSTATE=55039
Explanation:
A process attempted to access a table space which is in an
invalid state for which the intended access is not allowed.
o If the table space is in a quiesced state, only processes
which also hold the table space in a quiesced state are
allowed access to the table space.
o If the table space is in any other state, only the process
which is performing the action specified is allowed access to
the table space.
o A system or user temporary table space cannot be dropped
which contains active system or declared temporary tables.
o The SET CONTAINER api cannot be used to set the container list
unless the table space is in a "restore pending" state.
User Response:
Possible actions include:
o If the table space is in a quiesced state, attempt to acquire
a quiesced share or quiesced update state on the table space.
Or, attempt to quiesce reset the table space.
o If the table space is in any other state, wait until the
table space has returned to normal state before attempting to
access the table space.
Refer to the Administration Guide for further information about
the table space states.
sqlcode : -290
sqlstate : 55039
Please help me out in solving this problem
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page