How to RETIX when Datacom MUF down

Document ID : KB000102975
Last Modified Date : 21/06/2018
Show Technical Document Details
Question:
How do I reinitialize and rebuild a database INDEX when the Datacom Multi-User (MUF) is down? 
Answer:
Run a DBUTLTY job as seen in the following example:

//DBUTLTY PGM=DBUTLTY,REGION=0M
...
//SYSIN    DD *                               
 SET OPTION1=MUF_NOT_ENABLED                  
 INIT AREA=IXX,DBID=dbid                     
 RETIX DBID=dbid,OPTIMIZE=YES,SORT=1000000, 
   SORTDFLT=YES,SORTDD=SYSOUT,OPTION1='(I)'  
/*                                     
      

NOTE:
The SET shown is needed when MUF is non enabled or the DBUTLTY step will fail with Datacom RC 68(001).
The INIT is needed or the DBUTLTY step will fail with the following error: 
DB13028E - LOAD/RETIX FOR FULL BASE MUST FOLLOW AN INIT OF THE INDEX FOR THE BASE
The RETIX syntax as shown is an example.
 
Additional Information:
Refer to the CA Datacom Core - 15.1 documentation for details on DBUTLTY SET, INIT, and RETIX.