DBEXPORT 6.0

>> >> I am trying to export a Online 6.0 database using dbexport >> and it is taking upwards to around 21 hours to run. Listed >> below is the syntax I am using. Any help would great. This >> database is working in conjunction with SAP R/3 2.1D Informix >> Online Engine 6.00 >> >> dbexport -c -d -ss -t /dev/rmt/1hc -b 256 -s 2097151 -f \\ >> /tmp/tst.imp tst>> >> Watch the log of the .out file in the Informix home directory, >> indicates that everything seems to be running fine. >> >> Thanks in advance >> Bill Hankard >> hankard@wellfleet.com Hello Hank, I've just completed a limited test on the dbexport command and am pleased to say that it runs well, granted my test database is relatively small and I just happen to have a zippy rm400 machine to myself at the moment but, that said, it compares well at first glimpse with its predecessor. Oh BTW I don't have any BLOBS in the db and that may be a consideration. If you can include the -q option which suppresses the display of messages, warnings and generated sql statements you will definitely save some overhead but unless your database is >5 Gigabytes it seems you definitely have a problem somewhere I would suggest that you look closely at the BLOB characteristics and then see how your Unix system resources are being hit. It would be interesting to know your hardware platform and size of database here too. Hope This Helps Tom Hogarty Standard Disclaimers Apply SNI Paderborn Germany Tel +494-52518-11602 +494-5254-65553($HOME) mail <bumidev.pad@sni.de>