Ansicht
Dokumentation

ASCORRINDX - Adjust database indexes for archive information structures

BAL_S_LOG - Application Log: Log header data   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Functionality

The program ASCORRINDX can be used to create, change and delete database indexes for archive information structures, without having to delete and rebuild the infostructures completely. You can use a test run to check, whether the definition of the database indexes in the Archive Information System corresponds to the indexes created in the data dictionary.

In Customizing of the Archive Information System you can create database indexes for infostructures. However, these indexes are only incorporated into the definition of the generated table ("ZARIX table") if this table is newly created. In other words, if you want to create a new index for an active infostructure or if you want to change or delete an index for an active infostructure, you must generally deactivate the infostructure, delete the corresponding table, then reactivate the infostructure and rebuild it.

Especially the building of infostructures that have been active for some time can take a long time, because a lot of archived data has to be read. The program ASCORRINDX helps you avoid this.

Use

• Change the definition of the database indexes according to your requirements. This can be done in Customizing of the Archive Information System (transaction SARJ) via the function Goto -> Database Index. Here you can create a new index for an infostructure, or delete or change existing indexes.
  For more information see Application Help.

• Then start the program ASCORRINDX. The parameters of the program have the following meaning:

• Archive Infostructure: Here you can limit your action to specific infostructures.

• Test Mode: If you select this field, then the program does not execute any changes. It runs through all the checks (insofar as possible), and then produces a log showing the information as if the program had run in production mode.

• After the program has finished, you receive a log about which infostructures were checked or changed and their database indexes. In this log you can see whether changes were necessary and whether these changes were executed.

Technical information

The program ASCORRINDX synchronizes the index definitions in table AIND_STR8 with the database indexes of the generated ZARIX table according to the data dictionary. This can cause new database indexes to be created, which can lead to longer runtimes if you have large data volumes. However, these runtimes are by far shorter than those you could expect if you completely rebuilt your infostructures.

CPI1466 during Backup   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Length: 3121 Date: 20240531 Time: 114517     sap01-206 ( 75 ms )