Re: Slow dbimport

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