How DB2 will create container If tablespace is full.

[Former Member]

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

[former_member105207]

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.

[Former Member]

/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

[Thomas_Matthä]

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