Thread: change TS (SMS) page size?
06-08-09, 12:32 #1Registered User
- Join Date
- Dec 2008
- Toronto, Canada
Unanswered: change TS (SMS) page size?
(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 advanceDB2 9.5/9.7 on Unix/AIX 6.1/Linux
06-08-09, 14:20 #2Registered User
- Join Date
- Nov 2005
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.--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
DB2 v220.127.116.11 os 18.104.22.168