(DB2 v9.5.1 ESE on AIX v6.1)
I have a table which is growing and it will reach max table size of 65,536MB soon (it's in SMS with 4K page). To solve the problem we want to
- create another BP with bigger page size (e.g. 32KB);
- increaze the page size of the TS to same page size and assign new BP (ALTER TABLESPACE ... BUFFERPOOL ...);

Can we do this?
If not, how can we do it with minimal outage (create new BP, new TS, move table...)?
Thanks in advance

Just by changing BP of the TBS your TBS will still be the same size. haven't tried it myself but seams logical.

I would do it as you said. New BP, new TBS, new TB with a new name. Load from cursor, build indexes, runstats, rename. if done online and original table received changes, grab those new changes and add them to a new table. This can be done by using triggers or other methods recently discussed here.

p.s. I suspect you do have an archival process? Maybe redesign this table using new functionality that allows you to break up portion of a table into a stand alone table.