Re: Problem loading data - 9.21.FC4

HPL is NOT necessarily a good suggestion in this case, as there is a bug in 9.21FC4 that makes HPL unloads abnormally slow. -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "Richard Kofler" <richard.kofler@chello.at> wrote in message news:40124613.F42879FA@chello.at... > Howard Jones wrote: > > > > 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 > > there are better alternatives than using > INSERT INTO. > > Look into the migration guide on the docs web pages > and use dbload instead > > Or, better and much faster if you have more than 5 records to > put into your database: use the HPL > It is very well documented in the HPL users giude on the very same > ifx docs web page, which you have an etry to using this link > http://www.k7.com/getID.pl?id=927059375538619&x=1166&re=2 > > If you must or wanna stick to the INSERT INTO method, then > read the adminguide and monitor your logical log activity > using onstat -l. If you do *any* type of logging, you > simply have a good chance to run into troubles, if you > don't. Also watch out for long transaction rollbacks, which > you will find in the log file. You can check where that > thingies sits using onstat -m, which does not only > show you some of the last lines in that file, but also > tells you the path & filename, ready to cut & paste that > into your > view + <this-is-the-log-file-I-want-to-see-now> > command line > If you are on (Win)DOS od any type, I cannot help, though > > good luck > -- > Richard Kofler > SOLID STATE EDV > Dienstleistungen GmbH > Vienna/Austria/Europe