Viewing Dbspace Statistics

Display dbspace statistics for the selected Sybase IQ server.

  1. In the Perspective Resources window, right-click the resource and select Monitor Node.
  2. In the left pane of the IQ Node Level Monitor view, select DBSpaces.
Note:

Click a column header to sort the data by that column.

To display the information in a chart or table in the full window, select the Maximize icon in the top right of the area.

Hover the mouse pointer over any line or bar graph to display information for that graph.

Area Description

DBSpaces

Displays the dbspaces on the server.

DBSpace details tab

Select a dbspace to display the details for the dbspace, including:

DBSpace size – total size of the dbspace, in kilobytes.

Size in use – amount of space being used in the dbspace, in kilobytes.

Size available – percentage of the dbspace available for use.

Reserved size – reserved space for the dbspace.

Stripe size – size allowed for the stripe.

Number of files – number of files in the dbspace.

Number of RW files – number of read/write files in the dbspace.

Droppable – indicates whether the dbspace file can be dropped.

DBSpace size Details tab

Displays the total size of the dbspace, as well as the percentages of the dbspace that are in use and available.

DBSpace files

Displays the list of DBSpace files that are part of the selected DBSpace.

DBSpace file details tab

Select the a dbspace file to display details for the dbspace file, including:

File size – total size of the dbspace file, in kilobytes.

Size in use – amount of space being used in the file, in kilobytes.

Size available – percentage of the file available for use.

Reserved size – reserved space for the dbspace file.

Stripe size – size allowed for the stripe.

Droppable – indicates whether the dbspace file can be dropped.

DBSpace file size details tab

Displays the size of the selected dbspace file, as well as the percentages of the dbspace file that are in use and available.


Created February 25, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com