Skip to Content
Former Member
Jul 21, 2010 at 06:24 PM

DB2 change the database recovery mode


Hi Friends,

We are doing an upgrade, in the process will be necessary to change the DB recovery mode.

Database is DB2 9.5 and the platform is Unix (AIX). I wold like to clarify the process of change the recovery mode, I underestand that it is to switch off the logg retain, but I have found in some forums that in order to switch on the logg retain, when the upgrade finished, I have to have an full backup of this database.

I need to plan this activity and its effects.

Please do you know something about it, can you clarify me the process?

Thanks a lot.


Enrique Sánchez