Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Unanswered: Automatic Storage For Tablespaces

    I have a following tablespace definition

    CREATE REGULAR TABLESPACE TSP1 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY AUTOMATIC STORAGE
    AUTORESIZE NO

    What kind of tablespace be created in the above situation.
    Will it be SMS or DMS ?
    Will this be a automatic storage tablespace ?

    Thx ahead
    Koganti

  2. #2
    Join Date
    Jun 2007
    Posts
    12
    it should be DMS tablespace....

    there is not type of tablespace, called auto storage
    but only db2 allows u a mechanism to make u'r DMS tablespace to be automatic storage.

    and well to make things clear for u'r statement

    1. u cannot specify autoresize option for an autostorage DMS tablespace
    by default it is set to YES

    2. U can explicitly specify for your tablespaces to be autostorage only while
    creating a database.

    3. and once u made your tablespaces to be autostorage DMS there is no other
    way that u can disable autostorage.

  3. #3
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    What if you dont want the tablespace to grow any further.

  4. #4
    Join Date
    Jun 2007
    Posts
    12
    Once your database has been set up for automatic storage, the db2 takes care of storage management like specifying paths to the containers and also the space management for the contaiers.

    Once you created your database using automatic storage you can make it grow or shrink as follows....

    you can create a table space and specify its initial size and growth characteristics, as follows:

    db2 create tablespace ts_name
    initialsize 10M
    increasesize 10M
    maxsize 100M

    here the max size limits the tablespace to grow any further beyond 100MB

Posting Permissions

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