Datacom RC 25(1) using CXXMAINT to remove DSN for VIRTUAL file

Products

• Datacom/DB
• Datacom/AD
• Datacom

Issue/Introduction

I am performing a cleanup on my environment and want to know how do I remove the old DSN reference in the CXX to DBID 017 CXX when the area is virtual.

I tried running CXXMAINT and get the following error:
Base:    17         

TABLE NAME - TTM
OCCURRENCE - TTM-TABLE P001
TABLE ID   -      1
RECORD LENGTH    -  4,082 /  4,094
RECORDS IN TABLE -              83
LENGTH OF KEY/ELEMENTS -    144
NUMBER OF KEYS         -      1
NUMBER OF ELEMENTS     -      1
CHANGE MASTER KEY    - NO
DUPLICATE MASTER KEY - NO
RECOVER  - YES   ENCRYPTION - NONE
LOGGING  - NO
....
TRIGGER(S)        - NO
CURRENT ROW(S) VIOLATE CONSTRAINT(S) - NO
DATA SET NAME - your.datacom.dataset.name.TTM017
VOLUMES       - vol1

----------------------------------------------

 CXXMAINT OPTION=ALTER,AREA=TTM,DBID=017,DSN=*

************************************************************

DB13001E - UNEXPECTED RETURN CODE 25 (1) CXX MAINTENANCE, VIRTUAL BASE
                    DB10045E - ABNORMAL TERMINATION DUE TO ERROR(S)

Environment

Release : 15.1

Cause

DBID 17 cannot be closed when the MUF has been enabled with SQL.

Resolution

A recycle of MUF would be required with all SQL startup related options and VIRTUAL 17 option commented out.

Once MUF is running with SQL off, CXXMAINT can be used to clear out or change the dataset name.