473,480 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

accessing active log files

GB
I heard that db2 (on windows 2000) crashes when making a xcopy of active
log files, is this true ?

Is there a way to copy active log files without crashing db2 ?

Thanks, Greg
Nov 12 '05 #1
14 2983
DB2 supports log mirroing. You can look it up in the Admin Guide.

GB wrote:
I heard that db2 (on windows 2000) crashes when making a xcopy of active
log files, is this true ?

Is there a way to copy active log files without crashing db2 ?

Thanks, Greg


Nov 12 '05 #2
DB2 supports log mirroing. You can look it up in the Admin Guide.

GB wrote:
I heard that db2 (on windows 2000) crashes when making a xcopy of active
log files, is this true ?

Is there a way to copy active log files without crashing db2 ?

Thanks, Greg


Nov 12 '05 #3
GB
Blair Adamache wrote:
DB2 supports log mirroing. You can look it up in the Admin Guide.


In this case db2 is writing to two files located on different drives,
and db2 is still accessing these files directly...

I'm using userexit and am trying to loose as few information as possible
in case of disaster (fire). Archived logs are copied to a remote site. I
think it could make sense to try to copy the active logfiles, but is it
really possible ???

P.S. I'm using db2 v7.2
Nov 12 '05 #4
GB
Blair Adamache wrote:
DB2 supports log mirroing. You can look it up in the Admin Guide.


In this case db2 is writing to two files located on different drives,
and db2 is still accessing these files directly...

I'm using userexit and am trying to loose as few information as possible
in case of disaster (fire). Archived logs are copied to a remote site. I
think it could make sense to try to copy the active logfiles, but is it
really possible ???

P.S. I'm using db2 v7.2
Nov 12 '05 #5
I copy log files on windows 2000 all the time without crashing DB2.
Why is it crashing? What is the error?

Bruce

GB <bo********@bigfoot.com> wrote in message news:<40********@news.deckpoint.ch>...
I heard that db2 (on windows 2000) crashes when making a xcopy of active
log files, is this true ?

Is there a way to copy active log files without crashing db2 ?

Thanks, Greg

Nov 12 '05 #6
I copy log files on windows 2000 all the time without crashing DB2.
Why is it crashing? What is the error?

Bruce

GB <bo********@bigfoot.com> wrote in message news:<40********@news.deckpoint.ch>...
I heard that db2 (on windows 2000) crashes when making a xcopy of active
log files, is this true ?

Is there a way to copy active log files without crashing db2 ?

Thanks, Greg

Nov 12 '05 #7
Ian
GB wrote:

I'm using userexit and am trying to loose as few information as possible
in case of disaster (fire). Archived logs are copied to a remote site. I
think it could make sense to try to copy the active logfiles, but is it
really possible ???


I would avoid copying active log files. If you are trying to minimize your
data loss, you need to manage your log file size so that files get archived
on a regular basis.

Good luck,

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #8
Ian
GB wrote:

I'm using userexit and am trying to loose as few information as possible
in case of disaster (fire). Archived logs are copied to a remote site. I
think it could make sense to try to copy the active logfiles, but is it
really possible ???


I would avoid copying active log files. If you are trying to minimize your
data loss, you need to manage your log file size so that files get archived
on a regular basis.

Good luck,

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #9
GB
Bruce M wrote:
I copy log files on windows 2000 all the time without crashing DB2.
Why is it crashing? What is the error?

Bruce


Sorry I don't have more information about this. Colleagues told me not
to do it, because they crashed db2 by doing an xcopy of the active logs,
but it was quite a long time ago and finding the corresponding log
entries is now quite difficult :-(

Greg
Nov 12 '05 #10
GB
Bruce M wrote:
I copy log files on windows 2000 all the time without crashing DB2.
Why is it crashing? What is the error?

Bruce


Sorry I don't have more information about this. Colleagues told me not
to do it, because they crashed db2 by doing an xcopy of the active logs,
but it was quite a long time ago and finding the corresponding log
entries is now quite difficult :-(

Greg
Nov 12 '05 #11
GB
Ian wrote:
I would avoid copying active log files. If you are trying to minimize your
data loss, you need to manage your log file size so that files get archived
on a regular basis.

Good luck,


If copying the active logs is really impossible I will try to tune this.
If the log file size is too small it is quite sure that I will run into
performance and other problems :-(

Thanks, Greg

Nov 12 '05 #12
GB
Ian wrote:
I would avoid copying active log files. If you are trying to minimize your
data loss, you need to manage your log file size so that files get archived
on a regular basis.

Good luck,


If copying the active logs is really impossible I will try to tune this.
If the log file size is too small it is quite sure that I will run into
performance and other problems :-(

Thanks, Greg

Nov 12 '05 #13
most likely file contention.

PM

"Bruce M" <bw********@yahoo.com> a écrit dans le message de
news:18**************************@posting.google.c om...
I copy log files on windows 2000 all the time without crashing DB2.
Why is it crashing? What is the error?

Bruce

GB <bo********@bigfoot.com> wrote in message

news:<40********@news.deckpoint.ch>...
I heard that db2 (on windows 2000) crashes when making a xcopy of active
log files, is this true ?

Is there a way to copy active log files without crashing db2 ?

Thanks, Greg

Nov 12 '05 #14
most likely file contention.

PM

"Bruce M" <bw********@yahoo.com> a écrit dans le message de
news:18**************************@posting.google.c om...
I copy log files on windows 2000 all the time without crashing DB2.
Why is it crashing? What is the error?

Bruce

GB <bo********@bigfoot.com> wrote in message

news:<40********@news.deckpoint.ch>...
I heard that db2 (on windows 2000) crashes when making a xcopy of active
log files, is this true ?

Is there a way to copy active log files without crashing db2 ?

Thanks, Greg

Nov 12 '05 #15

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

Similar topics

2
2178
by: Keith E. | last post by:
I have implemented a Web Service on an IIS 5.0 platform using the ASP listener I can access the Web Service just fine from a VB 6 App and classic ASP using the SOAP 3.0 toolkit and its...
0
346
by: GB | last post by:
I heard that db2 (on windows 2000) crashes when making a xcopy of active log files, is this true ? Is there a way to copy active log files without crashing db2 ? Thanks, Greg
1
7863
by: Stephen Adam | last post by:
Hi there, Have spent a while trying to find out how to connect to Windows Media Player through COM. Unfortunately there doesnt seem to be much stuff about it on the web. What I need to do is...
1
1482
by: Roger Hembury | last post by:
Hi All, Hope you can help / point me in the right direction with a little problem. I have a VB6 created active X dll which is downloaded to the client using <object> </object> so that I can...
2
334
by: Conversão .cs em .dll | last post by:
I'm having a problem accessing Active Directory, the problem is that I need to access the passwords of the user to validate a login that i'm doing. I have access for the usernames but not to there...
4
3593
by: raj_genius | last post by:
I hav two queries, whc are as follows: FIRSTLY: is it possible to access the controls(by name) of a parent form(MDI) from its child forms??if yes then how??plzz provide a coded example in VB if...
1
1955
by: Jason Huang | last post by:
Hi, My IIS6 is running on my Win2K3 Active Directory. My file server is on Win2K3 R2, it's not in my AD, but it's in my LAN. Is it possible to create a virtual directory in my IIS so that...
2
1931
by: =?Utf-8?B?SklNLkgu?= | last post by:
Accessing AD in ASP.Net 1. It sees I can I access Active Directory catalog from asp.net, is the version of AD important for this? 2. Do I need to have a domain user for that or IIS will be...
2
3032
by: San24 | last post by:
Guys, Let me explain the application I have - Form > Main Tab Control > Main Tab Page > User Control > Sub Tab Control > Sub Tab Page > User Control > Contols/Text Box. Form - The main...
0
7039
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
6904
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7037
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,...
1
6735
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...
0
6895
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...
1
4770
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...
0
4476
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...
1
558
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
176
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...

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.