SPEEDGAIN FOR DATASTAGE
Complete application monitoring
A complete picture of the whole application is provided. The intelligent combination of information from DataStage, from the database behind it, and from the associated operating system enables a comprehensive evaluation and analysis.
Internal DataStage process usage display
Usage information is displayed on jobs, stages, data access, and projects, so that the user gains transparency on all relevant resource usage.
From problem to solution
The consequent integration of proven methods of analysis helps the user with in effectively solving problems. By a process of elimination, the bottleneck resource is recognized and, using the causal principle, the responsible factor identified.
Drill down: From the Stage to SQL Explain
Evaluation and linkage to different information sources are consequently implemented into the application. Drill-down functionalities from the Stage to SQL Explain enable efficient and targeted analyses.
Efficient identification of weak points
The rule-based evaluation of job indicators identifies weak points in the system. As a result, the user can focus on performance optimization of relevant objects and save time.
The Status Monitor shows the current status of all monitored DataStage systems, database servers, and databases on one page.
One page – all information:
- DataStage server and database server information
- Detailed DataStage workload and usage information
- Detailed database workload and usage information
The Speedgain Cockpit offers a quick overview of the DataStage activity and resource usage.
- Complete DataStage workload information
- Overview of ETL CPU usage
- Overview of ETL time usage
- Overview of the stages
The Job Monitor provides transparency to all job activities. Jobs responsible for high usage values are identified using an ABC overview analysis.
- Drill-through of stage and job details
- Display of database stages
The Stage Monitor provides all the information for the analysis of the stages.
- All job stages listed
- Statements on pipelining and partitioning (critical path or uneven distribution of data)
- Identification of stage presenting a weak point
- Drill-through on link information
Server Monitoring provides the basis of optimal server configuration. Display of correlated operating system and DataStage performance metrics, preparation of server performance indicators for causal analysis
- Number of interrupts and context switches
- CPU load
- Storage usage
- SWAP area usage
Clear assignment of DataStage or database weak points
A clear message states which phase a resource usage has surfaced in: E, T, or L. Through this, it is quickly ascertained whether the system responsible is the database or DataStage.
Improved ETL processes based on historical causal analysis
During a causal analysis, all necessary historical information from the DataStage server is made available. This includes data from the database, the operating system and network, alongside the performance data of the DataStage. This enables a retroactive and complete analysis of specific problems and leads to an improved service quality of ETL processes.
Transparency on the ETL process - Where has the time gone?
A complete view of the process beyond the boundaries of the DataStage server provides transparency on time usage. This is the basis for analysis and optimization.
Competent help when it's necessary
All support and development is provided from Germany. In a worse-case scenario, there are experienced DBAs at your side who are able to set up Speedgain themselves.
Cost savings though a one-stop solution for performance management of DB2, Oracle, DataStage and BigSQL
Employees require less time for familiarization, as all Speedgain products are built in the same intuitive way. Usage is more efficient, and the quality of the service is improved.