IQ UTILITIES Command

IQ UTILITIES is the underlying statement that executes whenever you run most IQ system procedures. In most cases, users are unaware that IQ UTILITIES is executing. The only time IQ UTILITIES is issued directly by users is to run the IQ buffer cache monitor.

IQ UTILITIES provides a systematic way to collect and report on information maintained in the IQ system tables. There is no general user interface; you can use IQ UTILITIES only in the ways that existing system procedures do.

System procedures declare local temporary tables in which to store information. When you execute a system procedure, it in turn executesIQ UTILITIES to get the information from the system tables and store it in the local temporary table. The system procedures may simply report the information from the local temporary table or perform additional processing.

In some system procedures, the IQ UTILITIES statement includes a predefined number as one of its arguments. This number performs a specific function, for example, deriving a value from information in the system tables.