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