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-db2idxlvchown 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 ibmdefaultbpDB20000I 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