ondwa tasks command
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.
$ ondwa tasks
TaskManager tracking 3 task(s):
------------------+--------------------------------+---------+---------+--------+------------
Task 410390516044136472 (of type 'QUERY' with name Session 4 @ Servernum 74 - 0:00)
------------------+--------------------------------+---------+---------+--------+------------
Location | Status | Progr. | Upd. ms | Memory | Monitor
------------------+--------------------------------+---------+---------+--------+------------
Primary Node 0 | OPNQRY | 0 | 59 | 163K | Fine
-> Node 1 | Dim 110 | 0 | 3 | 18M | Fine
(Total Memory) | | | | 18M |
------------------+--------------------------------+---------+---------+--------+------------
Used Resources | Mart ID: 0 1 on node 0
------------------+--------------------------------+---------+---------+--------+------------
Task 227150306205499494 (of type 'QUERY' with name Query execution @ coordinator - 0:00)
------------------+--------------------------------+---------+---------+--------+------------
Location | Status | Progr. | Upd. ms | Memory | Monitor
------------------+--------------------------------+---------+---------+--------+------------
Primary Node 0 | Queued | 0 | 160 | 0 | Fine
(Total Memory) | | | | 0 |
------------------+--------------------------------+---------+---------+--------+------------
------------------+--------------------+---------+---------+--------+------------
Task 437785070080 (of type 'DAEMON' with name DRDADaemon - 4:48)
------------------+--------------------+---------+---------+--------+------------
Location | Status | Progr. | Upd. ms | Memory | Monitor
------------------+--------------------+---------+---------+--------+------------
Primary Node 0 | Running | 2 | 30 | 0 | Fine
(Total Memory) | | | | 0 |
------------------+--------------------+---------+---------+--------+------------
Used Resources | DRDA device: 'lo' address: '127.0.0.1:21022' on node 0
| Unbound on node 0
------------------+--------------------+---------+---------+--------+------------
- End of Tasklist -
Release date: March 2015