perl/Informix problem

We are using perl to insert rows into an Informix table. We are using: Online Dynamic Server ver 7.24 Perl ver 5.004 Unix on a Siemens platform The database is non-logging. When we run the program it inserts 2408 of 16,683 rows and then hangs. 'onstat -u' looks normal. There are no messages in the online log or in any system logs indicating a problem. The machine that hangs at 2408 rows has 1.5 gig of memory. When we run the same program on another machine that has 3 gig of memory it inserts more rows (about 3000 - it varies) but still ends up hanging. Any ideas? We have had very little experience with DBD::Informix and we're stumped. I'm wondering if there is some memory related variable that needs to be changed in a perl module somewhere? We have read all kinds of manuals and postings but we still can't figure it out. Help!! Sent via Deja.com http://www.deja.com/ Before you buy.

When things hang, what does onstat -l report? How about onstat -g ses <sesid> for the perl session, what are the flags? Art S. Kagel jblatz2@my-deja.com wrote: > > We are using perl to insert rows into an Informix table. We are using: > > Online Dynamic Server ver 7.24 > Perl ver 5.004 > Unix on a Siemens platform > > The database is non-logging. > > When we run the program it inserts 2408 of 16,683 rows and then hangs. > > 'onstat -u' looks normal. > > There are no messages in the online log or in any system logs indicating > a problem. > > The machine that hangs at 2408 rows has 1.5 gig of memory. When we run > the same program on another machine that has 3 gig of memory it inserts > more rows (about 3000 - it varies) but still ends up hanging. > > Any ideas? We have had very little experience with DBD::Informix and > we're stumped. > > I'm wondering if there is some memory related variable that needs to be > changed in a perl module somewhere? > > We have read all kinds of manuals and postings but we still can't figure > it out. > > Help!! > > Sent via Deja.com http://www.deja.com/ > Before you buy.

On Thu, 24 Aug 2000 00:18:02 GMT, jblatz2@my-deja.com Wrote: > We are using perl to insert rows into an Informix table. We are using: > You posted this identical question in comp.lang.perl.misc - please could you spend a little time with the manual of your newsreader and work out how to do crossposting. /J\\