Question about tablespace design

[Michel Esber]

Hi all,

DB2 LUW v8 FP15

Is there any performance overhead if a table is created on data and
index tablespaces with different page sizes ?
What kind of penalty is expected ?

Sample Layout:

BufferPool A (pagesize 16K) -Tablespace A (pagesize 16k)
BufferPool B (pagesize 8K) -Tablespace B (pagesize 8k)

create Table a ( several fields ) in A index in B;

Thanks in advance, Michel.

[Mark A]

Re: Question about tablespace design

"Michel Esber" <michel@us.auto matos.comwrote in message
news:5da03187-b4b6-4604-84e1-8c6bf087eda3@m3 g2000hsc.google groups.com...

Hi all,
>
DB2 LUW v8 FP15
>
Is there any performance overhead if a table is created on data and
index tablespaces with different page sizes ?
What kind of penalty is expected ?
>
Sample Layout:
>
BufferPool A (pagesize 16K) -Tablespace A (pagesize 16k)
BufferPool B (pagesize 8K) -Tablespace B (pagesize 8k)
>
create Table a ( several fields ) in A index in B;
>
Thanks in advance, Michel.

There is no absolutely no performance penalty in using different page sizes
for the table and indexes.

The most important factor is that the page size:

1. Is appropriate for the row size,
2. Is appropriate for the type of application (use smaller page size for
OLTP and larger page size for data warehouses), and
3. The tablespace is assigned to a bufferpool with a sufficient number of
pages to keep the bufferpool hit ratio high.