Chat now with support
Chat with Support

Spotlight on SAP ASE 2.11 - Release Notes

Database Analysis drilldown Utilities tab

The Utilities tab on the Database Analysis drilldown shows the status of running utilities for a database or partition. You can use it to monitor the status and progress of backup, load, rebalance, restore, runstats, crash recovery, and rollforward recovery operations. You can also use it to determine whether a utility is degrading database performance.

Columns in the Utilities tab

All columns available for the Utilities tab are listed below in alphabetic order. Initially, the tab contains Spotlight's default column selection. You can choose which columns to display and organize them in any order from left to right using the Organize Columns function. This can be selected from the right-click menu for column headers.

Column

Description

Completed Units

The number of work units that have been completed for the current phase. The value is a running count of completed work units. If the value does not increase over a long period of time, this might indicate that a utility is stalled. (A value is not shown for some utilities.) Check the Work Metric column to see the type of unit used, for example bytes or extents. Check the Total Units column to see the total amount of work for a phase.

Curr Seq

The number of the current phase of a multiphase utility. A number is only shown if a utility contains multiple sequential phases.

ID

The unique identifier for a utility job. An example of the format that might be used for an ID is userid.jobname .

Invoker

The invoker type for a utility. One of the following is shown:

  • User is shown if a utility was invoked by a user.

  • Auto is shown if a utility was invoked automatically by DB2.

Phase Description

A description of the work performed during a utility phase. Phase descriptions include Delete, Load, and Redo.

Phase Start Time

The timestamp for the start of a utility phase. This includes year, month, date, and hour, in that order.

Priority

Utility priority specifies the amount of relative importance of a throttled utility with respect to its throttled peers. A priority of 0 implies that a utility is executing unthrottled . Non-zero priorities must fall in the range of 1-100, with 100 representing the highest priority and 1 representing the lowest.

Start

The timestamp for the time a utility was invoked. This includes year, month, date, and hour, in that order.

State

The current state of a utility. One of the following is shown:

  • Execute is shown when a utility is executing

  • Wait is shown when a utility is waiting for an event to occur before continuing.

  • Error is shown when an error has occurred.

Total Units

The total number of work units in a phase. A value is not shown for some utilities. It is continuously updated for utilities that cannot quantify the total amount of work. Check the Work Metric column to see the type of unit used, for example, bytes or extents. 

Type

The class of a utility. One of the following is shown:

  • Rebalance

  • Backup

  • Runstats

  • Reorg

  • Restore

  • Crash recovery

  • Rollforward recovery

  • Load

  • Restart recreate index

Utility Description

A description of the work being performed by a utility. The format used for a description depends on a utility's class. For example, the description for rebalancer might read "Tablespace ID: 3" to indicate that a rebalancer is working on a tablespace with an ID of 3.  

Work Metric

The type of unit used to measure completed work and total work for a utility. Possible units include bytes and extents. A value is not shown for some utilities.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating