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