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.
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.
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.
3. You upgrade your database when required.
4. You recover your database if a failure occurs with data loss.
5. You consider using various standard tools and services offered to increase the availability of your database:
Ў SAP Safeguarding, including GoingLive and EarlyWatch
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:
7. You review your procedures to increase the availability of your database. Refer to Procedures at Your Site for High Availability.
Your DB2 UDB for UNIX and Windows database is more available for production use.