Re: Just scratching my head...
davidegrove@gmail.com wrote:
> On Oct 31, 8:19 am, "Neil Truby" <neil.tr...@ardenta.com> wrote:
>> Could it be this?: we had a PMR, 52108,019,866, where dbimport failed on IDS
>> 11.5. The Tech Support analysis was that it was a known problem and that
>> the dbimport SQL "be split the script in different blocks for example 8000
>> rows then execute the first block then force IDS to remove the session
>> control block to clean all the memory so just close the dbaccess and then
>> start an new dbaccess that will execute the next block and so on".
>>
>> This was in fact effective but the customer preferred to go with version 10
>> instead.
>>
>> It's said to be fixed in 11.5xC2.
>
>
> VERY INTERESTING. Could be. Certainly sounds very like it. I think
> we don't see the problem with a small instance (say only a few hundred
> MB).
>
> But, we were experiencing it back with 9.4. Maybe even 9.21. Don't
> really recall, we've been on 10.0 for a long time. (Point is it has
> been defective for years.) Anyway, we are planning to go to 11.5
> before end of year.
>
> DG
>
I don't agree with the statement that "it's been defective for years".
The fact is, there were several bugs with dbexport/dbimport. But I keep using
it successfully (for small instances, because it's a slow process).
Last time a customer complained to me about a dbimport issue we nailed it down
to a firewall cutting the session. Before that another situation I recall had
to do with a table corruption (the unload file didn't have the rows written in
the export .sql file).
Anyway, you showed your impression about the tool. It is caused by your
experience and nobody can deny that...
I hope everything works fine for your forthcoming migration. By the way, xC3 is
out (today). It has some nice and some intriguing features :)
Regards.
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
"Fernando Nunes" <domusonline@gmail.com> wrote in message news:geg1h4$so1>
> I don't agree with the statement that "it's been defective for years".
> The fact is, there were several bugs with dbexport/dbimport. But I keep
> using it successfully (for small instances, because it's a slow process).
>
This is where we have to respectfully part company.
We have been experiencing the defects in dbimport/dbexport for many years.
Until recently we were moving between servers on our side of the firewall.
In fact, on the same subnet. Over the years, we have repeatedly and
reliably produced and reproduced the errors. IBM admitted to us in an
official tech support case that there were problems with dbimport/dbexport
that they did not fully understand. We have a copy of the IBM bug report on
it. Other users, on this very newsgroup, also indicated familiarity with
the problem when I posted on it years ago. At that time, IBM told us they
would be fixing it in the "next release". The current manifestation is
nothing new. It is the same old symptoms we have experienced for years. We
have absolutely no table corruption. We have no firewall issue. dbimport
just fails to run to completeion (it reports an error and terminates). The
very same SQL, using dbaccess, runs successfully (to completion).
Let me mention again that I am an enthusiastic supporter of Informix.
I just wish IBM would fix the problem.
DG
>... By the way, xC3 is out (today). It has some nice and some intriguing features :) ... Nice to know... but where is it ? I didn't found on passport advantage ... J. PD: I am intrigued by the intriguing features :) 2008/10/31 Fernando Nunes <domusonline@gmail.com> > ...Regards. > > -- > Fernando Nunes > Portugal >
Jean Sagi wrote: > >... By the way, xC3 is out (today). It has some nice and some > intriguing features :) ... > > Nice to know... but where is it ? I didn't found on passport advantage ... > > > J. > > PD: I am intrigued by the intriguing features :) > > 2008/10/31 Fernando Nunes <domusonline@gmail.com > <mailto:domusonline@gmail.com>> > > ...Regards. > > -- > Fernando Nunes > Portugal > > It's on FixCentral. It may take a few days to get to PA. But if you have support you can get it from FixCentral. Don't be so "intrigued". I was thinking about the change data capture API. I suppose it's intended for third party tools... Regards -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...