Use case 3 - COBOL, JCL, HTML5, Oracle and SQL Analyzer

Introduction

After moving from Oracle AIP to SQL Analyzer as explained here Transitioning from Oracle Server , at the end of the new scan the following report has been generated: SQLAnalyzerMetricsReport.csv

During transition, Oracle source will not change, the same extraction will be now analyzed by SQL Analyzer. A new UA analysis unit, equivalent of all previous Oracle analysis units, has been added. Dependency between “Mainframe and the new SQL analysis unit”, and “HTML5 analysis unit and the SQL new analysis unit” has been added at the end.

New dashboard

Numbers

Before After
Nb of modules: 1
Nb of active analysis units: 5
Nb of inactive analysis units: 0
Total nb of analysis units: 5
Nb of saved objects: 208301
Nb of modules: 1
Nb of active analysis units: 4
Nb of inactive analysis units: 0
Total nb of analysis units: 4
Nb of saved objects: 206062
Number of applications with full call graph : 1 (#65050)
Number of relevant objects in repository : 217085
Number of OMG AFP-links in repository : 241689
Number of DF records / TR end points : 18175
Number of transactions : 3863
Number of empty transactions : 1450
Number of links -> DF records / TR end points : 376822
Number of links -> other objects in full graph : 149314
Number of transaction links generated (sum) : 526136
Number of objects in largest transaction : 6337
Number of elements in largest SCC group : 8
Number of applications with full call graph : 1 (#65050)
Number of relevant objects in repository : 210069
Number of OMG AFP-links in repository : 269773
Number of DF records / TR end points : 19067
Number of transactions : 3863
Number of empty transactions : 1450
Number of links -> DF records / TR end points : 376822
Number of links -> other objects in full graph : 149903
Number of transaction links generated (sum) : 526725
Number of objects in largest transaction : 6337
Number of elements in largest SCC group : 8