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

Applicable RDBMS

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 = ‘’ 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**