Monitoring resources used for PDQ and DSS queries

You can monitor the resources (shared memory and threads) that the Memory Grant Manager (MGM) has allocated for PDQ queries and the resources that PDQ and decision-support (DSS) queries currently use.

You monitor PDQ resource use in the following ways:
  • Run individual onstat utility commands to capture information about specific aspects of a running query.
  • Execute a SET EXPLAIN statement before you run a query to write the query plan to an output file.

Copyright© 2019 HCL Technologies Limited