Mirroring to remote server

Michael Henry

Hi,

I'm a DB2 newbie so please don't be too harsh :)

I'd like to replicate a DB2 database to a remote server which will be
used for disaster recovery. What I'd like to know is: what options are
available to achieve this?

The data doesn't have to be absolutely up-to-date. What we're thinking
at the moment is a cron-job which runs "db2move EXPORT" every night
and then copy the IXF files to the remote server where we can run
"db2move IMPORT" if necessary. However I can't help but feel that we
can do better than this, if only I know anything about DB2!

Thanks in advance for your advice,

Michael

Nov 12 '05 #1

Subscribe Reply

3598

Bernd Giegerich

Hi,

However I can't
help but feel that we can do better than this, if only I know
anything about DB2!

there are several ways, take a look at the "Data Recovery and High
Availability Guide and Reference", available at

http://www-306.ibm.com/software/data...manualsv8.html

Regards,
Bernd

Nov 12 '05 #2

Joachim Müller

Michael,

try with Version 8.2 the new "hadr" function.
You have to setup a standby system with log-shipping.

look for "setting up high availibility disaster"
http://publib.boulder.ibm.com/infoce...help/index.jsp

Best regards,
Joachim Müller

"Michael Henry" <Mi***********@ axegroup.com.au > schrieb im Newsbeitrag
news:32******** *************** ***@posting.goo gle.com...

Hi,

I'm a DB2 newbie so please don't be too harsh :)

I'd like to replicate a DB2 database to a remote server which will be
used for disaster recovery. What I'd like to know is: what options are
available to achieve this?

The data doesn't have to be absolutely up-to-date. What we're thinking
at the moment is a cron-job which runs "db2move EXPORT" every night
and then copy the IXF files to the remote server where we can run
"db2move IMPORT" if necessary. However I can't help but feel that we
can do better than this, if only I know anything about DB2!

Thanks in advance for your advice,

Michael

Nov 12 '05 #3

Norbert Munkel

Hi,

I got the impression, things are mixed up a little bit.

Joachim Müller wrote:

Michael,

try with Version 8.2 the new "hadr" function.
You have to setup a standby system with log-shipping.

hadr ist basically log-buffer shipping.

log-shipping is an alternate way for desaster recovery scenarios and
works with older DB2-Versions also.

I would use hadr for _real_ HA-Environments as it allows very short outages.

As there are no recommendations like this in this particular case, I
would prefer log-shipping as this works with pre-8.2 UDB and is quite
easy to setup.

Finally, if you need to have a "working copy" on the remote server which
is accessible by other applications you would need to set up replication.

There is a nice presentation titled "Designing and Building 24x7
applications using DB2" hold by Dale McInnis at IDUG Europe 2004. A nice
decision matrix when to use which technology is included.

best regards,

Norbert

Nov 12 '05 #4

Similar topics

2819

Log Mirroring + User Exit AIX

by: Mulder | last post by:

Has anyone enabled log mirroring under DB2 v8 on AIX 4.3.3 or 5.? and if so are you archiving these mirrored logs to TSM? Is this possible? If so is there any sample code for the user exit and mirrored logging? Thanks

DB2 Database

1513

Mirroring databases in v8

by: Glen Eustace | last post by:

I thought I had seen something that indicated that v8 was going to provide a means to mirror databases without needing all the triggers etc. I downloaded beta 3 but couldn't see anything that would do this. My goal is to mirror a database from one server to another, hopefully from the logs so that there is nothing added to the database. The mirrored db will be used by the remote server in a read-only fashion and will become read-write if...

PostgreSQL Database

2173

2005 Database Mirroring & Witness

by: Ryan | last post by:

I'm devlving into 2005 and specifically mirroring. Having read the following article ( http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx ), is mirroring a sensible option as it indicates that it should not be used in a production environment, yet the SQL2005 seminars I've been to indicate that this is a worthy option. Do we also need a witness server, or can this be done (sensibly) with two SQL2005 servers ?

Microsoft SQL Server

6234

Shrinking database log used for mirroring

by: d.grabov | last post by:

Can anyone offer some advice on how to reduce the size of a database log. The database is mirrored on another server using the logs. Thanks

Microsoft SQL Server

4403

SP2 Database Mirroring - "The remote copy of database "ABC" has not been rolled forward..."

by: serge | last post by:

I have 2 SQL Enterprise Editions running SP2 and same collation. When i try to start database mirroring I get the following error message: "The remote copy of database "ABC" has not been rolled forward to a point in time that is emcompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)" Both SQL Server services are running under account

Microsoft SQL Server

5869

Database Mirroring Monitor Job Error

by: bosko19 | last post by:

We have recently set up two SQL Server 2005 Standard Edition servers with database mirroring. The mirrors function and fail over without a problem, but the Database Mirroring Monitor Job fails every time with the following error message: Incorrect syntax near '.'. (Error 102) Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated...

Microsoft SQL Server

1646

Database Mirroring In Mysql

by: vishnutd4u | last post by:

Hi friends, This is vishnu.Here in our company we have decided to implement database mirroring in mysql.Database mirroring means just when one database server is down the backup database server will take over database server's work just thats i know.But i dont know how to implement that thing.So plz if any one knows help me step by step of implementing in this matter.I am working on VC++ which is on window based(client side).But mysql...

MySQL Database

3087

replication or mirroring

by: mmark751969 | last post by:

We have a sql server 2000 sp3 server on a win2k3 server standard edition. This is on dell hardware with a dell scsi dasd enclosure directly attached. We want to duplicate the hardware and replicate or mirror the database to the backup server and do a manual or automatic failover in case of outage(more than likely manual). Wondering right now if replication - with say software like doubletake - is preferred over sql database mirroring or...

Microsoft SQL Server

2221

Problem in implementing mirroring

by: cmrhema | last post by:

Hi, All I underwent the following Steps for creating a mirror in sql server 2005. 1. Downloaded and isntalled sp2 in principal,mirror as well as witness servers 2. Created a new database named it as FinalMirror 3. Right clicked on the database Tasks-backup-BackupType--Full--Ok created FinalMirror.bak 4. Right clicked on the database Tasks-backup-BackupType--Transactional Log--Ok created FinalMirror-Transaction Log Backup(both of the...

Microsoft SQL Server

9602

Changing the language in Windows 10

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,...

Windows Server

10639

Problem With Comparison Operator <=> in G++

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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10376

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

7661

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5550

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

5688

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4332

transfer the data from one system to another through ip address

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

C# / C Sharp

3861

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3015

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General