home‎ > ‎monitoring‎ > ‎

infx rstat

Show the status of instances on remote hosts.

usage

infx rstat [ util remote_insts ]
     remote instance status
       optional:
         util - template to use for output format
         remote_insts - list of remote instance names

notes

  • by default, infx determines the list of remote instances based on the SQLHOSTS file.
  • alternatively define the variable REMOTE_INSTS in config to specify a list
  • pass remote_insts= on the command line to provide a specific list to execute against

example

demo1b@bobii:/home/informix>infx rstat remote_insts=demo1bhdr@awsvpn02+demo1b@awsvpn01

status: error values:warn, backup:error, pool:error
server: demo1bhdrsec@awsvpn02 (online) 11.70.FC4TL up: 02:14:29
alias:  demo1bhdrsec(soc:62300) demo1bhdr(soc:62000)

           host            user            memory           space          write            prof
name:  awsvpn02   active:    18  total:  219.18mb  total:  1.14gb  total:  8,427   read:  98.98%
 cpu:       1/1      max:    26    res:  120.88mb   free:  0.68gb     fg:      0  write:  75.25%
 mem:    1.66gb    total:   128   virt:   98.30mb   temp:  0.05gb    lru:  7,576  ckpts:      72
free:    1.25gb  threads:    18   free:   40.89mb   free:  0.05gb  chunk:    851  waits:      73

logs:    curr(30) 95% avail, 5% used. 1 need backup  LO:    2012-02-31 05:48 (29)
i/os:    aio(1) fifo(0) lio(0.5) pio(0.1)            pool:  0.00gb avail
act(1):  soctcppoll(1)

STATUS REASON: values:warn, backup:error, pool:error


status: error values:warn, dbspace:warn, dri:error, backup:error, pool:error
server: demo1bsec@awsvpn01 (online) 11.70.FC4TL up: 02:14:24
alias:  demo1bsec(soc:62302) demo1b(soc:62002)

drsecs: error demo1bhdr(error)

           host            user            memory           space          write            prof
name:  awsvpn01   active:    18  total:  219.18mb  total:  1.14gb  total:  5,235   read:  98.47%
 cpu:       1/1      max:    26    res:  120.88mb   free:  0.68gb     fg:      0  write:  76.11%
 mem:    1.66gb    total:   128   virt:   98.30mb   temp:  0.05gb    lru:  4,750  ckpts:      41
free:    1.29gb  threads:    18   free:   43.01mb   free:  0.05gb  chunk:    485  waits:      41

logs:    curr(30) 89% avail, 11% used. 2 need backup  LO:    2012-02-28 10:19 (23)
i/os:    aio(0) fifo(0) kio(1.2) lio(0) pio(0)        pool:  0.00gb avail
act(1):  soctcppoll(1)

STATUS REASON: values:warn, dbspace:warn, dri:error, backup:error, pool:error

notes

  • output format defined in /infx/template/infx-cli/infx-cli-status.htmlt, copy to /infx/local/etc and change there
  • see parser library for the list of what information is available
  • see sub-infx-alert.ini for warning and error thresholds