Results 1 to 2 of 2
  1. #1
    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 advance
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    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 v9.7.0.6 os

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts