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.
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.
