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

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