[wplug] DB2 on Linux

[Petrucci, Joseph]

Keir

In udb/db2 the ratio of containers to raw partician (equal to datafiles in Oracle) is one to one not the ration of tablespace to raw. I believe it is the same for oracle. But you have a very valid point a db2 database of 7 Terabytes with only 255 containers would perform poorly to say the least. Thanks for poining that out I forgot about the device limit. But if there is a significant performance increase in say writing to large clustered tables, or large reads there may be an advantage to having some of my tablespaces on raw and some on file system.

Joe

-----Original Message-----
From: wplug-bounces+joseph.petrucci=ddiworld.com at wplug.org
[mailto:wplug-bounces+joseph.petrucci=ddiworld.com at wplug.org]On Behalf
Of Keir Josephson
Sent: Wednesday, April 13, 2005 11:49 AM
To: General user list
Subject: Re: [wplug] DB2 on Linux


Well, I haven't specifically booted linux from a SAN-based drive, but I'm
pretty sure that either GRUB or LILO supports it. As for raw versus file
systems, if the tablespace to raw device ratio has to be 1-1 (as is the
case with Oracle) you should check to see if the database will require
more than 250 tablespaces. I believe Linux has a ceiling of 255 raw
devices.

-Keir

> I am designing an implementation of DB2/UDB 8.1 (parallel) on Linux
> (fedora core 3) and Veritas Cluster server on Dell machines with an EMC
> Storage array for one of my clients. This will be a several Terabyte
> database for telecomm applications. The application servers will also be
> running on the same type equipment and Linux environment but will be in a
> WebSphere cluster instead of VCS. Can anyone point me in the proper
> direction for information on the following.
>
> 1.. booting Linux from a SAN. (Altboot to internal drives)
> 2.. Raw patricians verses file systems for UDB/DB2 databases on Linux
> 3.. Load balancing across a Linux (VCS) cluster.
>
> Thanks
> Joe
>
>
> _______________________________________________
> wplug mailing list
> wplug at wplug.org
> http://www.wplug.org/mailman/listinfo/wplug
>

_______________________________________________
wplug mailing list
wplug at wplug.org
http://www.wplug.org/mailman/listinfo/wplug