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_CPU_TIME_SUM | CPU time consumed by the work processes (in seconds). |
SPBS_ROLLWAIT_TIME_SUM | Time spent in a rolled out status in the application server (in seconds). |
SPBS_PRIVMODE_COUNT_SUM | Number of times a work process ran in private mode. |
SPBS_MEMORY_USED_SUM | Amount of SAP’s extended (shared) memory attributed to the application. |
SPBS_KB_TRANSFERRED_SUM | Amount of database data transferred (in KB). |
SPBS_PHY_READ_COUNT_SUM | Number of read access performed to the database (could not be satisfied from SAP buffers). |
SPBS_DB_SEQ_REQS_SUM | Number of requests for database sequential read. |
SPBS_DB_SEQ_CALL_SUM | Number of actual calls to the database to satisfy a sequential read request. |
SPBS_DB_SEQ_TIME_SUM | Time spent in the database for sequential reads (in seconds). |
SPBS_DB_DIR_REQS_SUM | Number of requests for database direct read. |
SPBS_DB_DIR_CALL_SUM | Number of actual calls to the database to satisfy a direct read request. |
SPBS_DB_DIR_TIME_SUM | Time spent in the database for direct reads (in seconds). |
SPBS_DB_ROWS_READ_SUM | Number of rows read from the database. |
SPBS_DB_READ_REQS_SUM | Total number of database read requests. |
SPBS_DB_REQS_SUM | Total number of database requests. |
PW_SPRS_APPSVR_BUFFER_STAT_T
Application server statistics, also has D, H, W, and M summary levels.
| Column Name | Column Description |
|---|---|
SPRS_PWII_INSTANCE_ID | |
SPRS_TIMESTAMP | |
SPRS_RECEIVED_TIMESTAMP | |
SPRS_MINUTES_COUNT_SUM | |
SPRS_PWHG_ID | |