DB2 Express

[naveenpuskur]

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

[Matt Emmerton]

<na**********@gmail.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...

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.

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

[Mark A]

"Matt Emmerton" <me******@nospam.yahoo.com> wrote in message
news:bY********************@rogers.com...

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

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

[Ian]

na**********@gmail.com wrote:

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.

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/developerwork...04mcinnis.html
For information about this. This is the poor man's version of HADR.

[Krzysztof Paz]

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.

[Jean-Marc Blaise]

<na**********@gmail.com> a écrit dans le message de
news:11*********************@g49g2000cwa.googlegro ups.com...

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

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