HI,all
HP-UX mscp1 B.11.11 U with IDS 9.40FC7W4
1.the server mscp1 start and to be SECONDARY of HDR at 00:01:41
2.the mscp2 (the PRIMARY) dbimport the datebase scp20 about 00:09
3.after finish dbimport scp20, switch mscp1 from SECONDARY to PRIMARY at 00:26
4.the program connect to DB,the error occur.
online.log follow
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Sat Sep 15 00:01:41 2007
00:01:41 Warning: ONCONFIG dump directory (DUMPDIR) '/tellinshare/sms/informixdump' has insecure permissions
00:01:41 Event alarms enabled. ALARMPROG = '/opt/informix/etc/alarmprogram.sh'
00:01:41 Dynamically allocated new virtual shared memory segment (size 8436KB)
00:01:41 Booting Language <c> from module <>
00:01:41 Loading Module <CNULL>
00:01:41 Booting Language <builtin> from module <>
00:01:41 Loading Module <BUILTINNULL>
00:01:47 Dynamically allocated new message shared memory segment (size 672KB)
00:01:47 IBM Informix Dynamic Server Version 9.40.FC7W4 Software Serial Number AAA#B000000
00:01:48 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:01:49 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
00:01:49 DR: Reservation of the last logical log for log backup turned on
00:01:49 Data replication type and state information reset. To start DR, use
the 'onmode -d' command and wait for the pair to be operational,
before shutting down the database server
00:01:49 Dataskip is now OFF for all dbspaces
00:01:49 Restartable Restore has been DISABLED
00:01:49 Recovery Mode
00:01:54 Physical Restore of rootdbs, logdbs, phydbs, workdbs started.
00:02:03 Checkpoint Completed: duration was 0 seconds.
00:02:03 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a0a
00:02:03 Maximum server connections 0
00:02:03 Checkpoint Completed: duration was 0 seconds.
00:02:03 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a12
00:02:03 Maximum server connections 0
00:02:03 Checkpoint Completed: duration was 0 seconds.
00:02:03 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a1a
00:02:03 Maximum server connections 0
00:05:10 Checkpoint Completed: duration was 0 seconds.
00:05:10 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a21
00:05:10 Maximum server connections 0
00:05:11 Physical Restore of rootdbs, logdbs, phydbs, workdbs Completed.
00:05:11 Checkpoint Completed: duration was 0 seconds.
00:05:11 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a26
00:05:11 Maximum server connections 0
00:05:56 DR: Reservation of the last logical log for log backup turned off
00:05:56 DR: new type = secondary, primary server name = mscp_server2_net
00:05:56 DR: Trying to connect to primary server = mscp_server2_net
00:05:59 DR: Secondary server connected
00:05:59 DR: Secondary server needs failure recovery
00:06:00 DR: Failure recovery from disk in progress ...
00:06:00 Logical Recovery Started.
00:06:00 10 recovery worker threads will be started.
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Start Logical Recovery - Start Log 5847, End Log ?
00:06:00 Starting Log Position - 5847 0x195018
00:06:00 Clearing the physical and logical logs has started
00:08:10 Cleared 1952 MB of the physical and logical logs in 131 seconds
00:08:13 DR: Secondary server operational
00:08:13 Checkpoint Completed: duration was 0 seconds.
00:08:13 Checkpoint loguniq 5847, logpos 0x198018, timestamp: 0xcac20a4f
00:08:13 Maximum server connections 0
00:09:41 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:09:46 Booting Language <spl> from module <>
00:09:46 Loading Module <SPLNULL>
00:26:31 Checkpoint Completed: duration was 0 seconds.
00:26:31 Checkpoint loguniq 5847, logpos 0x19c018, timestamp: 0xcac23ca9
00:26:31 Maximum server connections 23
00:26:32 DR: Receive error in thread dr_secrcv [id: 36]
00:26:32 ASF Echo-Thread Server: asfcode = -25582: oserr = 4: errstr = : Network connection is broken.
System error = 4.
00:26:34 DR: Turned off on secondary server
00:26:41 Logical Recovery has reached the transaction cleanup phase.
00:26:41 Logical Recovery Complete.
32 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
00:26:41 Logical Recovery Complete.
00:26:42 Quiescent Mode
00:26:42 Checkpoint Completed: duration was 0 seconds.
00:26:42 Checkpoint loguniq 5847, logpos 0x19d018, timestamp: 0xcac23cb4
00:26:42 Maximum server connections 23
00:26:42 DR: Reservation of the last logical log for log backup turned on
00:26:42 DR: new type = standard
00:26:43 On-Line Mode
00:26:43 DR: new type = primary, secondary server name = mscp_server2_net
00:26:43 DR: Trying to connect to secondary server = mscp_server2_net
00:26:43 DR: Cannot connect to secondary server
00:26:43 DR: Turned off on primary server
00:30:42 DR: Primary server connected
00:30:42 DR: Secondary server needs failure recovery
00:30:43 DR: Sending log 5847 (current), size 50000 pages, 0.83 percent used
00:30:44 DR: Sending Logical Logs Completed
00:30:45 DR: Primary server operational
00:30:46 Checkpoint Completed: duration was 0 seconds.
00:30:46 Checkpoint loguniq 5847, logpos 0x1a2018, timestamp: 0xcac24888
00:30:46 Maximum server connections 25
00:46:42 stack trace for pid 22543 written to /tellinshare/sms/informixdump/af.46abaf2
00:46:42 Assert Failed: No Exception Handler
00:46:42 IBM Informix Dynamic Server Version 9.40.FC7W4
00:46:42 Who: Session(93, tellin@mscp1, 12705, c0000000188b00e8)
Thread(130, sqlexec, c00000001887bf60, 1)
File: mtex.c Line: 435
00:46:42 Results: Exception Caught. Type: MT_EX_OS, Context: mem
00:46:42 Action: Please notify IBM Informix Technical Support.
00:46:42 stack trace for pid 22543 written to /tellinshare/sms/informixdump/af.46abaf2
00:46:42 See Also: /tellinshare/sms/informixdump/af.46abaf2, shmem.46abaf2.0
00:46:48 mtex.c, line 435, thread 130, proc id 22543, No Exception Handler.
00:46:48 The Master Daemon Died
00:46:49 PANIC: Attempting to bring system down
af.46abaf2 follow.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
00:46:42 Stack for thread: 130 sqlexec
base: 0xc00000001c450000
len: 36864
pc: 0x0000000000000000
tos: 0xc00000001c4530e0
state: running
vp: 1
( 0) 0x40000000008a73e8 legacy_hp_afstack + 0x258 [/opt/informix/bin/oninit]
( 1) 0x40000000008a6a3c afstack + 0x5c [/opt/informix/bin/oninit]
( 2) 0x40000000008abd6c mt_ex_throw_sig + 0x29c [/opt/informix/bin/oninit]
( 3) 0x400000000086f248 afsig_handler + 0xf8 [/opt/informix/bin/oninit]
( 4) 0xc0000000003f8bf0 _sigreturn [/usr/lib/pa20_64/libc.2]
( 5) 0x4000000000625a50 rowalter + 0xa8 [/opt/informix/bin/oninit]
( 6) 0x4000000000625700 decompress_row + 0x80 [/opt/informix/bin/oninit]
( 7) 0x40000000005b2ccc read_record + 0x4b4 [/opt/informix/bin/oninit]
( 8) 0x40000000005b1a34 gather_records + 0x1a4 [/opt/informix/bin/oninit]
( 9) 0x40000000005b0884 rsread + 0x1a4 [/opt/informix/bin/oninit]
(10) 0x400000000092ee68 fmread + 0xc38 [/opt/informix/bin/oninit]
(11) 0x40000000003547c8 sqisread + 0x68 [/opt/informix/bin/oninit]
(12) 0x40000000003843ec readidx + 0x3d4 [/opt/informix/bin/oninit]
(13) 0x400000000038356c gettupl + 0x3e4 [/opt/informix/bin/oninit]
(14) 0x400000000037fe8c scan_next + 0x114 [/opt/informix/bin/oninit]
(15) 0x400000000038c5d4 getrow + 0xcc [/opt/informix/bin/oninit]
(16) 0x400000000038c4f8 fetchrow + 0x278 [/opt/informix/bin/oninit]
(17) 0x400000000054a12c exfetch + 0x7c [/opt/informix/bin/oninit]
(18) 0x400000000049d54c sq_nfetch + 0x24c [/opt/informix/bin/oninit]
(19) 0x4000000000525630 sqmain + 0x128 [/opt/informix/bin/oninit]
(20) 0x400000000087e314 startup + 0xd4 [/opt/informix/bin/oninit]
(21) 0x400000000087e0fc resume + 0x10c [/opt/informix/bin/oninit]
base: 0xc00000001c450000
len: 36864
pc: 0x0000000000000000
tos: 0xc00000001c4530e0
state: running
vp: 1
00:46:42
00:46:42 IBM Informix Dynamic Server Version 9.40.FC7W4 Software Serial Number AAA#B000000
00:46:42 Assert Failed: No Exception Handler
00:46:42 Who: Session(93, tellin@mscp1, 12705, c0000000188b00e8)
Thread(130, sqlexec, c00000001887bf60, 1)
File: mtex.c Line: 435
00:46:42 Results: Exception Caught. Type: MT_EX_OS, Context: mem
00:46:42 Action: Please notify IBM Informix Technical Support.
00:46:42 Stack for thread: 130 sqlexec
base: 0xc00000001c450000
len: 36864
pc: 0x0000000000000000
tos: 0xc00000001c4537a0
state: running
vp: 1
( 0) 0x40000000008a73e8 legacy_hp_afstack + 0x258 [/opt/informix/bin/oninit]
( 1) 0x40000000008a6a3c afstack + 0x5c [/opt/informix/bin/oninit]
( 2) 0x40000000008a5ccc afhandler + 0x984 [/opt/informix/bin/oninit]
( 3) 0x40000000008a5334 afcrash_interface + 0x4c [/opt/informix/bin/oninit]
( 4) 0x40000000008abe0c mt_ex_throw_sig + 0x33c [/opt/informix/bin/oninit]
( 5) 0x400000000086f248 afsig_handler + 0xf8 [/opt/informix/bin/oninit]
( 6) 0xc0000000003f8bf0 _sigreturn [/usr/lib/pa20_64/libc.2]
( 7) 0x4000000000625a50 rowalter + 0xa8 [/opt/informix/bin/oninit]
( 8) 0x4000000000625700 decompress_row + 0x80 [/opt/informix/bin/oninit]
( 9) 0x40000000005b2ccc read_record + 0x4b4 [/opt/informix/bin/oninit]
(10) 0x40000000005b1a34 gather_records + 0x1a4 [/opt/informix/bin/oninit]
(11) 0x40000000005b0884 rsread + 0x1a4 [/opt/informix/bin/oninit]
(12) 0x400000000092ee68 fmread + 0xc38 [/opt/informix/bin/oninit]
(13) 0x40000000003547c8 sqisread + 0x68 [/opt/informix/bin/oninit]
(14) 0x40000000003843ec readidx + 0x3d4 [/opt/informix/bin/oninit]
(15) 0x400000000038356c gettupl + 0x3e4 [/opt/informix/bin/oninit]
(16) 0x400000000037fe8c scan_next + 0x114 [/opt/informix/bin/oninit]
(17) 0x400000000038c5d4 getrow + 0xcc [/opt/informix/bin/oninit]
(18) 0x400000000038c4f8 fetchrow + 0x278 [/opt/informix/bin/oninit]
(19) 0x400000000054a12c exfetch + 0x7c [/opt/informix/bin/oninit]
(20) 0x400000000049d54c sq_nfetch + 0x24c [/opt/informix/bin/oninit]
(21) 0x4000000000525630 sqmain + 0x128 [/opt/informix/bin/oninit]
(22) 0x400000000087e314 startup + 0xd4 [/opt/informix/bin/oninit]
(23) 0x400000000087e0fc resume + 0x10c [/opt/informix/bin/oninit]
base: 0xc00000001c450000
len: 36864
pc: 0x0000000000000000
tos: 0xc00000001c4537a0
state: running
vp: 1
00:46:42 See Also: /tellinshare/sms/informixdump/af.46abaf2, shmem.46abaf2.0
---------------------------------
Begin System Alarm Program Output
---------------------------------
Assertion Failure Type: CRASH
Host Name: mscp1
Database Server Name: mscp_server_net
Time of failure: Sat Sep 15 00:46:43 EAT 2007
AF file: /tellinshare/sms/informixdump/af.46abaf2
Shared memory file: None
System Blocking: OFF
===========------------- - - - - - -
tail -100 /opt/informix/online.log:
the 'onmode -d' command and wait for the pair to be operational,
before shutting down the database server
00:01:49 Dataskip is now OFF for all dbspaces
00:01:49 Restartable Restore has been DISABLED
00:01:49 Recovery Mode
00:01:54 Physical Restore of rootdbs, logdbs, phydbs, workdbs started.
00:02:03 Checkpoint Completed: duration was 0 seconds.
00:02:03 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a0a
00:02:03 Maximum server connections 0
00:02:03 Checkpoint Completed: duration was 0 seconds.
00:02:03 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a12
00:02:03 Maximum server connections 0
00:02:03 Checkpoint Completed: duration was 0 seconds.
00:02:03 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a1a
00:02:03 Maximum server connections 0
00:05:10 Checkpoint Completed: duration was 0 seconds.
00:05:10 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a21
00:05:10 Maximum server connections 0
00:05:11 Physical Restore of rootdbs, logdbs, phydbs, workdbs Completed.
00:05:11 Checkpoint Completed: duration was 0 seconds.
00:05:11 Checkpoint loguniq 5847, logpos 0x195018, timestamp: 0xcac20a26
00:05:11 Maximum server connections 0
00:05:56 DR: Reservation of the last logical log for log backup turned off
00:05:56 DR: new type = secondary, primary server name = mscp_server2_net
00:05:56 DR: Trying to connect to primary server = mscp_server2_net
00:05:59 DR: Secondary server connected
00:05:59 DR: Secondary server needs failure recovery
00:06:00 DR: Failure recovery from disk in progress ...
00:06:00 Logical Recovery Started.
00:06:00 10 recovery worker threads will be started.
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:06:00 Start Logical Recovery - Start Log 5847, End Log ?
00:06:00 Starting Log Position - 5847 0x195018
00:06:00 Clearing the physical and logical logs has started
00:08:10 Cleared 1952 MB of the physical and logical logs in 131 seconds
00:08:13 DR: Secondary server operational
00:08:13 Checkpoint Completed: duration was 0 seconds.
00:08:13 Checkpoint loguniq 5847, logpos 0x198018, timestamp: 0xcac20a4f
00:08:13 Maximum server connections 0
00:09:41 Dynamically allocated new virtual shared memory segment (size 8192KB)
00:09:46 Booting Language <spl> from module <>
00:09:46 Loading Module <SPLNULL>
00:26:31 Checkpoint Completed: duration was 0 seconds.
00:26:31 Checkpoint loguniq 5847, logpos 0x19c018, timestamp: 0xcac23ca9
00:26:31 Maximum server connections 23
00:26:32 DR: Receive error in thread dr_secrcv [id: 36]
00:26:32 ASF Echo-Thread Server: asfcode = -25582: oserr = 4: errstr = : Network connection is broken.
System error = 4.
00:26:34 DR: Turned off on secondary server
00:26:41 Logical Recovery has reached the transaction cleanup phase.
00:26:41 Logical Recovery Complete.
32 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
00:26:41 Logical Recovery Complete.
00:26:42 Quiescent Mode
00:26:42 Checkpoint Completed: duration was 0 seconds.
00:26:42 Checkpoint loguniq 5847, logpos 0x19d018, timestamp: 0xcac23cb4
00:26:42 Maximum server connections 23
00:26:42 DR: Reservation of the last logical log for log backup turned on
00:26:42 DR: new type = standard
00:26:43 On-Line Mode
00:26:43 DR: new type = primary, secondary server name = mscp_server2_net
00:26:43 DR: Trying to connect to secondary server = mscp_server2_net
00:26:43 DR: Cannot connect to secondary server
00:26:43 DR: Turned off on primary server
00:30:42 DR: Primary server connected
00:30:42 DR: Secondary server needs failure recovery
00:30:43 DR: Sending log 5847 (current), size 50000 pages, 0.83 percent used
00:30:44 DR: Sending Logical Logs Completed
00:30:45 DR: Primary server operational
00:30:46 Checkpoint Completed: duration was 0 seconds.
00:30:46 Checkpoint loguniq 5847, logpos 0x1a2018, timestamp: 0xcac24888
00:30:46 Maximum server connections 25
00:46:42 stack trace for pid 22543 written to /tellinshare/sms/informixdump/af.46abaf2
00:46:42 Assert Failed: No Exception Handler
00:46:42 IBM Informix Dynamic Server Version 9.40.FC7W4
00:46:42 Who: Session(93, tellin@mscp1, 12705, c0000000188b00e8)
Thread(130, sqlexec, c00000001887bf60, 1)
File: mtex.c Line: 435
00:46:42 Results: Exception Caught. Type: MT_EX_OS, Context: mem
00:46:42 Action: Please notify IBM Informix Technical Support.
00:46:42 stack trace for pid 22543 written to /tellinshare/sms/informixdump/af.46abaf2
00:46:42 See Also: /tellinshare/sms/informixdump/af.46abaf2, shmem.46abaf2.0
===========------------- - - - - - -
/opt/informix/bin/onstat -g ath:
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line (Prim) -- Up 00:45:02 -- 468548 Kbytes
Threads:
tid tcb rstcb prty status vp-class name
2 c000000018a2ab80 0 2 sleeping forever 17lio lio vp 0
3 c000000018aa7630 0 2 sleeping forever 18pio pio vp 0
4 c000000018ac8630 0 2 sleeping forever 19aio aio vp 0
5 c000000018ae9630 0 2 sleeping forever 20msc msc vp 0
6 c000000018b1a630 0 2 sleeping forever 21aio aio vp 1
7 c000000018b3b890 c00000001886b028 4 sleeping secs: 1 5cpu main_loop()
8 c000000018b1ad38 0 2 sleeping forever 1cpu soctcppoll
9 c000000018ac8db0 0 2 running 22shm sm_poll
10 c000000018a4ecb8 0 3 sleeping forever 1cpu soctcplst
11 c000000018a5dc10 0 3 sleeping forever 1cpu sm_listen
12 c000000018a31730 0 2 sleeping secs: 1 5cpu sm_discon
13 c000000018a319a8 c00000001886b860 2 sleeping forever 3cpu flush_sub(0)
14 c000000018a31c88 c00000001886c098 2 sleeping forever 1cpu flush_sub(1)
15 c000000018932498 0 2 sleeping forever 23aio aio vp 2
16 c0000000189327b8 0 2 sleeping forever 24aio aio vp 3
17 c000000018c66630 0 2 sleeping forever 25aio aio vp 4
18 c000000018c87630 0 2 sleeping forever 26aio aio vp 5
19 c000000018ca8630 0 2 sleeping forever 27aio aio vp 6
20 c000000018cc9630 0 2 sleeping forever 28aio aio vp 7
21 c000000019506a58 0 2 sleeping forever 29aio aio vp 8
22 c0000000195d9208 0 2 sleeping forever 30aio aio vp 9
23 c0000000195f1630 0 2 sleeping forever 31aio aio vp 10
24 c00000001961b208 0 2 sleeping forever 32aio aio vp 11
25 c00000001963c208 0 2 sleeping forever 33aio aio vp 12
26 c00000001965d208 0 2 sleeping forever 34aio aio vp 13
27 c00000001967e208 0 2 sleeping forever 35aio aio vp 14
28 c00000001969f208 0 2 sleeping forever 36aio aio vp 15
29 c000000018ca8d78 c00000001886c8d0 3 sleeping forever 1cpu aslogflush
30 c0000000195f1950 c00000001886d108 1 sleeping secs: 77 3cpu btscanner_0
31 c0000000195d9528 c00000001886d940 4 ready 1cpu onmode_mon
32 c0000000195d9918 c00000001886e178 2 cond wait bp_cond 1cpu bf_priosweep()
91 c00000001c6e2df8 c000000018883270 2 cond wait netnorm 1cpu sqlexec
119 c00000001c407df8 c0000000188785d8 2 cond wait netnorm 1cpu sqlexec
120 c00000001c74b158 c00000001887f8e8 2 cond wait netnorm 1cpu sqlexec
121 c00000001c74b380 c00000001887a6b8 2 cond wait netnorm 1cpu sqlexec
122 c00000001c74b5a8 c000000018879648 2 cond wait netnorm 1cpu sqlexec
123 c00000001c74b7d0 c0000000188819c8 2 cond wait netnorm 1cpu sqlexec
124 c00000001c74baf0 c000000018881190 2 cond wait netnorm 1cpu sqlexec
125 c00000001c1f1138 c00000001887e878 2 cond wait netnorm 1cpu sqlexec
126 c00000001c370cc8 c00000001887aef0 2 cond wait netnorm 1cpu sqlexec
127 c00000001c2bd530 c00000001887cfd0 2 cond wait netnorm 3cpu sqlexec
128 c00000001c3e38b0 c00000001887c798 2 cond wait netnorm 1cpu sqlexec
129 c00000001c34d828 c000000018880958 2 cond wait netnorm 1cpu sqlexec
*130 c00000001c31f138 c00000001887bf60 2 running 1cpu sqlexec
131 c00000001c33d4a8 c00000001887e040 2 cond wait netnorm 1cpu sqlexec
132 c00000001c39f100 c000000018882200 2 cond wait netnorm 1cpu sqlexec
133 c00000001c3ce538 c00000001887b728 2 cond wait netnorm 1cpu sqlexec
134 c00000001c5822b8 c000000018878e10 2 cond wait netnorm 1cpu sqlexec
135 c00000001c324628 c00000001887d808 2 cond wait netnorm 1cpu sqlexec
136 c00000001c2a5120 c000000018882a38 2 cond wait netnorm 1cpu sqlexec
137 c00000001c4a7818 c00000001887f0b0 2 cond wait netnorm 1cpu sqlexec
138 c00000001c2f5cb0 c000000018879e80 2 cond wait netnorm 1cpu sqlexec
139 c00000001c4a71b8 c000000018880120 2 cond wait netnorm 1cpu sqlexec
147 c00000001969fdd0 c000000018871b00 1 cond wait btc sort 1cpu btscanner_1
152 c00000001c281b80 c0000000188712c8 2 cond wait netnorm 1cpu sqlexec
165 c00000001c1ae028 c000000018872338 2 cond wait drcb_bqf 1cpu dr_prsend
166 c00000001c4e8a90 c000000018870a90 2 sleeping secs: 1 4cpu dr_prping
167 c00000001c1f1810 c0000000188733a8 2 sleeping secs: 3 5cpu dr_idx_send
===========------------- - - - - - -
/opt/informix/bin/onstat -g stk 130 light:
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line (Prim) -- Up 00:45:02 -- 468548 Kbytes
Stack for thread: 130 sqlexec
base: 0xc00000001c450000
len: 36864
pc: 0x0000000000000000
tos: 0xc00000001c453150
state: running
vp: 1
0x400000000087dff0 oninit :: resume + 0x0 sp=0xc00000001c453150
0x400000000087ae53 oninit :: mt_system + 0xd3 sp=0xc00000001c453020 delta_sp=304
0x40000000008a5f7f oninit :: afhandler + 0xc37 sp=0xc00000001c452f90 delta_sp=144
0x40000000008a5337 oninit :: afcrash_interface + 0x4f sp=0xc00000001c452950 delta_sp=1600
0x40000000008abe0f oninit :: mt_ex_throw_sig + 0x33f sp=0xc00000001c4528d0 delta_sp=128
0x400000000086f24b oninit :: afsig_handler + 0xfb sp=0xc00000001c4526c0 delta_sp=528
0xc0000000003f8bf0 ?unknown? :: ?unknown? + 0x0 sp=0xc00000001c452620 delta_sp=160
===========------------- - - - - - -
/opt/informix/bin/onstat -u:
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line (Prim) -- Up 00:45:03 -- 468548 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads nwrites
c00000001886b028 ---P--D 1 informix - 0 0 0 21 26
c00000001886b860 ---P--F 0 informix - 0 0 0 0 28
c00000001886c098 ---P--F 0 informix - 0 0 0 0 0
c00000001886c8d0 ---P--- 9 informix - 0 0 0 0 0
c00000001886d108 ---P--B 10 informix - 0 0 0 0 0
c00000001886d940 ---P--D 11 informix - 0 0 0 17 9
c00000001886e178 Y--P--D 12 informix - c000000000566968 0 0 0 0
c000000018870a90 ---P--D 130 informix - 0 0 0 0 0
c0000000188712c8 Y--P--- 114 tellin - c0000000195d9cd0 0 1 7 0
c000000018871b00 Y--P--B 111 informix - c000000018bd3380 0 0 0 0
c000000018872338 Y--P--D 129 informix - c000000018b3bdc0 0 0 424 3
c0000000188733a8 ---P--D 131 informix - 0 0 0 0 0
c0000000188785d8 Y--P--- 82 tellin tc c00000001c2dc6a0 0 0 930 0
c000000018878e10 Y--P--- 97 tellin tc c00000001c34d028 0 0 32 0
c000000018879648 Y--P--- 85 tellin tc c00000001c390ed0 0 0 0 0
c000000018879e80 Y--P--- 101 tellin tc c00000001c4e8870 0 0 0 0
c00000001887a6b8 Y--P--- 84 tellin tc c00000001c2dc7b0 0 0 0 0
c00000001887aef0 Y--P--- 89 tellin tc c00000001994b450 0 0 49 0
c00000001887b728 Y--P--- 96 tellin tc c00000001c33d398 0 0 46 0
c00000001887bf60*---PR-- 93 tellin tc 0 0 0 48 0
c00000001887c798 Y--P--- 91 tellin tc c00000001c30cec0 0 0 37 0
c00000001887cfd0 Y--P--- 90 tellin tc c00000001c4a53a8 0 0 25 0
c00000001887d808 Y--P--- 98 tellin tc c00000001c34d690 0 0 46 0
c00000001887e040 Y--P--- 94 tellin tc c00000001c33d0c0 0 0 42 0
c00000001887e878 Y--P--- 88 tellin tc c00000001c48b878 0 0 39 0
c00000001887f0b0 Y--P--- 100 tellin tc c00000001c4a7600 0 0 28 0
c00000001887f8e8 Y--P--- 83 tellin tc c00000001c3907e0 0 0 0 0
c000000018880120 Y--P--- 102 tellin tc c00000001c370b30 0 0 96 0
c000000018880958 Y--P--- 92 tellin tc c00000001c4a5680 0 0 43 0
c000000018881190 Y--P--- 87 tellin tc c00000001c2f5b30 0 0 43 0
c0000000188819c8 Y--P--- 86 tellin tc c00000001c1f15f0 0 0 35 0
c000000018882200 Y--P--- 95 tellin tc c00000001c33d310 0 0 52 0
c000000018882a38 Y--P--- 99 tellin tc c00000001c34d7a0 0 0 43 0
c000000018883270 Y--P--- 54 tellin - c00000001c7779b8 0 0 0 0
34 active, 128 total, 49 maximum concurrent
===========------------- - - - - - -
/opt/informix/bin/onstat -g ses 93:
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line (Prim) -- Up 00:45:03 -- 468548 Kbytes
session #RSAM total used dynamic
id user tty pid hostname threads memory memory explain
93 tellin tc 12705 mscp1 1 299008 287560 off
tid name rstcb flags curstk status
130 sqlexec c00000001887bf60 ---PR-- 24240 running
Memory pools count 2
name class addr totalsize freesize #allocfrag #freefrag
93 V c00000001c386040 294912 10608 440 18
93*O0 V c00000001c3d8040 4096 840 1 1
name free used name free used
overhead 0 6512 scb 0 144
opentable 0 16032 filetable 0 1632
log 0 2184 temprec 0 3232
keys 0 176 ralloc 0 207632
gentcb 0 1624 ostcb 0 3416
sort 0 104 sqscb 0 25240
sql 0 72 rdahead 0 224
hashfiletab 0 552 osenv 0 3248
buft_buffer 0 2168 sqtcb 0 5600
fragman 0 6752 sapi 0 72
udr 0 872
sqscb info
scb sqscb optofc pdqpriority sqlstats optcompind directives
c00000001c74d8d8 c00000001c387028 0 0 0 2 1
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
93 SELECT scp20 CR Wait 5 0 0 7.24 Off
Current statement name : usqlcurs
Current SQL statement :
select
GroupNumber,PhoneNo,ISDNNumber,Vgrpno,CloseGroupNo1,CloseGroupNo2,CloseGrou
pNo3,CloseGroupNo4,CloseGroupNo5,ISDNType,LockFlag,Power,Status,MonFeeLimit
Flag,UserPIN,UserType,ServiceNo,CurMonPkgFeeType,CurPkgActiveDate,RentLeftF
ee1,RentLeftFee2,LastPayRentDate,RentLeftTime1,RentLeftTime2,CurPkgDay,Mult
iServiceFlag,CurScreenList,KvpnGroupNo,KvpnCurMonPkgType,FvpnGroupNo,Vipman
agerID,IF3GUser from mvpn_phone where ISDNNumber=?
Host variables :
address type flags value
-----------------------------------------
0xc00000001c423f48 CHAR 0x000 13758949063
Last parsed SQL statement :
select
GroupNumber,PhoneNo,ISDNNumber,CloseGroupNo1,CloseGroupNo2,CloseGroupNo3,Cl
oseGroupNo4,CloseGroupNo5 from mvpn_user where GroupNumber=? and PhoneNo=?
===========------------- - - - - - -
/opt/informix/bin/onstat -g sql 93:
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line (Prim) -- Up 00:45:03 -- 468548 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
93 SELECT scp20 CR Wait 5 0 0 7.24 Off
Current statement name : usqlcurs
Current SQL statement :
select
GroupNumber,PhoneNo,ISDNNumber,Vgrpno,CloseGroupNo1,CloseGroupNo2,CloseGrou
pNo3,CloseGroupNo4,CloseGroupNo5,ISDNType,LockFlag,Power,Status,MonFeeLimit
Flag,UserPIN,UserType,ServiceNo,CurMonPkgFeeType,CurPkgActiveDate,RentLeftF
ee1,RentLeftFee2,LastPayRentDate,RentLeftTime1,RentLeftTime2,CurPkgDay,Mult
iServiceFlag,CurScreenList,KvpnGroupNo,KvpnCurMonPkgType,FvpnGroupNo,Vipman
agerID,IF3GUser from mvpn_phone where ISDNNumber=?
Host variables :
address type flags value
-----------------------------------------
0xc00000001c423f48 CHAR 0x000 13758949063
Last parsed SQL statement :
select
GroupNumber,PhoneNo,ISDNNumber,CloseGroupNo1,CloseGroupNo2,CloseGroupNo3,Cl
oseGroupNo4,CloseGroupNo5 from mvpn_user where GroupNumber=? and PhoneNo=?
===========------------- - - - - - -
/opt/informix/bin/onstat -c:
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line (Prim) -- Up 00:45:03 -- 468548 Kbytes
Configuration File: /opt/informix/etc/onconfig
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: Informix Dynamic Server Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /dev/vgdata/rlvrootdbs # Path for device containing root dbspace
ROOTOFFSET 50 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 1000000 # 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 phydbs # Location (dbspace) of physical log
PHYSFILE 1000000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 10 # Number of logical log files
LOGSIZE 100000 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /opt/informix/online.log # System message log file path
CONSOLE /dev/console # System console message path
# To automatically backup logical logs, edit alarmprogram.sh and set
# BACKUPLOGS=Y
ALARMPROGRAM /opt/informix/etc/alarmprogram.sh # Alarm program path
TBLSPACE_STATS 1 # Maintain tblspace statistics
# System Archive Tape Device
#TAPEDEV /tellinshare/sms/informixdump/fullbak # Tape device path
TAPEDEV /dev/rmt/0m # Tape device path
TAPEBLK 128 # Tape block size (Kbytes)
TAPESIZE 4096000 # Maximum amount of data to put on tape (Kbytes)
# Log Archive Tape Device
LTAPEDEV /opt/informix/lp # Log tape device path
LTAPEBLK 128 # Log tape block size (Kbytes)
LTAPESIZE 20480 # Max amount of data to put on log tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server staging area
# System Configuration
SERVERNUM 0 # Unique id corresponding to a OnLine instance
DBSERVERNAME mscp_server_net # Name of default database server
DBSERVERALIASES mscp_server # List of alternate dbservernames
NETTYPE # 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 15 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one
NOAGE 1 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 500000 # Maximum number of locks
BUFFERS 150000 # Maximum number of shared buffers
NUMAIOVPS # Number of IO vps
PHYSBUFF 128 # Physical log buffer size (Kbytes)
LOGBUFF 128 # Logical log buffer size (Kbytes)
CLEANERS 2 # Number of buffer cleaner processes
SHMBASE 0 # 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 86400 # Check point interval (in sec)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 2 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit
TXTIMEOUT 300 # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
# Dynamic Logging
# DYNAMIC_LOGS:
# 2 : server automatically add a new logical log when necessary. (ON)
# 1 : notify DBA to add new logical logs when necessary. (ON)
# 0 : cannot add logical log on the fly. (OFF)
#
# When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM,
# because the server can add new logical logs during long transaction rollback.
# However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM
# can be set to smaller values.
#
# If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values
# to avoid long transaction rollback hanging the server due to lack of logical
# log space, i.e. 50/60 or lower.
DYNAMIC_LOGS 2
LTXHWM 70
LTXEHWM 80
# System Page Size
# BUFFSIZE - OnLine no longer supports this configuration parameter.
# To determine the page size used by OnLine 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 20 # Default number of online worker threads
# Data Replication Variables
DRINTERVAL 1 # DR max time between DR buffer flushes (in sec)
DRTIMEOUT 120 # DR network timeout (in sec)
DRLOSTFOUND /opt/informix/etc/dr.lostfound # DR lost+found file path
# CDR Variables
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 (Kbytes)
CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)
CDR_SERIAL 0 # Serial Column Sequence
CDR_DBSPACE # dbspace for syscdr database
CDR_QHDR_DBSPACE erdbs # CDR queue dbspace (default same as catalog)
CDR_QDATA_SBSPACE ersbs # List of CDR queue smart blob spaces
# CDR_MAX_DYNAMIC_LOGS
# -1 => unlimited
# 0 => disable dynamic log addition
# >0 => limit the no. of dynamic log additions with the specified value.
# Max dynamic log requests that CDR can make within one server session.
CDR_MAX_DYNAMIC_LOGS 0 # Dynamic log addition disabled by default
# Backup/Restore variables
BAR_ACT_LOG /opt/informix/bar_act.log # ON-Bar Log file - not in /tmp please
BAR_DEBUG_LOG /opt/informix/bar_dbug.log # ON-Bar Debug Log - not in /tmp please
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
RESTARTABLE_RESTORE off
BAR_PROGRESS_FREQ 0
# Informix Storage Manager variables
ISM_DATA_POOL ISMData
ISM_LOG_POOL ISMLogs
# Read Ahead Variables
RA_PAGES # Number of pages to attempt to read ahead
RA_THRESHOLD # Number of pages left before next group
# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online. If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.
DBSPACETEMP tempdbs # Default temp dbspaces
# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure) occurs
# during OnLine operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR /tellinshare/sms/informixdump # Preserve diagnostics in this directory
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this aborts OnLine)
DUMPCNT 1 # Number of shared memory or gcore dumps for
# a single user's session
FILLFACTOR 90 # Fill factor for building indexes
# method for OnLine to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
DS_MAX_QUERIES # Maximum number of decision support queries
DS_TOTAL_MEMORY # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DATASKIP off
# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below. Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
# mode. Nested loop joins are not necessarily
# preferred. Optimizer bases its decision purely
# on costs.
OPTCOMPIND 2 # To hint the optimizer
DIRECTIVES 1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0)
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0
SBSPACENAME # Default smartblob space name - this is where blobs
# go if no sbspace is specified when the smartblob is
# created. It is also used by some datablades as
# the location to put their smartblobs.
SYSSBSPACENAME # Default smartblob space for use by the Informix
# Server. This is used primarily for Informix Server
# system statistics collection.
BLOCKTIMEOUT 3600 # Default timeout for system block
SYSALARMPROGRAM /opt/informix/etc/evidence.sh # System Alarm program path
# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL -1
ALLOW_NEWLINE 0 # embedded newlines(Yes = 1, No = 0 or anything but 1)
===========------------- - - - - - -
/opt/informix/bin/onstat -s:
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line (Prim) -- Up 00:45:03 -- 468548 Kbytes
Latches with lock or userthread set
name address lock wait userthread
===========------------- - - - - - -
/opt/informix/bin/onstat -k:
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line (Prim) -- Up 00:45:03 -- 468548 Kbytes
Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
c000000003906470 0 c0000000188712c8 0 HDR+S 100002 204 0
1 active, 500000 total, 65536 hash buckets, 0 lock table overflows
===========------------- - - - - - -
/opt/informix/bin/onstat -b:
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line (Prim) -- Up 00:45:03 -- 468548 Kbytes
Buffers
address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist
c000000004be93e8 0 802 5:215460 c0000000071c4000 2 2001 10 0 0
2 modified, 150000 total, 262144 hash buckets, 2048 buffer size
===========------------- - - - - - -
/opt/informix/bin/onstat -t:
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line (Prim) -- Up 00:45:03 -- 468548 Kbytes
Tblspaces
n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns
4 c00000001c18e050 0 1 100001 1:14 250 250 0 0 1
30 c00000001c191050 0 1 200001 2:4 50 2 0 0 1
31 c00000001c194050 0 1 300001 3:4 50 2 0 0 1
32 c00000001c197050 0 1 400001 4:4 50 2 0 0 1
33 c00000001c19e050 0 1 500001 5:4 1900 1900 0 0 27
38 c00000001c5a07b8 0 17 500009 5:12 8 1 0 0 1
127 c00000001c677700 0 1 5000b5 5:1720 8 3 2 74 1
128 c00000001c677a58 0 1 5000b6 5:1721 4 2 0 0 1
129 c00000001c677db0 0 1 5000b7 5:1722 8 2 1 4 1
130 c00000001c678108 0 1 5000b9 5:1724 8 2 1 4 1
131 c00000001c678460 0 1 5000bb 5:1726 8 2 1 18 1
132 c00000001c6787b8 0 1 5000bd 5:1728 8 1 0 0 1
133 c00000001c678b10 0 1 5000bf 5:1730 8 1 0 0 1
134 c00000001c678e68 0 1 5000c1 5:1732 8 1 0 0 1
136 c00000001c6a83a8 0 1 5000c5 5:1736 8 1 0 0 1
165 c00000001c7233a8 0 1 5000f7 5:2279 8 2 1 8 1
167 c00000001993e7b8 0 16 500126 5:2806 465920 449124 449012 898024 4
168 c000000019a1e3a8 0 16 500128 5:2808 31232 31218 31210 873865 5
169 c000000019a1e700 0 16 500129 5:2809 19865 18961 0 0 7
170 c00000001993eb10 0 16 50012a 5:2810 13631 13608 0 0 2
171 c00000001c19e3a8 0 23 5005a0 5:528320 56 50 27 399 7
199 c00000001993ee68 0 16 50066a 5:572673 22882 22832 22826 45652 8
200 c000000019a1e050 0 16 50066b 5:572674 704 691 0 0 6
205 c000000019a1ea58 0 4 500672 5:572681 428 274 273 19607 1
206 c000000019a1edb0 0 4 500673 5:572682 517 432 0 0 1
246 c00000001c44eb10 0 2 500767 5:592977 8 1 0 0 1
26 active, 247 total
===========------------- - - - - - -
/opt/informix/bin/onstat -d:
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line (Prim) -- Up 00:45:03 -- 468548 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
c000000018691e80 1 0x1 1 1 N informix rootdbs
c000000018692888 2 0x1 2 1 N informix logdbs
c000000018692a28 3 0x1 3 1 N informix phydbs
c000000018692bc8 4 0x2001 4 1 N T informix tempdbs
c000000018692d68 5 0x1 5 4 N informix workdbs
5 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
c000000018692028 1 1 25 500000 496872 PO-- /dev/vgdata/rlvrootdbs
c0000000188c0e10 2 2 25 524000 23947 PO-- /dev/vgdata/rlvlogdbs
c0000000188acc50 3 3 25 524000 23947 PO-- /dev/vgdata/rlvphydbs
c0000000188acde8 4 4 25 524000 523947 PO-- /dev/vgdata/rlvtempdbs
c000000018692228 5 5 25 1024000 373635 PO-- /dev/vgdata/rlvworkdbs1
c0000000186923c0 6 5 25 1024000 1023997 PO-- /dev/vgdata/rlvworkdbs2
c000000018692558 7 5 25 1024000 1023997 PO-- /dev/vgdata/rlvworkdbs3
c0000000186926f0 8 5 25 1024000 1023997 PO-- /dev/vgdata/rlvworkdbs4
8 active, 2047 maximum
Expanded chunk capacity mode: disabled
===========------------- - - - - - -
/opt/informix/bin/onstat -l:
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line (Prim) -- Up 00:45:03 -- 468548 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 3 64 14 1 14.00
phybegin physize phypos phyused %used
3:53 500000 335136 3 0.00
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-2 0 64 102 6 4 17.0 1.5
Subsystem numrecs Log Space used
OLDRSAM 102 5276
address number flags uniqid begin size used %used
c0000000188c0a00 7 U---C-L 5847 2:53 50000 419 0.84
c0000000188c0a68 8 F------ 0 2:50053 50000 0 0.00
c0000000188c0ad0 9 F------ 0 2:100053 50000 0 0.00
c0000000188c0b38 10 F------ 0 2:150053 50000 0 0.00
c0000000188c0ba0 1 F------ 0 2:200053 50000 0 0.00
c0000000188c0c08 2 F------ 0 2:250053 50000 0 0.00
c0000000188c0c70 3 F------ 0 2:300053 50000 0 0.00
c0000000188c0cd8 4 F------ 0 2:350053 50000 0 0.00
c0000000188c0d40 5 F------ 0 2:400053 50000 0 0.00
c0000000188c0da8 6 F------ 0 2:450053 50000 0 0.00
10 active, 10 total
===========------------- - - - - - -
/opt/informix/bin/onstat -p:
IBM Informix Dynamic Server Version 9.40.FC7W4 -- On-Line (Prim) -- Up 00:45:03 -- 468548 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
9281 9554 1228561 99.24 41806 1609750 71 0.00
isamtot open start read write rewrite delete commit rollbk
1294851 30081 36463 1086297 0 35 0 33 0
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 17.72 17.44 9 17
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
4555 0 88846 0 0 0 1 2695
ixda-RA idx-RA da-RA RA-pgsused lchwaits
127 0 82 207 3056
