Personal tools
You are here: Home DB2 DB2 UDB v9 Enabling AUTORESIZE for DMS tablespaces on DB2 V9
Navigation
Log in


Forgot your password?
 
Document Actions

Enabling AUTORESIZE for DMS tablespaces on DB2 V9

When migrating DB2 V8 databases to DB2 V9 or when creating DMS (non automatic storage tablespaces) on DB2 V9 might be a good practice to enable autoresize for these tablespaces

Check the example below:

db2 create db test automatic storage no

DB20000I  The CREATE DATABASE command completed successfully.


db2 create tablespace ts1 managed by database using (file 'c:\temp\data\cont1.dat' 1000)

DB20000I  The SQL command completed successfully.


C:\Documents and Settings\Administrator>db2 alter tablespace ts1 AUTORESIZE yes

DB20000I  The SQL command completed successfully.


After enabling AUTORESIZE for DMS tablespaces, DBA no longer needs to extend the tablespaces manually. DBA needs only to guarantee that there is enough space on the file systems so that DB2 can increase the tablespaces automatically when they get full. In this case, monitoring for tablespace full should be disabled.

To have control about how much the tablespaces are being increased, the parameter INCREASESIZE can be set (its default is automatic). For example:

db2 alter tablespace ts1 INCREASESIZE 20 percent

DB20000I  The SQL command completed successfully.


After enabling AUTORESIZE yes on DMS tablespaces you can still manually extend the existing containers or add new ones.


db2 alter tablespace ts1 extend (all 100)

DB20000I  The SQL command completed successfully.


db2 alter tablespace ts1 add (file 'c:\temp\data\cont2.dat' 1100)

DB20000I  The SQL command completed successfully.

Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls