Re: [HELP] What my Informix is doing?
onstat -u - user sessions
onstat -g ses session_id - detailed session info
onstat -d - chunk info
For starters
----- Original Message -----
From: "steven" <steven@steven4u.net>
To: <informix-list@iiug.org>
Sent: Thursday, September 11, 2003 05:54
Subject: [HELP] What my Informix is doing?
> I wrote a esql/c program, which read about 100,000 records from a
> plain data file one bye one while inserted(or updated) them into a
> local database.
>
> When the progress go to about 20,000 records, the program seems halt(
> ver very slow!), and the hard disk keeps flashing for about 2 hours.
> The sar -u reports:
>
> 17:47:16 %usr %sys %wio %idle (-u)
> 17:47:17 0 2 98 0
> 17:47:18 0 0 100 0
> 17:47:20 0 3 97 0
> 17:47:23 0 1 99 0
> 17:47:24 0 2 65 33
> 17:47:25 1 3 64 32
> 17:47:26 0 1 42 57
> 17:47:27 0 6 94 0>
> sar -d reports:
> 17:49:06 device %busy avque r+w/s blks/s avwait
> avserv (-d)
> 17:49:07 wd-0 95.05 1.08 830.69 6693.07 0.10
> 1.14
> 17:49:08 wd-0 97.03 1.08 837.62 6700.99 0.09
> 1.16
> 17:49:09 wd-0 99.01 1.00 790.10 6320.79 0.00
> 1.25
> 17:49:10 wd-0 100.00 1.25 280.20 2225.74 0.88
> 3.57
> 17:49:11 wd-0 98.02 1.01 343.56 2748.51 0.03
> 2.85>
> sar -r reports:
> 17:49:46 freemem freeswp availrmem availsmem (-r)
> 17:49:47 1245 224576 11548 23929
> 17:49:48 953 229240 11548 23929
> 17:49:49 1394 225128 11548 23929
> 17:49:50 1175 226896 11548 23929
> 17:49:51 1001 228248 11548 23929
> 17:49:52 840 229544 11548 23929
> 17:49:53 703 230664 11548 23929
> 17:49:54 1196 224192 11548 23929>
> My system is SCO OSR5 + Informix Online 7.x with 128M ram. The
> database is created w/o loging.
>
> Is any method here let me know what the Informix is doing?
>
>
> Thans in advance.
> --
> steven@lczmsoft.com
sending to informix-list