High Availability for the IBM DB2 Universal Database for UNIX and Windows

Purpose

This section looks at database administration for the IBM DB2 Universal Database for UNIX and Windows – abbreviated to DB2 UDB for UNIX and Windows – and makes specific recommendations on improving availability. The information provided here applies to both platforms, UNIX and Windows, unless stated otherwise.

This section does not apply to DB2 for OS/400 or DB2 UDB for OS/390.

Process Flow

...

       1.      You work out your approach to backing up your database. You must do this before you start production with the database. When using the database for production, you must back up the database as regularly as possible.

Refer to Archive and Backup with DB2 UDB for UNIX and Windows.

       2.      You manage the space in your database. You do this both before you start production with the database and during production as the database grows.

Refer to Space Management with DB2 UDB for UNIX and Windows.

       3.      You upgrade your database when required.

Refer to Upgrade with DB2 UDB for UNIX and Windows.

       4.      You recover your database if a failure occurs with data loss.

Refer to Recovery with DB2 UDB for UNIX and Windows.

       5.      You consider using various standard tools and services offered to increase the availability of your database:

Ў        Computing Center Management System (CCMS)

Ў        SAP Safeguarding, including GoingLive and EarlyWatch

Ў        DB2CC

DB2CC, or "Control Center," helps you to perform your tasks in the most precise and efficient way. DB2CC is written in Java. On UNIX platforms you must have Java installed as a prerequisite. On Windows platforms Java comes with DB2 UDB for UNIX and Windows.

       6.      You consider using advanced products and services to increase the availability of your database:

Ў        DB Reconnect

Ў        Switchover Software for High Availability

Ў        Replicated Standby Database for DB2 UDB for UNIX and Windows

       7.      You review your procedures to increase the availability of your database. Refer to Procedures at Your Site for High Availability.

Result

Your DB2 UDB for UNIX and Windows database is more available for production use.