dbexport hangs

I have an instance where dbexport (dbexport system -ss) hangs. (AIX 4.3; Informix 7.24.UC7) The system.sql appears to have everything in it except the UPDATE STATS statements.... onstat -u shows this line: 5003f0d4 Y--P--- 2715 azit-dw - 5047a248 0 1 25526 0 onstat -s doesn't show any latches onstat -k shows this: Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 30114538 0 5003f0d4 0 HDR+X 100002 220 0 1 active, 300000 total, 65536 hash buckets onstat -g sql 2715 shows it's running the following SQL statement: select data , seqno from informix . sysprocbody where procid = ? and datakey ='T' order by seqno I ran every oncheck command I could think of to see if I could find anything wrong, but everything looked okay. It always hangs at this point. Any ideas?

And have all your stored procedures written out successfully? From: "Danny Wright" <dwright@sherwoodfoods.com> > >I have an instance where dbexport (dbexport system -ss) hangs. (AIX 4.3; >Informix 7.24.UC7) > >The system.sql appears to have everything in it except the UPDATE STATS >statements.... > >onstat -u shows this line:> >5003f0d4 Y--P--- 2715 azit-dw - 5047a248 0 1 25526 0 > >onstat -s doesn't show any latches >onstat -k shows this:> >Locks >address wtlist owner lklist type tblsnum rowid key#/bsiz >30114538 0 5003f0d4 0 HDR+X 100002 220 0 > 1 active, 300000 total, 65536 hash buckets > >onstat -g sql 2715 shows it's running the following SQL statement:> > select data , seqno from informix . sysprocbody where procid = ? and> datakey = 'T' order by seqno > >I ran every oncheck command I could think of to see if I could find >anything wrong, but everything looked okay. It always hangs at this point. > >Any ideas? > _________________________________________________________________ Find a cheaper internet access deal - choose one to suit you. http://www.msn.co.uk/internetaccess