Need recommendations re a good DB2 backup/recovery tool

[datapro01]

I 'm working with a company that decided to install a new dbms and
environment (DB2 on AIX). Most of the talent here is mainframe
oriented. When the deision was made as to which distributed database
tools to go with in Unix, folks here went with a vendor that is well
accomplished on the mainframe, but whose distributed database tools are
horrendous.

I don't want to name the tool vendor but will say they have 3 letters
in their name. Last week a recovery tool of theirs failed during a
recovery and it left DB2 in a terrible state.

We are researching alternative tools.

Can y'all recommend some good distributed db2 tools? We are
specifically interested in a good backup and recovery tool but also
might be in the market for a good monitoring tool. We don't have
extensive scripting experience here..

Thanks
Gerry

[Paul Reddin]

Gerry,

We use Quest Central for DB2, it's very good/intuitive for monitoring & tuning.
- though I don't know what its product future is, as a dispute with CA seems
to be stopping them from shipping updates.

It does have interfaces to Backup/Restore utilities, but I haven't used
it for this (I prefer CLP and my own scheduled scripts for these, currently)

Paul.

"da*******@yahoo.com" <da*******@yahoo.com> wrote in message news:<11**********************@c13g2000cwb.googleg roups.com>...

Can y'all recommend some good distributed db2 tools? We are
specifically interested in a good backup and recovery tool but also
might be in the market for a good monitoring tool. We don't have
extensive scripting experience here..

Thanks
Gerry

[Yasaswi Pulavarti]

You can use Veritas NetBackup software. It is quite easy to setup.
Yasaswi
"da*******@yahoo.com" <da*******@yahoo.com> wrote in message news:<11**********************@c13g2000cwb.googleg roups.com>...

I 'm working with a company that decided to install a new dbms and
environment (DB2 on AIX). Most of the talent here is mainframe
oriented. When the deision was made as to which distributed database
tools to go with in Unix, folks here went with a vendor that is well
accomplished on the mainframe, but whose distributed database tools are
horrendous.

I don't want to name the tool vendor but will say they have 3 letters
in their name. Last week a recovery tool of theirs failed during a
recovery and it left DB2 in a terrible state.

We are researching alternative tools.

Can y'all recommend some good distributed db2 tools? We are
specifically interested in a good backup and recovery tool but also
might be in the market for a good monitoring tool. We don't have
extensive scripting experience here..

Thanks
Gerry

[Christos Kalantzis]

We use Tivoli. DB2 has good intergration with this tool (Its from IBM).

Hope this helps

Christos


da*******@yahoo.com wrote:

I 'm working with a company that decided to install a new dbms and
environment (DB2 on AIX). Most of the talent here is mainframe
oriented. When the deision was made as to which distributed database
tools to go with in Unix, folks here went with a vendor that is well
accomplished on the mainframe, but whose distributed database tools are
horrendous.

I don't want to name the tool vendor but will say they have 3 letters
in their name. Last week a recovery tool of theirs failed during a
recovery and it left DB2 in a terrible state.

We are researching alternative tools.

Can y'all recommend some good distributed db2 tools? We are
specifically interested in a good backup and recovery tool but also
might be in the market for a good monitoring tool. We don't have
extensive scripting experience here..

Thanks
Gerry