ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How do I delete a User in History (HIST) status from the CA Datacom Datadictionary?

book

Article ID: 49489

calendar_today

Updated On:

Products

Datacom DATACOM - AD Ideal CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services Datacom/AD 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

Description:

I deleted the PROD (Production) version of a User (Entity PERSON) in the CA Datacom Datadictionary which caused a HIST (History) version of the User to be created.
Now, how can I now delete the History version? When I tried to re-add or update the User in DDUPDATE, the following errors result. 

 For:
      -ADD PERSON username                                       
  Result is error:                                                                      
      **** ERROR ****  RETURN CODE = DDPOAE0001  OCCURRENCE ALREADY EXISTS                                                                              
 For:
      1003 RELT,AUTHORIZATION,$DD-SEC-ADM(PROD),PER-ATZ-AUTH    
 Result is error:                                                                          
      **** ERROR ****  RETURN CODE = DDPR010001  CANNOT RELATE TO HISTORY     
 For:                                                     
      -UPD PERSON,TSJSS,PROD 
 Result is error:                                   
      **** ERROR ****  RETURN CODE = DDPISC0001  INVALID STATUS CHANGE REQUEST

Solution:

In batch, use the DDUPDATE utility with the following SYSIN: 

 -USR user, password
 -DEL PERSON, person, (histver,pswd,ovrd)
 -END

Provide the History version, the Datadictionary password and override password.

See CA Datacom Datadictionary Batch reference Guide , chapter: "Using the -DEL Header Transaction" for more information.

Environment

Release:
Component: DB
Powered by Wolken Software