PW_PWII_INSTANCE_ID
Defines the instances in the Precise installation.
| Column Name | Column Description |
|---|---|
PWII_ID | The instance ID. Columns of XXXX_PWII_INSTANCE_ID have values from the column. |
PWII_INSTANCE_NAME | The name of the instance. |
PWII_TECHNOLOGY | Two characters defining technology of the instance (such as OR for Oracle and JE for J2EE). |
PWII_SERVER | The name of the server on which the instance is installed. |
PW_SPVS_AVAIL_STAT_LS_T
Calculated table showing total availably. Source tables are PW_SPSS_APPSVR_AVAIL_STAT_T and PW_SPLS_LOCALE_STAT_T.
| Column Name | Column Description |
|---|---|
SPVS_PWII_INSTANCE_ID | The instance ID. |
SPVS_TIMESTAMP | The sampling end time aligned to the time grain (5 minutes). |
SPVS_RECEIVED_TIMESTAMP | The received timestamp. |
SPVS_MINUTES_COUNT_SUM | The minutes count. |
SPVS_PWHG_ID | The hour group in the PW. |
SPVS_APPSVR_KEY | The application server ID, on which the job step occurred. |
SPVS_LOCALE_KEY | The locale ID, on which the step took place. |
SPVS_LOCALE_AVAIL_AVG | The average availability of the destinations in this locale’s locale. |
SPVS_APPSVR_AVAIL_AVG | The average availability of the application server. |
SPVS_REAL_AVAILABILITY_AVG | The average end to end availability. |
SPVS_AVAIL_WITH_DOWNTIME_AVG | The average end to end availability, excluding planned down time in the average. |
PW_SPBS_BATCH_STAT_T
Batch step statistics table.
| Column Name | Column Description |
|---|---|
SPBS_PWII_INSTANCE_ID | The instance ID. |
SPBS_TIMESTAMP | The start time of the batch step. |
SPBS_RECEIVED_TIMESTAMP | The received timestamp. |
SPBS_MINUTES_COUNT_SUM | The minutes count. |
SPBS_PWHG_ID | The hour group in the PW. |
SPBS_HOST_KEY | The host machine ID, on which the transaction took place. |
SPBS_APPSVR_KEY | The application server ID, on which the job step occurred. |
SPBS_CLIENT | The ID of the SAP client executing the step. |
SPBS_PGM_KEY | The ID of the executing ABAP program. |
SPBS_USER_KEY | The ID of the user executing the job. |
SPBS_ROW_ID | The row ID. |
SPBS_JOB_KEY | The ID of the executed job. |
SPBS_STEP_ID | The step order in the executed job. |
SPBS_QUEUE_TIME_SUM | Time spent waiting in the dispatcher for a work process (in seconds). |
SPBS_APP_TIME_SUM | Total time spent in the application server (in seconds). |
SPBS_DB_TIME_SUM | Total time spent in the database (in seconds). |
SPBS_LOAD_TIME_SUM | Total time spent on loading from the database and generate objects like ABAP source code, CUA and screen information. |
SPBS_ENQ_TIME_SUM | Time spent waiting for a resource protected by a SAP lock (in seconds). |
SPBS_ |