Recovery model of current database I want to know how can I change the recovery model of my current database. I am having sysadm rights.Operating system is windows, Db2 10.5.

can some one let me know the command please
In DB2, the SQL Server's recovery model simple equivalent is called circular.

&lt;p&gt;C:\WINDOWS\system32&gt;db2 get db cfg for sample |findstr "LOGARCHMETH1 LOGARCHMETH2" &lt;\p&gt;
&lt;p&gt; First log archive method                 (LOGARCHMETH1) = OFF &lt;/p&gt;
&lt;p&gt; Second log archive method                (LOGARCHMETH2) = OFF &lt;/p&gt;


If both logarchmeth1 and logarchmeth2 are set to OFF, the database uses circular logging and is not rollforward recoverable.