Continuous Delivery Automation

Expand all | Collapse all

Clarification on the DB2 Tablespaces

  • 1.  Clarification on the DB2 Tablespaces

    Posted 04-13-2017 10:43 PM
    In the documentation for Setting up DB2 Database, it states:
    Definition of tablespaces:
    Create tablespaces of page size 8, 16 and 32 KB.
    Issue:
    It has been confused that there are specific tablespace names to look for.  This is not the case.

    Solution:

    This statement has been modified to provide additional clarification:
    Definition of tablespaces:
    Create three tablespaces as follows:
    1 tablespace of page size 8 KB
    1 tablespace of page size 16 KB
    1 tablespace of page size 32 KB
    Therefore, the tablespace name does not matter as long as the page size are set as above and the user has the necessary rights to those tablespaces.



  • 2.  Re: Clarification on the DB2 Tablespaces

     
    Posted 04-09-2019 04:16 PM

    Hi,

    How many tables will be placed under each of the 3 tablespaces?

     

    It is a  little difficult to image that the tablespace names are not important. The database setup can find the right tablespaces itself.

    Thanks