How to rebuild index in DB2 9.7 LUW

db2 db2-luw db2-connect
Masheed picture Masheed · Jul 4, 2014 · Viewed 8.2k times · Source

How I can rebuild index in DB2 9.7 LUW. Is there any rebuild utility for index or I have to recreate index.

Regards,

Masheed

Answer

Ramazan Polat picture Ramazan Polat · Aug 28, 2014

You can use REORG command to recreate ALL INDEXES on a table like this:

REORG INDEXES ALL FOR TABLE table1 ALLOW WRITE ACCESS CLEANUP ALL RECLAIM EXTENTS

Related questions

DB2 Comma Separated Output by Groups

Is there a built in function for comma separated column values in DB2 SQL? Example: If there are columns with an ID and it has 3 rows with the same ID but have three different roles, the data should be concatenated …

Read More
Failing update table in db2 with SQLCODE: -668, SQLSTATE: 57016, SQLERRMC: 7;

I am using db2 9.5 i have created a column in table which is created successfully but i am not able to update table column and getting following error [Error] Script lines: 1-1 -------------------------- DB2 SQL error: SQLCODE: -668, SQLSTATE: 57016, SQLERRMC: 7;…

Read More
Db2 connection problem with java

I am having problem with DB2. I just installed the db2 as a db2admin and with a password. When i try to connect to database it is success full and while running any simple select query it give me …

Read More