473,320 Members | 1,724 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

archive logs regularly for restore on 2. server

Hello,
is there a way (Win 2003, DB2 UDB 8.1 Fixpack9), that the logs are
archived regularly? Our server writes logs (-> archive logs) only 1-3
times per day. I would like to have them more frequently, because I
move them (with OS tools) to another server for the case of desaster(
server destroyed completly).
Is the only way to schedule a job with the 'archive log'-command?
How do other DBAs handle this requirement of recoverability?
Thanks
Marion

Jun 7 '06 #1
1 1417
ma**@netexpress.de wrote:
Hello,
is there a way (Win 2003, DB2 UDB 8.1 Fixpack9), that the logs are
archived regularly? Our server writes logs (-> archive logs) only 1-3
times per day. I would like to have them more frequently, because I
move them (with OS tools) to another server for the case of desaster(
server destroyed completly).
Is the only way to schedule a job with the 'archive log'-command?
How do other DBAs handle this requirement of recoverability?


You can also decrease the size of your log files. Smaller log files are
closed earlier so that they can be archived more frequently. The
alternative is the ARCHIVE command that you mention.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Jun 7 '06 #2

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

Similar topics

6
by: Edwinah63 | last post by:
Hi Gurus, i am having problems with restoring a ms sql database. i have restored the database using veritas to a different location ('g:\datafiles') in no recover mode. when i view the...
2
by: Pierre HIRTH | last post by:
Hi, Someone could tel me ho can i do to put a database in Archive log Mod ? And how can i do to apply redo log on a backup database ? Thank's
6
by: paul | last post by:
Hi, i made an attempt to restore a online backup made with include logs option. But when i rollforward the db, i can't pout it online because it always ned log file. I tried the option to...
3
by: Kush | last post by:
Hi. I was just wondering if someone could help me understand the relationship between the recv_hist_retention value and archive logs (and pruning of history file). My understanding is that the...
4
by: aj | last post by:
DB2 LUW v8.2 FP 14 RHAS 2.1 I have a DB2 online DB backup that was done w/ the INCLUDE LOGS option. I am interested in restoring that backup, and rolling forward ONLY the logs contained in the...
1
by: nevsoft | last post by:
Hello I have Oracle 10.2.0.1 on Solaris 10g. I want to make level0 incremental backup every night and level1 incremental backup during the day. Each level0 backup will be copied over network...
0
by: prashanthdb2 | last post by:
Hi, Im new to db2. Im using db2 ese 9.1 (fix pack 1) on SLES 9.0 32 bit. I have single instance on three logical nodes 0,1,2. i have cofigured userexit - on, logretain - on, trackmod - on. ...
1
by: shiva359 | last post by:
Dear All , will changes done on a table data After a load with nonrecoverable option on a archive loging enabled Database be recorded in logs if we don't do a complete backup ...
3
by: Kofa | last post by:
Hi, we have an application which uses online backups, so archive logging is a requirement. We have a small/moderate size database (a few hundred megabytes isn't much by today's standards) with...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.