Remote operation through DRDA

Db2 SQL Performance Analyzer can run a remote copy of Db2 SQL Performance Analyzer on another Db2® subsystem, on the same z/OS® server, or on another z/OS server by using the DRDA protocol and the SQL CONNECT statement.

The remote locations must contain fully installed versions of Db2 SQL Performance Analyzer, including a REGISTRY and the following explain tables:
  • PLAN_TABLE
  • DSN_STATEMNT_TABLE
  • DSN_FUNCTION_TABLE
  • DSN_DETCOST_TABLE
  • DSN_PREDICAT_TABLE

Users can initiate Db2 SQL Performance Analyzer on any system that contains a valid copy of the product and run their SQL by using any other valid copy and Db2 subsystem through DRDA Connect facilities. The location at which the explain will be performed and the location for the package information can be set differently. Results are returned back to the local system for presentation, storing report files, and other tasks. This feature provides the ability to quickly diagnose production problems.

This feature operates in TSO and batch modes only.