Automic Workload Automation

Expand all | Collapse all

Hidden objects

  • 1.  Hidden objects

    Posted 12-08-2015 07:50 AM
    In activation logs I often see messages related to objects that are not visible in the system, e..g., XC_INC.ACTION.SET_VALUE. Is there a way to display these objects so that I can better understand how they work?


  • 2.  Hidden objects

    Posted 04-07-2017 08:33 AM
    The XC_INC.* objects appear to be JOBI objects related to XREQ objects. Based on my SQL query for displaying XREQ objects, I came up with a simpler query to display just XC_* JOBI objects.
    WITH BIND_PARMS
                   AS (SELECT 'XC_%' AS OBJECT_NAME FROM DUAL),
         OT_TABS
         AS (  SELECT OH_Idnr,
                      RTRIM (
                         XMLCAST (
                            XMLAGG (XMLELEMENT (e, OT_Content || CHR (10))
                                    ORDER BY OT_Lnr) AS CLOB))
                         AS OT_CONTENT_CLOB
                 FROM OT LEFT OUTER JOIN OH ON OT_OH_Idnr = OH_Idnr
             GROUP BY OH_Idnr
             ORDER BY OH_Idnr),
         INITIAL_DATA_OBJECTS
         AS (  SELECT OH.OH_Idnr,
                      OH_Name,
                      OH_OType,
                      OT_TABS.OT_CONTENT_CLOB
                 FROM OH LEFT JOIN OT_TABS ON OH.OH_Idnr = OT_TABS.OH_Idnr
                WHERE     OH_NAME LIKE (SELECT OBJECT_NAME FROM BIND_PARMS)
                      AND OH_Client = 0
                      AND OH.OH_Idnr < 100000
                      AND OH_OType = 'JOBI'
                      AND OH_DeleteFlag = 0
             ORDER BY OH_Name)
    SELECT *
      FROM INITIAL_DATA_OBJECTS
    WHERE 1 = 1 AND ROWNUM < 1000
    There are also some VARA and PRPT objects related to the XC_* JOB objects.
    select * from OH
    where 1=1
    and OH_Client = 0
    and OH_Idnr < 100000
    and OH_DeleteFlag = 0
    and OH_OType <> 'XREQ'
    and OH_Name like 'XC_%'
    order by OH_OType,OH_Name asc

    As far as I could determine, all of these objects are included with the initial data. This is evident from the fact that they all have OH_Idnr values less than 100000. One can list all initial data objects using this query:
    select * from OH
    where 1=1
    and OH_Client = 0
    and OH_Idnr < 100000
    and OH_DeleteFlag = 0
    order by OH_Idnr asc