IT分销/经销数据库

备份压缩问题

为什么db2 backup database test COMPRESS online  to E:DB2_BACKUP include logs  会报错呢?db2 backup database test online  to E:DB2_BACKUP include logs  这样没有问题db2 backup database test COMPRESS 也没有问题怎么...显示全部
为什么
db2 backup database test COMPRESS online  to E:DB2_BACKUP include logs  会报错呢?

db2 backup database test online  to E:DB2_BACKUP include logs  这样没有问题
db2 backup database test COMPRESS 也没有问题

怎么写才正确呢?

谢谢收起
参与6

查看其它 4 个回答xiewenpeng的回答

xiewenpengxiewenpeng数据库开发工程师河南众品
从 backup 语法规则上可以看到参数的先后顺序



D:\aa>db2 ? backup


BACKUP DATABASE database-alias [USER username [USING password]]
[On-DbPartitionNum-Clause]
[TABLESPACE (tbspace-name [{, tbspace-name} ... ])]
[ONLINE] [INCREMENTAL [DELTA]]
[Media-Target-Clause]
[WITH num-buff BUFFERS] [BUFFER buffer-size] [PARALLELISM n]
[COMPRESS [COMPRLIB lib-name [EXCLUDE]] [COMPROPTS options-string]]
[UTIL_IMPACT_PRIORITY [priority]] [{INCLUDE | EXCLUDE} LOGS]
[WITHOUT PROMPTING]

On-DbPartitionNum-Clause:
  ON {{DBPARTITIONNUM | DBPARTITIONNUMS} (db-partition-number
  [TO  db-partition-number] , ... ) | ALL DBPARTITIONNUMS [EXCEPT
  {DBPARTITIONNUM | DBPARTITIONNUMS} (db-partition-number
  [TO db-partition-number] , ...)]}

Media-Target-Clause:
  USE {TSM | XBSA} [OPEN num-sess SESSIONS] | SNAPSHOT [LIBRARY lib-name]]
     [OPTIONS {options-string | options-filename}] |
  LOAD lib-name [OPEN num-sess SESSIONS]
     [OPTIONS {options-string | options-filename}] |
  TO dir/dev [{,dir/dev} ... ]
互联网服务 · 2012-03-23
浏览1097

回答者

xiewenpeng
数据库开发工程师河南众品

xiewenpeng 最近回答过的问题

回答状态

  • 发布时间:2012-03-23
  • 关注会员:1 人
  • 回答浏览:1097
  • X社区推广