1.查看logfilSize的大小,以及如何保证调整循环日志后,不会导致not enough space;
1)执行
db2 get db cfg for <dbName>
得到:
Log file size (4KB) (LOGFILSIZ) = 51200
Number of primary log files (LOGPRIMARY) = 20
Number of secondary log files (LOGSECOND) = 4
Changed path to log files (NEWLOGPATH) =
Path to log files = /cmsp2/usr/db2ad/db2ad/NODE0000/SQL00001/SQLOGDIR/
通过查看path to log file,得到循环日志文件的目录;
计算日志文件的大小:51200×(20+4)×4K=4.6875G
&nb