Patch 3 for version 7.6.06 (7.6.06.003)

This topic contains information about fixes and updates in Patch 3 and provides instructions for downloading and installing the patch.

• • Prerequisites
  • Performance updates
  • Downloading the patch
  • Installing the patch
  • Related topic

Prerequisites

• You must have administrative rights to import the modified Fiscal Calendar .def file in BMC Remedy AR System. If you are using the Server Group option, you must provide the Primary AR System Server details to load this .def file.
• To use the procedure for modifying the Fiscal Calendar view, the Database User must have the CREATE VIEW rights.Otherwise, the procedure fails and the new column defined in the Fiscal Calendar cannot be modified.

Performance updates

This section explains the performance updates that are provided in this patch.

The following table displays the records of the custom reports and the percentage of improvement after installing this patch:

These performance testing numbers are based on the following system configurations. These might vary, depending on your system configurations and settings.

• Processor—2 GHz (2 processors)
• RAM—8 GB
• Operating system—64-bit (Microsoft Windows 2008 Service Pack 2)

Updated SQL query for multitenancy in the Universe

To run queries faster for better performance, some sub-queries are moved to the back-end. For more information, see Supporting-the-multitenancy-implementation-in-BMC-Remedy-AR-System.

Universe level formula moved as precalculated value

The formulas that are used in some of the universe objects (date objects) are now moved to the back-end and stored as a column in the ANA_FISCAL_CALENDAR view as a precalculated value. See the following Incident Reported Date example for Oracle and MSSQL:

Updated the date conversion function

When you select the time zone during installation, instead of storing the region-specific data in the ANA_TIMEZONE_INFO table, the data is now stored in the ANA_TZ_DSTTIME table. This back-end change improves the time to perform the function call, because this new table stores only 20 records. Additionally, the date conversion function is split into separate files.

For recommendations about restricting data in the ANA_FISCAL_CALENDAR and the ANA_TZ_DSTTIME tables, see Updating-report-time-zones.

Changed the implementation of some outer joins used in the Universe

The back-end implementation of the outer joins between the transaction table date and the alias table of the ANA_FISCAL_CALENDAR in the Universe has been changed to improve the performance.

Created additional indexes for the modules in the universe

During installation, indexes were created on the BMC Remedy AR System tables. To improve performance, the indexes are now created on the BMC Remedy AR System tables and the BMC Analytics for BSM tables. For more information about replicated databases, see BMC Analytics for BSM with a replicated BMC Remedy AR System database.

Converted some derived tables into views

To improve performance, some of the derived tables, like D_ASSET_CONTRACTS, have been moved to the back-end database as database views. The following new database views related to BMC Analytics for BSM are created:

• ANA_ASSET_CONTRACTS_VW
• ANA_VIRTUAL_SYSTEMS_VW
• ANA_SR_BUSINESSSERVICE_VW
• ANA_BASEELEMENT_VW

Downloading the patch

The following table lists the installation files to download for Patch 3 from the BMC Electronic Product Distribution (EPD) web page.

BMC Analytics for BSM patch files

Installing the patch

For instructions about installing the patch, see Installing-the-BMC-Analytics-for-BSM-universes-and-reports. For prerequisites, see Planning and Preparing-for-installation.

Related topic

Known-and-corrected-issues