Monday, September 19, 2016

Turn off Archive log in DB2

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.


No comments:

Post a Comment