Re: UNLOAD Problems

Degtearyov M.V. wrote: > > Hi All, > > Could You help me in my problem: > > I work in Informix 4GL 6.01 UD4 under Informix-OnLine 7.30 UC2 > on SCO UNIX 3.2 v 5.0.4. > > In my program I have a procedure which performs a series of unload > operators, e.q. > > UNLOAD TO 'smo_selects.unl' SELECT * FROM smo_selects > WHERE select_prx = pSelectPrx AND select_lbl = pSelectLbl> > UNLOAD TO 'smo_domains.unl' SELECT * FROM smo_domains > WHERE select_prx = pSelectPrx AND select_lbl = pSelectLbl> > , etc. > > The total number of unloads is 13. > Periodicaly (not always) program crashes after 6th or 7th unload with core > dumping. > > The same situation I observed on my customers hosts under another releases > of OnLine. (7.20, 7.22) > > I tried to rearrange my unloads, removed all screen output (file names) > between unloads, but nothing helps. > > Is there any workaround ? Please help me. > -- > Michael Degtyarev, System analyst Are you running out of file handles? Check the per-user and per-system kernel parameters. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions and the release notes. Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/ ---