Dear all,

I had set the logretain, user exit and mirrorlogpath to take online backup
by using the following commans

UPDATE DATABASE CONFIGURATION FOR sample USING logretain Recovery IMMEDIATE;

UPDATE DATABASE CONFIGURATION FOR sample USING logretain Recovery userexit
Yes IMMEDIATE;

UPDATE DATABASE CONFIGURATION FOR sample USING logretain Recovery
mirrorlogpath 'D:\MirrorImageOnLine\' userexit Yes IMMEDIATE;


I want to revert all the three parameters to stop archieved logging.

Please help me, how can I do so and what the prequistics we would have to
follow.

The database is currently in use. After setting the parameter to off what
are the required stept to connect to the database and continuing
transaction.

Thanks in advance,
Jitendra





DB2 & UDB email list listserv db2-l LazyDBA home page