var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Partitioned TS creation & ReORG
I need to create a table..which will have insertion till next 1 year..no deletion.. daily it will have 1 k records inserted..
LEV_NR DECIMAL(13 , 0)
INCOMMIT_VAG DECIMAL(3 , 0)
STORE_ID DECIMAL(8 , 0)
RES_TIME DECIMAL(12 , 0)
1)how much i need to give for PRIMARy & sec quantity?
2) i am planning to make partitioned tablespace. But how many partitions i need to create?
3)It will be weekly REorged ,in this case how reorg will work?
DB2 VERSION : V8R1M0
Thanks in advance...
why would you need a weekly reorg? It being a history table, one would think that all of your data will be inserted at the end and there would not be any updates. As far as number of partitions that is all based on how many rows you want to see in a partition and how much data you expect the table to have and then its future growth into the partition scheme.
thanks for the response.
MSG_FLG n updt_timestamp fields of new records will be updated daily. .
i dont hav more idea on partitions. .
plz help me how much i need give for PRI n SEC qty.
thnq n iRegards
Is there any formula to calculate PRI & SEC allocations for a tablespace?
Do we have any answer for this question?