DB2 Application Performance Trace and Optimization

InfoTrace® for DB2 on z/OS

Together with InfoSimulation and InfoScope, InfoVic is part of the INFO-OPTIMIZER line, a software suite ensuring the quality of DB2 applications throughout their life cycle.

The Problem

  • Today, DB2 applications are increasingly complex and the size of DB2 databases never stops growing
  • A company needs to respond quickly to customers to gain a competitive edge
  • It is crucial for a company to trace and improve performance throughout the life cycle of DB2 applications
  • It is always necessary to be able to trace execution of an application whose performance is identified as below par

The InfoTrace solution

  • InfoTrace is designed to provide a low-cost simple solution to performance problems of DB2 programs from design through production
  • InfoTrace generates the information you need to fine-tune your DB2 application packages or plans
  • InfoTrace allows you to analyze and explain, i.e. control the performance of DB2 applications

More details…

The advantages of InfoTrace

  • It considerably reduces adjustment and maintenance times and provides a rapid return on investment
  • It allows on-demand trace (you select the plans to be traced, the trace start time, and how long it lasts)
  • It offers a clear analysis of the access path chosen by DB2 and the actors who led to this choice
  • It makes recommendations for improving the performance of the queries analyzed
  • It is very easy to use with an interactive ISPF interface

We are prepared to demonstrate to you the excellent return on investment you will achieve with InfoTrace.