473,574 Members | 2,233 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Expected Impact of Changing Logging Type

I have a production database that I need to change the logging type
from circular to archived so that I can do online backups. The
database is not particularly large, but is used by many people. What
impact from the users perspective can I expect? Is the only impact
behind the scenes in the db manager? Thanks in advance for any help.
Matt

Mar 16 '06 #1
6 1514
Matt wrote:
I have a production database that I need to change the logging type
from circular to archived so that I can do online backups. The
database is not particularly large, but is used by many people. What
impact from the users perspective can I expect? Is the only impact
behind the scenes in the db manager? Thanks in advance for any help.


There will be no impact no the user. DB2 has to manage the log files now
and as long as there is enough disk space (or a proper user exit archiving
the completed log files away), you don't have to worry.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Mar 16 '06 #2
Thanks for the quick response. I appreciate it very much. Matt

Mar 16 '06 #3
In article <dv**********@l c03.rz.uni-jena.de>, st****@de.ibm.c om says...
Matt wrote:
I have a production database that I need to change the logging type
from circular to archived so that I can do online backups. The
database is not particularly large, but is used by many people. What
impact from the users perspective can I expect? Is the only impact
behind the scenes in the db manager? Thanks in advance for any help.


There will be no impact no the user. DB2 has to manage the log files now
and as long as there is enough disk space (or a proper user exit archiving
the completed log files away), you don't have to worry.


But after changing the logging type a full offline backup is needed,
which means no users are allowed to connect. So the right time for
changing the logging type is just before creating a full backup.
Mar 16 '06 #4
In general database logging affects performance of bulk data
modifications from SQL (INSERT, UPDATE, DELETE) because the default
behaviour is to log table data updates. However, if your database is
fairly small it may not be an issue. After you turned on the logging
you would need to monitor performance anyways to see whether
performance degrades.

-Eugene

Mar 16 '06 #5
Ian
Eugene F wrote:
In general database logging affects performance of bulk data
modifications from SQL (INSERT, UPDATE, DELETE) because the default
behaviour is to log table data updates. However, if your database is
fairly small it may not be an issue. After you turned on the logging
you would need to monitor performance anyways to see whether
performance degrades.


Yes, but this is irrelevant when comparing circular to archive logging.
DB2 always uses the transaction log for recovery. It's just a matter of
whether we want to keep the old log files or not.

Mar 16 '06 #6
Agreed... sorry for the confusion... :-(
-Eugene

Mar 16 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
395
by: Karuppasamy | last post by:
H I am trying to use the Logging Module provided by Microsoft Application Blocks for .Net I installed everything as per the Instructions given in the 'Development Using the Logging Block' But when i am trying to run the sample, i am getting the following error in the Event Viwer Kindly help me on this
3
1231
by: Garvin, Michael [CAR:C28G:EXCH] | last post by:
Hi I'm working on some impact analysis stuff for C++. I was wondering if anyone has seen an example of a type (lets say type "A") change impacting the storage/layout another type (lets say type "B"), but B does not include the header/src file where A is defined. Also B is using type A by more than just a pointer, that is B needs to know the...
10
3582
by: Steve Benson | last post by:
Our regular programmer moved on. I'm almost clueless in Javascript/ASP and got the job of adapting existing code. In the page below, everything works until I added the function checkIt() to validate which radio button was clicked and what was in a textfield. The form is an attendance checking page for a cyber charter school. What I'm trying to...
4
1348
by: John Baker | last post by:
Hi: I am having a problem making the impact a field property change in a table trickle through to a report. Between the table and the report are numerous queries and sums. I have changed the field definition from Text to Numeric (single), so that formatting can be done more efefctivlet, but somwhow the report doesnt recognize that change. ...
4
2698
by: Pieter | last post by:
I synthetically create an overrun by copying more data than a buffer can hold: int buffer; int i = 0; for (i = 0; i < sizeof(buffer) / sizeof(buffer) + 1; i ++) { buffer = i; } In debug builds the /RTC option is enabled and catches the overrun.
1
1307
by: Bala Nagarajan | last post by:
Hello, I am building a web service application in which i will have to implement logging based on user id. My question is where do i store the user ids? Since the nature of this problem is so dynamic, in the sense the number of users for whom the logging will be turned on may vary from 0 to N from point to point. Though i have couple of...
16
47673
by: Steve Chapel | last post by:
When I load the page <https://bugzilla.mozilla.org/attachment.cgi?id=237739with Internet Explorer 7 RC 1, I get the error "Object Expected" at line 174. When I click on the button, I also get the same error on line 186. This same HTML and JavaScript works perfectly in Firefox and Opera. How can I make the code work in IE?
0
2094
by: rajesh.hanchate | last post by:
Please help me in resolving this issue. I am using EnterpriseLibrary 2.0 Exception and logging block for logging exceptions to event log. It works fine for sometime. After some time it stops logging to event log. To make it active again I need to open the web.config and save without making any changes. It starts to work again. Here is the...
1
3894
by: JOJO123 | last post by:
I got here in search of an answer to this Javascrpt question. I upgraded jave on XP Ie 7, acrobat 5.1 and suddenly can't open any pdf files on web sites using IE. I see u guys all say, this is a Javscript issue. but how do we, mere mortals who know nothing of anything about Java, scripts, etc, fix this? Is there a programm, does MS have any fix?...
0
8044
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7808
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8096
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5616
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5299
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3739
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3749
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1335
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1055
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.