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.

**********************************************************************


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