Re: Problem loading data - 9.21.FC4
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