Re: Slow dbimport

May be it's a stupid question, but just to check: are you using the -l or -ansi options with dbimport ? If yes - import the database wihtout this options, and then change the database logging using ontape. Kind Regards, Octav On Thu, Mar 04, 1999 at 01:19:22PM -0500, Steve Romankiw wrote: > The dbimport will generally take longer to run. Keep in mind what is going on > - loading tables, creating indexes, and updating statistics. You can get some > performance improvements if your fiddle around with PSORT_NPROCS, > PSORT_MAXALLOC, and turn on PDQ to get benefits of parallelism. > > HTH, > > Steve Romankiw > > Wim Van Poelvoorde wrote: > > > Hello, > > > > I have a DBEXPORT on tape which I try to import in our Informix dbase > > (Version 7.23 UC6). The export lasted 2 hours. The import however, is now > > already running for about 3 hours and is still busy. > > > > When I investigate the running dbimport process (with the truss command) I > > notice that 99 procent of the time the process is executing the semop() > > system call ( semop(5601, 0x........., 1) = 0 ). > > Sometimes I see: semop(5601, 0x....., 1) (sleeping ...). And every now and > > then I see the read() system call ( read(5, ".......", 65536) = 65536 ). > > This means, I think, the dbimport is not hanging , but is running and > > working, but the question is why does it import so slowly ? The import will > > finish succesfully after me waiting for a couple of days, probably :-( > > > > I only see a dbimport process, no sqlrm processes, is that normal ? > > > > Can anyone help me with this ASAP please ? > > > > thanks, > > > > Wim Van Poelvoorde > > ISG Consultant > > UNISYS Belgium > -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com