about create index online

[jane]

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.

[Pierre StJ]

Re: about create index online

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.


On Mar 25, 4:21 pm, jane <esthershe...@y ahoo.comwrote:

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.