Skip to Content

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.

/wp-content/uploads/2012/03/1_84921.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.

/wp-content/uploads/2012/03/2_84922.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”

/wp-content/uploads/2012/03/3_84938.jpg

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

/wp-content/uploads/2012/03/4_84939.jpg

/wp-content/uploads/2012/03/5_84940.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.

/wp-content/uploads/2012/03/6_84941.jpg

/wp-content/uploads/2012/03/7_84942.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.

/wp-content/uploads/2012/03/8_84943.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.

/wp-content/uploads/2012/03/9_84944.jpg

/wp-content/uploads/2012/03/10_84945.jpg

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

/wp-content/uploads/2012/03/11_84946.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.

/wp-content/uploads/2012/03/12_84947.jpg

/wp-content/uploads/2012/03/13_84948.jpg

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

/wp-content/uploads/2012/03/14_84949.jpg

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

/wp-content/uploads/2012/03/15_84950.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.

/wp-content/uploads/2012/03/16_84951.jpg

/wp-content/uploads/2012/03/17_84952.jpg

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

/wp-content/uploads/2012/03/18_84953.jpg

To report this post you need to login first.

16 Comments

You must be Logged on to comment or reply to a post.

  1. Jens Gleichmann

    Hi George,

    at first thanks for your blog. This is one of the most frequently asked questions regarding BWA.

    With your solution you have to reindex the complete index. In some cases this will take a lot of time and is not possible during normal operating time.

    For this you can split it with the python standalone tool:

    → tab Landscape →search for the index → right click on Split/Merge Index → “ROUNDROBIN x″  x is the number of active blades (includes not the backup blades) it splits the selected index in x parts. The number of parts should be always the number of active blades to ensure the best performance for searching for this information. During the time index is read-only!

    Regards,

    Jens

    (0) 
    1. Eumir Reyes

      Hi Jens,

      We have also followed that kind of reorg in order to solve this problem but the alerts are not turned off. Do you know how can we turn the alterts off after the cube has been correctly reorgnized with python tools?

      Regards,

      Eumir

      (0) 
  2. HS Kok

    Hi George, thanks for the blog post.

    From my experience, BIA indexes need to be dropped and rebuilt on a regular basis (weekly) to optimize the performance of the blade servers.

    (0) 
    1. George Thomas Post author

      Hi HS Kok,

      You are correct. The best practice is used to drop the indexes and rebuild it weekly. But due to any activities if the indexes of a particular cube is rebuilt and if we face the issue we can proceed with this practice. Else it is always recommended to do the index maintenance weekly by scheduling a PC.

      Regards,

      George

      (0) 
    2. Cobus van Rooyen

      HS,

      Your comment about rebuilding once a week – I assume that’s for delta indexing?  We drop our indexes as part of our daily process chains – we don’t use delta indexing. Just checking if I should build a new PC 🙂

      Thanks

      (0) 
      1. HS Kok

        Hi Cobus,

        Not sure what delta indexing you are talking about. I’m referring to the BIA indexes, not the InfoCube index.

        When you load delta requests to an InfoCube, a BIA index roll-up needs to happen before you can see the delta information in your BW reports. In such cases, the BIA indexes should be fully dropped and re-created on a weekly basis as the performance will degenerate over time.

        (0) 
  3. Cindy Jia

    Hi George,

    Very good blog!

    Sometimes, I will recommend to update the DB statistic to get the correct size of the infocube. Then try to rebuild the index again, it will be split.

    Regards,

    Cindy

    (0) 
  4. SAm kAn

    Hi,

    We have the same warning for X tables and S tables, how do we rebuild the Master Data tables? We are on BW 7.0.

    (0) 
    1. George Thomas Post author

      Hi SAm,

      You can drop the index for the entire cube using RSDDV and then rebuild using the required settings, split to all the available blades.

      (0) 

Leave a Reply