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.