維基書籍
- 問題
- 維基書籍
- 論壇
- 問答集
- 公開專案
搜尋技巧

簡便查詢:#<問題 ID>
範例:#1832

搜尋位於：<使用者名稱>,<名稱>與<姓氏>，就能輕鬆找到成員。

如：搜尋smith將返回結果smith以及adamsmith
您可使用：
- 布爾運算符 ANDOR 和 NOT（必須是大寫，比如 oracle AND debugger、debugger NOT oracle）
- 單個或多個字元通配符（如 de?ug、debug*）
- 分組（如 ((oracle debugger) AND exception)）
- 加引號的詞句（如 "Oracle Debugger"）

#loadingpage {display:none}JavaScript and Cookies must be enabled in order for you to use AquaClusters.here

Aqua Data Studio / nhilam

跟進 827

IDE for Relational Databases

喜愛 0

14.5.3 Storage Manager

DB2 for LUW DBA Tools - Storage Manager Provides manageability of the DB2 for LUW databases, database devices, dump devices and caches, allowing a user to visualize and maintain storage.
Toolbar Operations - Refresh : Will refresh all tabs in the storage manager from the database Reconnect: Reconnect to the Server Copy All w/Headers and Row Count: Will copy the entire information with headers and rows Expand All: Expands all tree nodes in the tree tab Collapse All: Collapses all tree nodes in the tree tab Create Tablespace: Create a new Tablespace Alter Tablespace : Edit the selected Tablespace Drop Tablespace: Drop the selected Tablespace Tablespace Properties: View properties of selected Tablespace Create Datafile: Create a new Datafile Alter Datafile: Alter a new Datafile Datafile Properties: Displays the properties of the 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	DB2 for LUW DBA Tools - Storage Manager - Tree Tab
Tablespaces 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	DB2 for LUW DBA Tools - Storage Manager - Tablespaces Tab
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 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	DB2 for LUW DBA Tools - Storage Manager - Buffer Pools Tab
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 database object Table Schema: Owner of the Table Tablespace: Name of the tablespace containing the Table Type: Specifies whether Sytem 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 rows that overflow Rows that Overflow: The number of rows that overflow Created Date: Date on which 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 Type: Specifies whether Sytem or User Index Tablespace: Name of the tablespace containing the index Buffer Pool: The Bufferpool containing the 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 rows in the index Created On: Date on which the index was created	DB2 for LUW DBA Tools - Storage Manager - Objects Tab
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: {FILE or DIRECTORY} Total Pages: Total number of pages for the datafile Usable Pages: Number usable pages allocated for datafile File Size: Number allocated for the datafile	DB2 for LUW DBA Tools - Storage Manager - Datafiles Tab

評論 (0) 附件 (18)

此清單是空的。

關於 AquaClusters 隱私政策支援 Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017