PW_PWII_INSTANCE_ID
Defines the instances in the Precise installation.
Column Name | Column Description |
---|---|
PWII_ID | ID of the instance. Columns of |
PWII_INSTANCE_NAME | Name of the instance. |
PWII_TECHNOLOGY | Two characters defining the technology of the instance (such as |
PWII_SERVER | Name of the server on which the instance is installed. |
PW_SYMP_MONITORS_PREV
Stores the last and current collected Sysmonitor counter values. Serves the Statistics process for the calculation of the delta values of the counters.
Column Name | Column Description |
---|---|
SYMP_PWII_INSTANCE_ID | ID of the counter instance. |
SYMP_GROUP_NAME | Group that includes the counter. |
SYMP_FIELD_NAME | Counter name in the sysmonitor table. |
SYMP_FIELD_ID | Counter ID in the sysmonitor table. |
SYMP_VALUE | Counter value in the sysmonitor table. |
SYMP_TYPE | Marks if this is the last or current counter's value. |
PW_SYOU_OBJECTS_SPACE_USAGE_D
Holds statistics on the objects space. By default, this process runs every 24 hours.
- The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.
Column Name | Column Description |
---|---|
SYOU_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYOU_DATABASE_ID | Name of the database, normalized in table |
SYOU_PRODUCTION_DATABASE_ID | ID of the database in Sybase. |
SYOU_OBJECT_ID | ID of the table. |
SYOU_FULL_OBJECT_ID | The full object ID, normalized in table |
SYOU_INDEX_ID | ID of the index. |
SYOU_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are in GMT. On all other summary levels, the time part is zeroed. |
SYOU_PWHG_ID | Hour group ID. |
SYOU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYOU_O_ALL_ALLOC_MAX | Size in Megabytes allocated to the object. |
SYOU_O_ALL_USED_MAX | Size in Megabytes used by the object. |
SYOU_O_TEXT_ALLOC_MAX | Size in Megabytes allocated to text pages of the object. |
SYOU_O_TEXT_USED_MAX | Size in Megabytes used for text pages of the object. |
SYOU_O_DATA_USED_MAX | Size of data pages in Megabytes used by the objects. |
SYOU_O_INDEX_ALLOC_MAX | Size in Megabytes allocated to the indexes of the object. |
SYOU_O_INDEX_USER_MAX | Size in Megabytes used by the indexes of the object. |
SYOU_ROW_COUNT_MAX | Number of rows the table has. |
SYOU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYDU_DEVICES_SPACE_USAGE_D
Holds statistics on the space of devices. By default, this process runs every 24 hours.
- The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.
Column Name | Column Description |
---|---|
SYDU_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYDU_DEVICE_ID | ID of the device, normalized in table |
SYDU_TIMESTAMP | Date the statistic was sampled. The time part is zeroed because the data is collected once a day. |
SYDU_PWHG_ID | Hour group ID. |
SYDU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYDU_DEVICE_SIZE_MAX | Maximum device size in Megabytes. |
SYDU_SPACE_USED_MAX | Maximum space used in Megabytes. |
SYDU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYSU_SEGMENTS_SPACE_USAGE_D
Holds statistics on the space of segments. By default, this process runs every 24 hours.
- The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.
Column Name | Column Description |
---|---|
SYSU_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYSU_DATABASE_ID | ID of the database, normalized in table |
SYSU_SEGMENT_ID | ID of the segment, normalized in table PW_SYSN_SEGMENT_NAMES_N . |
SYSU_PRODUCTION_DATABASE_ID | ID of the database in Sybase. |
SYSU_PRODUCTION_SEGMENT_ID | ID of the segment in Sybase. |
SYSU_DEVICE_ID | ID of the device, normalized in table |
SYSU_SEGMENT_TYPE | Segment type:
|
SYSU_TIMESTAMP | Date the statistic was sampled. The time part is zeroed because the data is collected once a day. |
SYSU_PWHG_ID | Hour group ID. |
SYSU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYSU_SEGMENT_SIZE_MAX | Maximum segment size in Megabytes. |
SYSU_SPACE_FREE_MAX | Maximum free space size in Megabytes. |
SYSU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |