Folks,
IDS11.50FC8, RHEL6.
[informix@ncdopsdba101 tmp]$ onstat -g ath
IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 01:48:45
-- 13803348 Kbytes
Threads:
tid tcb rstcb prty status
vp-class name
2 213effd70 0 1 IO Idle
14lio* lio vp 0
3 213f372a8 0 1 IO Idle
15pio* pio vp 0
4 213f572a8 0 1 IO Idle
16aio* aio vp 0
5 213f762a8 0 1 IO Idle
17msc* msc vp 0
6 213fa52a8 0 1 IO Idle
18fifo* fifo vp 0
7 213fc52a8 0 1 IO Idle
19aio* aio vp 1
8 213fe42a8 0 1 IO Idle
20aio* aio vp 2
9 2140032a8 0 1 IO Idle
21aio* aio vp 3
10 214022548 213394028 3 sleeping secs: 1
7cpu main_loop()
11 213f37c50 0 1 running
22soc* soctcppoll
12 213f577b8 0 1 running
23soc* soctcppoll
13 213f57d70 0 1 running
24soc* soctcppoll
14 213f76918 0 1 running
25soc* soctcppoll
15 213fa55c0 0 1 running
1cpu* sm_poll
16 213ee1890 0 2 sleeping forever
1cpu* soctcplst
17 2143202c8 0 2 sleeping forever
1cpu sm_listen
18 21440b9b8 0 1 sleeping secs: 1
8cpu sm_discon
19 214461c40 0 2 sleeping forever
7cpu* soctcplst
20 2144c6418 0 2 sleeping forever
8cpu* soctcplst
21 2144c6d90 213394880 1 sleeping secs: 1
9cpu flush_sub(0)
22 2144e90e0 2133950d8 1 sleeping secs: 1
9cpu flush_sub(1)
23 2144e93f8 213395930 1 sleeping secs: 1
9cpu flush_sub(2)
24 2144e9710 213396188 1 sleeping secs: 1
9cpu flush_sub(3)
25 2144e9a28 2133969e0 1 sleeping secs: 1
7cpu flush_sub(4)
26 2144e9d40 213397238 1 sleeping secs: 1
8cpu flush_sub(5)
27 2145760e0 213397a90 1 sleeping secs: 1
9cpu flush_sub(6)
28 2145763f8 2133982e8 1 sleeping secs: 1
7cpu flush_sub(7)
29 214576710 213398b40 1 sleeping secs: 1
8cpu flush_sub(8)
30 214576a28 213399398 1 sleeping secs: 1
9cpu flush_sub(9)
31 214576d40 213399bf0 1 sleeping secs: 1
9cpu flush_sub(10)
32 2146120e0 21339a448 1 sleeping secs: 1
7cpu flush_sub(11)
33 2146123f8 21339aca0 1 sleeping secs: 1
1cpu flush_sub(12)
34 214612710 21339b4f8 1 sleeping secs: 1
7cpu flush_sub(13)
35 214612a28 21339bd50 1 sleeping secs: 1
7cpu flush_sub(14)
36 214612d90 21339c5a8 1 sleeping secs: 1
9cpu flush_sub(15)
37 2146ae130 0 3 IO Idle
1cpu* kaio
38 21481b418 21339ce00 2 sleeping secs: 1
9cpu aslogflush
39 21493a220 21339d658 1 sleeping secs: 17
13cpu btscanner_0
41 2149983e8 0 3 IO Idle
7cpu* kaio
62 214bc3028 21339ef60 3 sleeping secs: 1
1cpu* onmode_mon
63 214bc3288 21339e708 3 sleeping secs: 1
9cpu periodic
70 214dce028 0 3 IO Idle
9cpu* kaio
71 214c4d278 0 3 IO Idle
8cpu* kaio
72 214c4d590 0 3 IO Idle
10cpu* kaio
74 214c4ead8 2133a0868 1 sleeping secs: 95
11cpu* dbScheduler
76 214a36ca0 2133a0010 1 sleeping forever
1cpu dbWorker1
77 214ad32c8 21339f7b8 1 sleeping forever
1cpu dbWorker2
78 214bbfab8 0 3 IO Idle
11cpu* kaio
79 214b1f310 2133a10c0 1 cond wait netnorm
7cpu sqlexec
80 215096418 0 3 IO Idle
12cpu* kaio
87 21512a1e8 0 3 IO Idle
13cpu* kaio
88 2151c8568 2133a1918 1 cond wait bp_cond
8cpu bf_priosweep()
Apparently, There is no dbWorker3 in the above list ( only dbWorker1 and
dbWorker2)
So, dbWorker3 just dump things(see below) and run ?
If possible, Please shed light on how to stop dbWorker3's dump.
Thanks,
Frank
[informix@ncdopsdba101 tmp]$ more af.4480f24
01:11:00 Context ptr = 0x000000000178a340
01:11:00 Siginfo ptr = 0x000000000178a470
01:11:00 Reg 0(R8) 0x0000000000000000 Reg 1(R9)
0x0000000000000000
01:11:00 Reg 2(R10) 0x0000000000000008 Reg 3(R11)
0x0000000000000246
01:11:00 Reg 4(R12) 0x00000000495d96b0 Reg 5(R13)
0x0000000215a646f0
01:11:00 Reg 6(R14) 0x0000000215a646e0 Reg 7(R15)
0x0000000215a64c00
01:11:00 Reg 8(RDI) 0x0000000215a646e0 Reg 9(RSI)
0x0000000214b68028
01:11:00 Reg 10(RBP) 0x0000000215a646e0 Reg 11(RBX)
0x0000000000000001
01:11:00 Reg 12(RDX) 0x0000000000000000 Reg 13(RAX)
0x0000000000000000
01:11:00 Reg 14(RCX) 0x0000003ba0c32be0 Reg 15(RSP)
0x0000000215a643e0
01:11:00 Reg 16(RIP) 0x000000000064bfe4 Reg 17(EFL)
0x0000000000010246
01:11:00 Reg 18(CSGSFS) 0x0000000000000033 Reg 19(ERR)
0x0000000000000004
01:11:00 Reg 20(TRAPNO) 0x000000000000000e Reg 21(OLDMASK)
0x0000000000000000
01:11:00 Reg 22(CR2) 0x0000000000000010
01:11:00
01:11:00 IBM Informix Dynamic Server Version 11.50.FC8 Software Serial
Number AAA#B000000
01:11:00 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem
01:11:00 Who: Session(42, informix@, 0, 0x2133dccf8)
Thread(96, dbWorker3, 21339deb0, 8)
File: mtex.c Line: 417
01:11:00 Action: Please notify IBM Informix Technical Support.
01:11:00 Raw hex dump of stack located in /tmp/af.4480f24.rawstk
01:11:00 Stack for thread: 96 dbWorker3
base: 0x0000000215a46000
len: 135168
pc: 0x00000000010c91d7
tos: 0x0000000001789450
state: running
vp: 8
0x00000000010c91d7 (oninit) afstack
0x00000000010cb12c (oninit) afhandler
0x00000000010cb9e4 (oninit) affail_interface
0x00000000010cf7e9 (oninit) mt_ex_throw_sig
0x000000000108d895 (oninit) afsig_handler
0x0000003ba140f710 (Linux) <signal frame>
0x000000000064bfe4 (oninit) sqapi_error_desc_first
0x000000000064e5c8 (oninit) sqapi_callback_list_call
0x000000000064eab8 (oninit) sqapi_call_callbacks
0x000000000064ca4c (oninit) sqapi_error_dispatch
0x000000000064d0e3 (oninit) sqapi_online_error
0x0000000000549e19 (oninit) mi_exec
0x0000000000d59383 (oninit) aus_refresh
0x0000000000968514 (oninit) udrlm_clang_execute_internal
0x000000000096a319 (oninit) udrlm_clang_execute
0x0000000000907846 (oninit) udrlm_exec_routine
0x000000000063e641 (oninit) udr_execute
0x0000000000559aa5 (oninit) mi_routine_exec
0x0000000000d507d9 (oninit) ph_exec_func
0x0000000000d55511 (oninit) ph_execute
0x0000000000d55be8 (oninit) do_task
0x0000000000d568a8 (oninit) db_sch_worker
0x000000000096861e (oninit) udrlm_clang_execute_internal
0x000000000096a319 (oninit) udrlm_clang_execute
0x0000000000907846 (oninit) udrlm_exec_routine
0x000000000063e641 (oninit) udr_execute
0x0000000000d4dda5 (oninit) dbsched_start_udr
0x000000000109a9bb (oninit) startup
01:11:00 See Also: /tmp/af.4480f24, shmem.4480f24.0
---------------------------------
Begin System Alarm Program Output
---------------------------------
Assertion Failure Type: FAILURE
Host Name: ncdopsdba101
Database Server Name: ncdcops101_tcp
Time of failure: Sat Jan 25 01:11:00 UTC 2014
AF file: /tmp/af.4480f24
Shared memory file: None
System Blocking: OFF
===========------------- - - - - - -
tail -100 /dbbackup/online_log/online_ops.log:
00:13:33 Started 1 B-tree scanners.
00:13:33 B-tree scanner threshold set at 5000.
00:13:33 B-tree scanner range scan size set to -1.
00:13:33 B-tree scanner ALICE mode set to 6.
00:13:33 B-tree scanner index compression level set to med.
00:13:33 Physical Recovery Started at Page (2:808252).
00:13:33 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
00:13:33 Logical Recovery Started.
00:13:33 16 recovery worker threads will be started.
00:13:34 Logical Recovery has reached the transaction cleanup phase.
00:13:34 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
00:13:35 Dataskip is now OFF for all dbspaces
00:13:37 SCHAPI: Started dbScheduler thread.
00:13:37 Checkpoint Completed: duration was 2 seconds.
00:13:37 Sat Jan 25 - loguniq 88381, logpos 0x46018, timestamp: 0xd50e5bfc
Interval: 308710
00:13:37 Maximum server connections 0
00:13:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 2, Llog used 1
00:13:37 On-Line Mode
00:13:40 Booting Language <spl> from module <>
00:13:40 Loading Module <SPLNULL>
00:13:40 SCHAPI: Started 2 dbWorker threads.
00:14:39 requested number of KAIO events (10000) exceeds limit (7768).
using 7768.
00:15:13 requested number of KAIO events (10000) exceeds limit (3884).
using 3884.
00:18:15 requested number of KAIO events (10000) exceeds limit (1942).
using 1942.
00:18:36 Checkpoint Completed: duration was 0 seconds.
00:18:36 Sat Jan 25 - loguniq 88381, logpos 0x5c018, timestamp: 0xd50e69ae
Interval: 308711
00:18:36 Maximum server connections 2
00:18:36 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 17, Llog used 22
00:23:37 Checkpoint Completed: duration was 0 seconds.
00:23:37 Sat Jan 25 - loguniq 88381, logpos 0x5e018, timestamp: 0xd50ea23a
Interval: 308712
00:23:37 Maximum server connections 2
00:23:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 0, Llog used 2
00:28:36 Checkpoint Completed: duration was 0 seconds.
00:28:36 Sat Jan 25 - loguniq 88381, logpos 0x60018, timestamp: 0xd50ea2a9
Interval: 308713
00:28:36 Maximum server connections 2
00:28:36 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 2, Llog used 2
00:33:37 Checkpoint Completed: duration was 0 seconds.
00:33:37 Sat Jan 25 - loguniq 88381, logpos 0x62018, timestamp: 0xd50ea5b1
Interval: 308714
00:33:37 Maximum server connections 2
00:33:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 0, Llog used 2
00:38:37 Checkpoint Completed: duration was 0 seconds.
00:38:37 Sat Jan 25 - loguniq 88381, logpos 0x68018, timestamp: 0xd50ea5e4
Interval: 308715
00:38:37 Maximum server connections 2
00:38:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 9, Llog used 6
00:43:37 Checkpoint Completed: duration was 0 seconds.
00:43:37 Sat Jan 25 - loguniq 88381, logpos 0x6a018, timestamp: 0xd50ea5f3
Interval: 308716
00:43:37 Maximum server connections 2
00:43:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 2, Llog used 2
00:53:37 Checkpoint Completed: duration was 0 seconds.
00:53:37 Sat Jan 25 - loguniq 88381, logpos 0x6c018, timestamp: 0xd50ebade
Interval: 308717
00:53:37 Maximum server connections 2
00:53:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 0, Llog used 2
00:58:37 Checkpoint Completed: duration was 0 seconds.
00:58:37 Sat Jan 25 - loguniq 88381, logpos 0x6e018, timestamp: 0xd50ee103
Interval: 308718
00:58:37 Maximum server connections 2
00:58:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 2, Llog used 2
01:00:00 SCHAPI: [Auto Update Statistics Evaluation 39-89] Error -206 The
specified table (aus_work_info) is not in the database.
01:00:00 SCHAPI: [Auto Update Statistics Evaluation 39-89] Error -111 ISAM
error: no record found.
01:03:37 Checkpoint Completed: duration was 0 seconds.
01:03:37 Sat Jan 25 - loguniq 88381, logpos 0xd4018, timestamp: 0xd50ee87c
Interval: 308719
01:03:37 Maximum server connections 2
01:03:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 121, Llog used 102
01:08:38 Checkpoint Completed: duration was 0 seconds.
01:08:38 Sat Jan 25 - loguniq 88381, logpos 0x129018, timestamp:
0xd50eee34 Interval: 308720
01:08:38 Maximum server connections 2
01:08:38 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
0, Plog used 78, Llog used 85
01:11:00 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem
01:11:00 IBM Informix Dynamic Server Version 11.50.FC8
01:11:00 Who: Session(42, informix@, 0, 0x2133dccf8)
Thread(96, dbWorker3, 21339deb0, 8)
File: mtex.c Line: 417
01:11:00 Action: Please notify IBM Informix Technical Support.
01:11:00 stack trace for pid 6196 written to /tmp/af.4480f24
01:11:00 See Also: /tmp/af.4480f24, shmem.4480f24.0
===========------------- - - - - - -
/usr/informix/bin/onstat -g ath:
IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 00:57:40
-- 13803348 Kbytes
Threads:
tid tcb rstcb prty status
vp-class name
2 213effd70 0 1 IO Idle
14lio* lio vp 0
3 213f372a8 0 1 IO Idle
15pio* pio vp 0
4 213f572a8 0 1 IO Idle
16aio* aio vp 0
5 213f762a8 0 1 IO Idle
17msc* msc vp 0
6 213fa52a8 0 1 IO Idle
18fifo* fifo vp 0
7 213fc52a8 0 1 IO Idle
19aio* aio vp 1
8 213fe42a8 0 1 IO Idle
20aio* aio vp 2
9 2140032a8 0 1 IO Idle
21aio* aio vp 3
10 214022548 213394028 3 sleeping secs: 1
7cpu main_loop()
11 213f37c50 0 1 running
22soc* soctcppoll
12 213f577b8 0 1 running
23soc* soctcppoll
13 213f57d70 0 1 running
24soc* soctcppoll
14 213f76918 0 1 running
25soc* soctcppoll
15 213fa55c0 0 1 running
1cpu* sm_poll
16 213ee1890 0 2 sleeping forever
1cpu* soctcplst
17 2143202c8 0 2 sleeping forever
1cpu sm_listen
18 21440b9b8 0 1 sleeping secs: 1
8cpu sm_discon
19 214461c40 0 2 sleeping forever
7cpu* soctcplst
20 2144c6418 0 2 sleeping forever
8cpu* soctcplst
21 2144c6d90 213394880 1 sleeping secs: 1
12cpu flush_sub(0)
22 2144e90e0 2133950d8 1 sleeping secs: 1
7cpu flush_sub(1)
23 2144e93f8 213395930 1 sleeping secs: 1
7cpu flush_sub(2)
24 2144e9710 213396188 1 sleeping secs: 1
9cpu flush_sub(3)
25 2144e9a28 2133969e0 1 sleeping secs: 1
7cpu flush_sub(4)
26 2144e9d40 213397238 1 sleeping secs: 1
7cpu flush_sub(5)
27 2145760e0 213397a90 1 sleeping secs: 1
9cpu flush_sub(6)
28 2145763f8 2133982e8 1 sleeping secs: 1
9cpu flush_sub(7)
29 214576710 213398b40 1 sleeping secs: 1
8cpu flush_sub(8)
30 214576a28 213399398 1 sleeping secs: 1
8cpu flush_sub(9)
31 214576d40 213399bf0 1 sleeping secs: 1
12cpu flush_sub(10)
32 2146120e0 21339a448 1 sleeping secs: 1
12cpu flush_sub(11)
33 2146123f8 21339aca0 1 sleeping secs: 1
7cpu flush_sub(12)
34 214612710 21339b4f8 1 sleeping secs: 1
7cpu flush_sub(13)
35 214612a28 21339bd50 1 sleeping secs: 1
7cpu flush_sub(14)
36 214612d90 21339c5a8 1 sleeping secs: 1
7cpu flush_sub(15)
37 2146ae130 0 3 IO Idle
1cpu* kaio
38 21481b418 21339ce00 2 sleeping secs: 1
12cpu aslogflush
39 21493a220 21339d658 1 sleeping secs: 8
12cpu btscanner_0
41 2149983e8 0 3 IO Idle
7cpu* kaio
62 214bc3028 21339ef60 3 sleeping secs: 1
1cpu* onmode_mon
63 214bc3288 21339e708 3 sleeping secs: 1
7cpu periodic
70 214dce028 0 3 IO Idle
9cpu* kaio
71 214c4d278 0 3 IO Idle
8cpu* kaio
72 214c4d590 0 3 IO Idle
10cpu* kaio
74 214c4ead8 2133a0868 1 sleeping secs: 300
1cpu* dbScheduler
76 214a36ca0 2133a0010 1 sleeping forever
7cpu dbWorker1
77 214ad32c8 21339f7b8 1 sleeping forever
1cpu dbWorker2
78 214bbfab8 0 3 IO Idle
11cpu* kaio
79 214b1f310 2133a10c0 1 ready
8cpu sqlexec
80 215096418 0 3 IO Idle
12cpu* kaio
87 21512a1e8 0 3 IO Idle
13cpu* kaio
88 2151c8568 2133a1918 1 cond wait bp_cond
1cpu bf_priosweep()
*96 215b67d20 21339deb0 1 running
8cpu* dbWorker3
===========------------- - - - - - -
/usr/informix/bin/onstat -g stk 96 light:
IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 00:57:40
-- 13803348 Kbytes
Stack for thread: 96 dbWorker3
base: 0x0000000215a46000
len: 135168
pc: 0x000000000107fdcd
tos: 0x00000000017897a0
state: running
vp: 8
Changing data structure forced command termination.
===========------------- - - - - - -
/usr/informix/bin/onstat -u:
IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 00:57:41
-- 13803348 Kbytes
Userthreads
address flags sessid user tty wait tout
locks nreads nwrites
213394028 ---P--D 1 informix - 0 0
0 343 494
213394880 ---P--F 0 informix - 0 0
0 0 267
2133950d8 ---P--F 0 informix - 0 0
0 0 45
213395930 ---P--F 0 informix - 0 0
0 0 39
213396188 ---P--F 0 informix - 0 0
0 0 18
2133969e0 ---P--F 0 informix - 0 0
0 0 0
213397238 ---P--F 0 informix - 0 0
0 0 0
213397a90 ---P--F 0 informix - 0 0
0 0 0
2133982e8 ---P--F 0 informix - 0 0
0 0 0
213398b40 ---P--F 0 informix - 0 0
0 0 0
213399398 ---P--F 0 informix - 0 0
0 0 0
213399bf0 ---P--F 0 informix - 0 0
0 0 0
21339a448 ---P--F 0 informix - 0 0
0 0 0
21339aca0 ---P--F 0 informix - 0 0
0 0 0
21339b4f8 ---P--F 0 informix - 0 0
0 0 0
21339bd50 ---P--F 0 informix - 0 0
0 0 0
21339c5a8 ---P--F 0 informix - 0 0
0 0 0
21339ce00 ---P--- 16 informix - 0 0
0 0 0
21339d658 ---P--B 17 informix - 0 0
0 0 0
21339deb0 *---P--- 42 informix - 0 0
1 13 1
21339e708 ---P--D 21 informix - 0 0
0 3 0
21339ef60 ---P--D 20 informix - 0 0
0 0 0
21339f7b8 ---P--- 32 informix - 0 0
1 313 38
2133a0010 ---P--- 31 informix - 0 0
1 522 123
2133a0868 ---P--- 29 informix - 0 0
1 250 23
2133a10c0 Y--P--- 9 informix - 214b1f0d0 0
3 13259074 0
2133a1918 Y--P--D 40 informix - 496ce970 0
0 0 0
27 active, 128 total, 38 maximum concurrent
===========------------- - - - - - -
/usr/informix/bin/onstat -g ses 42:
IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 00:57:41
-- 13803348 Kbytes
session effective #RSAM total
used dynamic
id user user tty pid hostname threads memory
memory explain
42 informix - - 0 - 1 258048
237160 off
tid name rstcb flags curstk status
96 dbWorker 21339deb0 ---P--- 338548832 running-
Memory pools count 2
name class addr totalsize freesize #allocfrag
#freefrag
42 V 2153da040 253952 20080 292 15
42*O0 V 215244040 4096 808 1 1
name free used name free used
overhead 0 6576 mtmisc 0 72
resident 0 72 scb 0 216
opentable 0 11104 filetable 0 2480
ru 0 600 log 0 16536
temprec 0 36000 partn 0 192
keys 0 904 ralloc 0 107832
gentcb 0 1584 ostcb 0 2920
sqscb 0 28064 sql 0 144
rdahead 0 1120 hashfiletab 0 552
sqtcb 0 10280 fragman 0 5360
sapi 0 208 SQL error 0 472
SAPI callback 0 880 udr 0 2464
sqlj 0 256
sqscb info
scb sqscb optofc pdqpriority optcompind
directives
214954028 214b68028 0 0 0 1
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
Explain
42 - sysadmin DR Wait 5 0 0 -
Off
===========------------- - - - - - -
/usr/informix/bin/onstat -g env 42:
IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 00:57:41
-- 13803348 Kbytes
Environment for session 42: (WARNING: No specific environment.)
Variable Value [values-list]
DBCENTURY C
DBDATE Y4MD/
DBDELIMITER |
DBPATH .
DBPRINT lp -s
DBTEMP /tmp
IFX_DEF_TABLE_LOCK ROW
IFX_LARGE_PAGES 0
INFORMIXDIR /usr/informix
[/usr/informix]
[/usr/informix]
[/usr/informix]
INFORMIXSERVER ncdcops101_tcp
[ncdcops101_tcp]
[ncdcops_tcp]
INFORMIXSQLHOSTS /usr/informix/etc/sqlhosts
INFORMIXTERM terminfo
KAIOON 10000
LANG en_US.UTF-8
LC_COLLATE en_US.UTF-8
LC_CTYPE en_US.UTF-8
LC_MONETARY en_US.UTF-8
LC_NUMERIC en_US.UTF-8
LC_TIME en_US.UTF-8
LKNOTIFY yes
LOCKDOWN no
NODEFDAC no
ONCONFIG onconfig.ncdcops101
[onconfig.ncdcops101]
[onconfig.ncdcops]
PATH
/usr/informix/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/s
bin:/usr/sbin:/sbin:/etc/opt/emcpower/bin:/home/informix/b
in:/usr/informix/bin:/usr/sbin:/opt/bin:.:/home/shared/fqu
/informix/monitor:/dbbackup/bin
SERVER_LOCALE en_US.819
SHELL /bin/bash
TERM xterm
[xterm]
[dumb]
TERMCAP /usr/informix/etc/termcap
[/usr/informix/etc/termcap]
[/etc/termcap]
===========------------- - - - - - -
/usr/informix/bin/onstat -g sql 42:
IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 00:57:41
-- 13803348 Kbytes
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
Explain
42 - sysadmin DR Wait 5 0 0 -
Off
===========------------- - - - - - -
/usr/informix/bin/onstat -c:
IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 00:57:41
-- 13803348 Kbytes
Configuration File: /usr/informix/etc/onconfig.ncdcops101
###################################################################
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Dynamic Server
# Copyright IBM Corporation 1996, 2010. All rights reserved.
#
# Title: onconfig.std
# Description: IBM Informix Dynamic Server Configuration Parameters
#
# Important: $INFORMIXDIR now resolves to the environment
# variable INFORMIXDIR. Replace the value of the INFORMIXDIR
# environment variable only if the path you want is not under
--90e6ba3fd721fd55b804f0c1f3cf
