Re: IDS 7.30 on Linux Tuning Benchmark?

> It would be better to get a high-performance loader ported, so we could > avoid the buffer problem altogether. This would eliminate having to chop up > load files. Unless of course I'm missing something, I can't load large loads > without incurring long transactions. Obvious question alert: Can you temporarily turn off logging? I know there are reasons why this may not be an option, but if you CAN turn it off, you'll have no long transaction problem. Mark Collins mcollins@us.dhl.com Originality is the art of concealing your sources.

Mark Collins wrote: > > > It would be better to get a high-performance loader ported, so we could > > avoid the buffer problem altogether. This would eliminate having to chop up > > load files. Unless of course I'm missing something, I can't load large loads > > without incurring long transactions. > > Obvious question alert: Can you temporarily turn off logging? I know there are > reasons why this may not be an option, but if you CAN turn it off, you'll have no > long transaction problem. > Yes. Point you tape device to /dev/null and ontape -s -L -N database_name turns you database into a non-logged db. Swap the N for U to get unbuffered logging, B for buffered logging or A for ANSI logging. Dominic -- Dominic Binks/Systems Engineer/Logica-Aldiscon 400 Park Avenue/Aztec West/Bristol/BS32 4TR/United Kingdom Tel: +44 1454 614455/Fax: +44 1454 620527/Mobile: +44 498 693964 E-mail: dominic.binks@aethos.co.uk

Dominic Binks wrote: > > Mark Collins wrote: > > > > > It would be better to get a high-performance loader ported, so we could > > > avoid the buffer problem altogether. This would eliminate having to chop up > > > load files. Unless of course I'm missing something, I can't load large loads > > > without incurring long transactions. > > > > Obvious question alert: Can you temporarily turn off logging? I know there are > > reasons why this may not be an option, but if you CAN turn it off, you'll have no > > long transaction problem. > > > Yes. Point you tape device to /dev/null and ontape -s -L -N > database_name turns you database into a non-logged db. Swap the N for U > to get unbuffered logging, B for buffered logging or A for ANSI logging. > > Dominic > Very cool. I've been over in XPS too long. The high-performance loader does this automagically... and there's no ontape for XPS just <gasp> onfubar... Thanks to all... meanwhile back to the salt mine... :-) Tim > -- > Dominic Binks/Systems Engineer/Logica-Aldiscon > 400 Park Avenue/Aztec West/Bristol/BS32 4TR/United Kingdom > Tel: +44 1454 614455/Fax: +44 1454 620527/Mobile: +44 498 693964 > E-mail: dominic.binks@aethos.co.uk -- - -- --- Tim Schaefer ---- tschaefe@mindspring.com --- http://www.inxutil.com -- -