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.
Details | Displays two charts:
|
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.