Re: tbspaces hangs , why ?

In article <3sk6tr$ehi@cssun.mathcs.emory.edu> valery@milcse.cig.mot.com "Valery Azbel" writes: > > Hi , all > > I run installation script from packaging tool ( OS System V , release 4 ) > An standart input is closed by packaging tool. > > At installation of the package I run from shell script : > > tbinit -iy > sleep 60 > > #and right here > /usr/informix/bin/tbspaces -c -d my_dbspace -p /dev/informix -o 0 -s 100000 > > As result of it tbspaces hangs with tbstat -u flag C - waiting for checkpoint. > > #tbstat -m shows > RSAM Version 5.02.UC7X1 -- On-Line (CKPT REQ) -- Up 00:00:23 -- 4784 Kbytes > Users > address flags pid user tty wait tout locks nreads nwrites > 8027ec ------D 6320 root console 0 0 0 3 21 > 802860 ------D 0 root console 0 0 0 0 0 > 8028d4 ------F 6321 root 0 0 0 0 0 > 802948 ------F 6322 root 0 0 0 0 0 > 8029bc C-B---M 6355 root console 0 0 0 0 3 > > Also tbinit do not perform checkpoint according to CKPTINTVL 300 > in the tbconfig. > > Online is hangs. > > What could cause such strange behavior ? > If I run in another session tbmode -c then tbspaces goes on , but following > after it additional tbspaces also hangs for checkpoint as well. > > Additional : > If I run simple shell script with tbinit -iy and tbspaces -c everything is OK. > > How do explain this stuff ?! > > I can't > > May be DBA's have something to say ? > > Thanks in advance > I have also seen behaviour like this. As part of our rc.local we execute tbinit. Soon after that a program gets started which gets the size of the dbspace, and its freespace, by doing 'tbmode -c; tbstat -d'. There are times when this would hang (30-40 mins). Unfortunately, it would never repeat to order, but my supposition is that a checkpoint request soon after 'tbinit' is risky. I haven't found a workround that is bombproof either, other than waiting for a while to make sure on-line is good and ready. Andy Lennard andy@kontron.demon.co.uk