You need to grant the permission for that tablespace:
eg:
Grant user BOBBY the ability to create tables/alter tablespace in table space PLANS and to grant this privilege to others.

GRANT USE OF TABLESPACE PLANS TO BOBBY

Hope this helps
Yogesh Kansal

Vasan Subramanian <db2udbdba-ezmlmshield-x47316604.[Email address protected] wrote:
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



"The degree of normality in a database is inversely proportional to
that of its DBA"

---------------------------------
Do you Yahoo!?
Discover all that’s new in My Yahoo!

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