MVSFORUMS.com

satishsv · Posted: Wed Jun 14, 2006 6:26 pm Post subject: Altering Tablespace

Hi,

We have a tablespace created in the following way.

kolusu · Posted: Wed Jun 14, 2006 9:26 pm Post subject:

satishsv,

If you haven't inserted any data into the tablespace then I would advise you to drop and re-create the tablespace again with DEFINE YES.

With DEFINE NO the data sets are not created until data is inserted into the table space. DB2 uses the SPACE column in catalog table SYSTABLEPART to record the status of the data sets (undefined or allocated).

The value is -1 if the table space was defined with the DEFINE NO clause, which defers the physical creation of the data sets until data is first inserted into one of the partitions, and data has yet to be inserted. If you have authority then you can update this space column with Integer number of kilobytes. This will be DASD storage allocated to the table space partition, as determined by the last execution of the STOSPACE utility or RUNSTATS utility. The value is 0 if STOSPACE or RUNSTATS has not been run. The value is updated by STOSPACE if the table space is related to a storage group

Hope this helps...

Cheers

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

satishsv · Posted: Thu Jun 15, 2006 10:50 am Post subject:

Kolusu,

Your reply is really helpful to me. I shall go ahead and try the option that you have given me of updating SYSIBM.SYSTABLEPART.

Thanks,
Satish