$ onstat -p  //查看配置信息

Informix Dynamic Server Version 7.31.UC5   -- On-Line -- Up 01:56:19 -- 393216

Kbytes

Profile

dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached

68558   146410  254945722 99.97  30494   130688  2576681 98.82

isamtot open    start   read    write   rewrite delete  commit  rollbk

123330084 101083  22285053 73196190 753222  86      173258  36646   33

gp_read gp_write gp_rewrt gp_del  gp_alloc gp_free gp_curs

0       0       0       0       0       0       0

ovlock  ovuserthread ovbuff  usercpu syscpu  numckpts flushes

0       0           0       5815.06 200.72  23      46

bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans

10622   0       93009744 0       0       27      108488  28847

ixda-RA idx-RA  da-RA   RA-pgsused lchwaits

8401    2947    43476   54766     791809

$ onstat -k //查看锁信息（省略了若干行）

Informix Dynamic Server Version 7.31.UC5   -- On-Line -- Up 01:57:42 -- 393216

Kbytes

Locks

address wtlist  owner   lklist  type    tblsnum rowid   key#/bsiz

10217d70 0       26061a84 115eeee0 HDR+S   100002  225        0

10217e0c 0       2606b29c 0       HDR+S   100002  30c        0

10217e74 0       26065564 0       HDR+S   100002  204        0

10217ea8 0       260601fc 0       HDR+S   100002  208        0

10217f10 0       26059fdc 0           S   100002  22b        0

10218014 0       2605e974 0       HDR+S   100002  22b        0

10218048 0       26058c3c 0           S   100002  225        0

10218118 0       2605789c 0       HDR+S   100002  313        0

102181b4 0       2605c71c 115edf70    S   100002  313        0

1021821c 0       2605b37c 0       HDR+S   100002  209        0

102183bc 0       26068b5c 0           S   100002  225        0

115ef2f0 0       2606a3e4 0           S   100002  30c        0

115ef358 0       26069a14 0           S   100002  30c        0

115ef908 0       2605a4c4 0           S   100002  208        0

115efa74 0       26062e24 0       HDR+S   100002  227        0

115efbe0 0       2605cc04 0           S   100002  209        0

115f008c 0       26070604 0           S   100002  204        0

115f13a4 0       2606f264 0           S   100002  208        0

 67 active, 800000 total, 131072 hash buckets

$ onstat –d  //查看数据库分配空间

Informix Dynamic Server Version 7.31.UC5   -- On-Line -- Up 01:59:38 -- 393216

Kbytes

Dbspaces

address number  flags   fchunk  nchunks flags   owner   name

2605413c 1       1001    1       1       N       informix rootdbs

26055398 2       1001    2       3       N       informix datadbs

26055454 3       1001    5       15      N       informix data_dbs

26055510 4       1       20      1       N       informix tmpdbs

 4 active, 2047 maximum

Chunks

address chk/dbs offset  size    free    bpages  flags pathname

260541f8 1  1  0       250000  130888           PO-  /dev/chunk1

26054344 2  2  0       250000  121364           PO-  /u/informix/data/data

dbs

26054420 3  2  250000  50000   48613            PO-  /u/informix/data/data

k18

26055104 18 3  0       1000000 409872           PO-  /u/informix/dbs/rchun

k19

260551e0 19 3  0       1000000 102400           PO-  /u/informix/dbs/rchun

k20

260552bc 20 4  0       1000000 968773           PO-  /u/informix/dbs/rchun

k26

 20 active, 2047 maximum

$ onstat –h //查看buffer状态

Informix Dynamic Server Version 7.31.UC5   -- On-Line -- Up 02:01:08 -- 393216

Kbytes

buffer hash chain length histogram

  # of chains        of len

       203912             0

        51860             1

         5757             2

          610             3

            5             4

       262144  total chains

        58232  hashed buffs

       150000   total buffs

$

$ onstat –c   //查看数据库配置文件

Ovlock超出锁的个数

Dltouts死锁超时

Ckpwaits检查点等待次数

Rollbk 回滚

Informix Dynamic Server Version 7.31.UC5   -- On-Line -- Up 02:01:55 -- 393216

Kbytes

Configuration File: /u/informix/etc/onconfig.test

#**************************************************************************

#

#                         INFORMIX SOFTWARE, INC.

#

# Title:      onconfig.std

# Descrīption: Informix Dynamic Server Configuration Parameters

#

#**************************************************************************

# Root Dbspace Configuration

ROOTNAME       rootdbs        # Root dbspace name

ROOTPATH       /dev/chunk1    # Path for device containing root dbspace

ROOTOFFSET     0              # Offset of root dbspace into device (Kbytes)

ROOTSIZE       500000         # Size of root dbspace (Kbytes)

# Disk Mirroring Configuration Parameters

MIRROR         0              # Mirroring flag (Yes = 1, No = 0)

MIRRORPATH                     # Path for device containing mirrored root

MIRROROFFSET   0              # Offset into mirrored device (Kbytes)

# Physical Log Configuration

PHYSDBS        rootdbs        # Location (dbspace) of physical log

PHYSFILE       50000          # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES       5              # Number of logical log files

LOGSIZE        10000          # Logical log size (Kbytes)

# Diagnostics

MSGPATH        /u/informix/online.log # System message log file path

CONSOLE        /dev/console   # System console message path

ALARMPROGRAM   /u/informix/etc/log_full.sh # Alarm program path

SYSALARMPROGRAM /u/informix/etc/evidence.sh # System Alarm program path

TBLSPACE_STATS 1

# System Archive Tape Device

TAPEDEV        /dev/null      # Tape device path

TAPEBLK        20             # Tape block size (Kbytes)

TAPESIZE       2000000         # Maximum amount of data to put on tape (Kbytes

)

# Log Archive Tape Device

LTAPEDEV       /dev/null      # Log tape device path

LTAPEBLK       20             # Log tape block size (Kbytes)

LTAPESIZE      200000         # Max amount of data to put on log tape (Kbytes)

# Optical

STAGEBLOB                      # Informix Dynamic Server/Optical staging area

# System Configuration

SERVERNUM      0              # Unique id corresponding to a Dynamic Server in

stance

DBSERVERNAME   test           # Name of default database server

DBSERVERALIASES test_tcp       # List of alternate dbservernames

NETTYPE        ipcshm,1,80,CPU # Configure poll thread(s) for nettype

NETTYPE        tlitcp,1,80,NET # Configure poll thread(s) for nettype

DEADLOCK_TIMEOUT 60             # Max time to wait of lock in distributed env.

RESIDENT       0              # Forced residency flag (Yes = 1, No = 0)

MULTIPROCESSOR 1              # 0 for single-processor, 1 for multi-processor

NUMCPUVPS      2              # Number of user (cpu) vps

SINGLE_CPU_VP  0              # If non-zero, limit number of cpu vps to one

NOAGE          0              # Process aging

AFF_SPROC      0              # Affinity start processor

AFF_NPROCS     0              # Affinity number of processors

# Shared Memory Parameters

LOCKS          800000         # Maximum number of locks

LOCKS          800000         # Maximum number of locks

BUFFERS        150000         # Maximum number of shared buffers

NUMAIOVPS                      # Number of IO vps

PHYSBUFF       32             # Physical log buffer size (Kbytes)

LOGBUFF        32             # Logical log buffer size (Kbytes)

LOGSMAX        50             # Maximum number of logical log files

CLEANERS       1              # Number of buffer cleaner processes

SHMBASE        0x10000000       # Shared memory base address

SHMVIRTSIZE    8000           # initial virtual shared memory segment size

SHMADD         8192           # Size of new shared memory segments (Kbytes)

SHMTOTAL       0              # Total shared memory (Kbytes). 0=>unlimited

CKPTINTVL      300            # Check point interval (in sec)

LRUS           8           # Number of LRU queues //LRU最近最少使用的队列长度

LRU_MAX_DIRTY  60             # LRU percent dirty begin cleaning limit

LRU_MIN_DIRTY  50             # LRU percent dirty end cleaning limit

LTXHWM         50             # Long transaction high water mark percentage

LTXEHWM        60             # Long transaction high water mark (exclusive)

TXTIMEOUT      0x12c            # Transaction timeout (in sec)

STACKSIZE      32             # Stack size (Kbytes)

# System Page Size

# BUFFSIZE - Dynamic Server no longer supports this configuration parameter.

#           To determine the page size used by Dynamic Server on your platform

#           see the last line of output from the command, 'onstat -b'.

# Recovery Variables

# OFF_RECVRY_THREADS:

# Number of parallel worker threads during fast recovery or an offline restore.

# ON_RECVRY_THREADS:

# Number of parallel worker threads during an online restore.

OFF_RECVRY_THREADS 10             # Default number of offline worker threads

ON_RECVRY_THREADS 1              # Default number of online worker threads

# Data Replication Variables

# DRAUTO: 0 manual, 1 retain type, 2 reverse type

DRAUTO         0              # DR automatic switchover

DRINTERVAL     30             # DR max time between DR buffer flushes (in sec)

DRTIMEOUT      30             # DR network timeout (in sec)

DRLOSTFOUND    /u/informix/etc/dr.lostfound # DR lost+found file path

# CDR Variables

CDR_LOGBUFFERS 2048           # size of log reading buffer pool (Kbytes)

CDR_EVALTHREADS 1,2            # evaluator threads (per-cpu-vp,additional)

CDR_DSLOCKWAIT 5              # DS lockwait timeout (seconds)

CDR_QUEUEMEM   4096           # Maximum amount of memory for any CDR queue (Kb

ytes)

CDR_LOGDELTA   30             # % of log space allowed in queue memory

CDR_NUMCONNECT 16             # Expected connections per server

CDR_NIFRETRY   300            # Connection retry (seconds)

CDR_NIFCOMPRESS 0              # Link level compression (-1 never, 0 none, 9 ma

x)

# Backup/Restore variables

BAR_ACT_LOG    /tmp/bar_act.log

BAR_MAX_BACKUP 0

BAR_RETRY      1

BAR_NB_XPORT_COUNT 10

BAR_XFER_BUF_SIZE 31

# Informix Storage Manager variables

ISM_DATA_POOL  ISMData        # If the data pool name is changed, be sure to

                               # update $INFORMIXDIR/bin/onbar. Change to

                               # ism_catalog -create_bootstrap -pool <new name>

ISM_LOG_POOL   ISMLogs

# Read Ahead Variables

RA_PAGES                       # Number of pages to attempt to read ahead

RA_THRESHOLD