Re: lock mode wait 600 ??

In article <39295041.DA54EA39@teleatlas.com>, Stefan Moens <stefan.moens@teleatlas.com> writes > Hi, > > We're doing a 'load' of a table ( +- 1.300.000 records ), at a > certain moment the load process hangs (there are no new records > loaded to the table). The output of the 'onstat -g ses sesid' says > 'lock mode wait 600', why is the process locked and what is locking > the process ? > > batman:informix> onstat -g ses 206 > > Informix Dynamic Server 2000 Version 9.20.UC2   -- On-Line -- Up > 04:53:58 -- 955392 Kbytes > > session                                   #RSAM    total      used > id       user     tty      pid   hostname threads  memory > memory > 206      ads      2        1063  batman   1        65536      52040 > > tid      name     rstcb    flags    curstk   status > 295      sqlexec  320f0c18 Y--P---  1656     320f0c18 cond > wait(netnorm) > cond wait (netnorm) means that online is waiting for a command from the client program. > Memory pools    count 1 > name         class addr     totalsize freesize #allocfrag #freefrag > 206          V     32f89020 65536     13496    107        8 > > name           free       used           name           free > used > overhead       0          1648           scb            0 > 96 > opentable      0          4360           filetable      0 > 808 > ru             0          224            log            0 > 2152 > temprec        0          16200          keys           0 > 384 > ralloc         0          4096           gentcb         0 > 1240 > ostcb          0          2520           sqscb          0 > 11960 > rdahead        0          1616           hashfiletab    0 > 280 > osenv          0          1512           sqtcb          0 > 2544 > fragman        0          304            sapi           0 > 96 > > Sess  SQL            Current            Iso Lock       SQL  ISAM > F.E. > Id    Stmt type      Database           Lvl Mode       ERR  ERR > Vers > 206   -              mn_fra002          CR  Wait 600   0    0 > 9.03 > > Last parsed SQL statement : >   insert into tsi values(?, ?, ?)> > batman:informix> onstat -k > > Informix Dynamic Server 2000 Version 9.20.UC2   -- On-Line -- Up > 04:55:13 -- 955392 Kbytes > > Locks > address  wtlist   owner    lklist   type     tblsnum  rowid > key#/bsiz > a0dd964  0        320f0c18 0            S    100002   203         0 > a1ddef4  0        0        0        HDR+     100002   203         0 >  2 active, 25000 total, 16384 hash buckets, 0 lock table overflows > > Best regards, > Stefan > > >[ A MIME text / x-vcard part was included here. ] > -- David Williams

What is the output from onstat -g mgm? In article <KyzMDEAYuaK5Ewvj@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> wrote: > In article <39295041.DA54EA39@teleatlas.com>, Stefan Moens > <stefan.moens@teleatlas.com> writes > > Hi, > > > > We're doing a 'load' of a table ( +- 1.300.000 records ), at a > > certain moment the load process hangs (there are no new records > > loaded to the table). The output of the 'onstat -g ses sesid' says > > 'lock mode wait 600', why is the process locked and what is locking > > the process ? > > > > batman:informix> onstat -g ses 206 > > > > Informix Dynamic Server 2000 Version 9.20.UC2'' -- On-Line -- Up > > 04:53:58 -- 955392 Kbytes > > > > session'''''''''''''''''''''''''''''''''' #RSAM''' total''''' used > > id'''''' user'''' tty''''' pid'' hostname threads' memory'''' > > memory > > 206''''' ads''''' 2''''''' 1063' batman'' 1''''''' 65536''''' 52040 > > > > tid''''' name'''' rstcb''' flags''' curstk'' status > > 295''''' sqlexec' 320f0c18 Y--P---' 1656'''' 320f0c18 cond > > wait(netnorm) > > > cond wait (netnorm) means that online is waiting for a command > from the client program. > > > Memory pools''' count 1 > > name'''''''' class addr'''' totalsize freesize #allocfrag #freefrag > > 206''''''''' V'''' 32f89020 65536'''' 13496''' 107''''''' 8 > > > > name'''''''''' free'''''' used'''''''''' name'''''''''' free'''''' > > used > > overhead'''''' 0''''''''' 1648'''''''''' scb''''''''''' 0''''''''' > > 96 > > opentable''''' 0''''''''' 4360'''''''''' filetable''''' 0''''''''' > > 808 > > ru'''''''''''' 0''''''''' 224''''''''''' log''''''''''' 0''''''''' > > 2152 > > temprec''''''' 0''''''''' 16200''''''''' keys'''''''''' 0''''''''' > > 384 > > ralloc'''''''' 0''''''''' 4096'''''''''' gentcb'''''''' 0''''''''' > > 1240 > > ostcb''''''''' 0''''''''' 2520'''''''''' sqscb''''''''' 0''''''''' > > 11960 > > rdahead''''''' 0''''''''' 1616'''''''''' hashfiletab''' 0''''''''' > > 280 > > osenv''''''''' 0''''''''' 1512'''''''''' sqtcb''''''''' 0''''''''' > > 2544 > > fragman''''''' 0''''''''' 304''''''''''' sapi'''''''''' 0''''''''' > > 96 > > > > Sess' SQL''''''''''' Current''''''''''' Iso Lock'''''' SQL' ISAM > > F.E. > > Id''' Stmt type''''' Database'''''''''' Lvl Mode'''''' ERR' ERR' > > Vers > > 206'' -''''''''''''' mn_fra002''''''''' CR' Wait 600'' 0''' 0''' > > 9.03 > > > > Last parsed SQL statement : > > ' insert into tsi values(?, ?, ?) > > > > batman:informix> onstat -k > > > > Informix Dynamic Server 2000 Version 9.20.UC2'' -- On-Line -- Up > > 04:55:13 -- 955392 Kbytes > > > > Locks > > address' wtlist'' owner''' lklist'' type'''' tblsnum' rowid''' > > key#/bsiz > > a0dd964' 0''''''' 320f0c18 0''''''''''' S''' 100002'' 203'''''''' 0 > > a1ddef4' 0''''''' 0''''''' 0''''''' HDR+'''' 100002'' 203'''''''' 0 > > '2 active, 25000 total, 16384 hash buckets, 0 lock table overflows > > > > Best regards, > > Stefan > > > > > >[ A MIME text / x-vcard part was included here. ] > > > > -- > David Williams > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.