Changing ACCTPRM and CBS back to default DBID values

Products

• Datacom/DB

Issue/Introduction

While in the process of virtualizing the CBS for our Datacom environments, several MUFS had the default DBID’s flipped for the accounting table PRM and CBS.

Example:

ACCTPRM    006,005,YES      ACCOUNTING PRM DBID

CBS        004,780K,0,0,16,1006               

What steps should be taken to re-assign these parameters to use the default DBID assignments? 

Environment

Release : 15.1

Component : DATACOM/DB

Resolution

A MUF outage is required to make these DBID changes.

Follow these steps:

1. Start the MUF with startup option LIMITED_INSTALL_MUF. 
   Some startup options need to be put in comment as mentioned in the documentation.
2. Run DBUTLTY BACKUP on the CXX , datadictionary bases with DBID 2 and 15 , DBID 5 and 6 
3. Run DBUTLTY EXTRACT DBID=6,AREA=PRM,TABLE=PRM,SEQ=NATIVE,DDNAME=
4. Run DDUPDATE 
    -DEL DATABASE,PRM-ACT-DB(,DD,PRIV)
    1000 OBSOLETE
    -END
5. Run DDUPDATE using CABDSAMP members  AC1BAS, AC1DEF and  AC1CPY.
6.  Run DDUPDATE 
       -UPD DATABASE,PRM-ACT-DB(PROD,DD,PRIV)
       1000 CATALOG 
       -END 
7. Rename the existing datasets for IXX004 , IXX006 and PRM006. 
8. Allocate new data sets for IXX004 and PRM004 
9. Run DBUTLTY 

       INIT AREA=IXX,DBID=0004,OLDEP=NO          

       INIT AREA=PRM,DBID=0004                    
       LOAD AREA=PRM,DBID=0004,TABLE=PRM,FORMAT=EXTRACT,SORT=1,SORTDFLT=YES,DDNAME= the extract from step 3
10. Run DDUPDATE using CABDSAMP member BDCBS  (the cards for base CACBSHEURISTIC can be removed).
11. Stop the MUF and then start it after removing LIMITED_INSTALL_MUF and making changes to the CBS and ACCTPRM cards.  Also, VIRTUAL for IXX006 is needed. 
12. Delete  the renamed datasets.
13. Review the existing DBUTLTY ACCT OPTION=CATALOG jobs as they are using DBID=006 . DBID is an optional keyword. DBID=004 is the default.