Re: Problem loading data - 9.21.FC4
When you say "appears to hang" what exactly do you mean? What happens
next? Has it actually hung or is it just doing its thing but very
slowly?
A couple of of-the-top-of-head theories:
- Logical logs filling up (I know you've discounted this but check
again), possibly causing long transaction rollback; rollbacks can be
VERY slow. What are your values of LTXHWM and LTXEHWM? Is the system
useable after whatever you do to get rid of the "hang"?
- Getting held at the Memory Grant Manager gate - do an onstat -g mgm
and see if it's getting stuck in the "Ready" queue;
- It's running but just very slowly. Do an onstat -u while it appears
to be hanging. What do the flags tell you it's doing? Are the reads
and writes incrementing or is it genuinely stuck? What checkpoint
durations does onstat -m show?
Andy
"Howard Jones" <howie_lfc@hotmail.com> wrote in message news:<Q9sPb.21905$OA3.6983796@newsfep2-win.server.ntli.net>...
> 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