Informix Notes
1. Version 12 Blockers
1.1 Session 1
create table a(b int);
begin work;
insert into a values(1);
1.2 Session 2
begin work;
delete from a where b=1;
1.3 Check for blocking
onstat -g bth
Your evaluation license will expire on 2014-11-16 00:00:00
IBM Informix Dynamic Server Version 12.10.FC4TL -- On-Line -- Up 1 days 12:47:32 -- 208516 Kbytes
This command attempts to identify any blocking threads.
Highest level blocker(s)
tid name session
226 sqlexec 62
Threads waiting on resources
tid name blocking resource blocker
19 readahead_0 Condition (ReadAhead) -
213 bf_priosweep() Condition (bp_cond) -
227 sqlexec Lock (0x441b21e0) 226
Run 'onstat -g BTH' for more info on blockers.
1.4 Detail on blockers
onstat -g BTH
Your evaluation license will expire on 2014-11-16 00:00:00
IBM Informix Dynamic Server Version 12.10.FC4TL -- On-Line -- Up 1 days 12:51:52 -- 208516 Kbytes
This command attempts to identify any blocking threads.
Highest level blocker(s)
tid name session
226 sqlexec 62
session effective #RSAM total used dynamic
id user user tty pid hostname threads memory memory explain
62 informix - 2 18717 localhos 1 86016 67376 off
Program :
/opt/IDS.12.10.FC4/bin/dbaccess
tid name rstcb flags curstk status
226 sqlexec 450deee8 Y-BP--- 6416 cond wait netnorm -
Memory pools count 2
name class addr totalsize freesize #allocfrag #freefrag
62 V 47612040 81920 17832 84 14
62*O0 V 4752b040 4096 808 1 1
name free used name free used
overhead 0 6576 scb 0 144
opentable 0 2712 filetable 0 888
ru 0 600 log 0 16536
temprec 0 3232 keys 0 176
gentcb 0 1592 ostcb 0 2944
sqscb 0 20600 sql 0 72
hashfiletab 0 552 osenv 0 2552
sqtcb 0 7792 fragman 0 408
sqscb info
scb sqscb optofc pdqpriority optcompind directives
45b011c0 47b41028 0 0 2 1
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
62 - djw CR Not Wait 0 0 9.24 Off
Last parsed SQL statement :
insert into a values(1)
Stack for thread: 226 sqlexec
base: 0x00000000479fe000
len: 102400
pc: 0x000000000134697f
tos: 0x0000000047a156f0
state: cond wait
vp: 1
0x000000000134697f (oninit) yield_processor_mvp
0x00000000013564c1 (oninit) mt_wait
0x00000000014d9caa (oninit) net_buf_get
0x0000000001480bdb (oninit) recvsocket
0x00000000014d5f99 (oninit) slSQIrecv
0x00000000014c9194 (oninit) pfRecv
0x00000000014c0c6d (oninit) asfRecv
0x000000000146b6a1 (oninit) ASF_Call
0x0000000000aac0f8 (oninit) _iread
0x0000000000aac4f1 (oninit) _igetint
0x0000000000aaaf6c (oninit) sqmain
0x0000000001476169 (oninit) spawn_thread
0x000000000138f470 (oninit) th_init_initgls
0x0000000001358cd7 (oninit) startup