Currently Being Moderated

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.

1.jpg

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.

2.jpg

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”

3.jpg

We can confirm the above information by crosschecking in TREXADMIN. Provide the name of the system you want to connect to.

4.jpg

5.jpg

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.

6.jpg

7.jpg

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.

8.jpg

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.

9.jpg

10.jpg

Now select “Create” option to recreate the deleted index.

11.jpg

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.

12.jpg

13.jpg

Now select “Activate and Fill BWA Index and select immediate option. This will schedule a job with name “RSDDB_BIAINDEX_FILL”

14.jpg

Monitor the job “RSDDB_BIAINDEX_FILL” to make sure the reindexing is successful.

15.jpg

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.

16.jpg

17.jpg

On Refreshing we can see that the alert does not exist anymore. Splitting the indexes on different blades helps to optimize the performance.

18.jpg

Comments

Actions

Filter Blog

By author: By date:
By tag: