grant use on the tablespace



"Varma Jampana " <db2udbdba-ezmlmshield-x19548520.[Email address protected]

09/23/2004 02:13 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Error






Hi

I am new to DB2. When, I try to create a table, I got the following error
regarding the state of Tablespace.

------------------
SQL0290N Table space access is not allowed.

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.

------------------

Please advise me how to see the state of the Tablespace and how to set to
valid state.

Thanks

Kris




---------------------------------------------------------------------
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