You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

Column NameColumn Description
PWII_ID

ID of the instance. Columns of XXXX_PWII_INSTANCE_ID have values from the column.

PWII_INSTANCE_NAME

Name of the instance.

PWII_TECHNOLOGY

Two characters defining the technology of the instance (such as OR for Oracle and JE for J2EE).

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 NameColumn 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_VALUECounter value in the sysmonitor table.
SYMP_TYPEMarks 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 NameColumn Description
SYOU_PWII_INSTANCE_ID

ID of the Sybase instance.

SYOU_DATABASE_ID

Name of the database, normalized in table PW_SYDN_DATABASE_NAMES_N.

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 PW_SYKN_LOCKED_OBJECT_NAMES_N.

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 NameColumn Description
SYDU_PWII_INSTANCE_ID

ID of the Sybase instance.

SYDU_DEVICE_ID

ID of the device, normalized in table PW_SYEN_DEVICE_NAMES_N.

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 NameColumn Description
SYSU_PWII_INSTANCE_ID

ID of the Sybase instance.

SYSU_DATABASE_ID

ID of the database, normalized in table PW_SYDN_DATABASE_NAMES_N.

SYSU_SEGMENT_IDID of the segment, normalized in table PW_SYSN_SEGMENT_NAMES_N.
SYSU_PRODUCTION_DATABASE_ID

ID of the database in Sybase.

SYSU_PRODUCTION_SEGMENT_IDID of the segment in Sybase.
SYSU_DEVICE_ID

ID of the device, normalized in table PW_SYEN_DEVICE_NAMES_N.

SYSU_SEGMENT_TYPE

Segment type:

  • 3 = Data only (system and default segments)
  • 4 = Log only
  • 7 = Data and log
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.









IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal
  • No labels