Restore DB2 on Cio File System Fails due to File System Corruption!

File system corruption can occur in both PCs and Macs, on external drives or internal drives when you are connected via FireWire, aSATA, USB or iSCSI. Corruption issues results in severe system performance hits. Along with driver manufacture, it happens on any drive enclosure.  Concurrent I/O or cio option specifies the file system to be mounted for concurrent reads and writes. It has licensed feature of VxFS separately.  When cio is specified and if feature is not licensed then the mount command sends an error message thus terminating the operation without mounting the file system. With remount, you will be unable to disable cio file system. In order to disable cio option then at first unmount the file system then mount again without cio option.

DB2 belongs to Relational Database Management System (RDBMS) family being developed by IBM. It is based on the relational model. DB2 has many features with high performance database engine providing several features to user. DB2 file stores data in tabular format executing requested problem in few seconds thus displaying accurate results. This file provides reduce data redundancy, protection of data, restricted unauthorized entry etc. Database corruption occurs at any layer starting from db2 to operating system and right down to the hardware layer.

Issue:

File System Corruption occur when cio file system fails then need to restore DB@ file.

Cause:

1844483 [VxFS][281-623-013][Affiliated Computer] AIX5.3 VxFS 5.0MP1 – CIO returned ENOTSUP (124) and caused DB2 to crash.  Several other reasons such as abnormal shutdown of system or server, software bugs, virus infections or attacks, application malfunctioning, corruption of database objects, various Software or hardware related issues also results in crashing or corrupting db2 file.

Effects:

File System Corruption results in frequent system crashes thus creating business critical downtime situation. Due to this, DB2 file gets crashed or corrupted thereby preventing you to access db2 file.

Resolution:

When your db2 file is corrupted and you need to restore them then use third party software which is DB2 File Repair Tool. This is the most trusted software among all software available in the market in order to recover your corrupted or inaccessible db2 file without losing any data because several other software available may result in destroying your db2 file permanently. Thus, this software restores your db2 file completely and effectively stored at any loction of your system and provides manual option in order to select.

DB2 File Repair software automatically collects database lists which is stored at any default location and recovers them effectively. You will be able to preview all recoverable objects in order to decide easily which file you want to repair and gives you an insight actual recovery results. It is able to restore large and huge database efficiently. It records all the activities performed in log reports during DB2 recovery process. This tool has user friendly interface and can be updated easily from the internet. The software is compatible with Windows Server 2000, 2003 and XP.