RE: bad isam file format
hi.
I've just read about your problem.
Quick thought.
The database that you are importing.
Does it have any tables that contain for than one FLOAT field. ??
If so, do 2 or more of those fields contain nulls ??
I'm not sure about this but I vaguely remember a problem I had a while ago
where I had
a similar message during an import. The cause was I think that there was a
bug in informix
which gave this error if any table had more that one float field and that
these fields contained nulls.
Might be worth a quick look before you look too closely at your
configuration.
Many Regards
Rekaish
-----Original Message-----
From: Burkhard.=?iso-8859-1?Q?Oberg=F6ker?=@iiug.org
[mailto:Burkhard.=?iso-8859-1?Q?Oberg=F6ker?=@iiug.org]
Sent: Wednesday, October 13, 1999 10:02 AM
To: informix-list@iiug.org
Subject: Re: bad isam file format
"Art S. Kagel" schrieb:
>
> What import tools are you using? Sounds like dbimport, but that message:
> "*** execute sqlobj" is not familiar?!?
>
Right. I's dbimport. In detail is was this statement:
dbimport -i /opt/mbs/export -d data01 mbs
Meantime I changed various parameters in the onconfig file but without
efford. The problem appeard on different positions of the import so I
guess it's not a failure of the exported data.
Here are the important (I think) parameters of onconfig:
LOCKS 20000
BUFFERS 6000
NUMAIOVPS
PHYSBUFF 32
LOGBUFF 32LOGSMAX 200
CLEANERS 8
SHMBASE 0x10000000L
SHMVIRTSIZE 30000
SHMADD 8192
SHMTOTAL 0
CKPTINTVL 300
LRUS 8
LRU_MAX_DIRTY 60
LRU_MIN_DIRTY 50
LTXHWM 50
LTXEHWM 60
TXTIMEOUT 300
STACKSIZE 32
bye
Burkhard