Sunday, 8 October 2017

How to Turn off Archive log in DB2 datbase

Tags


The Following steps to Turn off archive log in DB2 DATABASE

 First Log on to Database server with db2 user.

Before that Check the status of Archive log Status.

        db2 archive log for db

Execute below commands to turn off archive log.

       db2  update db cfg for using logretain off
       db2 update db cfg for

 Restart SAP application Server & Database to effect the changes.

  Check archive log OFF or ON with below command

   db2 archive log for db   
   
If output “Archive log not allowed “then archive log was OFF.
else
Still Archive log in ON.


EmoticonEmoticon

Note: only a member of this blog may post a comment.