title: Disable & enable of Index in db2luw
body: <p>is it possible to temporarily disable &amp; again enable of an index on a table in db2luw.
  If so can some one tell me the syntax or process, to achieve this.</p>
  
  <p>I am updating tons of records . Before that I have to disable all the indexes on all the tables &amp; after that have to create only one user created index (I9) on all the tables. My update query has to be run only with one index(I9).
  When once my update query got completed. again I have to reset all the tables to their original position(previous indexes).</p>
  
  <p>I am very new to db2. kindly excuse me if I am wrong at any stage in my question.</p>
  
  <p>That is what I am trying to find.
  If you have a better solution for this, can you please let me know.It l be a very good favour.
  Thanks</p>