OH_DeleteFlag: what is the meaning of the the values

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The OH_Deleteflag of table OH can have one of these values:

 

Value	Description
0	'Normal' object.
1	Object moved to recycle bin, including version objects of the deleted object
2	Version Control Object
5	Object marked by DB Unload to be removed while reorg-run

Example:

SQL> SELECT
  2      oh_idnr,
  3      oh_deleteflag,
  4      oh_client,
  5      oh_name
  6  FROM
  7      oh
  8  WHERE
  9      oh_name LIKE '%JAC#MIGRATION.DUMMY.JOBS%'
 10  ORDER BY oh_name;

 OH_IDNR OH_DELETEFLAG  OH_CLIENT OH_NAME
-------- ------------- ---------- ---------------------------------------------------
 2261415             0       1977 JAC#MIGRATION.DUMMY.JOBS
 2276368             1       1977 JAC#MIGRATION.DUMMY.JOBS.NEW.1.OLD.20161124.110909
 2276369             1       1977 JAC#MIGRATION.DUMMY.JOBS.NEW.1.OLD.20161124.110924
 2276367             1       1977 JAC#MIGRATION.DUMMY.JOBS.NEW.1_0002276367
 2276366             2       1977 JAC#MIGRATION.DUMMY.JOBS.OLD.20161124.110823

 

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

N/A