Oninit cdi / Archive
Talk to an expert →

RE: Problem loading data - 9.21.FC4

Posted in 2004

Topics: SQL Development & Query Writing, Server Administration, Logging & Checkpoints

Tsutomu Ogiwara — — source: Usenet: comp.databases.informix

Hi Howard. Logical log is full ? Can you post output of onstat -l ? Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Howard Jones" <howie_lfc@hotmail.com> >Reply-To: "Howard Jones" <howie_lfc@hotmail.com> >To: informix-list@iiug.org >Subject: Problem loading data - 9.21.FC4 >Date: Wed, 21 Jan 2004 10:04:10 -0000 > >Hello all, > >Informix Version 9.21.FC4 >OS HPUX 11.0 > >I am attempting to load a bunch of tables into a new database using >dbaccess. >I am having problems with one particular table which appears to hang. > >I am guessing it has something to do with the "wait (netnorm)" which is >output using onstat -g (session id) > >The output form onstat -g ses is as follows: > >Informix Dynamic Server 2000 Version 9.21.FC4 -- On-Line -- Up 2 days >12:59:59 -- 4956180 Kbytes > >session >#RSAM total used >id user tty pid hostname >threads memory memory >100124 informix - 16732 sleepy 1 >61440 56240 > >tid name rstcb flags >curstk status >100764 sqlexec c0000000c4845028 Y--P--- 33056 >c0000000c4845028cond wait(netnorm) > >Memory pools count 1 >name class addr >totalsize freesize #allocfrag #freefrag >100124 V c0000000c549c040 61440 >5200 >106 6 > >name free used name free >used >overhead 0 3256 scb 0 >144 >opentable 0 3608 filetable 0 >1040 >log 0 2168 temprec 0 >1656 >keys 0 176 ralloc 0 >14728 >gentcb 0 1720 ostcb 0 >3416 >sqscb 0 16880 sql 0 >72 >rdahead 0 256 hashfiletab 0 >552 >osenv 0 2536 sqtcb 0 > 3144 >fragman 0 888 > >Sess SQL Current Iso Lock >SQL ISAM F.E. >Id Stmt type Database Lvl Mode >ERR ERR Vers >100124 INSERT arcdb CR Not Wait 0 >0 9.03 > >Current statement name : inscur > >Current SQL statement : > INSERT INTO tdmsma608500 values(?,?,?,?,?)> >Last parsed SQL statement : > INSERT INTO tdmsma608500 values(?,?,?,?,?)> > > > >Any ideas why it is hanging? >Cheers, > >Howard > > _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus sending to informix-list

↪ replying to Tsutomu Ogiwara
Howard Jones — — source: Usenet: comp.databases.informix

Not a problem with logical-logs, filestore "Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> wrote in message news:buo9as$gge$1@terabinaries.xmission.com... > > Hi Howard. > > Logical log is full ? > Can you post output of onstat -l ? > > Regards. > > -- > Tsutomu Ogiwara from Tokyo Japan. > ICQ#:168106592 > > > > > >From: "Howard Jones" <howie_lfc@hotmail.com> > >Reply-To: "Howard Jones" <howie_lfc@hotmail.com> > >To: informix-list@iiug.org > >Subject: Problem loading data - 9.21.FC4 > >Date: Wed, 21 Jan 2004 10:04:10 -0000 > > > >Hello all, > > > >Informix Version 9.21.FC4 > >OS HPUX 11.0 > > > >I am attempting to load a bunch of tables into a new database using > >dbaccess. > >I am having problems with one particular table which appears to hang. > > > >I am guessing it has something to do with the "wait (netnorm)" which is > >output using onstat -g (session id) > > > >The output form onstat -g ses is as follows: > > > >Informix Dynamic Server 2000 Version 9.21.FC4 -- On-Line -- Up 2 days > >12:59:59 -- 4956180 Kbytes > > > >session > >#RSAM total used > >id user tty pid hostname > >threads memory memory > >100124 informix - 16732 sleepy 1 > >61440 56240 > > > >tid name rstcb flags > >curstk status > >100764 sqlexec c0000000c4845028 Y--P--- 33056 > >c0000000c4845028cond wait(netnorm) > > > >Memory pools count 1 > >name class addr > >totalsize freesize #allocfrag #freefrag > >100124 V c0000000c549c040 61440 > >5200 > >106 6 > > > >name free used name free > >used > >overhead 0 3256 scb 0 > >144 > >opentable 0 3608 filetable 0 > >1040 > >log 0 2168 temprec 0 > >1656 > >keys 0 176 ralloc 0 > >14728 > >gentcb 0 1720 ostcb 0 > >3416 > >sqscb 0 16880 sql 0 > >72 > >rdahead 0 256 hashfiletab 0 > >552 > >osenv 0 2536 sqtcb 0 > > 3144 > >fragman 0 888 > > > >Sess SQL Current Iso Lock > >SQL ISAM F.E. > >Id Stmt type Database Lvl Mode > >ERR ERR Vers > >100124 INSERT arcdb CR Not Wait 0 > >0 9.03 > > > >Current statement name : inscur > > > >Current SQL statement : > > INSERT INTO tdmsma608500 values(?,?,?,?,?)> > > >Last parsed SQL statement : > > INSERT INTO tdmsma608500 values(?,?,?,?,?)> > > > > > > > > >Any ideas why it is hanging? > >Cheers, > > > >Howard > > > > > > _________________________________________________________________ > MSN 8 with e-mail virus protection service: 2 months FREE* > http://join.msn.com/?page=features/virus > > sending to informix-list

Related threads

Glossary