Informix Warehouse Accelerator: New Info for Query Tasks

Blog Content/Topics List


 

imageThe information provided applies to Informix Server and IWA Version 12.10.FC6 and newer.

With the new release of Informix 12.10.FC6 (GA in November 2015) comes the following new feature for the Informix Warehouse Accelerator (IWA), enhancing the information on query tasks.

The utility "ondwa", which is run in the environment of IWA accepts the option "tasks" to display a list of tasks that are currently ongoing in IWA. For each task some general and task specific data is displayed in the output. A feature request from at least one customer asked for more information on tasks of the type QUERY. While it is nice to see in the list of tasks which tasks pertain to queries that are currently being worked on or queued, including how much memory the tasks has in use, it is even better to be able to figure out, from where running queries originate. While on an Informix server there is the possibility to list current sessions with the command "onstat -g ses [ session_id ]", there is no reference in the output of "ondwa tasks" for linking a running query task back to the client session in Informix that issued the query.

Because different Informix server instances can connect to the same IWA, the complete information needed to link back to the origin of a query also needs to identify the Informix server instance. The choice for implementing all this is to use the numerical identifiers for both, as this can be transfered in a rather compact format compared to longwinded things like the actual name of an Informix server instance.

As a result, "ondwa tasks" output now shows the session ID of the client session in the Informix server and the server number of the Informix server instance for running query tasks. The client session ID corresponds to the one displayed by "onstat -g ses" and the server number of the Informix server instance corresponds to the value of the configuration parameter SERVERNUM. Following is an example of this new output format from the "ondwa tasks" command:

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 125819314589663232 (of type 'DAEMON' with name DRDADaemon - 12:06)
------------------+--------------------------------+---------+---------+--------+------------
  Location        | Status                         | Progr.  | Upd. ms | Memory | Monitor
------------------+--------------------------------+---------+---------+--------+------------
  Primary Node 0  | Running                        |       4 |    3078 |      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 -

The session ID and server number information is sent from the Informix server to IWA at the time of preparing the query statement. Therefore, for queries that are only queued but have not yet reached the prepare phase this new additional information is not displayed.


Blog Content/Topics List