Read Performance History Data actions
Read Performance History Data actions retrieve the performance history (ST03) data collected in the specified RFC Destination’s PHD tab. The performance history data may come from a LiveCompare RFC, a native SAP RFC, or an External Data Source.
Usage data for BSP Applications is retrieved into the action’s Application Archive and Application Statistics datasets if this has been configured for an RFC Destination.
The retrieved performance history data is stored in a number of Table datasets, along with a summary of the data retrieved.
Retrieve performance history data from a single RFC Destination
To retrieve performance history data from a single RFC Destinations, set the following action properties.
| Action property | Description |
|---|---|
| Application Archive | A Table dataset that stores application statistics retrieved from the RFC Destination’s PHD tab. Non-printable characters in the retrieved data are replaced with # characters. |
| Application Statistics | A Table dataset that stores a summary of the Application Archive dataset, grouped by object type, object name and account. Non-printable characters in the retrieved data are replaced with # characters. |
| Info | A Table dataset that stores a summary of the data retrieved. |
| RFC Destination | An RFC Destination parameter or dataset whose PHD tab has been used to extract performance history data. |
| Users Archive | A Table dataset that stores users statistics retrieved from the RFC Destination’s PHD tab. Non-printable characters in the retrieved data are replaced with # characters. |
| Users Statistics | A Table dataset that stores a summary of the Users Archive dataset, grouped by object type, object name and account. Non-printable characters in the retrieved data are replaced with # characters. |
Example
Retrieve performance history data from multiple RFC Destinations
To retrieve performance history data from multiple RFC Destinations, set the following action properties.
| Action property | Description |
|---|---|
| Application Archive | A Table dataset that stores application statistics retrieved from the RFC Destination’s PHD tab. Non-printable characters in the retrieved data are replaced with # characters. |
| Application Statistics | A Table dataset that stores a summary of the Application Archive dataset, grouped by object type, object name and account. Non-printable characters in the retrieved data are replaced with # characters. |
| RFC Destinations | A Table parameter or dataset that stores the RFC Destinations from which to retrieve performance history data. The table should have a NAME column which stores the name of each RFC Destination whose PHD tab is to be accessed. |
| Users Archive | A Table dataset that stores users statistics retrieved from the RFC Destination’s PHD tab. Non-printable characters in the retrieved data are replaced with # characters. |
| Users Statistics | A Table dataset that stores a summary of the Users Archive dataset, grouped by object type, object name and account. Non-printable characters in the retrieved data are replaced with # characters. |
The Application Archive dataset stores the following details:
Example
The Read Performance History Data action combines the RFC Destinations set in the RFC Destination and RFC Destinations properties, and aggregates the data stored in the Application Archive, Application Statistics, Users Archive and Users Statistics datasets.
If multiple RFC Destinations are specified, the Read Performance Data action’s Info dataset is not populated. If a single RFC Destination is specified, the action functions as described here.
| Column | Description |
|---|---|
| TYPE | The type of a used object. |
| NAME | The name of the used object. |
| ACCOUNT | This column is set to ‘cumul.’ for SAP kernel releases earlier than 700, and to <blank> for SAP kernel releases 700 and above. |
| COUNT | The usage count for this usage of the object. |
| DATE | The usage date for this usage of the object, in the format YYYYMM01. |
The Application Statistics dataset provides a summary of the Application Archive dataset, grouping the entries by object type, object name and account, and summing the COUNT values for each object. The Application Statistics dataset stores the following details:
| Column | Description |
|---|---|
| TYPE | The type of a used object. |
| NAME | The name of the used object. |
| ACCOUNT | This column is set to ‘cumul.’ for SAP kernel releases earlier than 700, and to <blank> for SAP kernel releases 700 and above. |
| COUNT | The total usage count for the object, obtained from the retrieved performance history data. |
The Info dataset stores the following details. Note that this dataset is not populated if multiple RFC Destinations are specified:
| Column | Description |
|---|---|
| Attr | The name of an attribute. |
| Value | The value of the attribute. |
| Count | For COUNT attributes, this column stores the number of rows in the specified table. |
The Attr column may have the following values:
| Attr | Description |
|---|---|
| SCHEDULE_ON | This attribute is included if a schedule has been enabled for the retrieval of performance history data. |
| SCHEDULE_DAY | This attribute refers to the day for which the retrieval of performance history data is scheduled. |
| SCHEDULE_RUNTIME | This attribute refers to the time (in milliseconds) taken for the scheduled run to complete. |
| SCHEDULE_MONTHS | This attribute refers to the number of months of performance history data retrieved by the scheduled run. |
| COUNT | This attribute refers to the number of rows in the Table dataset specified in the Value column. |
| LAST_TIME_RUN | This attribute refers to the date and time when performance history data was last retrieved for the specified RFC Destination. |
| START_DATE | This attribute refers to the start date used for the retrieval of performance history data. |
| MONTHS | This attribute refers to the number of months of performance history data retrieved. |
| STATUS | This attribute refers to the status of the retrieval operation. |
The Value column may have the following values:
| Value | Description |
|---|---|
| AppRaw | Refers to the raw application statistics retrieved from SAP. |
| AppArch | Refers to the Application Archive dataset. |
| AppSum | Refers to the Application Statistics dataset. |
| UserRaw | Refers to the raw users statistics retrieved from SAP. |
| UserArch | Refers to the Users Archive dataset. |
| UserSum | Refers to the Users Statistics dataset. |
| true | The value of the SCHEDULE_ON attribute. |
| <Date/Time> | The value for the LAST_TIME_RUN attribute. |
| <Date> (YYYYMMDD) | The value for the START_DATE attribute. |
| <Number> | The value for the SCHEDULE_RUNTIME, SCHEDULE_MONTHS and MONTHS attributes. |
| SUCCESS/FAILED | The value of the STATUS attribute. |
The Users Archive dataset stores the following details. Note that users statistics are not available for performance history data obtained from an External Data Source.
| Column | Description |
|---|---|
| TYPE | The type of a used object. |
| NAME | The name of the used object. |
| ACCOUNT | The SAP account that used the object. |
| PERIOD | The month in which the object was used, specified in the format YYYYMM01. |
| COUNT | The usage count for this usage of the object. |
| DATE | The usage date for this usage of the object, in the format YYYYMM01. If performance history data was obtained from an External Data Source, this column is set to the first day of the month when the performance history data was loaded into the PHD tab. |
The Users Statistics dataset provides a summary of the Users Archive dataset, grouping the entries by object type, object name and account, and summing the COUNT values for each object. The Users Statistics dataset stores the following details. Note that users statistics are not available for performance history data obtained from an External Data Source.
| Column | Description |
|---|---|
| TYPE | The type of a used object. |
| NAME | The name of the used object. |
| ACCOUNT | The SAP account that used the object. |
| PERIOD | This column is blank. |
| COUNT | The total usage account for the object. |
In the Users Archive and Users Statistics datasets, the COUNT column is always 0 when data is retrieved from SAP kernel releases earlier than 700.
To examine the details for a Read Performance History Data action, double-click the action node, or select ‘View Details’ from the node’s context menu. The Details screen displays the number of rows written to the Application Archive, Application Statistics, Users Archive and Users Statistics datasets, and the time taken for the action to complete.