DB2:SQL0290N 不允许访问表空间。 SQLSTAT=55039

  


报错：
db2 => select count(*) from test
1          
-----------
SQL0290N  Table space access is not allowed.  SQLSTATE=55039




查看表空间状态：
Tablespace ID                        = 3
 Name                                 = music
 Type                                  = Database managed space
 Contents                             = All permanent data. Regular table space.
 State                                  = 0x4080                         ----状态异常
 Detailed explanation:
 Roll forward pending
 Offline


查看容器信息：


$ db2 list tablespace containers for 3


            Tablespace Containers for Tablespace 3


 Container ID                         = 0
 Name                                 = /dev/music
 Type                                 = Disk



查看容器文件的属主和读写权限：
$ ls -lt /dev/music
crw-rw----    1 root     system       48, 14 Nov 20 16:09 /dev/music             ----属主有问题


修改属主和权限：
root@eric/# chown db2inst1.db2iadm1 /dev/music
root@eric/# chmod 777 /dev/music
root@eric/# su - db2inst1

重启数据库实例：
$ db2stop force
12/29/2014 14:30:38     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.

$ db2start
12/29/2014 14:30:43     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.


连接数据库：
$ db2 connect to music

 Database Connection Information


 Database server          = DB2/AIX64 9.5.6
 SQL authorization ID   = DB2INST1
 Local database alias     = MUSIC

执行查询语句：
db2 => select count(*) from test


1          
-----------
 9821


  1 record(s) selected.