Waiting on condition problem.

Environment : ODS 7.23uc4 HP-UX 10.20 Here is onstat -g ses for a session which is waiting on condition for more than an hour. 18807 prodadm 140 erp-trai 1 131072 79552 tid name rstcb flags curstk status 28185 sqlexec 99cf4118 Y--P--- 34024 99cf4118 cond wait(netnorm) Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 18807 V 9c6b6018 131072 51520 390 25 name free used name free used overhead 0 128 scb 0 128 opentable 0 14968 filetable 0 1752 log 0 2136 temprec 0 2376 ralloc 0 33536 gentcb 0 8480 ostcb 0 2160 sort 0 56 sqscb 0 9680 rdahead 0 80 hashfiletab 0 280 osenv 0 568 sqtcb 0 1976 fragman 0 1248 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers 18807 SELECT fprd CR Wait 0 0 7.23 Current statement name : task00conn00cur01 Current SQL statement : SELECT A.BUSINESS_UNIT, A.TRANSACTION_GROUP, B.OPRID, A.ACCOUNTING_DT, A.INV_ITEM_ID, A.ORDER_NO, A.ORDER_INT_LINE_NO, A.DISTRIB_TYPE, A.ACCOUNT, A.DEPTID, A.PRODUCT, A.GL_DISTRIB_STATUS, B.QTY,A.MONETARY_AMOUNT FROM PS_CM_ACCTG_LINE A, PS_TRANSACTION_INV B WHERE A.BUSINESS_UNIT = 'MEIN1' AND A.TRANSACTION_GROUP = '030' AND A.ACCOUNT = '661400' AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.INV_ITEM_ID = A.INV_ITEM_ID AND B.DT_TIMESTAMP = A.DT_TIMESTAMP AND B.SEQ_NBR = A.SEQ_NBR AND A.GL_DISTRIB_STATUS <> 'D' AND A.MONETARY_AMOUNT <> 0 ORDER BY 4 FOR READ ONLY How to find out the condition on which this is waiting ? And how to make it run ? Abhay Mannur Informix DBA Fairchild Semiconductor