Segment Statistics and Details

Interpret the Segment information for Adaptive Server.

The Segment Statistics and Details screen displays information about Adaptive Server segments. In Adaptive Server cluster configurations, selecting the Global tab displays information about segments on global databases. Selecting the Local tab displays information about segments on local, temporary databases, grouped by cluster instances.

The Segments screen displays information about all segments for this Adaptive Server. The charts on this screen are populated by data from the collection_ase_all_client_kpis, covering the current trend period.

The Segments table lists each segment used by this Adaptive Server and gives the name of the database that uses the segment, the database’s size and unused space on the segment, and the number of thresholds.

The tabs at the bottom of the screen show information about the segment selected in the Segments table.

Tabs on the Segments Screen
Details	Displays two charts: A pie chart showing current space usage on the selected segment. Includes used and unused space, in megabytes, and as percentages of the available space on the segment. The title above the chart indicates the total available space. Space Usage – a line graph showing changes in space usage on the selected segment over the current trend period.
Devices Used	Displays devices included in the selected segment and the size of each device, in megabytes. Click a name in the Device column to switch to the Devices monitoring view’s information for that device.
Used Tables	Displays tables allocated on the selected segment and the reserved size of each table, in kilobytes.
Used Indexes	Displays indexes allocated on the selected segment and the table associated with each index.

For more information on segments, see the chapter on creating and using segments in the Adaptive Server System Administration Guide, Volume 2.