데이터베이스/DB2

LOG파일 확인 및 제거

안드레날린 2013. 7. 30. 17:48

[Current Log File Number]

db2 list history backup all for db [DB명]

 

[DB2 Log File 확인]

db2 get db cfg for [DB명] | grep -i log

 

Number of primary log files                 (LOGPRIMARY) = 3

Number of secondary log files            (LOGSECOND) = 2

Path to log files                                = /home/db2jih/db2jih/NODE0000/SQL00003/SQLOGDIR/

 

primary log files + secondary log files 수를 제외하고 제거