互联网服务Db2Db2表空间管理

db2表空间缩减问题?

db2的表空间执行: db2 "alter tablespace USERSPACE1 Reduce (file '/opt/sisc/test/testdb/db2inst1/NODE0000/TESTDB/T0000002/C0000000.LRG' 32M)" 报错: DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Process...显示全部

db2的表空间执行:
 db2 "alter tablespace USERSPACE1 Reduce (file '/opt/sisc/test/testdb/db2inst1/NODE0000/TESTDB/T0000002/C0000000.LRG' 32M)"
报错:
DB21034E  The command was processed as an SQL statement because it was not a 
valid Command Line Processor command.  During SQL processing it returned:
SQL20318N  Table space "USERSPACE1" of type "AUTOMATIC STORAGE" cannot be 
altered using the "ADD" operation.  SQLSTATE=42858

收起
参与5

返回沈天真的回答

沈天真沈天真售前支持IPS

https://www.talkwithtrend.com/Question/262291

" 谢谢各位,问题已经找到了。要设置autoresize YES。 "

硬件生产 · 2021-02-24

回答者

沈天真
售前支持IPS
擅长领域: 服务器云计算存储

沈天真 最近回答过的问题

回答状态

  • 发布时间:2021-02-24
  • 关注会员:3 人
  • 回答浏览:1325
  • X社区推广