Re: DBEXPORT 6.0

In <33fge6$qb1@nanette.pdb.sni.de>, Tom Hogarty <bumidev.pad@sni.de> writes: > >>> >>> 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> My database is R3 as well and it is large enough that you would expect it to run a very long time. There is a lot of blob and a huge number of tables. Think about increasing the memory for buffers. That is the only hope, I think. Just use onarchive and logical volumes to make the database portable. Good luck.