CA Datacom - How to RETIX a single area
Article ID: 203185
Updated On:
Products
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.
Feedback
