MVSFORUMS.com

SMS · Beginner Joined: 16 Oct 2005 Posts: 53 Topics: 24

Hi All,

We have a tablespace created as below. Now this table space is quickly approaching its maximum limit of 4GB. As a quick fix, we are planning to alter the Tablespace from VCAT to use STOGROUP and later we are planning to increase the TS size from 4GB to 8GB.

Is it possible to alter the table space to use STOGROUP instead of VCAT without dropping the tablespace/table ?

Please give your inputs.

kolusu · Posted: Tue Aug 07, 2007 12:09 pm Post subject:

SMS,

Check this link

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2tools.adb.doc.ug/switch.htm

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

SMS · Beginner Joined: 16 Oct 2005 Posts: 53 Topics: 24

Thanks Kolusu. That link was very useful.

From that link I understood that the conversion can be done without dropping the tablespace.

I have one more doubt. Is it possible to do this through a batch utility ?

Actually I am not a DBA but I have been asked to do this and I am not having DBA authority.

Normally for the DDL/DML changes we will be executing the batch jobs through CRISS (a installation suupport system).

Thanks,
SMS
_________________
Regards,
SMS

kolusu · Posted: Tue Aug 07, 2007 12:55 pm Post subject:

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

if your concern is the limitation of 4GB, it's not related to using VCAT or STOGROUP (DB2 control or user maintenance).

You should define SMS Data Class with EA-enabled, and convert the data sets to SMS-controlled (associate the data sets with the SMS DC.

And if you want to change the DSSIZE to 8G or whatever, you must drop and recreate the tablespace. The DSSIZE cannot be changed by ALTER TABLESPACE after the page set is created.