The ondwa tasks command shows information about the tasks that are
currently running, memory that is used, and resources.
To
run this command, log on to the computer where the accelerator server
is installed either as user root or as user informix. For you to run
the command as user informix, specific memory resources must be available.
For more information, see Users who can run the ondwa commands.
The ondwa tasks command shows information about the following types of
tasks:
GENERIC: An unknown or generic task
QUERY: A running or queued query
LOAD: LOAD data processing
UPDATE: Incremental update processing, such as data mart refreshing and trickle feed
DAEMON: A running daemon
CLIENT CONNECTION: The AccessController establishing a connection and authenticating a user
TRACE COLLECTION: Trace collection
You can identify the client session in the database server that issued a
query that is being run by Informix® Warehouse Accelerator. The
ondwa tasks command shows the client session number, the @ symbol, and the value
of the SERVERNUM configuration parameter of the database server: for example, Session 4 @
Servernum 74. Queries that are queued have the task name Query execution @
coordinator.