LoveUnix » DB2 & Informix » db2 使用裸设备创建表空间的问题
让LU留住您的每

一天 让LU博客留住您的每一天
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

2008-4-29 13:14 beginner-bj
语法错

2008-4-30 10:17 bellman
实际执行的是
db2=> create regular tablespace tbstest managed by database using (device '/dev/rtest' 256000)

系统已经报错:
QL0298N  Bad container path.  SQLSTATE=428B2

页: [1]


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.