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

Document ID : KB000004885
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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) 

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)