check tablespace status, may be tablespace in backup pending state

db2 list tablespaces show detail

check for status, if it is backup pending state, take tablespace backup , or
db backup , based on your possibility.

db2 backup db dbname tablespace tablespacename online to backuplocation


Let me know , if any questions or issues.


Thank You

Lekharaju Ennam



-----Original Message-----
From: Varma Jampana
[mailto:db2udbdba-ezmlmshield-x19548520.[Email address protected]
Sent: Thursday, September 23, 2004 2:14 PM
To: LazyDBA Discussion
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