Table space in offline state.

[tbt102]

A system temporary table space in my database went to an offline state. Not sure how or why. The buffer pool looks OK.

How can I bring it back to normal state?

Environment
===========
Windows NT 4.0 service pack 5
DB2 UDB v7 fixpac DWC_WR21254

Thanks in advance for any help.

 

[dbmsguy]

try doing:

alter tablespace tsname switch online


Paul

http://www.dbmsguy.com