Re: Datawarehousing in Informix

Posted in 1998

Kai Shen — Mon, 02 Feb 1998 10:08:26 +0100 — source: Informix-list mailing list archive (1991-1998)

Bryan Allison wrote: > > We have been using Informix Online Dynamic Server for over a year on a = > Datawarehouse Project. Our fact table has approx. 350 million rows. We = > have been very pleased with Informix's parallel data query capabilities. = > =20 ... Dear Bryan, we are installing a Data Warehouse on Informix 7.20, SCO Unix, Acer 19000, 4 raw disks, 2 CPUs, 256 MB RAM. Can you give us a hint for the configuration of Informix and the Unix kernel? How do I set up the fact table for fragmentation across the disks (not within a disk), how do I use the HP loader? I really have no experience with PDQ, but assume I need to tune the parameters. Any help appreciated. TIA Kai