Доброго времени суток, господа!

1) db2 => list tablespaces

Tablespaces for Current Database

Tablespace ID = 0
Name = SYSCATSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal

Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = Any data
State = 0x4000
Detailed explanation:
Offline
......................................................................................


2) select * from table

SQL0007N The character "&" following "select " is not valid. SQLSTATE=42601

3) db2 => LIST TABLESPACE CONTAINERS FOR 2 show detail

Tablespace Containers for Tablespace 2

Container ID = 0
Name = /dev/sdb1
Type = Disk
Total pages = 7864320
Useable pages = 7864288
Accessible = No
Container ID = 1
Name = /dev/sdb2
Type = Disk
Total pages = 7864320
Useable pages = 7864288
Accessible = No

предистория : ошибка в следствии физического падения сервера во время длинной транзакции
Диагноз: контейнеры табличного пространства Userspace1 находятся в down.
Вопрос:Как поднять табл.пространство ?

спасибо.

опечатка:

2) select * from table

SQL0290N Table space access is not allowed. SQLSTATE=55039

тема закрыта.
проблема в правах доступа.