You may consider placing this table on 16K or 32 K page size dms, but
again you may need to partition the same as max for 32 k 512 GB.
Also you may consider logical partioning of this table , that is create
multiple tables and use unian all view to acess the data..but there are
limitations for dmls.






"Vijesh K Solomon "
<db2udbdba-ezmlmshield-x41388063.[Email address protected]
06/17/05 11:30 AM


To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: DB2 Capacity Planning Doubt

Hello All,

I've followed a method to estimate the size of a DMS tablespace as
suggested by an article in DB2 Magazine (
http://www.db2mag.com/story/showArticle.jhtml?articleID=172302427). But
I've a doubt when I estimated as such for a table in my database.

I considered a table named ORDER_HISTORY the estimated max row count is
26564500000 and the avg row length of the same is 85(this I got as
sum(AVGCOLLEN) from SYSCAT.COLUMNS for that particular table). Also I'm
using a 4K tablespace to hold this particular table.

Now according to the forumla given in the article the estimated size of
this particular table space is
=> 26564500000 * 85
=> 2257982500000 bytes
=> Roughly 2102 GBs.

But I understand that if I use a 4K tablespace the maximum size of a
regular tablespace is just 64 GB. So can you please let me know how to
proceed regarding this.

Please give me your suggestion whether I need to partition this table in
this regard.

Thanks,
Vij


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do not accept liability for damage caused by this email and may monitor email traffic.


DB2 & UDB email list listserv db2-l LazyDBA home page