Sybase - Storage Manager

Toolbar Operations - Depending on the Tab selected, there are different Toolbar Operations available.

Available Operations for Tree Tab
Refresh : Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Size: Shows total size of the database in the selected unit of measurement
Expand All: Expands all tree nodes in the tree tab
Collapse All: Collapses all tree nodes in the tree tab
Create Database: Creates a new database
Alter Database : Edits the selected database
Drop Database: Drops the selected database
Database Properties: Shows properties of selected database
DBCC: Runs DBCC commands on selected database
Move Log: Moves Log to another Device
Checkpoint: Issues a checkpoint for selected database
Set Online: Sets selected database online/offline

Available Operations for Databases Tab
Refresh : Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Size: Shows total size of the database in the selected unit of measurement
Create Database: Creates a new database
Alter Database : Edits the selected database
Drop Database: Drops the selected database
Database Properties: Shows properties of selected database
DBCC: Runs DBCC commands on selected database
Move Log: Moves Log to another Device
Checkpoint: Issues a checkpoint for selected database
Set Online: Sets selected database online/offline

Available Operations for Device Usages tab
Refresh : Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Size: Shows total size of the database in the selected unit of measurement

Available Operations for Objects tab
Refresh : Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Size: Shows total size of the database in the selected unit of measurement
Database: Chooses the database you want to see the objects from
Segment: Chooses the segment from the chosen database
Type: Chooses the type of object you want to see

Available Operations for Database Devices tab
Refresh : Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Size: Shows total size of the database in the selected unit of measurement
Create Database Device: Creates a new database device
Alter Database Device: Edits the selected database device
Drop Database Device: Drops the selected database device
Database Device Properties: Shows properties of selected database device
Reinit Database Device: Reinitializes the selected database device

Available Operations for Dump Devices tab
Refresh : Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Size: Shows total size of the database in the selected unit of measurement
Create Dump Device: Creates a new dump device
Drop Dump Device: Drops selected dump device
Dump Device Properties: Shows properties of selected dump device

Available Operations for Caches tab
Refresh : Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Size: Shows total size of the database in the selected unit of measurement
Create Cache: Creates a new cache
Alter Cache: Edits the selected cache
Drop Cache: Drops the selected cache
Cache Properties : Shows properties of the selected cache

Tree Tab - Displays hierarchically the databases and database devices.

Name: Name of the database or database device
Type: Database device type (Data, Log or Data & Log)
Status: Database status {ONLINE, OFFLINE, READ ONLY, SINGLE USER}
Total Size: Total allocated space for the database/database device
Unreserved: Unreserved space in the database/database device
Total Reserved (Percent): Percentage of reserved space in the database
Data Used: Space used in the database by data
Index Used: Space used in the database by indexes
Unused: Total available (unused) space in the database
Log Used: Space used in the database by logs

Databases Tab - Provides a list of databases and detailed information on each database.

Name: Name of the database
Status: Database status {ONLINE, OFFLINE, READ ONLY, SINGLE USER}
Date Created: Date when the database has been created
Total Size: Total allocated space for the database
Unreserved: Unreserved space in the database
Total Reserved (Percent): Percentage of reserved space in the database
Data Used: Space used in the database by data
Index Used: Space used in the database by indexes
Unused: Total unused space in the database
Log Used: Space used in the database by logs

Device Usages Tab - Provides a list of database devices used by databases and detailed information on their usage. Note: only database devices used by databases are listed

Device Name: Name of the device
Database: Name of the database using this device
Type: Database device type (Data, Log or Data & Log)
Size: Total allocated space for the database device
Unreserved: Unreserved space in the database device
Reserved (Percent): Percentage of reserved space in the database device

Type = Table

Table Name: Name of the database object
Table Schema: Owner of the Table
Segment: Name of the segment containing the Table
Type: Specifies whether Sytem or User Table
Indexes: shows how much space has actually been used by indexes
Data: shows how much space has actually been used by data
Reserved: reports the amount of space that has been allocated to all the tables that have been created in the database
Unused: shows the amount of space that has been reserved but not yet used by existing table
Row Count: The number of rows in the table
Lock Type: Indicates the type of Lock associated with the table
Created Date: Date on which the table was created

Type = Index

Index Name: Name of the index object
Index Schema: Owner of the Index
Segment: Name of the segment where the index is contained
Table Name: Name of the database object  
Clustered: Indicates whether the index is clustered or not
Unique: Indicates whether the index is unique or not
Data: Shows how much space has actually been used by data
Indexes: Shows how much space has actually been used by indexes
Reserved: Reports the amount of space that has been allocated to all the indexes that have been created in the database
Unused: Shows the amount of space that has been reserved but not yet used by existing index
Created Date: Date on which the index was created

Database Devices Tab - Provides a list of database devices and detailed information on each database device.

Name: Name of the database device
Size: Total allocated space for the database device
Free: Total available (free) space in the database device
Used (Percent): Percentage of used space in the database device
Physical Name: Name of the corresponding physical device
Device Number: Number allocated for the database device

Dump Devices Tab - Provides a list of dump devices and detailed information on each dump device.

Name: Name of the dump device
Type: Dump device type (Disk or Tape)
Physical Name: Name of the corresponding physical device

Caches Tab - Provides a list of database caches and detailed information on each cache.

Cache Name: Name of the database cache
Type: Mode of the cache (default, mixed, logonly)
Status: Status of the cache (active, pending, deleted)
Configured: Amount of memory initially configured for the cache
Run Size: Current amount of memory in the cache
Overhead: Memory used by the cache paramater