予定されていた保守を実行中のため、サポートサイトでのフォームの送信が一時的に利用できません。 すぐにサポートが必要な場合は、テクニカルサポートまでお問い合わせください。 ご不便をおかけして申し訳ありません。
オンラインヘルプの参照
登録の完了
サインイン
価格設定をリクエスト
営業担当に連絡
製品バンドルが選択されました。 リクエストにより良く対応できるように、個別の製品を選択していただけますか? *
現在、テクニカル・サポート・エンジニアはお客様のチャットに対応できません。 迅速にサービスを受けられるよう、サービス・リクエスト・フォームを使用して
お客様の説明に基づいて、以下の記事が問題解決に役立つ可能性があります。
The following table describes the metrics that are collected for each database configuration parameter.
DATABASE_NAME
The name of the monitored database.
NAME
The configuration parameter name.
CURRENT_VALUE
The current value of the configuration parameter stored in memory, in partition/member 0.
VALUE_FLAGS
Provides information about the current value of the configuration parameter. Values:
NONE — No additional information
AUTOMATIC — The configuration parameter has been set to automatic
DEFERRED_VALUE
The value of the configuration parameter on disk. For some database configuration parameters, changes only take effect when the database is reactivated. In such cases, all applications must first disconnect from the database. (If the database was enabled, then it must be deactivated and then reactivated.) The changes take effect with the next connection to the database.
DATATYPE
The configuration parameter data type.
MODIFIED
Indicates whether the value changed since the last collection.
If the value changed on disk, but the instance is still using the previous value, the value of this parameter is 0.
The following table describes the metrics that are collected for each database instance configuration parameter.
INSTANCE_NAME
The database instance name.
Provides specific information about the current value of the configuration parameter. Values:
Indicates whether the value changed since last collection.
The following table describes the metrics that are collected for each database instance registry variable.
The name of the monitored instance.
REG_VAR_NAME
The name of the DB2 registry variable.
REG_VAR_VALUE
The current value of the DB2 registry variable in memory.
REG_VAR_ON_DISK_VALUE
The current setting of the DB2 registry variable on disk. For DB2 versions prior to version 10, the current setting is not available, so the value of this parameter is “N/A”.
LEVEL
Indicates the level at which the DB2 registry variable acquires its value. The possible return values and the corresponding levels that they represent are:
I — Instance
G — Global
N — Database partition
E — Environment
The following table provides a list of the Database Tablespaces BP metrics that are collected, and a description for each.
DB_NAME
TBSP_NAME
The tablespace name.
DBPARTITIONNUM
The database partition from which the data was retrieved for this row.
TABLESPACE_TYPE
This interface returns a text identifier, based on the definitions in sqlutil.h, which is one of the following values:
DMS
SMS
TABLESPACE_ID
The tablespace ID.
POOL_ASYNC_DATA_READS
The number of data pages read in from the tablespace containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of tablespaces.
POOL_ASYNC_DATA_WRITES
The number of times a buffer pool data page was physically written to disk by either an asynchronous page cleaner or a prefetcher. A prefetcher may have written dirty pages to disk to make space for the pages being prefetched.
POOL_ASYNC_INDEX_READS
The number of index pages read in from the tablespace containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of tablespaces.
POOL_ASYNC_INDEX_WRITES
The number of times a buffer pool index page was physically written to disk by either an asynchronous page cleaner or a prefetcher. A prefetcher may have written dirty pages to disk to make space for the pages being prefetched.
POOL_ASYNC_DATA_READ_REQS
The number of read requests made by the prefetcher to the operating system. These requests are typically large block IOs of multiple pages.
POOL_ASYNC_READ_TIME
The total amount of time spent reading in data and index pages from the tablespace containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of tablespaces. This value is given in milliseconds.
POOL_ASYNC_WRITE_TIME
The total elapsed time spent writing data or index pages from the buffer pool to disk by database manager page cleaners.
POOL_DATA_L_READS
The number of data pages that have been requested from the buffer pool (logical) for regular and large tablespaces.
POOL_DATA_P_READS
The number of data pages read in from the tablespace containers (physical) for regular and large tablespaces.
POOL_DATA_WRITES
The number of times a buffer pool data page was physically written to disk.
POOL_INDEX_L_READS
The number of index pages that have been requested from the buffer pool (logical) for regular and large tablespaces.
POOL_INDEX_P_READS
The number of index pages read in from the tablespace containers (physical) for regular and large tablespaces.
POOL_INDEX_WRITES
The number of times a buffer pool index page was physically written to disk.
Like a data page, a buffer pool index page is written to disk for the following reasons:
POOL_READ_TIME
The total amount of time spent reading in data and index pages from the tablespace containers (physical) for all types of tablespaces. This value is given in milliseconds.
POOL_WRITE_TIME
Provides the total amount of time spent physically writing data or index pages from the buffer pool to disk. The elapsed time is given in milliseconds.
DIRECT_READ_REQS
The number of requests to perform a direct read of one or more sectors of data.
DIRECT_READ_TIME
The elapsed time (in milliseconds) required to perform the direct reads.
DIRECT_READS
The number of read operations that do not use the buffer pool.
DIRECT_WRITE_REQS
The number of requests to perform a direct write of one or more sectors of data.
DIRECT_WRITE_TIME
The elapsed time (in milliseconds) required to perform the direct writes.
DIRECT_WRITES
The number of write operations that do not use the buffer pool.
INDEX_HIT_RATIO
The percentage of index reads that were carried out from the buffer pool for the selected tablespace without having to perform physical reads.
100 * (1 - (POOL_INDEX_P_READS / (POOL_INDEX_L_READS) ) )
BUFFER_POOL_HIT_RATIO
The total hit ratio calculation for the selected tablespace.
100 * (1 - (
(POOL_DATA_P_READS +
POOL_INDEX_P_READS) /
(POOL_DATA_L_READS +
POOL_INDEX_L_READS) ) )
Quest *product*のオンラインサポートヘルプは、関連会社のサポートサイトで参照できます。「Continue(続行)」をクリックすると、*product*の適切なサポートコンテンツとアシスタンスへ移動します。
The document was helpful.
評価を選択
I easily found the information I needed.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center
Quest Softwareポータルでは、IE8、9、10のサポートを終了しました。ブラウザを最新バージョンのInternet ExplorerまたはChromeにアップグレードすることをお勧めします。
IE 11へのアップグレード: ここをクリック
Chromeへのアップグレード: ここをクリック
の優れたセルフサービス機能を最大限に活用していただけるよう、IE8、9、10以外のブラウザをぜひご利用ください。