MVSFORUMS.com

NASCAR9 · Posted: Wed Aug 31, 2005 12:26 pm Post subject: Re-Allocating a TableSpace

I have a table that has grown larger than expected. Here are the steps I believe need to be done:
Unload table
Delete table and tablespace(1 table in 1 tablespace)
Re-allocate the tablespace
Create tablespace and table with indexes
Reload table

Do I need to rebind all programs accessing the table?
Did I miss something?
It's my understanding you can't alter tablespace allocations.

Thanks,
NASCAR9

kolusu · Posted: Wed Aug 31, 2005 12:55 pm Post subject:

NASCAR9 · Posted: Wed Aug 31, 2005 1:23 pm Post subject:

Kolusu, The volumes this tablespace resides on are not full or even close to being full. The tablespace was created like this:

PRIQTY 140000
SECQTY 1400

ALLOCATION
SPACE-TYPE------CYLINDER
SPACE-PRI------------195
SPACE-SEC--------------2

There are 198 extents, so I would like to change the allocations.
Above appears to be used for full or close to full volumes. At least this is how I interpreted the manual. Correct me if I'm wrong.

Thanks,
NASCAR9

Bithead · Posted: Wed Aug 31, 2005 1:43 pm Post subject:

If you are not using STOGROUPs, the ADD VOLUMES will not work. If this is the case then these are the steps:

1. Backup the tables in the tablespace;
2. Stop the tablespace
3. Delete / Define the VSAM file (making it bigger)
4. Start the tablespace
5. Recover the tablespace TOCOPY
6. Either backup the tables or REPAIR .. NOCOPYPEND
7. Rebind all the PLANS affected

If you are using STOGROUPs then alter the PRIQTY, SECQTY and run a REORG.

NASCAR9 · Posted: Wed Aug 31, 2005 1:53 pm Post subject:

Thanks Bithead,
We are using Stogroups. The table was poorley allocated from day one. We were not aware you could alter the allocations.

Thanks,
NASCAR9