Viewing Dbspaces Statistics

View dbspace size and usage details for a single server, or for a node in a multiplex, including shared temporary dbspaces.

  1. In the Perspective Resources view, select the resource, and select Resource > Monitor Node.
  2. In the left pane of the IQ Node Level Monitor view, select Dbspaces.
  3. In the Dbspaces pane, highlight a dbspace name.
    Details on the dbspace appear in the Dbspace Details, DB Files, and Db File Details panes.
  4. If multiple DB files appear in the DB Files pane, highlight a DB file to show its information in the DB File Details pane.
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 Lists all dbsapces for the selected resource
Dbspaces Details  
  Dbspace Details Displays size information for the selected dbspace in KBs and as a percentage.
  Size Details Displays a pie chart comparing dbspace size in use to size available.
DB Files Lists all db files for the selected dbspace.
Db File Details  
  DB File Details Displays size information for the selected db file in KBs and as a percentage.
  Size Details Displays a pie chart comparing db file size in use to size available.
Related tasks
Viewing Overview Statistics
Viewing All Statistics
Viewing Engine Statistics
Viewing Connection Statistics
Viewing Transaction Statistics
Viewing Store I/O Statistics
Viewing Cache Statistics
Viewing Table Version Statistics
Viewing Operations and Requests Statistics
Viewing Network Statistics
Viewing Table Page Usage Statistics
Viewing Table Lock Statistics
Viewing Deadlock Statistics
Viewing RLV Memory Usage Statistics
Viewing RLV Merge History Statistics
Viewing Monitor Settings Details