informon

Informix Monitoring/Management Tools

./js

JavaScripts

./sh

Korn Shell Scripts v2

./tool

Korn Shell Scripts v1

Usage Example : READ AHEAD Top Table List

$ node toprah
-------------------------------------------------------------------------------------------------------------------
   READ AHEAD Top Table List

   Usage : toprah.js [ check interval (sec) ] [ number of tables ] [ sort by d(diskReads) | b(bufferReads) ]
   Unit of data size : Byte
-------------------------------------------------------------------------------------------------------------------
   systabnames.unl loaded.
   getting rah at 1651041643072 = Wed Apr 27 2022 06:40:43 GMT+0000 (KST)
   Countdown : 0 / 10
   getting rah at 1651041653096 = Wed Apr 27 2022 06:40:53 GMT+0000 (KST)
-------------------------------------------------------------------------------------------------------------------
partnumHex    partnumInt          diskReads        bufferReads             DBName   TableName
-------------------------------------------------------------------------------------------------------------------
 0x1200182      18874754      1,898,192,896      5,912,162,304
 0x210014d      34603341      1,318,387,712      3,950,080,000
 0x21003c1      34603969        904,138,752      2,708,762,624
 0x2100381      34603905        448,663,552      3,055,140,864
  0x100250       1049168         63,438,848        288,366,592           sysutils   bar_instance
  0x100249       1049161         19,804,160      1,257,078,784           sysutils   bar_object
 0x250097d      38799741          5,025,792         13,070,336
  0xd00158      13631832          3,158,016         15,839,232              db001   table01
 0x250096f      38799727          3,002,368         18,923,520
 0x250097e      38799742          2,662,400         13,189,120
 0x25008cd      38799565          2,260,992         13,713,408
 0x25008cc      38799564          2,039,808         14,028,800
 0x1502c59      22031449          1,044,480          7,462,912              db001   idx1_table02
  0xd00456      13632598            966,656          1,839,104
 0x2501206      38801926            946,176         17,907,712
 0x2400055      37748821            671,744          1,331,200              db001   table03
 0x1502c8d      22031501            552,960          7,041,024              db001   idx09_table04
 0x2400054      37748820            438,272          1,343,488              db001   table05
 0x2400056      37748822            405,504          9,142,272              db001   table06
 0x1502749      22030153            389,120          1,048,576              db001   table07_pk
 0x1502763      22030179            356,352          1,048,576              db001   table08_idx03
 0x21003fd      34604029            323,584        272,830,464
  0xd001d2      13631954            294,912            413,696              db001   table09
 0x1502e07      22031879            286,720            806,912              db001   table10_idx7
 0x1502e3e      22031934            282,624            856,064              db001   table11_idx01
 0x1501dca      22027722            233,472          1,548,288              db001   pktable12
 0x15001aa      22020522            229,376         94,765,056              db001   table13_idx6
 0x1502d86      22031750            172,032            495,616              db001   table14_pk
 0x2501200      38801920            159,744          5,132,288
 0x1502e02      22031874            151,552            929,792              db001   table15_idx01
-------------------------------------------------------------------------------------------------------------------

$