Please look into into reason Code that you are getting and
the tablespace should have "Use" privilege to access it.

Jayaprakash.

-----Original Message-----
From: Vasan Subramanian
[mailto:db2udbdba-ezmlmshield-x47316604.[Email address protected]
Sent: Tuesday, November 16, 2004 2:29 PM
To: LazyDBA Discussion
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

DB2 & UDB email list listserv db2-l LazyDBA home page