DB2 for LUW - 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: Reconnect to the database server
Copy All w/Headers and Row Count: Copies all the tab results from the database to paste the information anywhere else
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 Tablespace: Creates a new Tablespace
Alter Tablespace : Edits the selected Tablespace
Drop Tablespace: Drops the selected Tablespace
Tablespace Properties: Shows properties of selected Tablespace
Create Datafile: Creates a new Datafile
Alter Datafile: Alters the selected Datafile
Drop Datafile: Drops the selected Datafile
Datafile Properties: Shows properties of selected Datafile

Available Operations for Tablespaces 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 Tablespace: Creates a new Tablespace
Alter Tablespace : Edits the selected Tablespace
Drop Tablespace: Drops the selected Tablespace
Tablespace Properties: Shows properties of selected Tablespace

Available Operations for Buffer Pools 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 Buffer Pool: Creates a new Buffer Pool
Alter Buffer Pool: Edits the selected Buffer Pool
Drop Buffer Pool: Drops the selected Buffer Pool
Buffer Pool Properties: View properties of selected Buffer Pool

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 Count: Copies every data from the tab selected to paste the information anywhere else needed
Tablespaces: Chooses the tablespace you want to see the objects from
Type: Chooses the type of object you want to see

Available Operations for Datafiles tab

Refresh : Refreshes all tabs in the storage manager from the database
Reconnect: Reconnecst to the database server
Copy All w/Headers and Row Count: Copies every data from the tab selected to paste the information anywhere else needed
Create Datafile: Creates a new Datafile
Alter Datafile: Alters the selected Datafile
Drop Datafile: Drops the selected Datafile
Datafile Properties: Shows properties of selected Datafile

Tree Tab - Hierarchical display of the Tablespaces and Datafiles.

Name: Name of the Tablespace or Datafile
Path: Path of the Container
Managed By: Tablespace managed by {SYSTEM or DATABASE}
File Type: {FILE or DIRECTORY}
Extent Size: The number of pages of data that will be written to the container before data will be written to next container
Prefetch Size: The maximum number of pages the prefetcher gets from the disk at a time
Size: Space used in the Tablespace
Free: Free space available in the Tablespace
Used: Total space in percentage
 

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

Name: Name of the database
Managed by: Database managed by {SYSTEM or DATABASE}
Definer: Shows the user that defines the database
Created: Date and time the database was created
Data Type: Type of data from the database
Extent Size: The number of pages of data that will be written to the container before data will be written to next container
Perfetch Size: The maximum number of pages the prefetcher gets from the disk at a time
Page Size: The number of table spaces per page
Size: Space used in the Tablespace
Free: Free space used in the Tablespace
Used: Percentage of used space from the database
Overhead: Estimated time required before any data is read into memory
Transfer Rate: Estimated time required to read one page of data into memory
Partition Group Name: Name of the partition group
Buffer Pool Name: Name of the Buffer Pool
Drop Recovery: Shows if drop recovery is active or not

Buffer Pools 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

Name: Name of the device
Partition Group: Name of the partition group
# Pages: Number of pages in the buffer pool
Page Size: Size of the page
Extended Storage: Shows if there is extended storage for each buffer pool
# Block Pages: Number of block pages
Block Size (Pages): Size of block pages

Objects Tab - Provides a detailed information of Tables and Indexes. Contains the usage of space which is helpful to the Users

Type = Table

Table Name: Name of the table
Table Schema: Owner of the Table
Tablespace: Name of the tablespace containing the Table
Type: Specifies whether it is a System or User Table
Data: The size of data
Cardinality: The number of distinct values for a column is the table cardinality
Indexes: The size of the indexes
Pages Used: The number of pages used by the table
Pages Containing Row: The number of pages containing rows
Occupied Blocks: The number of occupied blocks
Rows that Overflow: The number of rows that overflow
Created Date: Date and time when the table was created

Type = Index

Index Name: Name of the index object
Index Schema: Owner of the Index
Table Name: Table for which the index is created
Table Schema: Owner of the Table
Tablespace: Name of the tablespace containing the index
Type: Specifies whether it is a System or User Index
Index Type: Type of the index
Clustered: Specifies whether the index is clustered or not
Unique: Specifies whether the index is unique or not 
Indexes: Size of the Index
Cardinality: The number of distinct values for a column is the index cardinality
Index Leaf Pages: Leaf pages are the lowest level index pages - the pages that contain index entries and information to the corresponding table rows
Cluster Ratio: The degree of data clustering of the index, represented as a percentage between 0 to 100
Sequential Pages: Number of sequential pages
Created Date: Date and time when the index was created

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

Container ID: Name of the database device
Path: Path of the datafile
Tablespace: Name of the Tablespace
Type: Type of the Datafile {FILE or DIRECTORY}
Total Pages: Total number of pages for the datafile
Usable Pages: Number of usable pages allocated for the datafile
File Size: Number allocated for the datafile