IFMX_CART_ALRM (XPS)

The IFMX_CART_ALRM environment variable triggers an alarm if a query executes a Cartesian join. The alarm has a severity of 3 (Attention), a Class ID of 10 (Performance Improvement Possible) and a Tag ID of 2 (Cartesian Join Processing). The alarm message indicates the ID of the session executing the Cartesian join.

To enable this alarm, set IFMX_CART_ALRM to any value before starting the database server.

>>-setenv--IFMX_CART_ALRM--n-----------------------------------><
 

Alternatively, you can turn this variable on or off with the onutil SET command:

% onutil
1> SET IFMX_CART_ALRM 1;
Dynamic Configuration completed successfully

Because IFMX_CART_ALRM is an environment variable and not a configuration parameter, it cannot be made persistent by the onutil command. Add the variable to an environment-configuration file to avoid setting it each time the server is restarted.