Monitoring Frequent Loads and Unloads

Use the onstat -g iof command to find out the global file descriptor (gfd) in the file that you want to examine. Figure 83 shows sample output.

AIO global files:
gfd   pathname   totalops    dskread   dskwrite    io/s
19    /tmp/pipe

To determine if the load or unload can use parallel execution, execute the SET EXPLAIN ON statement prior to the INSERT statement. The SET EXPLAIN output shows the following counts:

• Number of parallel SQL operators that the optimizer chooses for the INSERT statement
• Number of rows to be processed by each SQL operator

To monitor a load job, first run onstat -g sql to obtain the session ID, and run onstat -g xmp to obtain the query ID for the session ID. Then you can run onstat -g xqs query id to obtain the runtime number of rows processed by each SQL operator that the SET EXPLAIN output listed.

To obtain statistics for a coserver to which you are not connected or for multiple coservers, use the xctl utility to execute the onstat command. The xctl prefix displays onstat information for each coserver that is currently initialized.