Re: [HELP] What my Informix is doing?
ok, I run some onstat and get the following:
--------------------------- cut
----------------------------------------------
$ onstat -u
INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 21:04:15 -- 805400
Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads
nwrites
85c40014 ---P--D 1 informix - 0 0 0 27
5551
85c40448 ---P--F 0 informix - 0 0 0 0
34200
85c4087c ---P--B 9 informix - 0 0 0 0
0
85c410e4 ---P--- 14 informix ttyp0 0 0 0 0
0
85c41518 ---P--D 12 informix - 0 0 0 0
0
5 active, 128 total, 17 maximum concurrent
$ onstat -g ses 14
INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 21:01:06 -- 805400
Kbytes
session #RSAM total used
id user tty pid hostname threads memory memory
14 informix ttyp0 997 lczmdbsv 1 54476800 54413184
tid name rstcb flags curstk status
41 sqlexec 85c410e4 ---P--- 816 85c410e4 running
Memory pools count 1
name class addr totalsize freesize #allocfrag #freefrag
14 V 86040014 54476800 61568 52661 105
name free used name free
used
overhead 0 108 scb 0 80
opentable 0 1084 filetable 0 384
log 0 2132 temprec 0 828
ralloc 0 52016432 gentcb 0
7636
ostcb 0 1968 sqscb 0
2381260
hashfiletab 0 276 osenv 0
2360
sqtcb 0 644 fragman 0 40
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
14 - - - Not Wait -349 0 7.22
Last parsed SQL statement :
insert into t_loan_retint (tran_date, host_seqno, clt_seqno,
tran_no,
loan_acc, clr_int_date, accu, rate, rate_type, int_recv_acc,
payint_acc,
holdint_acc, rb_int, crt_retint, rcpt_int, prt_num, flag) values
(?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
$ onstat -g sql 14
INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 21:06:16 -- 805400
Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
14 INSERT - - Not Wait -349 0 7.22
Current SQL statement :
insert into t_loan_retint (tran_date, host_seqno, clt_seqno,
tran_no,
loan_acc, clr_int_date, accu, rate, rate_type, int_recv_acc,
payint_acc,
holdint_acc, rb_int, crt_retint, rcpt_int, prt_num, flag) values
(?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
Last parsed SQL statement :
insert into t_loan_retint (tran_date, host_seqno, clt_seqno,
tran_no,
loan_acc, clr_int_date, accu, rate, rate_type, int_recv_acc,
payint_acc,
holdint_acc, rb_int, crt_retint, rcpt_int, prt_num, flag) values
(?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
$ onstat -d
INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 21:07:11 -- 805400
Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
85c3e0ec 1 1 1 1 N informix rootdbs
85c3e5b0 2 1 2 1 N informix dbcrm
85c3e61c 3 1 3 3 N informix
dboriginal
3 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
85c3e158 1 1 0 977956 886579 PO-
/usr/informix/dbsps/rootdb
85c3e260 2 2 0 950000 488106 PO-
/usr/informix/dbsps/lczmdb1
85c3e334 3 3 0 950000 273565 PO-
/usr/informix/dbsps/lczmdb2
85c3e408 4 3 0 950000 61389 PO-
/usr/informix/dbsps/lczmdb3
85c3e4dc 5 3 0 950000 214960 PO-
/usr/informix/dbsps/lczmdb4
5 active, 2047 maximum
---------------------- cut
-------------------------------------------------
Any ideal?