Creating and populating secondary index for COEP table

[Former Member]

Hello,

Does anybody have an experience of creating secondary index for COEP table? I have transported the index to production and now need to populate it in SE14. However, as the the table is large this takes over an hour.

Now the problem is that it seems that the system blocks all the entries to the table during the population. In 24/7 business this of course is not acceptable.

Is it really so that no postings can be made during the population? Any ways to perform this during the normal operation hours?

Best Regards, JV

[Former Member · Accepted solution]

Use online clause at sqlplus command line

create index sapr3."COEP_2" on sapr3.coep(col1,col2) ONLINE NOLOGGING

ONLINE & NOLOGGING clause is very important, with this options, transaction can go online.

I have done this in the past, it works greate.

Take help from Hardcore DBA..

-AJ

[former_member204746 · Accepted solution]

abdullah, indexes should be created from within SAP, not through direct DB tools.

[stefan_koehler · Accepted solution]

Hello Eric,

normally this is correct, but as described in sapnote #334224 it is supported to create index on database level.

SAP has not implemented the ONLINE clause in the SE11 / SE14, so you have no other chance.

Regards

Stefan

[former_member204746 · Accepted solution]

OK, fair enough, then, it should be created later in the Data dictionary later... or dropped... or he will get warnings in DB13-CheckDB.

[stefan_koehler]

Hell Jarkko,

> Now the problem is that it seems that the system blocks all the entries to the table during the population

If you rebuild the index offline - yes.

> Any ways to perform this during the normal operation hours?

Create the index with the ONLINE clause. The exact procedure is described in sap note #334224

For more information / problems in an online environment take a look at sapnote #682926

Regards

Stefan