Dynamic SQL is essential for assessing the potential of performance improvement of client/server applications using z/OS-based DB2 environments. AQM Solutions’ Dynamic SQL Performance Control (DSPCTM) offers precise insight into DB2 CPU usage, quickly and with a minimum of personnel overhead. DSPC allows DB2 accesses that cause performance bottlenecks to be identified, analyzed, and optimized without extensive manual searches. It identifies individual dynamic SQL statements that may originate from mainframe or distributed applications, providing statement-level granularity that helps bridge the gap in the performance management process.

DSPC is a product of Data Base Solutions AG.

  • Detecting optimization potential of dynamic SQL statements
  • Producing “hit lists” of primary SQL statement consumers  
  • Evaluating, analyzing and optimizing dynamic SQL
  • Reducing CPU consumption by client/server applications that use DB2 on zOS
  • Improving service levels and end-user productivity
  • Increasing CPU savings and delaying expensive upgrades
DSPC Process
click to enlarge
  • Allows “transparent” view of  dynamic SQL CPU usage    
  • Provides key performance tuning data for dynamic SQL workloads
  • Monitors and logs DB2 cache activities
  • Works quickly with minimum manual intervention
  • Identifies key CPU resource consumers quickly
  • Produces comprehensive reports for analysis