Hi,

I need to reorg some indexes.
After reading reorg command description only option I see is "INDEXES ALL FOR TABLE" clause whitch reorg's all table indexes.
Is it possible to reorg only certain index ?

thank you in advance
Vilius

DROP/CREATE?

You can give it as follows:

REORG table <tablename> index <index name>

Thanks,
Madhavi.

You can refer the DB2 Manual where some very good example like this one is also mentioned:

db2 "reorg table homer.employee index homer.empid"