How to react on the “bia_indexes_size_perf_check” alert in BWA Monitor
While checking in BWA Monitor, RSDDBIAMON2 we may come across the alert “bia_indexes_size_perf_check: Returns a list of BWA indexes”. This occurs when physical index has reached the threshold and this scenario usually develops when the index is created on a single BWA blade instead of the all available blades.
To find out the cubes for which index have reached the threshold value click on the details tab. Here we can see the Indexes which are not split. In this case the cubes are Y*XP2**0 and Y*XC5**0.
We can also get details on the type of index and the recommended number of partitions that can be used to split the index. In our case we are having 28 blades available and so in the details it shows recommended number of partitions as 28. Also note that the index type is “Fact Table”
We can confirm the above information by crosschecking in TREXADMIN. Provide the name of the system you want to connect to.
In TREXADMIN go to Index Landscape tab and provide the Fact table names collected from RSDDBIAMON2 by adding “*” at the beginning and end and click display icon. In our case fY*XP2**0 and fY*XC5**0 with * added at beginning and ending.
Here we can see that the index is created only on a single blade eventhough we have another 27 blades available for splitting and distributing the index so that the threshold value will not be exceeded.
So now we have to recreate the index by distributing it on all the available blades. To do this, go to RSDDV and give the cube name and go to BWA Index maintenance.
Click on Delete to delete the existing index and when it pop up for confirmation click Yes. After this again we will receive a pop up asking for confirmation to delete the Master Data Indexes. As Master Data Indexes are shared between cubes referring to same Master Data it is advisable not to delete this.
Now select “Create” option to recreate the deleted index.
Go to the “Load Admin” tab and by default the selected setting will be “SYSTEMEINSTELLUNGEN” which means SYSTEM SETTINGS. Change this and select the option “EIGENE EINSTELLUNGEN” which means My Settings. Also set the number of records to some high value say 99999999.
Now select “Activate and Fill BWA Index and select immediate option. This will schedule a job with name “RSDDB_BIAINDEX_FILL”
Monitor the job “RSDDB_BIAINDEX_FILL” to make sure the reindexing is successful.
Once this indexing job is completed again check the “Index Landscape” in TREXADMIN and we can see that the indexes are splitted on all available blades.
On Refreshing we can see that the alert does not exist anymore. Splitting the indexes on different blades helps to optimize the performance.