DB2不支持LVM作为裸设备?
DB2不支持LVM作为裸设备?
redhat 6.5 + db2 10.1
lvcreate -n db2idxlv -L 60GB db2idxdg
Logical volume "db2idxlv" created
# lvcreate -n db2data1lv -L 300GB db2datavg
Logical volume "db2data1lv" created
# lvcreate -n db2data2lv -L 300GB db2datavg
Logical volume "db2data2lv" created
赋权
chown db2inst1.dasadm1 db2idxdg-db2idxlv
chown db2inst1.dasadm1 db2datavg*
建立表空间
db2 => create tablespace tpcc_idx managed by database using (device '/dev/mapper/db2idxdg-db2idxlv' 50G) bufferpool ibmdefaultbp
DB20000I The SQL command completed successfully.
db2 => create tablespace tpcc_data managed by database using (device '/dev/mapper/db2datavg-db2data1lv' 100G,device '/dev/mapper/db2datavg-db2data2lv' 100G) bufferpool ibmdefaultbp
DB20000I The SQL command completed successfully.
表空间的状态都是正确的
Tablespace ID = 4
Name = TPCC_IDX
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Tablespace ID = 5
Name = TPCC_DATA
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
但是建表就出现了问题
db2 "create table warehouse (w_id integer not null,w_ytd decimal(12,2),w_tax decimal(4,4),w_name varchar(10),w_street_1 varchar(20),w_street_2 varchar(20),w_city varchar(20),w_state char(2),w_zip char(9)) in tpcc_data index in tpcc_idx"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1034C The database is damaged. All applications processing the database
have been stopped. SQLSTATE=58031