about create index online

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jane - 25 Mar 2008 21:21 GMT

HI,

Just wondering is that OK to create index online ( without down the
application servers)..

it's OLTP 24*7 production environment..

Is that OK to create index on one table online ? the table size is
less than 1GB.

there is insert and update on the table from application.

very appreciated for any suggestion on it.

Reply to this Message

Pierre StJ - 29 Mar 2008 01:36 GMT

It's not so much the size (1GB) as the number of rows as the the table
as to be scanned to pick up the keys then sort them to generate this
index.
This can be done online if you are at DB2 V8.2 and up. The CREATE
INDEX command will run while providing full access to the data for
other appls.
Regards, Pierre.

> HI,
>
[quoted text clipped - 9 lines]
>
> very appreciated for any suggestion on it.

Reply to this Message