BMC Mainframe CDB Extractor

The BMC Helix Continuous Optimization for Mainframes ETL collects data from your mainframe infrastructure, including CPCs, LPARs, z/OS images, user-defined jobs, and applications. 

Before you begin

Before you configure and run this ETL to collect mainframe data, make sure that the following tasks are completed:

Task

Details

Reference

1

Install the following BMC AMI Capacity Management products:

  • Universal Information Exchange (UIE) version 2.0.00 or later - This daily batch job extracts data for mainframe objects.
  • BMC AMI Capacity Database Web Services version 1.7.00 or later  - This is an SQL server database that contains data extracted by the UIE daily job.

2

Subscribe to BMC Helix Continuous Optimization or deploy BMC Helix Continuous Optimization in an on-premises environment. 

3

Install the remote ETL Engine. 

4

Configure the CDB Automator to populate UIE data into a staging database. 

5

Install the BMC Helix Continuous Optimization for Mainframe add-on package. 

To configure and run the ETL

Before you configure BMC Helix Continuous Optimization for Mainframes ETL, you should familiarize yourself with the following BMC Helix Continuous Optimization concepts:

  • Extract, Transform, and Load (ETL)
  • ETL task
  • ETL run configuration

For more information, see Managing and maintaining ETL and System Tasks in the BMC Helix Continuous Optimizationdocumentation.

Related topic

Configuring

Data from UIE is transferred and populated into a CDB staging database. To get this data into the BMC Helix Continuous Optimization Database, you must:

  • Configure the BMC Helix Continuous Optimization for MainframesETL task to pull data from the CDB staging database and populate the data warehouse
  • Run the ETL task manually to prepare various system parameters
  • Schedule the ETL task to run automatically to keep the data warehouse updated with the latest information

The following topics provide more information about configuring BMC Helix Continuous Optimization for Mainframes:

For more information, see Using and Reference.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*