Testing temporary storage usage with the query governor

 

The predictive storage governor specifies a temporary storage limit for database queries. You can use the query governor to test if a query uses any temporary object to run the query, such as a hash table, sort or temporary index.

To test for a temporary object's usage, do the following:

• Set the query storage limit to zero ( QRYSTGLMT(0) ) using the Change Query Attributes (CHGQRYA) command or in the INI file. This forces an inquiry message from the governor anytime a temporary object will be used for the query, regardless of the temporary object's estimated size.

• Prompt for message help on the inquiry message and find the same information that you can find by running the Print SQL Information (PRTSQLINF) command. This allows you to see what temporary object(s) was involved. 

 

Parent topic:

Set resource limits with the Predictive Query Governor

 

Related information

Print SQL Information (PRTSQLINF) command
Change Query Attributes (CHGQRYA) command