Results 1 to 8 of 8
  1. #1
    Join Date
    May 2002
    Posts
    20

    Unanswered: Tablespace limit

    Hello there!
    I have a tablespace with 4k page size, with hundreds of tables. The
    tablespace currenlty is 60Gb of total size. It is DMS.

    Now I want to increase that size to 80Gb and I have the 64Gb
    limitation! How can I change the tablespace to a different page size,
    lets say 8k page size (i think there is a 128Gb limitation).

    The problem is that I have lots of tables (thousands) in that tablespace. Could anyone indicate me a process of how to change the page size, without loosing data of course. I cannot move them one by one.

    Configuration:
    AIX 4.3.3
    DB2 UDB V7.2 Fixpak 6 (SAP R/3 system - SEM)

    Thank you.
    Demetris

  2. #2
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi,

    I don't think you can change the page size of the same tablespcae in Db2 where the tablespace is a DMS tablespace.

    But the other way will be to create a database and have a new bufferpool and tablespace of the required pagesize 8k. Create the tables in this database tablespace and then export and import data.

    -Prashant
    Prashant

  3. #3
    Join Date
    Jan 2003
    Posts
    2

    Re: Tablespace limit

    Originally posted by demisco
    Hello there!
    I have a tablespace with 4k page size, with hundreds of tables. The
    tablespace currenlty is 60Gb of total size. It is DMS.

    Now I want to increase that size to 80Gb and I have the 64Gb
    limitation! How can I change the tablespace to a different page size,
    lets say 8k page size (i think there is a 128Gb limitation).

    The problem is that I have lots of tables (thousands) in that tablespace. Could anyone indicate me a process of how to change the page size, without loosing data of course. I cannot move them one by one.

    Configuration:
    AIX 4.3.3
    DB2 UDB V7.2 Fixpak 6 (SAP R/3 system - SEM)

    Thank you.
    Demetris
    Demetris,

    I think you will still have the 64Gb limit even if you go to 8k pages. It is my understanding that you will not be able to go above 64Gb until v8.

    I have ran into the same problem with PSAPBTABD and we created new table spaces and performed table moves from PSAPBTABD to the new table to help with this. I think SAP has the procedure in oss.

    FXST

  4. #4
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: Tablespace limit

    each page size has its own limit, they are as follows:

    4k 64 gig
    8 128 gig
    16 256 gig
    32 512 gig

    If you are using EEE, you can partion the database and those above limits would apply to each partion. so you could have 4 partions, 1 tablespace that could have a limit of 256 gig limit total between them

  5. #5
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Do a REDIRECTED RESTORE

    Take the Backup of Tablespace and then do a redirected restore with new tablespace with increased tablespace page size

    --Prasad

  6. #6
    Join Date
    Dec 2002
    Posts
    134

    Re: Do a REDIRECTED RESTORE

    Originally posted by koganti
    Take the Backup of Tablespace and then do a redirected restore with new tablespace with increased tablespace page size
    I do not think redirect restore allows changing page size
    And I do not think changing page size is a good desicion, for the tables with small row size you will loose a lot of space (in db2 255 rows pre pare is alowed)

    Can you create multiple tablespaces? And put some tables into the new tablespace. You can use export/load to move data into the new tablespace

    I think you should spend some time and decide what tables to put in what tablespaces

    It's rather strange to have 1 tablespace for 64Gb db.

    regards,
    dmitri

  7. #7
    Join Date
    Dec 2002
    Posts
    134

    Re: Do a REDIRECTED RESTORE

    One more thing if it's must have requirement for 1 tablespace only, use db2move

  8. #8
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Do a REDIRECTED RESTORE

    You should consider using different tablespace for indexes and long objects, if any ...

    If your table is large, you can consider UNION ALL Views

    http://www7b.boulder.ibm.com/dmdd/li...202zuzarte.pdf

    http://www7b.boulder.ibm.com/dmdd/li...209rielau.html

    HTH

    Cheers

    Sathyaram

Posting Permissions

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