DBUTLTY RETIX when Datacom MUF is down

Products

• Datacom
• Datacom/DB
• Datacom/AD

Issue/Introduction

This article explains how the index of a database can be initialized and the index be recreated based on the table data when the Datacom Multi-User facility ( MUF) is not running.

Environment

Release: 15.1
Component: CA Datacom/DB

Resolution

Run a DBUTLTY job as seen in the following example:

//DBUTLTY PGM=DBUTLTY,REGION=0M
//STEPLIB  DD DISP=SHR,DSN=hlq.CUSLIB  
//         DD DISP=SHR,DSN=hlq.CAAXLOAD  (or CABDLOAD for DB) 
//SYSPRINT DD SYSOUT=*
//SNAPER   DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//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 fails 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 Datacom Core - 15.1 documentation for details on DBUTLTY SET, INIT and RETIX.