home‎ > ‎monitoring‎ > ‎

infx photo

Record all information about an instance. Includes instance metrics, storage spaces, users and sql tracing. Does not include database table info.

usage

infx photo [ name res=low|med|high ]
     record instance metrics
       optional:
         name - enter name to use
         res - low is less data high is the most data

  • res=low - don't include user session info or sql tracing
  • res=med - don't include sql tracing
  • res=high - include all information
  • see parser library for complete list of information

taking photos

demo1@bobii:/home/informix>infx photo

dump location /infx/inst/demo1/photo
dumped photo-bobii-demo1-high-2012-03-23-102519.photo

reading photos back in

Pass the name of the photo to the status command.

demo1@bobii:/home/informix>infx status photo=photo-bobii-demo1-high-2012-03-23-102519.photo

status: error service:warn, dbspace:error
server: demo1sec@bobii (online) 11.70.FC4IE up: 3 days 01:03:25
alias:  demo1sec(bobii-vpn:soc:62301) demo1(bobii-vpn:soc:62001)

         host            user            memory           space          write            prof
name:   bobii   active:    18  total:  223.69mb  total:  1.28gb  total:    336   read:  99.97%
 cpu:     2/2      max:    19    res:  125.38mb   free:  0.51gb     fg:      0  write:  42.48%
 mem:  3.89gb    total:   128   virt:   98.30mb   temp:  0.05gb    lru:    252  ckpts:      18
free:  1.30gb  threads:    18   free:   37.68mb   free:  0.05gb  chunk:     84  waits:       0

logs:    curr(166) 100% avail, 0% used. 0 need backup  LO:    2012-02-22 22:00 (166)
i/os:    aio(0) fifo(0) kio(0) lio(0) pio(0)           pool:  4.71gb avail
act(1):  soctcppoll(1)

STATUS REASON: service:warn, dbspace:error

Pass the name of the photo to the check command, to list details of any errors.

demo1@bobii:/home/informix>infx check photo=photo-bobii-demo1-high-2012-03-23-102519.photo

Tue Mar 27 11:34:03 WST 2012 demo1 status: error service:warn, dbspace:error

Tue Mar 27 11:34:05 WST 2012 demo1 service: warn
class  service   start                     result                     run
error  mon-mons  Wed Mar 21 16:24:25 2012  failed - interupt rece...
error  restore   Tue Mar 20 08:52:19 2012  nothing to warm restor...

Tue Mar 27 11:34:06 WST 2012 demo1 dbspace: error
class  space  pg  flags  chks  size mb  free mb  used mb    used%  read mb  write mb  L0
error  dat01  2k  OK        2   190.00     0.00   190.00  100.00%     0.00      0.00  2012-02-22 22:00
error  idx01  2k  OK        2   252.04     0.00   252.04  100.00%     0.00      0.00  2012-02-22 22:00
photo=photo-bobii-demo1-high-2012-03-23-102519.photo

Pass the name of the photo to any of the cli utilities.

demo1@bobii:/home/informix>infx users photo=photo-bobii-demo1-high-2012-03-23-102519.photo

class  ses  flags    user      location  wait  dbname    sql  locks  nreads  nwrites  thr   kb
       25   ---P---  informix  -               sysadmin           1       1       43    1  620
       24   ---P---  informix  -               sysadmin           1       0       18    1  552
       23   ---P---  informix  -               sysadmin           2       0       12    1  556

notes

  • information from the SMI tables is cumulative, you should execute onmode -z as needed to reset these values
  • see the included script /infx/local/script/sample/snap for an example script that runs regularly, takes metrics and resets the statistics
  • don't change photo file permissions, infx will not read it back it the file is writable by others
  • add instance name to command to run against any instance
  • add instance@host to command to run against any remote instance