ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

OBSOLETE of a database structure gets DDFBWT0007 INVALID VERSION-STATUS error message

book

Article ID: 4885

calendar_today

Updated On:

Products

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services Datacom/AD CA ecoMeter Server Component FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA On Demand Portal CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware

Issue/Introduction

DDUPDATE utility is executed to delete all the versions of HUMAN-RESOURCE sample database via OBSOLETE function:

+DEL DATABASE,HUMAN-RESOURCE(ALL,DD,PRIV)
1000 OBSOLETE
+END

but it fails due to:
CODE ENTITY-TYPE,OCCURRENCE(VERS,PSWD,OVRD),STATUS,LOCK
-DEL DATABASE,HUMAN-RESOURCE(ALL,DD,PRIV)
TRANSACTION ERROR: DDFBWT0007 INVALID VERSION-STATUS 

Cause

The customer specified ALL as version:

 

-DEL DATABASE,HUMAN-RESOURCE(ALL,DD,PRIV) 

Environment

Release: DATABB00200-14-Datacom/AD
Component:

Resolution

ALL is not a valid version for -DEL header transaction. The customer can specify any valid version/status (T001,PROD..)

 

Note that usually OBSOLETE doesn't require a version on -DEL header transaction:

-DEL DATABASE,MYDB
1000 OBSOLETE
-END
 

but in this case a password is required so the customer can specify:

-DEL DATABASE,HUMAN-RESOURCE(PROD,DD,PRIV)

or:

 

-DEL DATABASE,HUMAN-RESOURCE(,DD,PRIV)