Performance Question - Loading of Database and LTAPEDEV

Posted in 2007

Topics: Performance & Tuning, Server Administration, Triggers, Constraints & Referential Integrity, Platform-Specific Issues

cpeek@hcso.tampa.fl.us — Mon, 30 Jul 2007 16:26:43 -0700 — source: Usenet: comp.databases.informix

I have a question regarding LTAPEDEV being set to /dev/null and performance, and will not have a chance to test until tomorrow. During a mass load process, will having LTAPEDEV set to /dev/null increase performance significantly over having LTAPEDEV go to a disk file backup triggered using ALARMPROGRAM set to the standard log_full.sh script? I would in no way leave this setting in a production, but we are seeing a significant difference between a high end pSeries server (4 processor, 8GB) and a low end Linux server (1 processor, 1GB) with similar onconfigs. The one setting that stands out is LTAPEDEV being set to /dev/null.

↪ replying to cpeek@hcso.tampa.fl.us

Obnoxio The Clown — Tue, 31 Jul 2007 00:43:32 +0100 (BST) — source: Usenet: comp.databases.informix

cpeek@hcso.tampa.fl.us said: > I have a question regarding LTAPEDEV being set to /dev/null and > performance, and will not have a chance to test until tomorrow. > > During a mass load process, will having LTAPEDEV set to /dev/null > increase performance significantly over having LTAPEDEV go to a disk > file backup triggered using ALARMPROGRAM set to the standard > log_full.sh script? Yes. -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo "Cluster in my trousers" -- Guy Bowerman -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

Glossary

onconfig