Skip to Content
0

When a Secondary Index Table is really created when it is transported

Nov 22, 2016 at 10:33 AM

113

avatar image
Former Member

Hi fellows.

I would like to know when really a new secondary index Z01 is created in the ZTable after transporting it.

Is it a background/assynchronus task ? When does it really start ?

best regards.

Glauco
ABAP Senior Consultant

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Nov 22, 2016 at 05:21 PM
0

Hi Glauco,

Go to SE14, utilities and then activation log.

It shows the time when the Index was activated. OR DB utility also shows all these details.

Regards,

Harish Karra

Share
10 |10000 characters needed characters left characters exceeded
Mario De Felipe Nov 23, 2016 at 11:51 AM
0

Hello Glauco

in SE11, the index needs to have (index on all database systems)

in that case, when you activate it it will request a TR, this TR when you move it it will create the index in the target system during the transport.

if you dont want the index to be created and only the definition to be syncronized, you need to select "No database index" then it will not be creted when you transport it.

if you want to move a TR with a big index, a good approach is to create the index with database tools before, because you can parallelize and when you move the transport (with option "Index on all database systems") SAP will see that the index is created in the DB and will not re-create it.

you can check SAP note 334224 that gives an overview of this approach.


indexes.png (27.7 kB)
Share
10 |10000 characters needed characters left characters exceeded