Windows UDB Question

Gerrit Groenendaal

Windows UDB Question
I forgot the the subject and of course it must be UDB 8.1


At the moment we have a Data warehouse on Windows with UDB 8.1. Now the warehouse will expand to 1Tb for the 7 fact tables (that is the data only, without the indexes).

The questions are:

§ Is Windows the right platform, or must we go for UNIX or Linux? The load for the 7 tables is 11 GB average, to a maximum of 40 GB a day before it is transferred to a star schema. The record size is 1K

§ What is the maximum size for a Windows environment?

§ Has anyone experiences with Z/VM and Linux partitions?



Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at