Datacom DEFRAG cannot fix corrupt Index Area (IXX)?

Products

• Datacom
• Datacom/AD
• Datacom/DB

Issue/Introduction

When it is determined that a Datacom Index Area (IXX) is corrupt, the IXX needs to be rebuilt.

Will the DBUTLTY DEFRAG function fix a corrupt IXX?

 

Environment

Component : Datacom/DB

Component : Datacom/AD

Resolution

No, the DEFRAG function does not validate or correct the data contained in the index and does not check the pointers in the blocks.

The DEFRAG function reads through the index blocks and merges partially full blocks, defragmenting or compressing the DXX (the "lowest" level of the IXX) that contains key values and pointers to actual rows.

A corrupted IXX requires its entries be rebuilt by reading data from disk using the DBUTLTY function RETIX or using DBUTLTY BACKUP and LOAD of the database. An INIT is only required if doing a RETIX or LOAD at the full database level. If an AREA= is included on the RETIX or LOAD, INIT is not required. Including an INIT is desirable when the total number of index entries associated with an AREA is the majority of the entries in the index.

Note, DBUTLTY functions INIT, RETIX and LOAD require that the database to be closed in the Datacom Multi-user (MUF) while the DEFRAG function does not.

Additional Information

Refer to the Datacom/DB DBUTLTY Reference for more information on the above functions.

As always, please contact Broadcom support for Datacom if you have further questions.