REDHAT 6.2 + 10.1
权限没有问题
# chown db2inst1.dasadm1 sdg
# ls -alt /dev/sdg
brw-rw---- 1 db2inst1 dasadm1 8, 96 Sep 15 19:14 /dev/sdg
建立表空间成功
db2 "create tablespace data managed by database using (device'/dev/sdg' 10g)"
DB20000I The SQL command completed successfully.
Tablespace ID = 4
Name = DATA
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Totalpages = 2621440
Useablepages = 2621408
Usedpages = 96
Freepages = 2621312
High water mark(pages) = 96
Page size(bytes) = 4096
Extent size(pages) = 32
Prefetch size(pages) = 32
Number ofcontainers = 1
但是为什么这里的Accessible却是No
db2 list tablespace containers for 4 show detail
Tablespace Containers for Tablespace 4
ContainerID = 0
Name = /dev/sdg
Type = Disk
Totalpages = 2621440
Useablepages = 2621408
Accessible = No