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

Article Id: 49489

Status: Published

Updated On: 21-03-2018 07:15

Legacy Id: TEC576366

Products:

CA Datacom CA Ideal 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:

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