In http://www-01.ibm.com/support/docview.wss?uid=swg21683633#online_index IBM was trying to discuss the improvements that have been made to the on line index reorganization initiated by the Spectrum Protect server. It was not IBM's intention to recommend that the above DB2 commands be executed outside of the Spectrum Protect server. Except for some exceptional case on line reorganization should only be initiated by the Spectrum Protect server.
For Spectrum Protect server version 6.3, IBM recommends upgrading to at least version 6.3.5.000 which will allow the use of this server option DISABLEREORGINDEX the default value for DISABLEREORGINDEX is BF_AGGREGATED_BITFILES,BF_BITFILE_EXTENTS,BACKUP_OBJECTS,ARCHIVE_OBJECTS With Spectrum Protect server version 6.3, IBM does not recommend on line index reorganization on BF_AGGREGATED_BITFILES,BF_BITFILE_EXTENTS,BACKUP_OBJECTS,ARCHIVE_OBJECTS IBM will clarify the information and update the technote. Thank you, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 04/25/2016 06:34:58 AM: > From: Krzysztof Przygoda <przy...@gmail.com> > To: ADSM-L@VM.MARIST.EDU > Date: 04/25/2016 06:35 AM > Subject: Re: Manual db2 online reorg for ver.6.3 > Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> > > Anyone from IBM? > Recently we raised PMR with such but support seems just to quote the same > docs... > Kind regards > Krzysztof > > > 2016-04-22 10:11 GMT+02:00 Krzysztof Przygoda <przy...@gmail.com>: > > > Hi > > Just wondering if anyone tried with TSM ver 6.3 method described in > > document related to ver 7.1 > > http://www-01.ibm.com/support/docview.wss?uid=swg21683633 > > > > "*Online index reorganization* > > > > You can initiate online index reorganization by running a command with the > > following syntax: > > db2 reorg indexes all for table <table name> allow write access > > > > For example: > > db2 reorg indexes all for table BF_AGGREGATED_BITFILES allow write access > > > > " > > > > as that part is missing in previous document version: > > http://www-01.ibm.com/support/docview.wss?uid=swg21452146 > > > > Seems to be pure db2 thing and would be nice to be able to use such...when > > we don't want to start it as automatic. > > Question is if TSM doing something more when initiating that for its own > > or if such manual run on db2 is anyhow harmful to tsm? > > > > > > Kind regards > > Krzysztof > > >
