Posted on 2010-01-29 15:44
Prayer 閱讀(538)
評論(0) 編輯 收藏 引用 所屬分類:
DB2
db2 get db cfg for dbname
Log file size (4KB) (LOGFILSIZ) = 10000
Number of primary log files (LOGPRIMARY) = 20
Number of secondary log files (LOGSECOND) = 10
Changed path to log files (NEWLOGPATH) =
Path to log files = /data1/instwip/
First active log file = S0006578.LOG
是 LOGFILSIZ太小了,加大就好了.
db2 update db cfg for dbname using LOGFILSIZ 數值(比如1000).