Originally posted by David Ulicny:
Hello,
I have a specific questions.
1. I need to know when are indexes rebuild within DB2 on iSeries.
2. How can I determine the index size on iSeries?
3. Is on iSeries some possibility to split one large table into some "partitions"?
Thanks in advance
1) Indexes on any database are rebuilt when data is added, updated or deleted from the relevant table. They can also be rebuilt on request.
2/3) These are probably system specific. I suspect the answer is in the docs.