By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,226 Members | 1,032 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,226 IT Pros & Developers. It's quick & easy.

Adjusting LOGSECOND

P: n/a
Hello,

If I increase LOGSECOND on a database, will the change become active
immediately, or does the DB2 instance need to be restarted before the
change is in effect?

--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/
Feb 8 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Feb 8, 6:40 am, Troels Arvin <tro...@arvin.dkwrote:
Hello,

If I increase LOGSECOND on a database, will the change become active
immediately, or does the DB2 instance need to be restarted before the
change is in effect?

--
Regards,
Troels Arvin <tro...@arvin.dk>http://troels.arvin.dk/
It will become effective when the database in deactivated. This will
occur when there are no connections to the database (assuming the
database was not explicitly activated).

Feb 8 '07 #2

P: n/a
On Feb 8, 2:40 pm, Troels Arvin <tro...@arvin.dkwrote:
Hello,

If I increase LOGSECOND on a database, will the change become active
immediately, or does the DB2 instance need to be restarted before the
change is in effect?

--
Regards,
Troels Arvin <tro...@arvin.dk>http://troels.arvin.dk/
You can verify whether a configuration changed by connection to the db
and:

db2 get db cfg for <dbshow detail

This will give you 1 column for current value and 1 for delayed value.
/Lennart

Feb 11 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.