DB2 Express

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

naveenpuskur@gmail.com - 12 Dec 2005 11:04 GMT

Hi Guys,

New to DB2 .

Want to create a disaster DB2 server with minimum resources, as
client(small company) can't afford big and don't have much budget to
spend.Currently backing to local tape. Tape is kept locally in safe,
as now client will loose all his data in event of major disaster to his
site.

1. I am running DB2 express edition on Redhat linux AS4 on IBM Server.

Requirment:-

Client want to failover to remote site in event of disaster. He don't
mind having his disaster site db2 server database not updated for 24
hrs. He has very small database of 4GB

Solutions I am thinking right now:

1. Using export utilitly to extract data into some file. Compress it
and send it using scp/sftp(write a script to automatically do every
night) to remote disaster server.

2. Then on disater site import the data.

Will this work? As I am new to DB2 express or DB2. I don't know if DB2
express has export/import utility.
Please anybody help me in telling if it works. If that don't, any
suggestions?
I am having basic understaning of databases and sql, as I am more of
unix admin.Had worked previously on oracle 8 but never on DB2.

Regards,
Naveen

Reply to this Message

Matt Emmerton - 12 Dec 2005 18:25 GMT

> Hi Guys,
>
[quoted text clipped - 24 lines]
> Will this work? As I am new to DB2 express or DB2. I don't know if DB2
> express has export/import utility.

This will work, but will be slow -- especially if you want to copy the
entire database.

A better idea would be to take a backup of the database nightly, scp/sftp
the backup images to the remote site, and then use a redirected restore to
update the remote server.

Or better yet, suggest using HADR and get your client to upgrade to DB2 ESE
on both machines :)

--
Matt Emmerton

Reply to this Message

Mark A - 13 Dec 2005 00:12 GMT

> This will work, but will be slow -- especially if you want to copy the
> entire database.
[quoted text clipped - 9 lines]
> --
> Matt Emmerton

HADR can be purchased as a separate licensed option to Workgroup Edition
without having to upgrade to ESE. Not sure about DB2 Express.

Reply to this Message

Ian - 13 Dec 2005 06:14 GMT

> Hi Guys,
>
[quoted text clipped - 28 lines]
> I am having basic understaning of databases and sql, as I am more of
> unix admin.Had worked previously on oracle 8 but never on DB2.

Copying the nightly backup image to the remote server will probably be
a lot of work. As suggested, HADR might be an option, although it's
still pretty expensive (HADR can be licensed with DB2 Express, but list
price is still $7000+ per CPU, even if you license DB2 Express on a
per-user basis).

You might also consider using a standby database and log shipping. See:

http://www-106.ibm.com/developerworks/db2/library/techarticle/0304mcinnis/0304mc
innis.html

For information about this. This is the poor man's version of HADR.

Reply to this Message

Krzysztof Paz - 14 Dec 2005 01:14 GMT

Hi,
maybe you could consider using HADR, which seems to be the solution for such
purposes.
More info - http://www-306.ibm.com/software/data/db2/udb/hadr.html
It's also available and support under DB2 Express, but priced additionaly as
separated option.

Regards,
Chris.

Reply to this Message

Jean-Marc Blaise - 16 Dec 2005 20:29 GMT

> Hi Guys,
>
[quoted text clipped - 31 lines]
> Regards,
> Naveen

Hi Naveen,

As per your customer requirement, ie "DB server not updated for 24h is not a
problem", you could do it by simple scripting:
backup primary source (use the compress option), rcp to secondary; retrieve
on a regular basis logs from the primary and reapply to the secondary.

HADR could help you automatize this, and would allow your customer to switch
to the secondary server in seconds, but this has a price ... we did not use
it for a customer on Windows, because pricing was too high for a DB2 Express
Edition; basically we had to ask our customer to multiply by 3 its
investement, and he logically refused.

Hope this helps,

Jean-Marc

Reply to this Message