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

book

Article ID: 4885

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- 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)