ADSM-L

[ADSM-L] Manual db2 online reorg for ver.6.3

2016-04-22 04:13:57
Subject: [ADSM-L] Manual db2 online reorg for ver.6.3
From: Krzysztof Przygoda <przygod AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 22 Apr 2016 10:11:48 +0200
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

<Prev in Thread] Current Thread [Next in Thread>