David, Appendix A, Table 32 of the DB2 UDB SQL Reference Volume 1 at ftp://ftp.software.ibm.com/ps/products/db2/info/vr82/pdf/en_US/db2s1e81.pdf
contains the DB2 database manager limitations. They are mostly architectural limitations which are quite generous. Basically you are limited to the size of a filesystem that can be configured. According to the Linux for zSeries Device Drivers manual 262,144 disk devices can be attached, so that is hardly an issue. David Kreuter wrote:
I had an interesting meeting today concerning a possible project moving some existing DB/2 data on servers and z/os to linux DB/2 under good ole z/vm. Someone on the project was told that linux on db/2 had a 450Gigabyte limitation with the size of a database, or tables, or ... This makes little or no sense to me ( 450Gigabyte isn't all that big really). Also there are 1,000 tables scattered around 100+ databases. Hey - I am not the architect here. Is anyone out there running linux DB/2 with aggregate sized DBs exceeding 450G? Anyone aware of limits running DB/2 on linux under z/VM? Thanks, David ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
-- Rich Smrcina VM Assist, Inc. Main: (262)392-2026 Cell: (414)491-6001 Ans Service: (360)715-2467 rich.smrcina at vmassist.com Catch the WAVV! http://www.wavv.org WAVV 2006 - Chattanooga, TN - April 7-11, 2006 ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
