Slow dbimport

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

dbimport will take much longer than an export. By a factor of 5-10 maybe. All export has to do is read the data and output it. By comparison, the import must load the data, sort it an a temp area and build each index. Do an onstat -g ses on the import's user table entry to see how far it's got. Neil Truby Londis Holdings Hampton Hill, UK Wim Van Poelvoorde wrote in message <7bm13i$m6r$1@mail.pl.unisys.com>... >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 > >