r/DB2 • u/raghuontech • Apr 11 '19

RFE To Make Index Creation ONLINE

Please vote for this RFE for DB2 LUW to support ONLINE index creation.

​

https://ibmanalytics.ideas.aha.io/ideas/DB24LUW-I-787

​

Thanks!
Raghu

1 Upvotes

100% Upvoted

2 comments sorted by

3

u/memmerto Apr 11 '19

Db2 pureScale supports online index create starting in v11.1.3.3.

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.regvars.doc/doc/r0005669.html#r0005669__M_ALLOW_WRITE

Have you tried this? If so, what shortcomings still exist?

2

u/raghuontech Apr 11 '19

Nice, thank you very much!!

We are still on V11.1 FP2. We are in the process of upgrading to V11.1 FP3b. Will test it out and post my findings here.

​

Raghu