Chat now with support
Chat with Support

Spotlight on SAP ASE 2.11 - User Guide

Spotlight on SAP ASE
Background Information Desktop Features Connect to SAP ASE Spotlight® on SAP ASE Drilldowns Spotlight® on SAP ASE Alarms Glossary
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Tablespace Analysis drilldown Containers tab

The Containers tab on the Tablespaces drilldown provides information about the physical storage devices on which the selected tablespace is defined.

Container list contents

The container list provides the following information for each container in a grid format. Since you can choose to hide, display, and rearrange any column in the grid, some columns below might not appear in your current list view, or be in the order they are shown here:

Column

Description

Name Name of the device, directory, or file that is the container.
Partition Partition number of the database partition on which the tablespace or buffer pool is defined.
ID Internal identifier of a container.
Accessible Identifies accessible containers.
Type

Specifies how the container is managed:

  • SMS directory path —System-managed space
  • DMS file spec —Database-managed space
Size Size of a container in megabytes.
Pages Size of a container in pages.
Useable

Percentage of the container space that the database manager can use to store data.

Note: Each device can have only one container defined. To avoid wasted space, you should make the size of the device and the size of the container equivalent. For example, if the device is allocated with 5000 pages and the device container is defined to allocate 3000 pages, then 2000 pages on the device are not useable.

File System ID Unique identifier for a file system.
File System Size Total size of a file system
File System Used Amount of space used on a file system.
Stripe Set Number of the stripe set to which a container belongs.

 

Related topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating