0. Contents

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