RE: How to reset logretain and user exit to off and required step

RE: How to reset logretain and user exit to off and required step

 

  

This depends on the nature of the parameter whether dynamic or
Non-dynamic. Sometime back, Lekharaju posted the dynamic and
non-dynamic parameters list.
However, you can decide whether bounce requirement by using

db2 get db cfg for <database> SHOW DETAIL

The clause 'SHOW DETAIL' shows both the current and modified
parameter's value. IF these values are same, then no bounce is
required. If these values are NOT same, then bounce is required.

EX:
C:\Partha\DB2\ug>db2 update db cfg using LOCKTIMEOUT 15
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W One or more of the parameters submitted for immediate modification
were not changed dynamically. For these configuration parameters, all
applications must disconnect from this database before the changes become
effective.
C:\Partha\DB2\ug>db2 get db cfg show detail |grep -i LOCKTIME
Lock timeout (sec) (LOCKTIMEOUT) = 10 15

Obviously, this example shows, the parameter LOCKTIMEOUT is non-dynamic.

Hope this helps.
Partha

-----Original Message-----
From: Jitendra Kumar
[mailto:db2udbdba-ezmlmshield-x50467129.[Email address protected]
Sent: Thursday, March 31, 2005 3:05 AM
To: LazyDBA Discussion
Subject: RE: How to reset logretain and user exit to off and required step

Thanks Bandaru,

tell me onething more,
is it neccessary to stop and start the datbase


-----Original Message-----
From: Bandaru Jayaprakash
[mailto:db2udbdba-ezmlmshield-x93117071.[Email address protected]
Sent: Thursday, March 31, 2005 1:08 PM
To: LazyDBA Discussion
Subject: RE: How to reset logretain and user exit to off and required
step


UPDATE DATABASE CONFIGURATION FOR sample USING logretain NO

UPDATE DATABASE CONFIGURATION FOR sample USING USEREXIT OFF

-----Original Message-----
From: Jitendra Kumar
[mailto:db2udbdba-ezmlmshield-x87630629.[Email address protected]
Sent: Thursday, March 31, 2005 12:49 PM
To: LazyDBA Discussion
Subject: How to reset logretain and user exit to off and required step


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






---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



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