If archive_log directory full, to turn off archive log in DB2

1. Log on to DB  server with db2<sid> user.

2. Execute below commands to turn off archive log.

db2  update db cfg for <DBSID> using logretain off
db2 update db cfg for <DBSID> using LOGARCHMETH1 OFF

3. Restart SAP&DB to effect the changes.

4. Check archive log OFF or ON with below command

db2 archive log for db <DBSID>
If output “Archive log not allowed “then archive log was OFF.

Leave a Reply

Your email address will not be published. Required fields are marked *