How to add size for allocate size for table space

[keeyw]

Hi, dear all
need help, I can't insert the new row to my table (error message - cannot create new create new page) when i check my DMS table spaces the percentage use are 99%. Do i need to allocate more size for my DMS and how

 

[blom0344]

Hello Keeyw,

If you use DMS tablespaces , you will have to maintain the tablespace yourselve, unlike SMS tablespaces who are managed by DB2 itself. In your case you have to add containers to enlarge the tablespace, using the ALTER TABLESPACE syntax or by using CONTROL CENTER. (alter table space GUI)

ALTER TABLESPACE 'tablespace-name'
ADD FILE 'container-string' number-of-pages

do a commit and contents of tablespace are automatically rebalanced over the containers, without restriction to access to the tablespace..... T. Blom
Information analyst
tbl@shimano-eu.com

 

[keeyw]

Thanks ! I already done it