CMS Analysis Unit - Information - Identify the analysis units that has not been executed

Purpose

If you have too many analysis units then you may use the below way to identify the analysis units that has not been executed.

Applicable CAST Version, CAST Extension Version, CAST Component Version


Release
Yes/No
8.3.x (tick)
8.2.x (tick)


Applicable RDBMS
RDBMS
Yes/No
Oracle Server (tick)
Microsoft SQL Server (tick)
CSS3(tick)
CSS2 (tick)
Details
  1. Run the following query on the mngt schema in order to generate the queries on analysis units by technologies:

    select
    'select object_name, execstatus, execdate from ' || table_name || ' where execstatus = ''ExecutionSuccessStatus'';'
    from
    information_schema.tables
    where
    table_schema = '<name of the management schema>'
    and
    table_name like '%analysis'
    Query result example
     "select object_name, execstatus, execdate from cms_pb_analysis where execstatus = 'ExecutionSuccessStatus';"

    "select object_name, execstatus, execdate from cms_asp_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_bo_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_cobol_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_cpp_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_forms_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_j2ee_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_migr_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_net_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_ora_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_sap_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_sqlsrv_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_syb_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_ua_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_udb_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_ui_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_vb_analysis where execstatus = 'ExecutionSuccessStatus';"
    "select object_name, execstatus, execdate from cms_zos_analysis where execstatus = 'ExecutionSuccessStatus';"

  2. Execute all queries, the query that returns rows, and does not contain execdate of the analysis unit that has not been executed/run.
    (warning) Note - All the tables that are used in the above select queries are internal tables and no update/delete/insert operations has to be performed on these tables.

Notes/comments

 

Related Pages