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.
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