How to split the index manually
How to de/activate initialReorg
When does an index get split?
To find out when the physical index has been created please check the followings.
1. Check if RSDDSTATTREX table has an entry with CHANGEMODE = I
*YES, there is an entry in RSDDSTATTREX table*
Report 'RSDDTREX_SINGLE_TABLE_INDEX' created the physical index. Check the next point below.
*NO, there is no entry with CHANGEMODE = I in RSDDSTATTREX table.* *
Does anyone merged the indexes in TREX Administrator tool? If anyone did not merge the split indexes manually and this issue is reproducible please inform SAP via a customer message for further analysis.
2. Check if RSDDTREXADMIN table has an entry with OBJECT = 'SINGLE_TABLE:<TIME STAMP>'
*YES, there is an entry in RSDDTREXADMIN table*
The user in RSDDSTATTREX table (Field TSTPNM) executed the report 'RSDDTREX_SINGLE_TABLE_INDEX' in SE38. Educate the user to deactivate 'initialReorg' parammeter before the execution.
**Keep in mind that the report must be executed manually only when there is an data inconsistency
*NO, there is no entry in RSDDTREXADMIN table*
The report must have been executed during Master Data Reorganization. Currently there is no functionality in BW to decide whether to split an index based on the table size during MD reorganization. Therefore, deactivation of initialReorg is required. After the reorganization initialReorg must be activated.