Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Unix SQL Advanced SQL 4GL Applications Advanced 4GL IDS Admin Migrating to V14 IDS Performance Managing & Optimising SPL and Triggers IDS V14 Upgrading Very Old Versions Custom Training
Onstat Guide Error Code Guide Reference Datablades The Dumb DBA Sysmaster Fault Finder
Co-Location Web Hosting Managed Servers Web Development
BenchMark Tookkit RegExp Datablade
Partnerships Contact
Onstat
-g act -g afr -g all -g amx -g aqt -g arc -g ath -g btc -g buf -g cac -g cdr -g cluster -g cdr config -g cfg -g cmsm -g con -g cpu -g dbc -g ddr -g dic -g dis -g dll -g dmp -g dri -g dsc -g dsk -g dss
-g env -g ffr -g glo -g grp -g imc -g ioa -g iob -g iof -g iog -g ioq -g iov -g ipl -g lap -g laq -g lmm -g lmx -g lsc -g mem -g mgm -g nbm -g nif -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-g opn -g osi -g pgp -g pos -g ppd -g ppf -g pqs -g prc -g proxy -g qst -g rah -g ras -g rbm -g rcv -g rep -g rea -g rss -g sch -g scn -g sds -g seg -g ses -g sle -g smb -g smx -g spi -g sql -g src -g ssc -g stk -g stm -g stq -g sts -g sym -g sync
-g rwm -g tgp -g tpf -g ufr -g wai -g vpcache -g wmx -g wst
-b/-B -F -g cac -g dic -g dsc -g prc -g ssc -g vpcache -h -p -X
-t/-T -g buf -g lap -g opn -g ppf -g scn
-g cat -g cdr -g cdrconfig -g ddr -g dss -g dtc -g grp -g nif -g que -g rcv -g rep -g rqm -g sync
-g cluster -g cmsm -g dri -g ipl -g laq -g proxy -g rss -g sds -g smx
-R -g afr -g ffr -g lmm -g lsc -g mem -g mgm -g nbm -g rbm -g seg -g ses -g stm -g stq -g ufr
-g imc -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-G -u -x -g env -g his -g pqs -g ses -g sql
-g act -g ath -g cpu -g rea -g sle -g stk -g sts -g tpf -g wai -g wst
-a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -g ioq Disk IO Statistics by Queue

The onstat -g ioq command provides statistics on the disk I/O by queue. The command line can specify the queue name 

AIO I/O queues:                                                 
q name/id    len maxlen totalops  dskread dskwrite  dskcopy     
drda_dbg   0      0      0        0        0        0        0
sqli_dbg   0      0      0        0        0        0        0
  kio   0      0     32    28354    12980    15374        0     
  adt   0      0      0        0        0        0        0     
  msc   0      0      1     3169        0        0        0     
  aio   0      0      1       95        9        2        0     
  pio   0      0      0        0        0        0        0     
  lio   0      0      0        0        0        0        0     
  gfd   3      0      0        0        0        0        0

Output Description

Heading Description Format
q name The AIO queue name.
  • drda_dbg: Handles I/O for DRDA feature
  • sqli_dbg: Handles I/O for SQL Interface Debugging feature
  • fifo: Handles I/O for FIFO VPs
  • adt: Handles auditing I/O
  • msc: Handles miscellaneous I/O
  • aio: Handles asynchronous I/O
  • kio: Handles kernel AIO
  • pio: Handles physical logging I/O
  • lio: Handles logical logging I/O
  • gfd: Global File Descriptor - Each primary and mirror chunk is given a separate global file descriptor. Individual gfd queues are used depending on whether kaio is on and the associated chunk is cooked or raw.
 Str
q id The global file descriptor associated with this queue (files only). Dec
len The current number of active requests in this queue. Dec
maxlen The maximum number of requests this queue has held. Dec
totalops The total number of operations performed for this queue. Dec
dskread The total number of read operations performed for this queue. Dec
dskwrite The total number of write operations performed for this queue. Dec
dskcopy The total number of copy operations performed for mirroring against this queue. Dec

Notes

    One gfd queue name exists for each chunk in the system.

Monitoring and Tuning

    The information from the onstat -g ioq command can assist in identifying bottlenecks with the processing of I/O through the queues. If the maxlen column for the AIO queue tends to exceed 25, additional AIO VPs should be started.

    The onstat -g ioq output for the global file descriptors (gfd) or chunks may also identify a potential I/O problem with specific disks in the system if certain gfd queues begin to back up. It may also point out a chunk that contains a table that needs better partitioning (fragmentation).

To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.