Monitor frequent load and unload operations

The following example shows sample onstat -g iof command output.

AIO global files:
gfd path name      bytes read   page reads   bytes write   page writes  io/s
3   rootdbs       1918976      937          145061888     70831        36.5

      op type     count         avg. time
      seeks       0             N/A
      reads       937           0.0010
      writes      4088          0.0335
      kaio_reads  0             N/A
      kaio_writes 0             N/A

To determine if a load or unload operation can use parallel execution, execute the SET EXPLAIN ON statement before 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