Rebuild index

[former_member227281]

In IBM AS/400 iseries using DB2/400 database, we are told to rebuild index on table ANEK asset balance table at SQL prompt using SQLutil.

WHat is the DB2/400 command to rebuild index of table ANEK.

Thanks and Regards

CHirag

[Former Member · Accepted solution]

Hi CHirag,

what do you mean with "rebuild" ? The same as on other DBs like Oracle ? This is just not necessary - indexes on iSeries are always with good performance )

If it should be missing, I would recreate it with DB02 as this is easiest.

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member]

DB2 UDB for iSeries maintains all SQL-based indexes automatically when the base table's content is changed. If U need to create a new index with different fileds from the existing ones, just create the new one. If the new index can provide better access plan for any SQL statements, DB2 engine will know that and use the new index automatically.

U can also check if the new index is used or not by using iSeries Navigator. See details here : http://www.mcpressonline.com/mc?50@73.UQD4dwDMtl0.2@.6b174ec0

Satid S.

IBM Thailand