Wednesday, July 7, 2010

High Availability Disaster Recovery Feature In Ibm Db2

IBM DB2 is a relational model database server or relational database management system, developed and marketed by IBM. It provides greater data availability and stability, as compared to other database management systems. You can prevent DB2 database corruption and need of DB2 Database Recovery using DB2 HADR (High Availability Disaster Recovery) feature. DB2 HADR is a data replication characteristics, which offers high availability for both complete and partial site failures. This features protects against the data loss by duplicating data changes from source database, known as primary, to target database.

A complete DB2 site failure may take place when any natural disaster, like fire or flood, causes the whole site to be destroyed. Since the HADR deploys TCP/IP to communicate between standby and primary databases, DB2 database may be situated at different locations. When any disaster takes place at primary site, the database availability is maintained through standby database. After the standby database takeovers primary database, the original database can be brought back to working state and return the database to primary database's status. It is called failback.

The partial DB2 site failure may take place when an application malfunction, operating system failure, hardware problems, and network issues damage your DB2 database. Without HADR, DBMS server or machine where DB2 database is stored, needs to be restarted. The time it requires to reboot the server and database is unpredictable.

In case the database corruption is serious and it is taking long time to process, critical situations of database unavailability may occur. It is highly recommended to have a complete HADR plan to ensure absolute safety of your mission-critical data on DB2 database server.

In case you do not have HADR configured or it fails to bring your database back to working state, an absolute backup of the database is required. You can restore damaged database very quickly and easily from the backup and prevent data loss. However, if the backup is either not updated or not available, DB2 Recovery becomes need of hour. You can effectively and quickly recover DB2 Database using powerful and advanced third-party DB2 database repair applications.

The DB2 database recovery software are capable of systematically scanning whole DB2 database and extracting all inaccessible data from it. With interactive user interface and simple graphical user interface, they do not require sound technical skills to retrieve data from damaged database.

DB2 Recovery software repairs damaged DB2 database and restores it back to original and working state. The software works well with IBM DB2 (UDB) v8. It restores all DB2 database objects, such as tables, views, schemas, triggers, buffer pools, and containers.

No comments:

Post a Comment