Hi, Esteemed listers.

V8 on z/OS.

I have two questions.

First, I want to move below index to a new stogroup SG111111.
Suppose this index is piecesized to 2M. When I look at the datasets for this index I see

..........I000.A001
..........I000.A002
..........I000.A003
and so on.

Is below Alter statement right?

ALTER INDEX DBPA33TI.IF1NOTE
USING STOGROUP SG111111;






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]
==============================================================================


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