15.4.3 Specification rules for the names of columns and tables
The following are the specification rules for names of columns and tables for when you extract performance data of Performance Management by using the PFM ODBC driver:
-
Column name
database-id_field-name
-
Table name#
product-type-identifier_record-name
- #
-
When a PFM - Agent or PFM - RM has multiple data models, the data model version must be specified for the table name, for all except the latest data model.
When you need to specify the data model version, specify the table name as follows:
product-type-identifier_record-name_data-mode-version
Items to be specified are as follows:
- database-id
-
For the database ID, specify an identifier that indicates the type of the Store database.
Identifiers that can be specified and their meanings are as follows:
-
PI: Indicates a record of the PI record type.
-
PD: Indicates a record of the PD record type.
You may also be able to specify another database ID depending on the PFM - Agent or PFM - RM. The database ID consists of the initials of the record type. For details on record types of each PFM - Agent or PFM - RM, see the chapters giving an overview of PFM - Agent or PFM - RM in the PFM - Agent or PFM - RM manuals.
-
- field-name
-
Use the PFM - Manager name to specify the field name of each record where performance data collected by PFM - Agent or PFM - RM is stored. For details on field names of each record, see the chapters that describe records in the PFM - Agent or PFM - RM manuals.
- product-type-identifier
-
Specify an identifier that indicates the type of each Performance Management program. For details on product type identifiers of each PFM - Agent or PFM - RM, see the lists of identifiers in the Appendixes of the PFM - Agent or PFM - RM manuals.
- record-name
-
Use the PFM - Manager name to specify the name of the record where performance data collected by the PFM - Agent or PFM - RM is stored. For details on record names, see the appropriate chapters that describe records in each PFM - Agent or PFM - RM manual.
- data-model-version
-
When the PFM - Agent or PFM - RM has multiple data models, the data model versions need to be specified. For details on the data model versions, see the appropriate chapters that describe records in each PFM - Agent or PFM - RM manual.
When you extract the Active Transactions (ACTIVE_TRANSACTIONS) field of the Activity Summary (PD_PDAS) record by using the PFM - Agent for Oracle, specify the names of a column and table as follows:
-
Column name: PD_ACTIVE_TRANSACTIONS
-
Table name: ORACLE_PD_PDAS
Also, when you extract the Active Transactions (ACTIVE_TRANSACTIONS) field of the Activity Summary (PD_PDAS) record by using the PFM - Agent for Oracle with multiple data models, specify the table name as follows:
-
Table name: ORACLE_PD_PDAS_4.0