If you have too many analysis units then you may use the below way to identify the analysis units that has not been executed.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 |
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';"Execute all queries, the query that returns rows, and does not contain execdate of the analysis unit that has not been executed/run.
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.