Interesting. If it's AIX, then 150-200Gb was the V8 64 bit boundary for SMP
mixed workload P-series servers we were given by a top IBM consultant. But
that was a couple of years back. His explanation was that you were trading
parallelism against the overhead of inter-partition communication.
BCUs on X-series are said to be in the 300-500 Gb range.
I don't imagine there are any hard and fast answers, but an IBM site with
such architectural recommendations would be very useful. Perhaps it exists?
Anyone know of one?
Regards
Alex Levy
Sustainable Software Ltd
-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x54608345.[Email address protected]
Sent: 28 September 2006 23:55
To: LazyDBA Discussion
Subject: Re: Database size limit/best practice
in the version 8 and 32 bit instances, the number was around 300 GB or if
you hit the limits of tablespace sizes for a particular page size.
Now its more of when you start getting above 500GB and you need to scale on
more than one machine or need to lower load times or backup times and more
for a warehouse type of environment.
It still is a good idea to look at it for BI solutions and greater than
500 GB
"akhileshmittal"
<db2udbdba-ezmlms
hield-x44580359.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
09/28/2006 06:27
PM Subject
Database size limit/best practice
Hi All,
Is there any recommendations in terms of size of database for DB2 with
single partition database, ie say if you have more then x gb of data, you
should consider to go for partitioning feature.
Thanks in advance.
Regards,
--Akhilesh
************************************************************
HSBC Software Development (India) Pvt Ltd HSBC Center Riverside,West Avenue
,
25 B Kalyani Nagar Pune 411 006 INDIA
Telephone: +91 20 26683000
Fax: +91 20 26681030
************************************************************
-----------------------------------------
*******************************************************************
This e-mail is confidential. It may also be legally privileged.
If you are not the addressee you may not copy, forward, disclose or use any
part of it. If you have received this message in error, please delete it and
all copies from your system and notify the sender immediately by return
e-mail.
Internet communications cannot be guaranteed to be timely, secure, error or
virus-free. The sender does not accept liability for any errors or
omissions.
*******************************************************************
"SAVE PAPER - THINK BEFORE YOU PRINT!"
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------------
Scanned by 186k-NetCleanse, spam and virus protection
DB2 & UDB email list listserv db2-l LazyDBA home page