OBSOLETE of a database gets DDPPWR0001 PASSWORD REQUIRED

Products

• Datacom

Issue/Introduction

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

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

but it fails due to:

CODE ENTITY-TYPE,OCCURRENCE(VERS,PSWD,OVRD),STATUS,LOCK
-DEL DATABASE,HUMAN-RESOURCE(PROD,DD,PRIV)
TRANSACTION ERROR: DDPPWR0001 PASSWORD REQUIRED

even if the password is actually provided in the -DEL header transaction

Environment

Datacom 

all versions

Cause

An old version of the occurrence has a different password, as shown by an Index report:

DATABASE HUMAN-RESOURCE 0002 H 0 HR11
DATABASE HUMAN-RESOURCE 0003 H 0 DD
DATABASE HUMAN-RESOURCE 0004 P 0 DD
DATABASE HUMAN-RESOURCE T001 T 0 DD

Resolution

Version 002 must be deleted first, as it has a different password (HR11 instead of DD):

+DEL DATABASE,HUMAN-RESOURCE(0002,HR11,PRIV)
+END

then the other versions can be deleted all together using the OBSOLETE function:

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

Additional Information

Technical document 9842 shows how to run a Datadictionary report to display the passwords for any occurrence.