Page tree
    Skip to end of metadata
    Go to start of metadata

    "Moviri Integrator for TrueSight Capacity Optimization – IBM Tivoli Monitoring" allows collecting information from IBM Tivoli Monitoring and it is able to extract and summarize resources performance data, configuration data and relations between infrastructure entities.

    Requirements

    Supported versions of data source software

    • Tivoli Enterprise Monitoring 6.2.1
    • Tivoli Enterprise Monitoring 6.2.2
    • Tivoli Enterprise Monitoring 6.2.3
    • Tivoli Enterprise Monitoring 6.3.x

    Supported configurations of data source software

    Moviri Integrator for TrueSight Capacity Optimization - IBM Tivoli Monitoring supports ITM mandatorily configured with Tivoli Data Warehouse component. The supported DBMS versions are:

    • Oracle Database 11g, 12c
    • DB2 version 9, 10
    • SQL Server 2005, 2008, 2012

    Moviri Integrator for TrueSight Capacity Optimization - IBM Tivoli Monitoring is able to import metrics generated by four Tivoli Agents "families", each including the following Tivoli Agents

    • NT: Windows OS Agent
    • LZ: Linux OS Agent
    • KUX: Unix OS Agent
    • AIX: AIX Premium Agent, CEC Base Agent, HMC Base Agent

    Installation

    Downloading the additional package

    ETL Module is made available in the form of an additional component, which you may download from BMC electronic distribution site (EPD) or retrieve from your content media.

    Installing the additional package

     To install the connector in the form of a TrueSight Capacity Optimization additional package, refer to Performing system maintenance tasks instructions.

     

    Datasource Check and Configuration

    This section provides outlines the process required to setup the data source for the integration.

    Preparing to connect to the data source software

    As a first step, please ensure that the correct version of Tivoli is installed. You can perform this check from the "About" section of the Tivoli Enterprise Portal (as in Figure 9).

     

     
    Please also ensure that the DBMS version is compliant with the requirement shown in Section 2.4.
    First you have to ensure data is properly collected through the deployment for each target platform of the correct Tivoli Agent Type, i.e.:

    • Windows Servers: Windows OS Agent
    • Linux Servers: Linux OS Agent
    • Generic Unix Servers: Unix OS Agent, AIX Premium Agent
    • PowerVM AIX Hosts and Guests: AIX Premium Agent, CEC Base Agent, HMC Base Agent

    For Agents' configuration and deployment refer to Tivoli official documentation and coordinate with Tivoli administrator.
    As an additional requirement for the connector, Tivoli needs to store historical metrics in the Tivoli Data Warehouse. History Collection needs to be configured with the proper aging parameters.
    For all Tivoli Data Warehouse tables listed proper historical collection needs to be setup. Examples are shown in figures below for Linux monitored systems, for Windows monitored systems and for Unix monitored systems.






     


     
    Ensure also that the Summarization and Pruning Agent is up and running.



     

    Connector configuration

    Connector configuration attributes

    There are three sections (tabs) in the ETL run configuration page where the behaviour of "Moviri Integrator for BMC TrueSight Capacity Optimization - IBM Tivoli Monitoring" can be specified:

    • Tivoli – Data Selection
    • Tivoli – Settings
    • Tivoli - Workloads
    • Connection Parameters (common TrueSight Capacity Optimization setting)

    Tivoli – Data Selection


     

     
    In "Tivoli – Data Selection" section the following can be specified:

    • Agent families to import:
      • AIX: data collected by AIX Premium Agent, CEC Base Agent, HMC Base Agent
      • Linux: data collected by Linux OS Agent
      • Unix: data collected by Unix OS Agent
      • Windows: data collected by Windows OS Agent
    • Import workload data only: if set to "yes" only process level data will be extracted from Tivoli Data Warehouse and then aggregated by the connector into "workloads"
    • Sql expressions applied to include systems: a ";" separated list of string that will be used to limit the servers imported by the connector. In the example above ("cat%") only servers whose name starts with "cat" will be imported by the connector
    • Sql expressions applied to exclude systems: a ";" separated list of string that will be used to exclude servers. In the example above ("%ux") servers ending in "ux" will be skipped by the connector
    • Tables to be imported: a ";" separated list of Tivoli Data Warehouse tables that limit the sources where the connector extracts data from. A complete list of the tables that the connector is able to manage is listed in next paragraphs. This list can be further reduced if "Import workload data only" setting is set to "yes"
    • Tables to be excluded: a ";" separated list of Tivoli Data Warehouse tables that are not to be considered by the connector. A complete list of the tables that the connector is able to manage is listed in next paragraphs.

    Tivoli - Settings

     
    In "Tivoli – Settings" section the following can be specified:

    • Schema for TDW tables: the database user owner of the Tivoli Data Warehouse tables
    • Default last counter: the default starting timestamp of the data import (format is YYYY-MM-DD HH24:MI:SS). This will be used only the first time each Tivoli Data Warehouse table is managed by the connector, all subsequent times the connector will start from where it ended the previous time.
    • Data resolution: Raw for importing raw data as recorded by Tivoli agents in the Tivoli Data Warehouse (typically 15 minutes), Hour for hourly data, Day for daily. Aggregation is not performed by the connector, the connector selects from the Warehouse the already computed level of aggregation.
    • Load statistics: (available for resolution greater than Raw) if set to "yes" minimum and maximum statistics are transferred to BMC TrueSight Capacity Optimization together with the default statistic of each metric
    • Max Duration for raw samples: duration of raw data is computed as the timestamp difference between subsequent samples. This property prevents inactivity periods of monitored servers to be incorrectly imported as long-duration samples.
    • Max days to import in a single run: maximum number of days to be imported for data at Raw resolution (Default value: 15)
    • BMC TrueSight Capacity Optimization Tree Entities:
      • Update hierarchy (track entities and remove from the tree if not imported): this mode aims at replicating what found in the Tivoli Data Warehouse in the BMC TrueSight Capacity Optimization Tree. The population of servers is inspected across subsequent executions of the ETL: what is missing will be removed from the tree (not deleted), what is new will be added.
      • Only add imported entities: this mode simply add to the tree the entities discovered during the execution. This mode is useful when you have entities with intermittent presence. If "Update hierarchy" mode would be used instead, intermittent entities (the ones not present every day, e.g. "workloads") will appear and disappear from the tree according to the fact they have data in the latest execution.
    • Assign timezone shifts to samples: makes the ETL associate each sample with the time zone indication on the time zone it refers to, if such information is available in ITM.

    Tivoli - Workloads

     

     
    In "Tivoli – Workloads" section the following can be specified:

    • For each imported workload force attachment of host to BMC TrueSight Capacity Optimization tree: in BMC TrueSight Capacity Optimization both the workloads and the hosts that contain them are entities, the relationship between a host and its workloads will be always loaded whereas
      • if this property is set to "yes": the hosts will be directly attached to the root domain associated to the ETL (defined in the "Object relationships" tab of the run configuration page). If the host happen to be an LPAR: the LPAR will be attached to its frame if that information is imported by this ETL (or another one sharing the lookup table) AND the LPAR will be attached to the root as well
      • if this property is set to "no": the hosts will not be attached to anything. Hosts (and therefore attached workloads) will appear in the BMC TrueSight Capacity Optimization tree only if this ETL (or another one sharing the lookup table) will attach them to some domain or parent system
    • Workload lists: a ";" separated list of the workloads definition. Each process found in the processes tables in Tivoli Data Warehouse is sequentially checked against each workload definition, as soon as one definition matches the process is labeled to belong to that workload. If no definition is matched process is labeled to belong to the default "zzz" workload, defined for each server
      • Criteria: for each dimension a regular expression can be specified. For a process to belong to a workload all defined criteria needs to be satisfied (AND logical operation).
        • user [USR]
        • command [CMD]
        • command fullpath [CMDPATH]
        • command arguments [ARGS]
        • server [SERVER]
        • zone [ZONE]
      • label: if criteria are met the label can be dynamically computed on the basis of the regular expression criteria, using regular expression capturing groups. In the example above a process started by the oracle user whose command is oracleDBSID1 will be placed in the "db_instance_DBSID1" workload, while a process started by the oracle user whose command is oracleDBSID2 will be placed in the "db_instance_DBSID2" workload. If no macro (%[DIMENSION]_GROUP1

    Historical data extraction

    In order to perform a historical recovery of data, please use the default, "lastcounter"-based mechanism of CO, i.e. change the current value of the desired lastcounter. "Max days" property can be useful during historical imports of raw data, enabling the split the overall load in smaller chunks.
    If the ETL is newly created and has no lastcounter defined, the "default lastcounter" is used.
    The pre-condition for an historical extraction is the presence of data inside the Tivoli data source.

    Workloads import notes

    Process-level detail can constitute a large amount of data volume, both unaggregated on Tivoli Data Warehouse side, and aggregated as workloads on the BMC TrueSight Capacity Optimization side. A general indication is to use this feature for highly shared critical server only, and for a limited period of time only.
    Following what described in the present section a suggested setting to import workload metrics would be:

    • One (or more) ETL importing all data except the workloads. This can be achieved by specifying an empty workload list in the "Tivoli – Workloads" tab of the run configuration page. Set this ETL to "Update hierarchy (track entities and remove from the tree if not imported)", so that dismissed entities are removed from BMC TrueSight Capacity Optimization tree once not present any more in Tivoli
    • One (or more) ETL importing only workloads. This can be achieved by setting "Import workload data only" in the "Tivoli – Data Selection" tab to "yes". Set this ETL to "Only add imported entities", so that "intermittent" workloads remain visible under the BMC TrueSight Capacity Optimization tree

    This configuration also helps balancing the tasks load.

    Supported Platforms

    Moviri Integrator for TrueSight Capacity Optimization connector supports following platforms and BMC TrueSight Capacity Optimization Entity Types:

    • Supported platforms:
      • Standalone OS Instance
      • AIX Power VM Hosts and LPARs
      • Solaris Containers
    • Supported BMC TrueSight Capacity Optimization Entity Type:
      • System (Generic)
      • AIX LPAR
      • AIX SPLPAR
      • AIX Virtual Host
      • Solaris Zone
      • Solaris Virtual Host
      • Resource Pool

    Supported metrics are listed in the paragraph Configuration and Performance Metrics Mapping

    Troubleshooting

    Missing data can also represent a common problem; as shown above, in this case a WARNING would be associated to the ETL task. This can be due to a number of scenarios, among which:

    • Data is not available on Tivoli. In this case, it is recommended to check the Tivoli Enterprise Portal, and to run reports associated to the desired systems and time ranges to check for the existence of data. Possible reasons for their absence might be an erroneous status of the distributed Agents (a correct one is presented below) or of the Summarization and Pruning Agent (a correct one is presented below), or an incorrect configuration of the data aging period.

     

     
    • Data is available on Tivoli, but the ETL is not able to extract it. For Raw data, this can be due to the lack of overlap of the "extraction window" (which starts from the date shown either in the property "Default Last Counter", or in the actual lastcounter for that table, and whose timespan is listed in the property "Max days to import at Raw Resolution"). In the screenshot below, the ETL logs it is trying to extract data from March 01 to March 15, in an environment where the data collection was started on March 20. In any case, it is possible to manually run the actual queries used for data collection against the Tivoli DataWarehouse, as they are displayed in the ETL log (when the ETL Log Level is set to 5 – Medium), in order to ascertain the presence of the data in that desired time range.


    Configuration and Performance Metrics Mapping

    The ETL connects to the Tivoli Warehouse instance and extracts data from a set of defined tables. The metrics supported by the ETL are stored in tables populated by the following Tivoli agent “families”:

    • NT: Windows OS Agent
    • LZ: Linux OS Agent
    • KUX: Unix OS Agent
    • AIX: AIX Premium Agent, CEC Base Agent, HMC Base Agent

    Below, data for the respective “families” are acquired by the ETL. The connector on the basis of reported ones may compute additional BMC TrueSight Capacity Optimizationmetrics.

    Metrics with * were previously custom, remapped as standard after v 4.4.00

    Agent Family

    ITM Table

    ITM Metric

    BMC TrueSight Capacity OptimizationEntity

    BMC TrueSight Capacity OptimizationMetric

    Factor

    AIX

    KPH_MANAGED_CECS

    Allocated_Mem_MB

    AIX Virtual Host

    MEM_USED

     

    AIX

    KPH_MANAGED_CECS

    CEC_Mfg

    AIX Virtual Host

    HW_VENDOR

     

    AIX

    KPH_MANAGED_CECS

    CEC_Model

    AIX Virtual Host

    HW_MODEL

     

    AIX

    KPH_MANAGED_CECS

    CEC_SN

    AIX Virtual Host

    SERIAL_NUMBER

     

    AIX

    KPH_MANAGED_CECS

    CEC_name

    AIX Virtual Host

    DS_SYSNM

     

    AIX

    KPH_MANAGED_CECS

    CPU_Total

    AIX Virtual Host

    CPU_NUM

     

    AIX

    KPH_MANAGED_CECS

    Total_Mem_MB

    AIX Virtual Host

    TOTAL_REAL_MEM

    1048576

    AIX

    KPH_MANAGED_LPARS

    CEC_Mfg

    AIX LPAR, AIX SPLPAR

    HW_VENDOR

     

    AIX

    KPH_MANAGED_LPARS

    CEC_Model

    AIX LPAR, AIX SPLPAR

    HW_MODEL

     

    AIX

    KPH_MANAGED_LPARS

    CEC_name

    AIX LPAR, AIX SPLPAR

    null

     

    AIX

    KPH_MANAGED_LPARS

    Hostname

    AIX LPAR, AIX SPLPAR

    DS_SYSNM

     

    AIX

    KPH_MANAGED_LPARS

    OS_Version

    AIX LPAR, AIX SPLPAR

    OS_TYPE

     

    AIX

    KPK_CPU_POOLS

    ACUIP

    Resource Pool

    null

     

    AIX

    KPK_CPU_POOLS

    Available_CPU_Units_in_Pool

    Resource Pool

    null

     

    AIX

    KPK_CPU_POOLS

    CPU_Units_Consumed

    Resource Pool

    CPU_ENTC_CONS

     

    AIX

    KPK_CPU_POOLS

    Machine_ID

    Resource Pool

    null

     

    AIX

    KPK_CPU_POOLS

    Maximum_Pool_Capacity

    Resource Pool

    CPU_NUM

     

    AIX

    KPK_CPU_POOLS

    PoolID

    Resource Pool

    DS_SYSNM

     

    AIX

    KPK_CPU_POOLS

    Pool_Entitlement

    Resource Pool

    CPU_ENTC

     

    AIX

    KPK_GLOBAL_CEC

    Machine_ID

    AIX Virtual Host

      

    AIX

    KPK_GLOBAL_CEC

    Name

    AIX Virtual Host

    DS_SYSNM

     

    AIX

    KPK_MON_UNMON_ALLOC

    CEC_Name

    AIX Virtual Host

    DS_SYSNM

     

    AIX

    KPK_MON_UNMON_ALLOC

    Total_Monitored

    AIX Virtual Host

    GM_NUM

     

    AIX

    KPK_MON_UNMON_ALLOC

    Total_Monitored_CPU_Used_Pct

    AIX Virtual Host

    CPU_UTIL

    0,01

    AIX

    KPK_PER_LPAR

    Hostname

    AIX LPAR, AIX SPLPAR

    DS_SYSNM

     

    AIX

    KPK_PER_LPAR

    PoolID

    AIX LPAR, AIX SPLPAR

    null

     

    AIX

    KPK_PER_LPAR

    Shared_Mode

    AIX LPAR, AIX SPLPAR

    null

     

    AIX

    KPX_CPU_SUMMARY

    AOFG

    AIX LPAR, AIX SPLPAR, Generic

    CPU_MHZ

    1000

    AIX

    KPX_CPU_SUMMARY

    IO_Wait_CPU_Pct

    AIX LPAR, AIX SPLPAR, Generic

    CPU_UTIL_WAIO

    0,01

    AIX

    KPX_CPU_SUMMARY

    Node

    AIX LPAR, AIX SPLPAR, Generic

    DS_SYSNM

     

    AIX

    KPX_CPU_SUMMARY

    Number_of_CPUs

    AIX LPAR, AIX SPLPAR, Generic

    CPU_NUM

     

    AIX

    KPX_CPU_SUMMARY

    System_CPU_Pct

    AIX LPAR, AIX SPLPAR, Generic

    CPU_UTIL_SYSTEM

    0,01

    AIX

    KPX_CPU_SUMMARY

    System_Software_Version

    AIX LPAR, AIX SPLPAR, Generic

    OS_VER

     

    AIX

    KPX_CPU_SUMMARY

    User_CPU_Pct

    AIX LPAR, AIX SPLPAR, Generic

    CPU_UTIL_USER

    0,01

    AIX

    KPX_CPU_SUMMARY

    User_CPU_Pct + System_CPU_Pct

    AIX LPAR, AIX SPLPAR, Generic

    CPU_UTIL

    0,01

    AIX

    KPX_DISKS

    Active_Disk_Pct

    AIX LPAR, AIX SPLPAR, Generic

    BYDISK_UTIL

    0,01

    AIX

    KPX_DISKS

    Avg_Read_Transfer_MS

    AIX LPAR, AIX SPLPAR, Generic

    null

     

    AIX

    KPX_DISKS

    Avg_ServiceQ_Size

    AIX LPAR, AIX SPLPAR, Generic

    BYDISK_QUEUE_SIZE

     

    AIX

    KPX_DISKS

    Avg_Write_Transfer_MS

    AIX LPAR, AIX SPLPAR, Generic

    null

     

    AIX

    KPX_DISKS

    Name

    AIX LPAR, AIX SPLPAR, Generic

    DSKNM

     

    AIX

    KPX_DISKS

    Node

    AIX LPAR, AIX SPLPAR, Generic

    DS_SYSNM

     

    AIX

    KPX_DISKS

    Read_KB_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    BYDISK_READ_RATE

    1024

    AIX

    KPX_DISKS

    Read_Transfers_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    BYDISK_PHYS_IO_READ_RATE

     

    AIX

    KPX_DISKS

    Transfers_Bytes_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    BYDISK_TRANSFER_RATE

     

    AIX

    KPX_DISKS

    Transfers_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    BYDISK_PHYS_IO_RATE

     

    AIX

    KPX_DISKS

    Write_Transfers_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    BYDISK_PHYS_IO_WRITE_RATE

     

    AIX

    KPX_DISKS

    Written_KB_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    BYDISK_WRITE_RATE

    1024

    AIX

    KPX_DISKS

    (Avg_Read_Transfer_MS * Read_Transfers_per_Sec +

    Avg_Write_Transfer_MS * Write_Transfers_per_Sec) /

    (Read_Transfers_per_Sec + Write_Transfers_per_Sec)

    AIX LPAR, AIX SPLPAR, Generic

    BYDISK_WRITE_RATE

    0,001

    AIX

    KPX_FILE_SYSTEMS

    Free_MB

    AIX LPAR, AIX SPLPAR, Generic

    BYFS_FREE

    1269760

    AIX

    KPX_FILE_SYSTEMS

    Mount_Point

    AIX LPAR, AIX SPLPAR, Generic

    FSNM

     

    AIX

    KPX_FILE_SYSTEMS

    Node

    AIX LPAR, AIX SPLPAR, Generic

    DS_SYSNM

     

    AIX

    KPX_FILE_SYSTEMS

    Size_MB

    AIX LPAR, AIX SPLPAR, Generic

    BYFS_SIZE

    1269760

    AIX

    KPX_FILE_SYSTEMS

    Used_MB

    AIX LPAR, AIX SPLPAR, Generic

    BYFS_USED

    1269760

    AIX

    KPX_FILE_SYSTEMS

    Used_Pct

    AIX LPAR, AIX SPLPAR, Generic

    BYFS_USED_SPACE_PCT

    0,01

    AIX

    KPX_LOGICAL_PARTITION

    Capacity_Weight

    AIX LPAR, AIX SPLPAR

    CPU_SHARES

     

    AIX

    KPX_LOGICAL_PARTITION

    Capped_Mode

    AIX LPAR, AIX SPLPAR

    LP_MODE

     

    AIX

    KPX_LOGICAL_PARTITION

    Entitlement

    AIX LPAR, AIX SPLPAR

    CPU_ENTC

     

    AIX

    KPX_LOGICAL_PARTITION

    Entitlement_Used_Pct

    AIX LPAR, AIX SPLPAR

    CPU_ENT_UTIL

    0,01

    AIX

    KPX_LOGICAL_PARTITION

    Hostname

    AIX LPAR, AIX SPLPAR

    HOST_NAME

     

    AIX

    KPX_LOGICAL_PARTITION

    IO_Wait_CPU_Pct

    AIX LPAR, AIX SPLPAR

    CPU_UTIL_WAIO

    0,01

    AIX

    KPX_LOGICAL_PARTITION

    Max_Virt_CPUs

    AIX LPAR, AIX SPLPAR

    LP_VCPU_MAX

     

    AIX

    KPX_LOGICAL_PARTITION

    Min_Virt_CPUs

    AIX LPAR, AIX SPLPAR

    LP_VCPU_MIN

     

    AIX

    KPX_LOGICAL_PARTITION

    Node

    AIX LPAR, AIX SPLPAR

    DS_SYSNM

     

    AIX

    KPX_LOGICAL_PARTITION

    Number_of_Logical_CPUs

    AIX LPAR, AIX SPLPAR

    CPU_NUM

     

    AIX

    KPX_LOGICAL_PARTITION

    Number_of_Virtual_CPUs

    AIX LPAR, AIX SPLPAR

    LP_CPU_ACTVP

     

    AIX

    KPX_LOGICAL_PARTITION

    Physical_CPU_Units_Used

    AIX LPAR, AIX SPLPAR

    CPU_ENTC_CONS

     

    AIX

    KPX_LOGICAL_PARTITION

    Shared_Mode

    AIX LPAR, AIX SPLPAR

    LP_TYPE

     

    AIX

    KPX_LOGICAL_PARTITION

    System_CPU_Pct

    AIX LPAR, AIX SPLPAR

    CPU_UTIL_SYSTEM

    0,01

    AIX

    KPX_LOGICAL_PARTITION

    User_CPU_Pct

    AIX LPAR, AIX SPLPAR

    CPU_UTIL_USER

    0,01

    AIX

    KPX_LOGICAL_PARTITION

    User_CPU_Pct + System_CPU_Pct

    AIX LPAR, AIX SPLPAR

    CPU_UTIL

    0,01

    AIX

    KPX_NETWORK_ADAPTERS_RATES

    Bytes_Recvd_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    BYIF_IN_BYTE_RATE

     

    AIX

    KPX_NETWORK_ADAPTERS_RATES

    Bytes_Sent_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    BYIF_OUT_BYTE_RATE

     

    AIX

    KPX_NETWORK_ADAPTERS_RATES

    Name

    AIX LPAR, AIX SPLPAR, Generic

    NETNM

     

    AIX

    KPX_NETWORK_ADAPTERS_RATES

    Node

    AIX LPAR, AIX SPLPAR, Generic

    DS_SYSNM

     

    AIX

    KPX_NETWORK_ADAPTERS_RATES

    Pkts_Recv_Errors_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    BYIF_IN_ERROR_RATE

     

    AIX

    KPX_NETWORK_ADAPTERS_RATES

    Pkts_Recvd_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    BYIF_IN_PKT_RATE

     

    AIX

    KPX_NETWORK_ADAPTERS_RATES

    Pkts_Sent_Errors_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    BYIF_OUT_ERROR_RATE

     

    AIX

    KPX_NETWORK_ADAPTERS_RATES

    Pkts_Sent_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    BYIF_OUT_PKT_RATE

     

    AIX

    KPX_NETWORK_INTERFACES

    IP_Address

    AIX LPAR, AIX SPLPAR, Generic

    BYIF_IP_ADDRESS

     

    AIX

    KPX_NETWORK_INTERFACES

    Name

    AIX LPAR, AIX SPLPAR, Generic

    NETNM

     

    AIX

    KPX_NETWORK_INTERFACES

    Node

    AIX LPAR, AIX SPLPAR, Generic

    DS_SYSNM

     

    AIX

    KPX_NETWORK_INTERFACES

    State

    AIX LPAR, AIX SPLPAR, Generic

    BYIF_STATUS

     

    AIX

    KPX_PAGING_SPACE

    Pages_Read_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    MEM_PAGE_IN_RATE

     

    AIX

    KPX_PAGING_SPACE

    Pages_Written_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    MEM_PAGE_OUT_RATE

     

    AIX

    KPX_PAGING_SPACE

    Pages_Read_per_Sec +Pages_Written_per_Sec

    AIX LPAR, AIX SPLPAR, Generic

    MEM_PAGE_RATE

     

    AIX

    KPX_PHYSICAL_MEMORY

    Free_Memory_MB

    AIX LPAR, AIX SPLPAR, Generic

    MEM_FREE

    1048576

    AIX

    KPX_PHYSICAL_MEMORY

    Memory_Size_MB

    AIX LPAR, AIX SPLPAR, Generic

    TOTAL_REAL_MEM

    1048576

    AIX

    KPX_PHYSICAL_MEMORY

    Node

    AIX LPAR, AIX SPLPAR, Generic

    DS_SYSNM

     

    AIX

    KPX_PHYSICAL_MEMORY

    Non_Comp_Memory

    AIX LPAR, AIX SPLPAR, Generic

    MEM_CACHED

    4096

    AIX

    KPX_PHYSICAL_MEMORY

    Used_Memory_MB

    AIX LPAR, AIX SPLPAR, Generic

    MEM_CONSUMED

    1048576

    AIX

    KPX_PHYSICAL_MEMORY

    Used_Memory_Pct

    AIX LPAR, AIX SPLPAR, Generic

    MEM_UTIL

    0,01

    AIX

    KPX_PHYSICAL_MEMORY

    Non_Comp_Memory / Memory_Size_MB

    AIX LPAR, AIX SPLPAR, Generic

    MEM_UTIL

    4 / 1024 = 0,00390625

    KUX

    Disk

    Mount_Point

    Generic, Solaris Virtual Host

    DSKNM

     

    KUX

    Disk

    Size

    Generic, Solaris Virtual Host

    BYLDISK_SIZE

    1024

    KUX

    Disk

    Space_Available

    Generic, Solaris Virtual Host

    BYLDISK_FREE_SPACE

    1024

    KUX

    Disk

    Space_Used

    Generic, Solaris Virtual Host

    BYLDISK_USED_SPACE

    1024

    KUX

    Disk

    Space_Used_Percent

    Generic, Solaris Virtual Host

    BYLDISK_USED_SPACE_PCT

    0,01

    KUX

    Disk

    System_Name

    Generic, Solaris Virtual Host

    DS_SYSNM

     

    KUX

    Disk_Performance

    Avg_Serv

    Generic, Solaris Virtual Host

    BYDISK_SERVICE_TIME

    0,001

    KUX

    Disk_Performance

    Avg_Wait

    Generic, Solaris Virtual Host

    BYDISK_QUEUE_TIME

    0,001

    KUX

    Disk_Performance

    Busy_Percent

    Generic, Solaris Virtual Host

    BYDISK_UTIL

    0,01

    KUX

    Disk_Performance

    Disk_Name

    Generic, Solaris Virtual Host

    DSKNM

     

    KUX

    Disk_Performance

    System_Name

    Generic, Solaris Virtual Host

    DS_SYSNM

     

    KUX

    Disk_Performance

    Transfer_Rate

    Generic, Solaris Virtual Host

    BYDISK_PHYS_IO_RATE

     

    KUX

    Disk_Performance

    Transferred_Bytes

    Generic, Solaris Virtual Host

    BYDISK_TRANSFER_RATE

    1024

    KUX

    Machine_Information

    Hardware_Manufacturer

    Generic, Solaris Virtual Host

    HW_VENDOR

     

    KUX

    Machine_Information

    Hardware_Model

    Generic, Solaris Virtual Host

    HW_MODEL

     

    KUX

    Machine_Information

    Number_of_Physical_Processors

    Generic, Solaris Virtual Host

    CPU_NUM

     

    KUX

    Machine_Information

    PHYSPROC

    Generic, Solaris Virtual Host

    CPU_NUM

     

    KUX

    Machine_Information

    Processor_Megahertz

    Generic, Solaris Virtual Host

    CPU_MHZ

     

    KUX

    Machine_Information

    System_Name

    Generic, Solaris Virtual Host

    DS_SYSNM

     

    KUX

    Network

    Frames_Received

    Generic, Solaris Virtual Host

    BYIF_IN_PKT_RATE

     

    KUX

    Network

    Frames_Transmitted

    Generic, Solaris Virtual Host

    BYIF_OUT_PKT_RATE

     

    KUX

    Network

    Input_Errors

    Generic, Solaris Virtual Host

    BYIF_IN_ERROR_RATE

     

    KUX

    Network

    Interface_Status

    Generic, Solaris Virtual Host

    BYIF_STATUS

     

    KUX

    Network

    Network_Interface_Name

    Generic, Solaris Virtual Host

    NETNM

     

    KUX

    Network

    Output_Errors

    Generic, Solaris Virtual Host

    BYIF_OUT_ERROR_RATE

     

    KUX

    Network

    System_Name

    Generic, Solaris Virtual Host

    DS_SYSNM

     

    KUX

    Network

    Transmission_Unit_Maximum

    Generic, Solaris Virtual Host

    BYIF_PKT_MAX_SIZE

     

    KUX

    Solaris_Zones

    CPU_Shares

    Solaris Zone

    CPU_SHARES

     

    KUX

    Solaris_Zones

    Name

    Solaris Zone

    DS_SYSNM

     

    KUX

    Solaris_Zones

    Physical_Memory

    Solaris Zone

    MEM_USED

    0,01

    KUX

    Solaris_Zones

    System_Name

    Solaris Zone

    null

     

    KUX

    Solaris_Zones

    Total_CPUs

    Solaris Zone

    LCPU_NUM

     

    KUX

    Solaris_Zones

    Virtual_Memory

    Solaris Zone

    MEM_ACTIVE_VIRTUAL

    0,01

    KUX

    Solaris_Zones

    Zone_CPU_Usage

    Solaris Zone

    CPU_UTIL

    0,01

    KUX

    System

    Active_Virtual_Memory

    Generic, Solaris Virtual Host

    MEM_ACTIVE_VIRTUAL

    1024

    KUX

    System

    CPU_Busy

    Generic, Solaris Virtual Host

    CPU_UTIL

    0,01

    KUX

    System

    Idle_CPU

    Generic, Solaris Virtual Host

    CPU_UTIL_IDLE

    0,01

    KUX

    System

    Net_Address

    Generic, Solaris Virtual Host

    NET_IP_ADDRESS

     

    KUX

    System

    System_CPU

    Generic, Solaris Virtual Host

    CPU_UTIL_SYSTEM

    0,01

    KUX

    System

    System_Name

    Generic, Solaris Virtual Host

    DS_SYSNM

     

    KUX

    System

    Type

    Generic, Solaris Virtual Host

    OS_TYPE

     

    KUX

    System

    User_CPU

    Generic, Solaris Virtual Host

    CPU_UTIL_USER

    0,01

    KUX

    System

    Version

    Generic, Solaris Virtual Host

    OS_VER

     

    KUX

    System

    Wait_I/O

    Generic, Solaris Virtual Host

    CPU_UTIL_WAIO

    0,01

    KUX

    Unix_Memory

    Avail_Real_Mem_MB

    Generic, Solaris Virtual Host

    MEM_FREE

    1048576

    KUX

    Unix_Memory

    Avail_Swap_Space_MB

    Generic, Solaris Virtual Host

    SWAP_SPACE_FREE

    1048576

    KUX

    Unix_Memory

    Page_Ins

    Generic, Solaris Virtual Host

    MEM_PAGE_IN_RATE

     

    KUX

    Unix_Memory

    Page_Outs

    Generic, Solaris Virtual Host

    MEM_PAGE_OUT_RATE

     

    KUX

    Unix_Memory

    Page_Scan

    Generic, Solaris Virtual Host

    MEM_PAGE_SCAN_RATE

     

    KUX

    Unix_Memory

    System_Name

    Generic, Solaris Virtual Host

    DS_SYSNM

     

    KUX

    Unix_Memory

    Total_Real_Mem_MB

    Generic, Solaris Virtual Host

    TOTAL_REAL_MEM

    1048576

    KUX

    Unix_Memory

    Total_Swap_Space_MB

    Generic, Solaris Virtual Host

    SWAP_SPACE_TOT

    1048576

    KUX

    Unix_Memory

    Used_Real_Mem_Pct

    Generic, Solaris Virtual Host

    MEM_UTIL

    0,01

    KUX

    Unix_Memory

    Used_Swap_Space_MB

    Generic, Solaris Virtual Host

    SWAP_SPACE_USED

    1048576

    KUX

    Unix_Memory

    Used_Swap_Space_Pct

    Generic, Solaris Virtual Host

    SWAP_SPACE_UTIL

    0,01

    LZ

    KLZ_CPU

    Busy_CPU

    Generic

    CPU_UTIL

    0,01

    LZ

    KLZ_CPU

    Idle_CPU

    Generic

    CPU_UTIL_IDLE

    0,01

    LZ

    KLZ_CPU

    System_CPU

    Generic

    CPU_UTIL_SYSTEM

    0,01

    LZ

    KLZ_CPU

    System_Name

    Generic

    DS_SYSNM

     

    LZ

    KLZ_CPU

    User_CPU

    Generic

    CPU_UTIL_USER

    0,01

    LZ

    KLZ_CPU

    Wait_IO_CPU

    Generic

    CPU_UTIL_WAIO

    0,01

    LZ

    KLZ_System_Statistics

    Ctxt_Switches_per_sec

    Generic

    CPU_CTX_SWITCHES

     

    LZ

    KLZ_System_Statistics

    Pages_paged_in_per_sec

    Generic

    MEM_PAGE_IN_RATE

     

    LZ

    KLZ_System_Statistics

    Pages_paged_out_per_sec

    Generic

    MEM_PAGE_OUT_RATE

     

    LZ

    KLZ_System_Statistics

    Pages_paged_in_per_sec + Pages_paged_out_per_sec

    Generic

    MEM_PAGE_RATE

     

    LZ

    KLZ_System_Statistics

    Pages_Swap_in_per_sec

    Generic

    MEM_SWAP_IN_RATE

     

    LZ

    KLZ_System_Statistics

    Pages_Swap_out_per_sec

    Generic

    MEM_SWAP_OUT_RATE

     

    LZ

    KLZ_Disk

    Disk_Free

    Generic

    BYLDISK_FREE_SPACE

    1048576

    LZ

    KLZ_Disk

    Disk_Used

    Generic

    BYLDISK_USED_SPACE

    1048576

    LZ

    KLZ_Disk

    Disk_Used_Percent

    Generic

    BYLDISK_USED_SPACE_PCT

    0,01

    LZ

    KLZ_Disk

    Mount_Point

    Generic

    DSKNM

     

    LZ

    KLZ_Disk

    Size

    Generic

    BYLDISK_SIZE

    1048576

    LZ

    KLZ_Disk

    System_Name

    Generic

    DS_SYSNM

     

    LZ

    KLZ_Disk_IO

    Dev_Name

    Generic

    DSKNM

     

    LZ

    KLZ_Disk_IO

    System_Name

    Generic

    DS_SYSNM

     

    LZ

    KLZ_Disk_IO

    Transfers_per_sec

    Generic

    BYDISK_PHYS_IO_RATE

     

    LZ

    KLZ_Network

    Bytes_Received_per_sec

    Generic

    BYIF_IN_BYTE_RATE

     

    LZ

    KLZ_Network

    Bytes_Transmitted_per_sec

    Generic

    BYIF_OUT_BYTE_RATE

     

    LZ

    KLZ_Network

    Input_Error_Percent

    Generic

    BYIF_IN_PKT_ERR_PCT

    0,01

    LZ

    KLZ_Network

    Input_Error_rate

    Generic

    BYIF_IN_ERROR_RATE

    0,016666667

    LZ

    KLZ_Network

    Interface_IP_Address

    Generic

    BYIF_IP_ADDRESS

     

    LZ

    KLZ_Network

    Interface_Status

    Generic

    BYIF_STATUS

     

    LZ

    KLZ_Network

    Network_Interface_Name

    Generic

    NETNM

     

    LZ

    KLZ_Network

    Output_Error_Percent

    Generic

    BYIF_OUT_PKT_ERR_PCT

    0,01

    LZ

    KLZ_Network

    Output_Error_rate

    Generic

    BYIF_OUT_ERROR_RATE

    0,016666667

    LZ

    KLZ_Network

    Packets_Received_per_sec

    Generic

    BYIF_IN_PKT_RATE

     

    LZ

    KLZ_Network

    Packets_Transmitted_per_sec

    Generic

    BYIF_OUT_PKT_RATE

     

    LZ

    KLZ_Network

    System_Name

    Generic

    DS_SYSNM

     

    LZ

    KLZ_Network

    Transmission_Unit_Maximum

    Generic

    BYIF_PKT_MAX_SIZE

     

    LZ

    KLZ_VM_Stats

    Memory_Cached

    Generic

    MEM_CACHED

    1048576

    LZ

    KLZ_VM_Stats

    Memory_Free

    Generic

    MEM_FREE

    1048576

    LZ

    KLZ_VM_Stats

    Memory_Used_Pct

    Generic

    MEM_UTIL

    0,01

    LZ

    KLZ_VM_Stats

    Memory_in_Buffers

    Generic

    MEM_BUFFERED

    1048576

    LZ

    KLZ_VM_Stats

    Swap_Space_Free

    Generic

    SWAP_SPACE_FREE

    1048576

    LZ

    KLZ_VM_Stats

    Swap_Space_Used

    Generic

    SWAP_SPACE_USED

    1048576

    LZ

    KLZ_VM_Stats

    Swap_Used_Pct

    Generic

    SWAP_SPACE_UTIL

    0,01

    LZ

    KLZ_VM_Stats

    System_Name

    Generic

    DS_SYSNM

     

    LZ

    KLZ_VM_Stats

    Total_Memory

    Generic

    TOTAL_REAL_MEM

    1048576

    LZ

    KLZ_VM_Stats

    Total_Swap_Space

    Generic

    SWAP_SPACE_TOT

    1048576

    LZ

    Linux_CPU_Config

    Clock_Speed

    Generic

    CPU_MHZ

     

    LZ

    Linux_CPU_Config

    Model_Name

    Generic

    CPU_MODEL

     

    LZ

    Linux_CPU_Config

    System_Name

    Generic

    DS_SYSNM

     

    LZ

    Linux_CPU_Config

    Vendor_ID

    Generic

    CPU_VENDOR

     

    LZ

    Linux_Machine_Information

    Hardware_Brand

    Generic

    HW_VENDOR

     

    LZ

    Linux_Machine_Information

    Hardware_Model

    Generic

    HW_MODEL

     

    LZ

    Linux_Machine_Information

    Number_of_Processors_Online

    Generic

    CPU_NUM

     

    LZ

    Linux_Machine_Information

    ONLNCPU

    Generic

    CPU_NUM

     

    LZ

    Linux_Machine_Information

    System_Name

    Generic

    DS_SYSNM

     

    NT

    Network_Interface

    BANDUTLPCT

    Generic

    BYIF_UTIL

    0,01

    NT

    Network_Interface

    Bytes_Received/sec

    Generic

    BYIF_IN_BYTE_RATE

     

    NT

    Network_Interface

    Bytes_Sent/sec

    Generic

    BYIF_OUT_BYTE_RATE

     

    NT

    Network_Interface

    Current_Bandwidth

    Generic

    BYIF_BANDWIDTH

     

    NT

    Network_Interface

    IPv4_Address

    Generic

    BYIF_IP_ADDRESS

     

    NT

    Network_Interface

    Network_Interface_Instance

    Generic

    NETNM

     

    NT

    Network_Interface

    Output_Queue_Length

    Generic

    BYIF_OUT_QUEUE_LENGTH

     

    NT

    Network_Interface

    Packets/sec

    Generic

    BYIF_TRANSFER_RATE

     

    NT

    Network_Interface

    Packets_Received/sec

    Generic

    BYIF_IN_PKT_RATE

     

    NT

    Network_Interface

    Packets_Received_Unicast/sec

    Generic

    BYIF_IN_UNI_PKT_RATE

     

    NT

    Network_Interface

    Packets_Sent/sec

    Generic

    BYIF_OUT_PKT_RATE

     

    NT

    Network_Interface

    Packets_Sent_Unicast/sec

    Generic

    BYIF_OUT_UNI_PKT_RATE

     

    NT

    Network_Interface

    System_Name

    Generic

    DS_SYSNM

     

    NT

    NT_Logical_Disk

    %_Disk_Time

    Generic

    BYLDISK_UTIL

    0,01

    NT

    NT_Logical_Disk

    %_Used

    Generic

    BYLDISK_USED_SPACE_PCT

    0,01

    NT

    NT_Logical_Disk

    Avg_Disk_Queue_Length

    Generic

    _to_compute_BYDISK_QUEUE_TIME

     

    NT

    NT_Logical_Disk

    Disk_Bytes/Sec_64

    Generic

    BYDISK_TRANSFER_RATE

     

    NT

    NT_Logical_Disk

    Disk_Name

    Generic

    DSKNM

     

    NT

    NT_Logical_Disk

    Disk_Read_Bytes/Sec_64

    Generic

    BYDISK_READ_RATE

     

    NT

    NT_Logical_Disk

    Disk_Reads/Sec

    Generic

    BYDISK_PHYS_IO_READ_RATE

     

    NT

    NT_Logical_Disk

    Disk_Transfers/Sec

    Generic

    BYDISK_PHYS_IO_RATE

     

    NT

    NT_Logical_Disk

    Disk_Write_Bytes/Sec_64

    Generic

    BYDISK_WRITE_RATE

     

    NT

    NT_Logical_Disk

    Disk_Writes/Sec

    Generic

    BYDISK_PHYS_IO_WRITE_RATE

     

    NT

    NT_Logical_Disk

    Avg_Disk_Queue_Length / Disk_Transfers/Sec

    Generic

    BYDISK_QUEUE_TIME

     

    NT

    NT_Logical_Disk

    Free_Megabytes

    Generic

    BYLDISK_FREE_SPACE

    1048576

    NT

    NT_Logical_Disk

    Server_Name

    Generic

    DS_SYSNM

     

    NT

    NT_Logical_Disk

    Total_Size

    Generic

    BYLDISK_SIZE

    1048576

    NT

    NT_Memory_64

    Available_Bytes

    Generic

    MEM_FREE

     

    NT

    NT_Memory_64

    Cache_Bytes

    Generic

    MEM_CACHED

     

    NT

    NT_Memory_64

    Pages/sec

    Generic

    MEM_PAGE_RATE

     

    NT

    NT_Memory_64

    Pages_Input/Sec

    Generic

    MEM_PAGE_IN_RATE

     

    NT

    NT_Memory_64

    Pages_Output/Sec

    Generic

    MEM_PAGE_OUT_RATE

     

    NT

    NT_Memory_64

    Server_Name

    Generic

    DS_SYSNM

     

    NT

    NT_Memory_64

    Total_Memory_Bytes

    Generic

    TOTAL_REAL_MEM

     

    NT

    NT_Memory_64

    1 - (Available_Bytes / Total_Memory_Bytes)

    Generic

    MEM_UTIL

     

    NT

    NT_Physical_Disk

    %_Disk_Time

    Generic

    BYDISK_UTIL

    0,01

    NT

    NT_Physical_Disk

    Avg_Disk_Queue_Length

    Generic

    _to_compute_BYDISK_QUEUE_TIME

     

    NT

    NT_Physical_Disk

    Disk_Bytes/Sec_64

    Generic

    BYDISK_TRANSFER_RATE

     

    NT

    NT_Physical_Disk

    Disk_Name

    Generic

    DSKNM

     

    NT

    NT_Physical_Disk

    Disk_Read_Bytes/Sec_64

    Generic

    BYDISK_READ_RATE

     

    NT

    NT_Physical_Disk

    Disk_Reads/Sec

    Generic

    BYDISK_PHYS_IO_READ_RATE

     

    NT

    NT_Physical_Disk

    Disk_Transfers/Sec

    Generic

    BYDISK_PHYS_IO_RATE

     

    NT

    NT_Physical_Disk

    Disk_Write_Bytes/Sec_64

    Generic

    BYDISK_WRITE_RATE

     

    NT

    NT_Physical_Disk

    Disk_Writes/Sec

    Generic

    BYDISK_PHYS_IO_WRITE_RATE

     

    NT

    NT_Physical_Disk

    Avg_Disk_Queue_Length / Disk_Transfers/Sec

    Generic

    BYDISK_QUEUE_TIME

     

    NT

    NT_Physical_Disk

    Server_Name

    Generic

    DS_SYSNM

     

    NT

    NT_Processor

    %_Privileged_Time

    Generic

    CPU_UTIL_SYSTEM

    0,01

    NT

    NT_Processor

    %_Processor_Time

    Generic

    CPU_UTIL

    0,01

    NT

    NT_Processor

    %_User_Time

    Generic

    CPU_UTIL_USER

    0,01

    NT

    NT_Processor

    Server_Name

    Generic

    DS_SYSNM

     

    NT

    NT_Processor_Information

    Maximum_Clock_Speed

    Generic

    CPU_MHZ

     

    NT

    NT_Processor_Information

    Processor_Name

    Generic

    CPU_MODEL

     

    NT

    NT_Processor_Information

    System_Name

    Generic

    DS_SYSNM

     

    NT

    NT_System

    Network_Address

    Generic

    NET_IP_ADRESS

     

    NT

    NT_System

    Number_of_Processors

    Generic

    CPU_NUM

     

    NT

    NT_System

    Operating_System_Type

    Generic

    OS_TYPE

     

    NT

    NT_System

    Operating_System_Version

    Generic

    OS_VER

     

    NT

    NT_System

    Processor_Queue_Length

    Generic

    CPU_RUN_QUEUE

     

    NT

    NT_System

    Processor_Type

    Generic

    CPU_FAMILY

     

    NT

    NT_System

    Server_Name

    Generic

    DS_SYSNM

     

     

    Process-level data present in the following tables

    • KLZ_Process (LZ)
    • KPX_PROCESSES_DETAIL (AIX)
    • Process (KUX)
    • NT_Process_64 (NT)

    Which are aggregated by the connector to compute the following workload metrics:

    • W_ALIVE_PROC*
    • W_CPU_UTIL
    • W_MEM_ALL (Previously W_MEM_RESIDENT_SIZE_C)
    • W_MEM_VIRTUAL_SIZE*
    • W_THREADS*

    Lookup Fields

    Moviri Integrator for BMC TrueSight Capacity Optimizationconnector uses standard BMC TrueSight Capacity OptimizationETL lookup mechanism. One single entry is used as entity identifier: Lookup field = “DEFAULT”. The following table shows, for each supported entity, what information is used as lookup value field.

     

    BMC TrueSight Capacity OptimizationEntity Type

    Lookup value field

    System (Generic)

    hostname

    AIX LPAR

    hostname

    AIX SPLPAR

    hostname

    AIX Virtual Host

    serial number

    Solaris Zone

    hostname

    Solaris Zone (global)

    hostname\global

    Solaris Virtual Host

    hostname

    Resource Pool

    pool id : serial number

     

     

    Here below some lookup tables as example:

     


    Object Relationships

    The ETL arranges the collected systems under a domain of choice. Additionally the following relationships are imported from the datasource:

    • Solaris Virtual Host contains Solaris Zone
    • AIX Virtual Host contains Resource Pool
    • AIX Virtual Host contains AIX LPAR
    • Resource Pool contains AIX SPLPAR
    • Generic contains Workload

    BMC TrueSight Capacity Optimizationautomatically creates a hierarchy rule associated to the ETL to process the Object-Relationship data.