OBSOLETE of a database structure gets DDPPWR0001 PASSWORD REQUIRED error message even if a password has been provided

book

Article ID: 5061

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(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

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

Environment

Release: DBCISF00200-15.1-Datacom-Database-Option for CICS Services
Component:

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 TEC1999261 shows how to run a CA Datadictionary report to display the passwords for any occurrence.