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
>