Posts Tagged ‘db2 repair’

What are the steps to Recover DB2 Database Components?

Friday, March 19th, 2010

In order to recover DB2 database components you must follow the below gives steps such as –

Step 1: Bring, install and launch the DB2 Recovery tool. (note: ignore if already installed)

Step 2: Select from “Repair corrupt DB2 Database stored at default location” and click “OK” button.

  • A pop up box will open having list of all DB2 database on default location.
  • Open the database by double-click on the name of the DB2 database.
  • All recoverable data will be pop up. You can “Preview” before recovery and select only necessary data.

It is the easiest way to recover the corrupted or deleted DB2 database tables and data. Another DB2 Database Recovery mode is “Manual selection of database for recovery”. Under its process you may also recover and repair DB2 database components.

How to Remove Inconsistency from DB2 Database?

Monday, March 8th, 2010

As you know DB2 database is very popular, powerful and consistent relational database management system that stores various database and applications. It is a server enterprises edition that can run over various operating systems such as: Windows, UNIX, Linux, etc. Now a day, it is well accepted by various large organizations as well as for personal use because it is more safe and consistent.

To maintain its consistency various algorithms are incorporated and regularly all integrity, privacy and consistency of the data as well as DB2 database tables are checked. But due to logical or physical errors the consistency of DB2 database may broken and finally data become inaccessible or corrupt. The logical error may cause due to unnecessary shutdown the system, power-failure, shutdown the system while data is not saved, virus attack or software malfunction while in physical error it may be due to system cracked, damaged or broken.

This inconsistency may lead to major data loss so its quick solution becomes necessary for you. DB2 database is developed by IBM who itself provided various utilities and tools to resolve the inconsistency or corrupt DB2 database table. But the handling of those utilities may complex for you so the best solution will be Repair DB2 Database using any professional DB2 Repair utility. The Repair tool will easily repair and once again make consistency of the DB2 database.