|
InnovizeIT for DB2 Flow Diagram
Main Product Processes:
- Data Preparation on Mainframe (data download - scripts generation)
- DB2 Catalog tables:
- metadata
- SQL Syntax
- DB2 Access information:
- Plan tables
- Statement tables (static, dynamic)
- Monitoring Information
- Transfer data to PC working environment:
- Download binary files and transfer to PC
- Upload (including EBCDIC to ASCII conversion)
- Data Processing
- Run queries for initial processing
- SQL Syntax Parsing
- Gather recommendations by schema objects (indices, tables, etc.)
- Calculation of relative cost for each performance issue <still not released>
- Recommendations - interactive research
- Recommendations display through set of linked screens with Drill Down functionality
for research
- Recommendation selection
- Reporting
- Executive level – Dashboard. Summary of issues and recommendations
- Detailed reporting
- Work Plan
|