problem(?) with OnLine dbimport
Posted in 1997
Topics: Migration, Import/Export & Data Conversion
Hi,
I'm doing a dbimport for a large OnLine database:
$ dbimport mydatabase -t /home3/importFile
the file "/home3/importFile" was created by running dd(1)
for the tape created by dbexport and looks quite good.
The proc dbimport consumes a lot of time and while examining
it with truss(1) I've just found that it is mostly playing with
a temp. file:
...
semop(1, 0x004AEF94, 1) = 0
unlink("/tmp/dbx21562_4") = 0
access("/tmp/dbx21562_4", 0) Err#2 ENOENT
open("/tmp/dbx21562_4", O_WRONLY|O_CREAT|O_TRUNC, 0666) = 6
fxstat(2, 6, 0x7FFFE49C) = 0
ioctl(6, TCGETA, 0x7FFFE44C) Err#25 ENOTTY
write(6, 0x004DE384, 0) = 0
write(6, "\\0FA85 H01 M8D -", 8) = 8
close(6) = 0
open("/tmp/dbx21562_4", O_RDONLY, 0644) = 6
semop(1, 0x7FFFE348, 1) = 0
read(6, "\\0FA85 H01 M8D -", 8) = 8
read(6, 0x004DD664, 0) = 0
close(6) = 0
semop(1, 0x7FFFE3A0, 1) = 0
semop(1, 0x004AEF94, 1) = 0
unlink("/tmp/dbx21562_4") = 0
access("/tmp/dbx21562_4", 0) Err#2 ENOENT
open("/tmp/dbx21562_4", O_WRONLY|O_CREAT|O_TRUNC, 0666) = 6
...
Is this a bug or a feature of dbimport? Thanks in advance for
any hint. This is with Informix OnLine 7.12 on SINIX 5.42 mips.
matthias
--
firm: matthias.apitz@sisis.de [voc:+49-89-61308-351, fax: +49-89-61308-188]
priv: guru@thias.muc.de
PGP: Key fingerprint = 0C 01 F2 23 EC 17 A2 D5 46 2D 29 4C 0E 8B 7E 8F