Receiving a 94(157) for cleanup on CBS DBID change

Products

• Datacom/DB

Issue/Introduction

Steps have been completed to change ACCTNUM from DBID 006 to DBID 0004 and the CBS has been changed from DBID 004 to DBID 006. 
However there are a few things that I didn’t anticipate.

The DBUTLTY has been run  to remove the DBID 006 data set name from the CXX as follows but and error was encountered and the IXX and PRM areas for DBID 006 are still defined to the CXX.

How do I remove them?

CXXMAINT OPTION=ALTER,DBID=006,AREA=IXX,DSN=*
CXXMAINT OPTION=ALTER,DBID=006,AREA=PRM,DSN=*

                    FUNCTION=CXXMAINT
                       AREA=PRM
                       DBID=00006
                       DSN=*
                       OPTION=ALTER

DB13001E - UNEXPECTED RETURN CODE 94 (157) INVALID AREA NAME
                    DB10045E - ABNORMAL TERMINATION DUE TO ERROR(S)

Additionally, when redefining the CBS base, the error and message below was encountered.  Is this acceptable? Is additional action required? 

   FUNCTION = DELETE-ENTITY
          ENTITY-TYPE       = DATABASE
          OCCURRENCE        = CBS-DB
          VERSION           = PROD

  **** ERROR ****  RETURN CODE = DDPNTF0003  NOT FOUND

   FUNCTION = CATALOG-STRUCTURE
          ENTITY-TYPE       = DATABASE
          OCCURRENCE        = CACBSTEMPORY
          VERSION           = PROD

  *** VERIFY WARNING MESSAGES ***
   DDWBAS0001 WARNING DATABASE HAS NO AREAS

  FUNCTION = CATALOG-STRUCTURE
         ENTITY-TYPE       = DATABASE
         OCCURRENCE        = CACBSHEURISTIC
         VERSION           = PROD

 *** VERIFY WARNING MESSAGES ***
  DDWKEY0013 SIGNED NUMERIC FIELD IN KEY
 ENTITY=CACBSHEURISTIC.KEY

Environment

Release : 15.1

Resolution

That PRM area is in history status in the CXX and so you get this RC 94(157). 

To remove PRM 006 from the CXX, first run DBUTLTY with sysin

CXXMAINT OPTION=DELETE,DBID=6,TABLE=PRM  

Then run DBUTLTY CXXMAINT OPTION=ALTER,DBID=006,AREA=IXX,DSN=*

 

First error was performing a delete and nothing was found to be deleted, so it threw out a "not found" error for this case

Second error/warning message is since you are virtualizing CBS, it will have no physical area which is what it is warning message means.

Third, the DDWKEY0013 message is a warning that a key contains signed numeric fields. It just tells you that a field that makes up a key is signed numeric.