Hi All
I was just wundering is there any way of mirroring our active logs
just in case of disk failures.wil db2 do it automatically for us maybe
through some inititalisation parameter.
regards
Hrishy 11 2034
"hrishy" <hr*****@yahoo. co.uk> wrote in message
news:4e******** *************** ***@posting.goo gle.com... Hi All
I was just wundering is there any way of mirroring our active logs just in case of disk failures.wil db2 do it automatically for us maybe through some inititalisation parameter.
regards Hrishy
What is your DB2 version and operating system?
"Mark A" <ma@switchboard .net> wrote in message news:<8t******* **********@news .uswest.net>... "hrishy" <hr*****@yahoo. co.uk> wrote in message news:4e******** *************** ***@posting.goo gle.com... Hi All
I was just wundering is there any way of mirroring our active logs just in case of disk failures.wil db2 do it automatically for us maybe through some inititalisation parameter.
regards Hrishy
What is your DB2 version and operating system?
Its interesting?
If my OpSys= AIX 5.2 ML01 (32 bit) and DB2/UDB 7.2EE FP10?
Thanks,
VKG
> > What is your DB2 version and operating system?
Its interesting? If my OpSys= AIX 5.2 ML01 (32 bit) and DB2/UDB 7.2EE FP10?
Thanks, VKG
The ability to do mirror logging depends on the release level, but I don't
remember when it was introduced. Maybe someone else can tell us.
I believe 7.2, with DB2 appending a "2" onto the end of the logpath. V8
allows one to customize, if I'm not mistaken.
Larry Edelstein
Mark A wrote: What is your DB2 version and operating system?
Its interesting? If my OpSys= AIX 5.2 ML01 (32 bit) and DB2/UDB 7.2EE FP10?
Thanks, VKG
The ability to do mirror logging depends on the release level, but I don't remember when it was introduced. Maybe someone else can tell us.
Mark A wrote: > > What is your DB2 version and operating system?
Its interesting? If my OpSys= AIX 5.2 ML01 (32 bit) and DB2/UDB 7.2EE FP10?
Thanks, VKG
The ability to do mirror logging depends on the release level, but I don't remember when it was introduced. Maybe someone else can tell us.
AFAIK it was introduced with DB2 7.2 (i.e. 7.1, Fixpak 3).
In 7.2 log mirroring can be configured thru the registry
variable DB2_NEWLOGPATH2 . However it was some kind of inflexible
because the mirror path could not be set explicitly, the character
'2' was appended to the the value of LOGPATH to build the
mirror logpath name.
In 8.1x DB2_NEWLOGPATH2 has been replaced by the MIRRORLOGPATH
db config parameter, which could be set to a full pathname.
Best regards
Eric
--
IT-Consulting Herber
*************** *************** *************** **
Download the IFMX Database-Monitor for free at: http://www.herber-consulting.de/BusyBee
*************** *************** *************** **
>The ability to do mirror logging depends on the release level, but I don't remember when it was introduced. Maybe someone else can tell us.
I posted a similar thread after my shop experienced a data loss. The feedback I
got then was V7 FP11 or as advised by our own certified guru V8.
I was taken aback by how primitive UDB was in this respect. After all, it is a
fairly fundamental requirement. Oracle has provided dual logging since I first
got my hands on it back in 1998 (and probably before then).
"MCPHEAL" <mc*****@aol.co m> wrote in message
news:20******** *************** ****@mb-m07.aol.com... The ability to do mirror logging depends on the release level, but I
don'tremember when it was introduced. Maybe someone else can tell us. I posted a similar thread after my shop experienced a data loss. The
feedback I got then was V7 FP11 or as advised by our own certified guru V8.
I was taken aback by how primitive UDB was in this respect. After all, it
is a fairly fundamental requirement. Oracle has provided dual logging since I
first got my hands on it back in 1998 (and probably before then).
Dual logging has been on DB2 for OS/390 from the beginning in the mid
1980's. However in defense of DB2 for Linux, UNIX, and Windows, disk
mirroring (at the disk controller level or at the OS level) as well as
RAID-5, have been available for a long time, which basically provides a
similar function.
Mark A wrote: However in defense of DB2 for Linux, UNIX, and Windows, disk mirroring (at the disk controller level or at the OS level) as well as RAID-5, have been available for a long time, which basically provides a similar function.
Not really. Hardware mirroring protects against a disk failing; dual
logging helps can do this as well, but also protects against user error
(someone accidentally removing the log files).
-----= 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! =-----
> > However in defense of DB2 for Linux, UNIX, and Windows, disk mirroring (at the disk controller level or at the OS level) as well as RAID-5, have been available for a long time, which basically provides a similar function.
Not really. Hardware mirroring protects against a disk failing; dual logging helps can do this as well, but also protects against user error (someone accidentally removing the log files).
I said it was similar, not exactly the same. Really. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: enigma |
last post by:
Just wondering if you could help me on this one. I'm not sure if my
transaction logs are behaving oddly or what. I've successfuly managed
to shrink my transaction logs from 7GB down to 1MB and now I find it
strange that the log file doesn't seem to increase its size. The
timestamp of the logfile is updating as well. But the size of the file
is constant. I haven't configured my database to do auto-shrink so Im
really confused why it hasn't...
|
by: Thiko |
last post by:
Hi
I take one nightly full database backup at 02:00 and backup the
transaction log to one backup set every 15mins.
The commands to do this are as follows and are set up to run as
database jobs:
-- Database Backup
BACKUP DATABASE TO WITH NOINIT ,
|
by: xo55ox |
last post by:
Hi,
I have been trying to set up an automated restore process from prod to
backup server. First, I schedule the full database backup nightly,
transfer the backup file and restore it to the database on the backup
server. Meanwhile, I leave the database ready to accept transaction
log from the transaction log backup at noon daily.
And I had used different restore options to test out the transaction
that was being applied. And I couldn't...
|
by: tram |
last post by:
Any one has setup the transaction log file (lDF) mirrored between two
SANS or betweeen local disk and SAN? What are the performance impact
doing this?
Mirroring at same location (either at local/SAN level) may not be
fully redundant in Disaster scenarios. Any ideas?
|
by: Andrew S. |
last post by:
I recently performed an SQL server 2000 installation. Other than
placing the program files on C: and data on D:, I saw no option to
install transaction logs in an alternate location.
What is the best practice with SQL server 2000 for location of
transaction logs? I remember that Microsoft used to take the position
that transaction logs should be placed on their own FAT partition.
| |
by: francois1 |
last post by:
I am running a website with a SQL Server database attached.
My transaction logs are full and my hosting co. won't allocate more
disk space for me.
I need to delete my database transaction logs and asume I will need to
run an SQL script to do this.
Problem: I do not have MS Enterprise Manager of any database utility
on my website apart from MS Access. Where can I download a free SQL
tool that I can use to delete the transaction logs...
|
by: TG |
last post by:
Coming from a (mostly) Oracle shop, I am unclear how SS transaction logs
work as far as up to point of failure recovery goes.
I have the few MSSQL databases I look after in full recovery mode, and I
set up maintenance plans to back these up online on a daily basis. In
the research I did it was recommended backing up the transaction logs as
well on a frequent basis to ensure recovery to POF or point in time.
I had assumed that they work...
|
by: JA |
last post by:
Hi, I know just about nothing about SQL Server. I am getting this error:
The log file for database 'my_database' is full. Back up the transaction log
for the database to free up some log space.
I can't access the transaction logs to back them up. I am told that my ISP's
tech support should have it set up to shrink those logs automatically every
so often. Is that true?
|
by: Laurence |
last post by:
Hi folks,
How to remove the transaction logs which are out of date in HADR
environment?
DB2 command PRUNE, it can only run on primary database but cannot run
on standby database. Because the database conection is not permitted
on standby database.
USEREXIT, I don't know whether it can run on standby database or
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |