Set Partition Index, DPSI to the same DSSIZE as Tablespace when converting to RPN and ALTER TABLESPACE DSSIZE is after ALTER TABLESPACE PAGENUM RELATIVE

In numerous cases it is impossible to put the ALTER TABLESPACE DSSIZE in front of the ALTER TABLESPACE PAGENUM RELATIVE due to the number of partitions and page size. Currently this only works with the following. After the reorg materialization the TS, IX will be 32G.

ALTER TABLESPACE DSSIZE 32G;

ALTER TABLESPACE PAGENUM RELATIVE;

Doing it in reverse leaves the indexes with the same DSSIZE as before the change. A subsequent ALTER INDEX needs to be done after the REORG.

ALTER TABLESPACE PAGENUM RELATIVE;

ALTER TABLESPACE DSSIZE 32G;

DB2 should not care about the sequence and the DSSIZE of the index in this case should be the same in both cases.

DSSIZE value	4K page size	8K page size	16K page size	32K page size
1 G - 4 G	4096	4096	4096	4096
8 G	2048	4096	4096	4096
16 G	1024	2048	4096	4096
32 G	512	1024	2048	4096
64 G	254	512	1024	2048
128 G	128	256	512	1024
256 G	64	128	256	512

Needed By

Quarter

Post comment

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.

Please enter your email address

RELATED IDEAS

Set Partition Index, DPSI to the same DSSIZE as Tablespace when converting to RPN and ALTER TABLESPACE DSSIZE is after ALTER TABLESPACE PAGENUM RELATIVE