Skip to Content
avatar image
Former Member

How DB2 will create container If tablespace is full.

Hi Experts,

If any tablespace used 100% and in SAPDATA1,2,3 and 4 it shows 8% is free,how I can increase the Size of tablespace, automatic storage is enble in DB2.

How DB2 will create container If tablespace is full.

Kindly help me.

Regards,

Abullais

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 16, 2008 at 07:54 AM

    Hi,

    when you have automatic storage enabled, DB2 manages the extention of tablespaces autonomically, and you do not have to take care of that. When DB2 required more space within that tablespace, it automatically increases the tablespace. The only thing you should be aware is, that you need to have space available on your file system, where sapdata1,2,3,4 are located. Because DB2 is not able to add space if no freespace on disk is available.

    When you do not have freespace on your filesystem any more, ou should add another disk to the filesystem. If this is not possible you can add additional autostorage paths.

    kind regards

    Thomas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2008 at 07:55 AM

    /ok, this message was answered 10 sec. earlier 😊

    Hello,

    with automatic storage you do not have to create or resize containers manually: when the amount of data grows close to the tablespace limit, the tablespace will be extended automatically by DB2. (as long as you have free disk space on your storage system)

    Therefore, it is normal that the tablespace usage shows only 8% free - it is so because of the optimal disk space usage by DB2. If you load more data into your tablespace, it will be extended.

    Kind regards,

    Sergiy Malikov.

    Edited by: Sergiy Malikov on Oct 16, 2008 9:55 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2008 at 10:17 AM

    hi Abullais,

    Check the type of storage management you have. If it is automatic storage management then it will be taken care by db2 itslef. You just need to add new storage (a new filesystem say sapdata5). You cannot add you own conatiners here.

    as db2<sid> user execute the following to add new storage

    db2 ALTER DATABASE ADD STORAGE ON '<sapdata5_storage_path>' ;

    If it is manual management then you have to add new containers to increase the tablespace.

    you can add new containers using DBACOCKPIT t-code.

    DBACOCKPIT -> Spaces -> conatiners -> add -> execute

    Regards,

    chandru.

    Add comment
    10|10000 characters needed characters exceeded