Precise for Sybase tables

PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

Column Name	Column 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 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 `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 Name	Column 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 Name	Column 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_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 `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.

PW_SYSC_STMT_CATALOG

Holds information on statements in the SQL workspace.

Column Name	Column Description
`SYSC_PWII_INSTANCE_ID`	ID of the Sybase instance.
`SYSC_CABINET`	Name of the cabinet in which the statement is stored.
`SYSC_FOLDER`	Name of the folder within the cabinet.
`SYSC_STATEMENT_ID`	Unique identifier (string) assigned to the statement.
`SYSC_WORKSHOP_ID`	Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0.

PW_SYEO_EXPLN_OPER

Holds information on batch access plans.

Column Name	Column Description
`SYEO_PWII_INSTANCE_ID`	ID of the Sybase instance.
`SYEO_DATABASE_NAME`	Name of the database to which the statement belongs.
`SYEO_PARSING_USER`	One of the Sybase users who executed this statement. If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch.
`SYEO_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SYEO_WORKSHOP_HV`	Unique identifier (number) assigned to statements inserted in the SQL workspace. Statements loaded into the PMDB have the value 0.
`SYEO_EXPLAIN_TIME`	Date and time the batch was explained and its access plan was changed.
`SYEO_STATEMENT_ID_IN_BATCH`	A statement number in the first batch sampled running the statement.
`SYEO_OPERATOR_ID`	Sequence order of this operation in the access plan for a statement.
`SYEO_OPERATOR_TYPE`	Physical operation in the access plan.
`SYEO_EXECUTION_ORDER`	Sequence order of this operation in the whole access plan.
`SYEO_TREE_LEVEL`	Tree level of this operation in the access plan.
`SYEO_OBJ_DATABASE_NAME`	Database name of the object accessed in this operation.
`SYEO_OBJ_OWNER_NAME`	Owner of the object accessed in this operation.
`SYEO_OBJ_NAME`	Name of the object accessed in this operation.
`SYEO_OBJ_NAME_ALIAS`	Alias name of the object accessed in this operation.
`SYEO_INDEX_NAME`	Name of the index accessed in this operation. Otherwise NULL.
`SYEO_ADDITIONAL_INFORMATION`	Additional Information provided for this Explain step.
`SYEO_LOGICAL_READS`	The optimizer is estimating how many pages will not be available in cache and will need to be read from disk.
`SYEO_PHYSICAL_READS`	Number of logical reads performed on the specified table. The optimizer is estimating how many pages are likely to be in cache.
`SYEO_ROWS`	Number of rows from the current table that is estimated to satisfy the join.
`SYEO_SCAN_COUNT`	Number of times we scan the table.
`SYEO_LOGICAL_READS_SUB`	Number of logical reads of sub-query.
`SYEO_PHYSICAL_READS_SUB`	Number of physical reads of sub-query.
`SYEO_PARALLEL_IND`	Indicates if the operation is performed in parallel.
`SYEO_LAST_EXPLAIN_IND`	Indicates that this operation belongs to the last explain of the batch.
`SYEO_OPERATOR_COST`	Estimated cost for the operator in the execution plan
`SYEO_AVG_WIDTH`	Estimated average width of row returned by the operator
`SYEO_CPU`	Estimated CPU cost for the operator in the execution plan
`SYEO_CPU_SUB`	Estimated CPU cost for the sub tree starting from the operator
`SYEO_PAGES`	Estimated number of pages accessed by the operator
`SYEO_PREFETCH`	Indication if prefetch performed by the operator
`SYEO_IOSIZE`	Estimated I/O size for the operator
`SYEO_BUFREPLACE`	Buffer replacement strategy used in the operator

Content

Space Tools