RE: DBIMPORT HANGS
Thanks for the hint, but it was not dued to full l;ogical logs. Recently
we found the
problem in de Informix documentation.
We als have a BLOB space in our database, and when you create a BLOB
space,
before you can start inserting data into that BLOB-space, you have to
switch to the next logical log
by executing the command:
onmode -l (or tbmode -l in earlier versions)
Informix want de creation of a BLOB space and the insertion of BLOBS in
that BLOB space
in seperate logical logs, otherwise he won't continue.
So, finally we found it, and hopefully this info is of any interest for
you guys too !
see you,
Wim Van Poelvoorde
> -----Oorspronkelijk bericht-----
> Van: mosserp@WellsFargo.COM [SMTP:mosserp@WellsFargo.COM]
> Verzonden: dinsdag 19 januari 1999 21:48
> Aan: Wim.Van.Poelvoorde@argo.be
> CC: informix-list@iiug.org
> Onderwerp: RE: DBIMPORT HANGS
>
> Sounds like your logical logs are filling up. Do you have logging
> turned
> on? You may want to consider turning it off for the import. But be
> sure to
> do a REAL level 0 *before* and *after* the import, and don't forget to
> turn
> logging back on afterwards. BTW, even with logging off, you will get
> *some*
> activity with the logical logs, so be sure to keep an eye on them.
>
> HTH
> ================================
> Paul Mosser, Open Systems DBA
> Wells Fargo & Co.
> paul.mosser@wellsfargo.com
> ================================
>
>
> > -----Original Message-----
> > From: Wim.Van.Poelvoorde@argo.be [mailto:Wim.Van.Poelvoorde@argo.be]
> > Sent: Monday, January 18, 1999 5:20 AM
> > To: informix-list@iiug.org
> > Subject: DBIMPORT HANGS
> >
> >
> > Hy,
> >
> > On our UNIX server we exported our Informix OnLine 5.0
> > database, dropped
> > the database and recreated it (severe tablespace including one
> BLOB).
> > Now we try to perform a dbimport and notice that the dbimport
> command
> > hangs after a while (about 10 min.) and always during the
> > import of one
> > specific table (always that same table).
> > There are no erros nor warning mentioned, the dbimport command
> simply
> > hangs and does nothing else (no disk activity anymore). We
> > also noticed
> > that an SQL-proces (sqlturbo) is running, and via the truss command
> we
> > see this command is
> > doing nothing:
> > read(0, ....) (sleeping)
> >
> > What is going on here. Anyone experienced this problem before ?
> >
> >
> > Thanks,
> >
> > Wim Van Poelvoorde
> > ISG Consultant
> > Unisys Belgium
> >