Welcome
Tuning performance
Learn how to plan the infrastructure of BigFix Inventory and to configure the application server to achieve optimal performance. The following guidelines are applicable in big data environments as well as in smaller environments that are running on low-performance hardware.
Tuning performance in medium and large environments
You can learn the possible causes of the most common performance issues in medium and large environments. Follow the tips and the known solutions to these issues to keep the system in good shape and avoid performance problems.
Tuning DB2 application database
To avoid performance issues in medium and large environments, configure the location of the transaction log and adjust the log size. If you are using DB2 as BigFix Inventory database, you might want also to change the swappiness parameter in Linux or configure the DB2_COMPATIBILITY_VECTOR.
Configuring statement heap size
Statement heap size configuration parameter (stmtheap) refers to the limit of the statement heap, which is used as a workspace for the SQL compiler during compilation of an SQL statement. Statement heap size has an impact on the time taken to execute complex queries, for example generating the audit snapshot.

BigFix Documentation Homepage
BigFix 11 Inventory Documentation
Welcome to the BigFix Inventory documentation, where you can find information about how to install and configure BigFix Inventory. The application provides you with information about your inventory and license metrics. You can manage your software assets, gather information about your hardware, and ensure license compliance for your enterprise using BigFix Inventory.
BigFix Platform
Overview
Become familiar with key concepts that are necessary to understand how BigFix Inventory works and learn about features and functions that are introduced in every version of the application.
Installing
Learn about the requirements and available installation scenarios to ensure that the deployment of BigFix Inventory goes smoothly in your environment.
Configuring
After you install BigFix Inventory, configure the application. Create accounts for the users who need access to the application and set up scans to collect software and hardware inventory data from your environment.
Upgrading
A new version of BigFix Inventory is released periodically, typically at the end of each calendar quarter. Upgrade to the new version regularly to take full advantage of new features and application fixes.
Catalog Overview
This section provides information about catalog updates available with every release.
Managing the infrastructure
After you complete the initial configuration of BigFix Inventory, learn how to manage components of its infrastructure: VM managers, server, database, and data sources.
Software inventory and license utilization
You can classify the discovered software so that reports in BigFix Inventory reflect your entitlements and properly show utilization of license metrics by particular products.
Managing security threats
Learn how to use BigFix Inventory to manage security threats in your environment. You can view whether any of the installed components is prone to any Common Vulnerability and Exposure (CVE).
Tutorials
Tutorials help you understand how to use BigFix Inventory. They consist of modules that focus on broad goals. Modules consist of tasks that show how to configure specific settings step-by-step.
Security
Configure different security features to adequately protect business assets and resources in the data model when using BigFix Inventory.
Troubleshooting and support
Learn about solutions to common problems that might arise when you use BigFix Inventory BigFix Inventory and how to find logs and trace files that help you troubleshoot those problems.
Tuning performance
Learn how to plan the infrastructure of BigFix Inventory and to configure the application server to achieve optimal performance. The following guidelines are applicable in big data environments as well as in smaller environments that are running on low-performance hardware.
- Setting up scans and import
  Learn how to improve the scanning and importing activities to optimize the performance in your infrastructure.
- Additional tasks for improving performance
  Learn about additional tasks that you might want to perform to improve the performance in your infrastructure.
- Tuning performance in medium and large environments
  You can learn the possible causes of the most common performance issues in medium and large environments. Follow the tips and the known solutions to these issues to keep the system in good shape and avoid performance problems.
  - Tuning DB2 application database
    To avoid performance issues in medium and large environments, configure the location of the transaction log and adjust the log size. If you are using DB2 as BigFix Inventory database, you might want also to change the swappiness parameter in Linux or configure the DB2_COMPATIBILITY_VECTOR.
    - Maintaining the DB2 database
      To ensure that the DB® database works properly, you need to regularly back up your data and perform maintenance actions.
    - Configuring the transaction logs size
      If your environment consists of many endpoints, increase the transaction logs size to improve performance.
    - Configuring the transaction log location for DB2
      To increase database performance, move the DB2® transaction log to a file system that is separate from the DB2 file system.
    - Configuring swappiness in Linux hosting DB2 database server
      Swappiness determines how quickly processes are moved from RAM to hard disk to free memory. It can assume the value 0 - 100. A low value means that your Linux™ system swaps out processes rarely while a high value means that processes are written to disk immediately. Swapping out runtime processes should be avoided on the DB2® server on Linux, so it is advisable to set the swappiness kernel parameter to a low value or zero.
    - Configuring the DB2_COMPATIBILITY_VECTOR variable for improved UI performance
      For environments with 5000 or more clients in your infrastructure, set the value of the DB2_COMPATIBILITY_VECTOR variable to MYS. The change in the value might result in faster UI response time on some installations. For information about how to modify the registry variable, refer to DB2_COMPATIBILITY_VECTOR registry variable.
    - Configuring statement heap size
      Statement heap size configuration parameter (stmtheap) refers to the limit of the statement heap, which is used as a workspace for the SQL compiler during compilation of an SQL statement. Statement heap size has an impact on the time taken to execute complex queries, for example generating the audit snapshot.
  - Tuning MS SQL application database
    To avoid performance issues in medium and large environments, configure the location of the transaction log. If you are using MS SQL as BigFix Inventory database, you might want to shrink the transaction log or update query optimization statistics.
- REST API considerations
  You can use BigFix Inventory REST API to retrieve large amounts of data that is related to computer systems, software instances, and license usage in your environment. Such information can then be passed to other applications for further processing and analysis.
Integrating with REST API
External systems integration is one of the key features of BigFix Inventory. Business logic is enabled for integration and interfaces are provided for common integration points.
Glossary
Guide in PDF format
DataFlow ServiceNow Integration

Configuring statement heap size

Statement heap size configuration parameter (stmtheap) refers to the limit of the statement heap, which is used as a workspace for the SQL compiler during compilation of an SQL statement. Statement heap size has an impact on the time taken to execute complex queries, for example generating the audit snapshot.

Allocating small statement heap size for complex queries causes the query to be not fully optimized and the execution lakes longer. It also consumes excessive amount of disk space. This scenario occurs in databases that have large amount of data. On the other hand, allocating large statement heap size may cause in longer execution time for complex queries even if the database has small amount of data. It may be helpful to adjust the statement heap size for large environments, if there are queries that run for a long time, or use large amount of disk space.

Use the below command to define the statement heap size:

db2 update db config for TEMADB using stmtheap 81920 automatic

Note: Restart BigFix Inventory application and DB2 database after you change the statement heap size.