Issue:
CA Datacom/DB Version 14.0 upgrade job BDUPG07 STEP9E resulted in error:
DDPFI30001 FILE NAME NOT CODED
The UNIVERSAL Table is very old and not connected to any database. It also does not exist in our production so I wanted to delete it but I am getting errors when trying to run a DDUPDATE to delete:
-DEL TABLE,UNIVERSAL(0000)
DDPIVS0001 INVALID VERSION/STATUS
-DEL TABLE,UNIVERSAL(T000)
TRANSACTION ERROR: DDFHDR0058 INVALID VERSION
-DEL TABLE,UNIVERSAL(TEST)
TRANSACTION ERROR: DDFBWT0007 INVALID VERSION-STATUS
How can I delete TABLE UNIVERSAL?
Environment:
CA Datacom/DB 12.0 upgrade to 14.0
z/OS
Cause:
CA Datacom/DB provided Table UNIVERSAL had been obsolete for several versions and should have been deleted in the past.
Resolution:
Run the following DDUTILTY report to find out if you have that UNIVERSAL entity as a FILE/RECORD pair defined in to the DATA-DICT and not as a TABLE entity:
-USR...
-DEF PATH,P1
-DEF TRACE,FILE.RECORD,$INTERNAL
-END
-RPT START,FILE,UNIVERSAL(ALL),P1
-RPT INDENT
-END
If this report gives you a not found condition then check if you have a user table with entity-name UNIVERSAL.
If not found or you have a user table named UNIVERSAL, open a support case so we can provide you a program called DDUNILM that will transform this Table into a FILE/RECORD pair. DDUNILM is the "UNIVERSAL" table clean up program.
Note, DDUNILM may return with COND 88 which can be ignored.
After you run DDUNLIM, verify the results with this DDUTILTY report:
-USR ...
-DEF PATH,P1
-DEF TRACE,FILE.RECORD,$INTERNAL
-END
-RPT START,FILE,UNIVERSAL(ALL),P1
-RPT INDENT
-END
The result should show the UNIVERSAL File and Record occurrence in T000 status.
If so, you can now rerun job BDUPG07 starting at STEP9E.
Additional Information:
Contact CA Datacom/DB Support if you need DDUNILM or have any questions or other problems.