home‎ > ‎monitoring‎ > ‎

infx status

Use the infx status command to access detailed information about an Informix instance or database. Either specify a template file name that defines your required output, or access information by specifying variable names on the command line.

usage

infx status [ util list vars photo ]
     show status of the instance
       optional:
         util - template to use for output format
         list - the list containing the vars
         vars - list of variables to output
         photo - photo file to read status from

example

default output

By default, the status command uses the /infx/template/infx-cli/infx-status.htmlt template to provide detailed status information about an instance.

demo1b@bobii:/home/informix>infx status

IBM Informix Dynamic Server Version 11.70.FC4IE -- On-Line -- Up 19:24:04 -- 219180 Kbytes

inst       host        address  cpu     mem    free    pool  curlog  last L0 archive
demo1bsec  bobii  192.168.1.34  2/2  3.89gb  2.41gb  6.70gb     108  2012-03-18 22:00 (107)

overall  inst   msg   user  service  space  chunk  pool  ckp   bar   dri   cdr
error    error  good  good  good     good   good   good  good  good  good  good

         llog            user            memory           space          write            prof
 avail:  100%   active:    26  total:  219.18mb  total:  1.06gb  total:    482   read:  99.45%
  used:    0%      max:     0    res:  120.88mb   free:  0.54gb     fg:      0  write:  61.79%
  span:    0%    total:   128   virt:   98.30mb   temp:  0.05gb    lru:    482  ckpts:       0
backup:     0  threads:    26   free:   41.31mb   free:  0.05gb  chunk:      0  waits:       0

io/sec   tot(118.8) kio(110.8) aio(8)
threads  tot(2) soctcppoll(1) kaio(1)
sql      tot(8) insert(1) update(1) select(6)
service  mon-mons

access stored photos

You can also pass the name of a photo file to the status command, and output status information from when it was taken.

demo1b@bobii:/home/informix>infx status photo=photo-bobii-demo1b-high-2012-04-18-115522.photo

IBM Informix Dynamic Server Version 11.70.FC4IE -- On-Line -- Up 15:15:52 -- 219180 Kbytes

inst       host        address  cpu     mem    free    pool  curlog  last L0 archive
demo1bsec  bobii  192.168.1.34  2/2  3.89gb  0.68gb  6.81gb     107  2012-03-17 22:00 (107)

overall  inst  msg   user  service  space  chunk  pool  ckp   bar   dri   cdr
warn     good  good  good  warn     good   good   good  good  good  good  good

         llog            user            memory           space          write            prof
 avail:  100%   active:    19  total:  219.18mb  total:  1.06gb  total:    522   read:  99.98%
  used:    0%      max:    20    res:  120.88mb   free:  0.54gb     fg:      0  write:  50.38%
  span:    0%    total:   128   virt:   98.30mb   temp:  0.05gb    lru:    406  ckpts:      24
backup:     0  threads:    19   free:   42.10mb   free:  0.05gb  chunk:    116  waits:       0

io/sec   tot(0)
threads  tot(1) soctcppoll(1)
sql      tot(0)
service  sample-snap

template output

You can define your output using a template. See template for format details. Template files must be located under the /infx/local/template directory tree, with an extension of .htmlt..

example template: /infx/local/template/mydbs.htmlt

<table>
 <TMPL_LOOP NAME=DB_LIST>
 <tr>
  <td><TMPL_VAR NAME=NAME></td>
  <td><TMPL_VAR NAME=IS_LOGGING></td>
 </tr>
 </TMPL_LOOP>
</table>

output:

demo1b@bobii:/home/informix>infx status util=mydbs

bartest       1
monitor_jgh1  1
sysadmin      1
sysmaster     1
sysuser       1
sysutils      1

quick access

Specify variable names on the command line. Separate variable names with the "+" symbol.

demo1b@bobii:/home/informix>infx vars=inst_status+inst_version

online IBM Informix Dynamic Server 11.70.FC4IE

Some variables are contained in lists, such as the list of storage spaces or user sessions. Specify the list name as well as variables

demo1b@bobii:/home/informix>infx list=dbspace_list vars=name+size_gb+l0_date

root     0.23  Tue Apr 17 22:00:00 2012
plog     0.10  Tue Apr 17 22:00:00 2012
log01    0.10  Tue Apr 17 22:00:00 2012
log02    0.10  Tue Apr 17 22:00:00 2012
dat01    0.10  Tue Apr 17 22:00:00 2012
dat02    0.03  Tue Apr 17 22:00:00 2012
dat03    0.03  Tue Apr 17 22:00:00 2012
dat04    0.03  Tue Apr 17 22:00:00 2012
idx01    0.12  Tue Apr 17 22:00:00 2012
idx02    0.03  Tue Apr 17 22:00:00 2012
idx03    0.03  Tue Apr 17 22:00:00 2012
idx04    0.03  Tue Apr 17 22:00:00 2012
tmp01    0.03
tmp02    0.03
ltmp01   0.03  Tue Apr 17 22:00:00 2012
blob01   0.03  Tue Apr 17 22:00:00 2012
sblob01  0.07  Tue Apr 17 22:00:00 2012

additional parameters

When you are working with lists, such as users or SQL history, you can supply an additional parameter, and limit the items in the list. One example is. passing a session id, and limiting the SQL tracing history to just that session. Another is to pass a database name and limit the table list to just that database.

 param description
 chunkfile The name of a specific chunk file or device. Used to get list of storage chunks allocated to this file or device.
 dir Specific directory name to list. Used to get service log files
 db A database name
 dbs A llist of databases separated by a comma  Use this to get more than just one database
 drvice A specific service name. Use this to limit the service history list to just one service.
 sid A specific database session id. Use to get list of locks, or SQL tracing history
 space A storage space name. Use to get list of chunks for just one storage space
 tab A table name. or use owner.table
 uname Limit output to a specific username. Use this with lock list or SQL tracing history

For example, list table information from the monitor_jgh1 database.

demo1@bobii:/home/informix>infx list=table_list vars=tabname+ti_nextns+fextsiz_kb+nextsiz_kb db=monitor_jgh1

day_syscolumns       1  3484   2500
day_sysfragments     1  738    2500
day_systables        1  840    500
hour_sysprofile      1  1372   1250
hour_sysptprof       4  41476  59904
hour_sysptprofb      4  41476  59904
hour_sysshmvals      1  162    1250
hour_systabinfo      1  7328   25000
objectdailydetail    5  14756  5270
objectdailysum       3  5892   3774
objectmonthlydetail  2  744    2274
objectmonthlysum     3  438    2408
spacedailysum        3  368    2872
spacemonthlysum      3  28     2860
syschunks            1  4286   2500
sysdbspaces          1  1168   1250
test1                3  26     830

notes