Re: Informix sessions hang !
In article <5i0iar$ovk@cssun.mathcs.emory.edu>, Manoj <manoj@mailhost.tw
owaytv.co.uk> writes
>
>I would appreciate it if someone would give me a few pointers to the problem
>below:
>
>We are on solaris 5.5.1 with informix 7.22 running r4gl apps.
>Every now and then we get a user session that freezes up.
>A "ps" shows that the user is running the prog and the time is clocking up.
>An "onstat" shows the the user is in cond wait(sm_read), locked mutex.
>
>Again any help would be appreciated.
>
>Thanks,
>
>=======================================================
>Manoj Schroff
>TWOWAYTV Ltd, London, UK
>[R&D, Technology Services]
>
>Tel: 0181 742 2422 x221
>Email: manoj@mailhost.twowaytv.co.uk Fax: 0181
>994 2426
>=======================================================
> "He who laughs last, obviously did not understand the joke
>!!"
>=======================================================
>
>
>
>
>
>
Run onstat -u and check if the number of reads/write for that
user/process is increasing. If it goes up by a few thousand per
second then an index is missing somewhere. Find out which
.4gi is being run and add SET EXPLAIN ON to it. Then recompile
and check the sqexplain.out file which gets produces in the
current directory of the .4gi process.
--
David Williams