Avoid RUNSTATS on BMCLGRNX
Do not run RUNSTATS against the BMC AMI Recovery Manager BMCLGRNX table space.
Doing so causes Db2 to perform an unnecessary table space scan on SYSLGRNX when doing unchanged analysis. Instead, if you have statistics in the Db2 catalog for BMCLGRNX, you should reset the values to -1. A sample job is located in the ARMRESET member in the .ARMSAMP data set that was created during installation. For more information about Db2 statistics, see the IBM Db2 Administration documentation.
Related topics
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*