GLOBAL_DETACH_INFORM (XPS)

All indexes in IBM Informix Extended Parallel Server are detached. An XPS index is locally detached when every index fragment resides on the same coserver as its associated data fragment and and XPS index is globally detached if it is fragmented, with index items and their associated data rows residing on different coservers.

You should avoid using globally detached indexes because they are inherently less efficient than locally detached indexes.

The GLOBAL_DETACH_INFORM environment variable triggers an alarm if a globally detached index is created. The alarm has a severity of 3 (Attention), a Class ID of 10 (Performance Improvement Possible) and a Tag ID of 1 (Globally Detached Index Built).

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

>>-setenv--GLOBAL_DETACH_INFORM--n-----------------------------><
 

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

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

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