On Tue, 9 Aug 2011 09:12:43 +0100, Jim McAlpine wrote:
>I have a DB2 tablespace that has a candidate volume assigned with no extents
>on a volume that no longer exsits. Is there a way to remove the candidate
>allocation ?
>
Try: 1. DB2: -STOP DATABASE(xxx) SPACENAM(xxx)
2. IDCAMS: ALTER vcat.DSNDBC.xxx REMOVEVOLUMES(??????)
3. DB2: -START DATABASE(xxx) SPACENAM(xxx)
If it's a DB2-managed tablespace then ALTER the STOGROUP(s) too:
select 'ALTER STOGROUP', sgname, 'REMOVE VOLUMES(', volid, ');'
from sysibm.sysvolumes where volid = '??????';
Norbert Friemel
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
