Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: page size for tablespaces to create tables!!!!!

    Good afternoon,
    I have several tables 150 and 300 million records and nose to assign page size tablespaces where I will create the tables and then do the load (eg 4K, 8K, 16K or 32K) my system is a decision support (not transactional)

    I have AIX 5.3 and DB2 V8.

    thank you very much and best regards.
    DBA DB2 for LUW

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    It's a very general question and the correct answer would be "it depends", but decision support systems frequently benefit from larger page sizes!!!!!
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    There is some guidance about the tablespaces page size?
    If I create the table in a 32K tablespace, indexes must also be a 32K tablespaces?

    thank you very much and best regards.
    DBA DB2 for LUW

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by georgipa View Post
    There is some guidance about the tablespaces page size?
    https://www.ibm.com/developerworks/m...2-22a73685871c

    Quote Originally Posted by georgipa View Post
    If I create the table in a 32K tablespace, indexes must also be a 32K tablespaces?
    No.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by georgipa View Post
    There is some guidance about the tablespaces page size?
    If I create the table in a 32K tablespace, indexes must also be a 32K tablespaces?

    thank you very much and best regards.
    No. You can create a table in a 16k tablespace with its LOB's in a 32K tablespace and indexes in a 4K tablespace.... if you wish
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Posting Permissions

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