Re: SQL load or DBLOAD

In article <358FE083.29C9@bellsouth.net>, Carlson@WHSmith <carlson1@bellsouth.net> writes >Informix: 7.23.UC4 >OS: HPUX 10.01 > >I'm looking at a partial database reorg this weekend and started looking >at my reorg shell script. I need to shave a bit of time off this >process, as our data has grown considerably. Short of using the >High-Performance Loader (haven't had the opportunity to play with it >yet), which would be faster: > > load from "filename" > insert into table_name> In $ONCONFIG set TAPEDEV=/dev/null Do ontape -s -N <db name> which should take only a few seconds. i.e. knock off transaction logging first. In fact since you probably want to do a level 0 archive before the reorg hence you can knock off transaction logging AND take a level 0 archive at the same time. Just remember to enable transaction logging again afterwards.. >OR > > DBLOAD -d database -c configfile . . . etc . . > > >BTW: I've seen the new loader . . . but I haven't found a >character-based mode for setup. Is it there, or is it GUI only???? > > >TIA > > > >John Carlson >Informix DBA >WH Smith, Inc. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care