2008-4-29 12:13
bellman
db2 使用裸设备创建表空间的问题
db2 8.14 FP7 AIX 5.3L
首先创建裸设备
mklv -y test -t raw datavg 20
chown db2inst1:db2grp1 /dev/*test
然后执行命令
su - db2inst1
db2
db2=> create regular tablespace tbstest managed by database usint (device '/dev/rtest' 256000)
系统提示
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0298N Bad container path. SQLSTATE=428B2
db2 => quit