search cancel

CA Datacom - How to RETIX a single area

book

Article ID: 203185

calendar_today

Updated On:

Products

Datacom DATACOM - AD Datacom/DB INFOCAI MAINTENANCE

Issue/Introduction

After restoring a single area in a database, a RETIX needs to be performed.

How can a RETIX be done for that area only without affecting the others?

 

Environment

Release :  15.1

Component : CA DATACOM/DB

Resolution

A RETIX can be performed for one area only by specifying the AREA= parameter in the RETIX statement.

When doing a RETIX of a single area, do not perform an INIT prior to the RETIX as that will clear the index entries for all the other areas in the database.

The RETIX of a single area can be done under the control of the MUF by specifying parameter MULTUSE=YES. In this way, there is no need to CLOSE the whole DBID so the other areas in the DBID can still be updated while you perform the RETIX. See Article 55735 which explains the use of MULTUSE=YES with DBUTLTY. 

Run DBUTLTY with the following input:

ACCESS STATUS=UTLTY,DBID=nnn,AREA=aaa,USERS=FAIL 
RETIX DBID=nnn,AREA=aaa,SORT=999999999,SORTWK=10,MULTUSE=YES
ACCESS STATUS=WRITE,DBID=nnn,AREA=aaa

The RETIX can also be done in single-user mode. In this case, the whole DBID needs to be closed in the MUF first, use the following input:

ACCESS STATUS=OFF,DBID=nnn,USERS=FAIL 
COMM OPTION=CLOSE,DBID=nnn 
RETIX DBID=nnn,AREA=MM2,SORT=999999999,SORTWK=10,OPTIMIZE=YES
ACCESS STATUS=WRITE,DBID=nnn

Additional Information

See the CA Datacom documentation in https://techdocs.broadcom.com/, section Rebuilding an Index Area.