Monitoring PDQ Resources

Monitor the resources (shared memory and threads) that the MGM has allocated for PDQ queries and the resources that those 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.