search cancel

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

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

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

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