Before DB2 Universal Database Version 6, if a regular, long, or temporary table space was damaged or missing and circular logging was used, a connection to the database failed. If the problem was not corrected, the database would have to be restored from a backup.
DB2 Universal Database Version 6 has addressed this shortcoming. When a regular, long or temporary table space is damaged or missing, the table space reverts to OFFLINE state and the connection to the database will succeed, even if circular logging is used. This change improves your ability to handle temporary table spaces, because now there is nothing to recover from a temporary table space, except in a REORG situation. For example, once a connection is established, there are ways to bring your database up:
If log retain is on (log archival), and a regular, long, or temporary table space is damaged or missing, the connect succeeds and the table space is put in a rollforward pending state.
If the table space is accessed while the database is up, an error is returned (SQL0290N Table space access is not allowed).
For regular tables spaces, dropping may be possible, even if this is the only user table space.
If a table spans multiple table spaces, dropping is not possible.
If it is a temporary table space and there are no others, then anything that requires a temporary table to be created will fail with an error. For example, if you try to create an index over a table, you may get "SQL0290N Table space access is not allowed". The reorganization of a table using this temporary table space may return "SQL2216N SQL error --290 was found while reorganizing a database table." If the temporary table space is the only one, you cannot drop it. DB2 prevents a user from dropping the only temporary table space in the database. In this case, the error message is "SQL0283N Temporary table space "TEMPSPACE1" cannot be dropped because it is the only temporary table space with a 4K page size in the database". The solution is to create a new temporary table space before dropping the old one.