db2 table space full

[v***@yahoo.com]

i have a db2 on aix and it got full on table space, how do i avoid this in the future.

i'm new with db2, i wish i could apply my oracle background but i'm blind on this technology. the last time i had with this was six years ago and just connect to an as/400 box.

please help,
itik

[Thomas Ritter]

Hi,

you can alter the table space by adding containers to it (only DMS table spaces) or you can just modify the size of the existing containers.

Assume you are using DB2 v9.1, see
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0000890.htm
for details on that.

Regards,
Thomas

[v***@yahoo.com]

thanks

[v***@yahoo.com]

thanks

[Blair Kenneth Adamache]

You can run the health monitor to generate an alert when the tablespace
gets close (i.e. 80%) to full:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0009214.htm

Or you can create your database with automated storage, which requires
less DBA intervention on storage:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.rn.doc/doc/c0023000.htm

Post by v***@yahoo.com
i have a db2 on aix and it got full on table space, how do i avoid this in the future.
i'm new with db2, i wish i could apply my oracle background but i'm blind on this technology. the last time i had with this was six years ago and just connect to an as/400 box.
please help,
itik