备份压缩问题

额~~顺序问题收起

>--+------------------------------------------------------------------+-->
   '-COMPRESS--+-----------------------------+--+-------------------+-'   
               '-COMPRLIB--name--+---------+-'  '-COMPROPTS -string-'     
                                 '-EXCLUDE-'                              

>--+------------------------------------+--+--------------+----->
   '-UTIL_IMPACT_PRIORITY--+----------+-'  +-EXCLUDE LOGS-+   
                           '-priority-'    '-INCLUDE LOGS-'   

写命令时，注意看下语法图的顺序，就没问题了收起

从 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} ... ]收起

:lol{:3_47:}收起

我知道回答吧  跟顺序有关系
db2 backup database test  online  to E:\DB2_BACKUP compress include logs
db2 太深奥了
^_^收起