Page tree

Unsupported content

   

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Skip to end of metadata
Go to start of metadata

This topic lists and describes the requirements for the BMC TrueSight Capacity Optimization database. Refer to the following sections for details:

BMC TrueSight Capacity Optimization supports two different Database technologies:

You must validate these options for your environment by performing an appropriate sizing exercise. For more information, see Planning. The Running the database on a virtual machine section provides recommendations in case of virtualized server.

Oracle Database requirements

The following software is required for the BMC TrueSight Capacity Optimization database server:

  • Operating system: Any 32- or 64-bit operating system supported by the Oracle Database.
  • Oracle Database Server: The following versions are currently supported:

    VersionEditions
    12c R1
    (12.1*)
    • Standard Edition One (SE1)
    • Standard Edition (SE)
    • Enterprise Edition (EE)
    • Express Edition (XE)
      (11.2 only)
    11g R2 and later
    (11.2)

    * Oracle version 12.1.0.2.0 does not work as expected (caused by Oracle bug 20508819).

    As a workaround, you can either perform any one of the following:

    • Add Oracle instance init parameter _optimizer_aggr_groupby_elim=false to use Oracle version 12.1.0.2.0
    • Use Oracle version 12.1.0.1.0

    Notes

    • For large volumes of records, BMC does not recommend use of ORACLE Express Edition due to its database size limitations.
    • The Oracle Advanced Compression (OAC) feature is not recommended for use with a BMC TrueSight Capacity Optimization database server. Activating this feature can have a significant impact on performance in terms of ETL execution time and DWH data processing time.
    • SQL*PLUS and SQL*LDR do not work on Oracle client 11g R2 running on an AMD processor platform. To fix this issue, you need to deploy Oracle Patch Set 8670579 after you install the Oracle Client.
      This is not a BMC TrueSight Capacity Optimization issue, but a known issue in the Oracle 11gR2 client.

    Recommendation

    BMC strongly recommends use of the following software for the BMC TrueSight Capacity Optimization database server:

    • Character set: AL32UTF8 — As part of Internationalization support and Unicode standard alignment, use of this character set prevents issues related to wrong character encoding while integrating heterogeneous datasources.
    • Oracle Partitioning: Installing and enabling Oracle Partitioning on the database server, especially for very large databases to ensure maximum performance.
    • Oracle Java Virtual Machine (JVM): Installing and enabling Oracle JVM on the database server.
    • Oracle Database version: Oracle Database 11gR2 version 11.2.0.3.0 and later.

Configuration recommendations

Configuration itemRecommendation
Schema
  • BMC TrueSight Capacity Optimization database schema uses five tablespaces: two for capacity data, two for indexes, and one for view configurations. For better performance, BMC recommends that the two data tablespaces be allocated on a different physical device than the two index tablespaces.
  • The default schema owner user is BCO_OWN. This user must have permissions on the five tablespaces and also on a temporary tablespace. 
  • The schema uses global temporary tables that can reach considerable size.

    Space allocation recommendations

    Allocate a minimum of 3 GB for the temporary tablespace.

    Allocate a minimum of 3 GB for the UNDO tablespace.

    Allocate at least 4 GB for the REDO logs. You must allocate enough archive space to accommodate the REDO logs for the backup period. For example, if backup is taken every six hours, then the archive space will need to be at least 24 GB.

Memory Management

We recommend using automatic memory management. Configure only the limit, and Oracle will manage the SGA and PGA.

Recommendation

Set the memory limit at 80 percent of the total memory.

Listener configuration

By default, the Oracle instance sets the listener port to 1521. You can also set a different port as per Oracle guidelines.

Recommendation

Set the max sessions parameter to 300.

Block size

The default block size should be used.

Recommendation

Set a block size between 8 KB and 32 KB.

Archive logging

BMC recommends running the database in archive logging (ARCHIVELOG) mode and using Oracle best practices:

  • Perform periodic full backups (For example, weekly)
  • Perform incremental backups (For example, daily)
  • Perform continuous archive log backups (For example, every 6 hours)

The size and frequency needed for the archive logs depends linearly on the size of the BMC TrueSight Capacity Optimization database in terms of daily population load.  As a rough estimation, provide 2.5GB/hour for every 10 million rows loaded per day. For example, provide 5 GB/hour for a BMC TrueSight Capacity Optimization database sized for 20 million rows per day.

Archive logging allows you to do a full backup without shutting down BMC TrueSight Capacity Optimization. Daily shutdown for backup can cause problems to application tasks and services: no task can be executed in the database maintenance window, so you would have to reconfigure OOTB tasks. If the database is shut down, BMC TrueSight Capacity Optimization will log several exceptions and send the administrator email, so you would also have to stop BMC TrueSight Capacity Optimization components before turning off the database.

PostgreSQL Database requirements

The following software is required for the BMC TrueSight Capacity Optimization database server:

  • Operating system: Any 32- or 64-bit operating system supported by the PostgreSQL Database Server
  • PostgreSQL Database Server: Versions 9.3 is currently supported

Note

The current compatibility offering for the PostgreSQL database supports only small/medium environments handling up to 25 million records per day.

Configuration recommendations

Configuration itemRecommendation
Users, Roles
  • The first installation of TrueSight Capacity Optimization Application Server will automatically create users, roles needed by the application. In order to do this, installer will ask to enter credentials for the PostgreSQL priviledged user (usually named postgres). 
  • Default names are provided for users, roles but they can be customized during installation.
  • The default schema owner user is BCO_OWN.
Schema and Tablespaces
  • BMC TrueSight Capacity Optimization database schema uses five tablespaces: two for capacity data, two for indexes, and one for view configurations. For better performance, BMC recommends that the two data tablespaces be allocated on a different physical device than the two index tablespaces.
  • Default names are provided for tablespaces (BCO_DATA, BCO_DATA_IDX, BCO, BCO_IDX, BCO_DASH) but they can be customized during installation.
  • Tablespaces are automatically created during installation of the first Capacity Optimization Application Server. Before launching installation, a proper directory structure must be prepared on Database Server to host tablespaces. 
    • For example, a parent directory like "/var/lib/pgsql/data" can be used to host tablespace files (or any other directory on the Database Server machine). Inside this parent folder, a folder for each tablespace must be created before launching install. By default the structure could be as follows (the names are case-sensitive)
      • /var/lib/pgsql/data
        • /BCO_DATA
        • /BCO_DATA_IDX
        • /BCO
        • /BCO_IDX
        • /BCO_DASH
    • The folders created above must be accessible and owned by the OS user that runs PostgreSQL process. The directories must be empty. Capacity Optimization installer will ask to enter the position of above tablespaces folder.
Client Authentication
  • Make sure all BMC TrueSight Capacity Optimization server machines (excluding Remote ETL Servers) can access the Database Server by allowing access in pg_hba.conf
  • Recommended configuration in pg_hba.conf is to use MD5 encryption for passwords.
Instance parameters
  • BMC recommends adding the following parameters to the configuration of the Database Server in postgresql.conf or equivalent file
listen_addresses = '*'
max_connections = 300
default_statistics_target = 50
constraint_exclusion = on
wal_buffers = 8MB
checkpoint_segments = 16
checkpoint_timeout = 15min
checkpoint_completion_target = 0.9

#following parameters should be tuned according to actual memory available to Database server machine
#example of configuration for 8GB RAM

 

maintenance_work_mem = 512MB
effective_cache_size = 5GB
work_mem = 48MB
shared_buffers = 2GB

Running the database on a virtual machine

The BMC TrueSight Capacity Optimization database can be set up using a virtual machine, instead of a physical machine.

  • Ensure that resources are available to the BMC TrueSight Capacity Optimization database, similar to mission critical workloads hosted on virtual machines. The choice of hypervisor and its configuration determines the levels of contention with other virtual machines sharing the CPU, memory, and other resources.
  • For BMC TrueSight Capacity Optimization, I/O throughput is a key sizing parameter, as explained in Sizing considerations. Configure the hypervisor layer to ensure that the required I/O throughput is available.

Related topics

Hardware requirements

Software requirements

Visualizer

Migrating Visualizer databases