James,

Didn't see anyone reply.... and it's been many moons since I worked on the mainframe. The way I remember it, a create index statement doesn't require the underlying VSAM datasets because it will execute an online IDCAMS to create them. You can also pre-create them yourself if you're so inclined. However, a rebuild index won't attempt to create the VSAM files under the index space - a rebuild expects them to be already there. The fastes way between here and there is to drop the indexes and simple re-create them.

Nick

-------------- Original message --------------
From: "JAMES PARK " <db2udbdba-ezmlmshield-x6809743.[Email address protected]

> Esteemed Listers.
>
> DB2 V7 on z/OS.
>
>
> When we are rebuilding user indexes on DB2 catalog tables and those
> indexes are stogroup defined it is our understanding that the underlying
> VSAM cluster does not need to be predefined. Is it the case that those
> VSAM cluster are defined when the rebuild takes place?
>
> We tried to rebuild index (ALL) after the tablespaces were recovered
> and this failed. So we rebuilt the IBM indexes individually and when we
> issue the rebuild for the user indexes we get a reason code of 00E40305
> (meaning the underlying vsam dataset is not there).
>
> Thanks,
>
> James Park
> Database Specialist II
> Annapolis Data Center
> 410-260-7489
> [Email address protected]
>
> ------------------------------------------------------------------------------
> This email and any file transmitted with it may be confidential and are intended
> solely for the use of the individual or entity to whom they are addressed. If
> you received this email in error, please notify the Comptroller's System Manager
> by forwarding this message to [Email address protected]
> ==============================================================================
>
>
>
> This footnote also confirms that this email message has been swept by the
> networkmaryland MIMEsweeper for the presence of computer viruses.
>
> **********************************************************************
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>

DB2 & UDB email list listserv db2-l LazyDBA home page