Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
라이브 도움말 보기
등록 완료
로그인
가격 산정 요청
영업 담당자에게 문의
제품 번들을 선택했습니다. 귀하의 요청에 더 적합한 서비스를 제공해 드릴 수 있도록 개별 제품을 선택해 주십시오. *
지금은 채팅에 회신할 수 있는 기술 지원 엔지니어가 없습니다. 즉각적인 서비스를 받으려면 당사의 서비스 요청 양식을 사용하여 요청을 제출하십시오.
다음 문서의 설명에 따라 문제를 해결할 수 있습니다.
The following table provides a list of the Database Tablespaces BP metrics that are collected, and a description for each.
DB_NAME
The name of the monitored database.
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) ) )
The following table provides a list of the FCM Activity metrics that are collected, and a description for each.
CONNECTION_STATUS
This interface returns a text identifier, based on the definition in sqlmon.h, which is one of the following values:
INACTIVE
ACTIVE
CONGESTED
CONNECTION_AVAILABILITY
The agent's connection FCM availability. Possible values are either 0 (INACTIVE or CONGESTED) or 100 (ACTIVE).
FCM_DBPARTITIONNUM
The database partition number to which data was sent or from which data was received (as per the TOTAL_BUFFERS_SENT and TOTAL_BUFFERS_RCVD columns).
TOTAL_BUFFERS_SENT
The total number of FCM buffers sent from the current node to the remote node.
High values of this metric can indicate the need to redistribute the database or to move tables to reduce the inter-node traffic.
TOTAL_BUFFERS_RCVD
The total number of FCM buffers received by the node issuing the GET SNAPSHOT command, from the node identified by the NODE_NUMBER (see the db2nodes.cfg file).
You can use this element to measure the level of traffic between the current node and the remote node. If the total number of FCM buffers received from this node is high, you may want to redistribute the database or move tables to reduce the inter-node traffic.
TOTAL_BUFFERS_SENT_RATE
The rate of the total number of FCM buffer pages sent from the current node to the remote node.
This parameter can be used for measuring the level of traffic between the current and remote nodes. High inter-node traffic can be addressed by redistributing the database or moving tables to reduce the inter-node traffic.
TOTAL_BUFFERS_RCVD_RATE
The rate of the total number of FCM buffer pages received by the current node from the remote node.
The following table provides a list of the FS Database Storage metrics that are collected, and a description for each.
FS_ID
This element shows the unique identification number provided by the operating system for a file system pointed to by a storage path.
FS_TOTAL_SIZE
This element shows the capacity (MB) of a file system pointed to by a storage path.
FS_USED_SIZE
This element shows the amount of space (MB) already used on a file system pointed to by a storage path.
STO_PATH_FREE_SIZE
This element shows the amount of free space (MB) available on a file system pointed to by a storage path. If multiple storage paths point to the same file system, the free size is not divided among them.
The following table provides a list of the FS Database Storage Summary metrics that are collected, and a description for each.
OVERALL_FS_TOTAL_SIZE
This element shows the capacity (MB) per database of a file system pointed to by a storage path.
OVERALL_FS_USED_SIZE
This element shows the amount of space (MB) per database already used on a file system pointed to by a storage path.
OVERALL_STO_PATH_FREE_SIZE
This element shows the amount of free space (MB) per database available on a file system pointed to by a storage path. If multiple storage paths point to the same file system, the free size is not divided among them.
OVERALL_DB_FS_UTILIZATION
This element shows the amount of used space (MB) per database available on a file system pointed to by a storage path.
계열사 지원 사이트에서 Quest *제품*에 대한 온라인 지원 도움말을 볼 수 있습니다. 올바른 *제품* 지원 콘텐츠 및 지원에 연결하려면 계속을 클릭하십시오.
The document was helpful.
평가 결과 선택
I easily found the information I needed.
© ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center
Quest Software 포털은 더 이상 IE 8, 9, 10을 지원하지 않습니다. 브라우저를 최신 버전의 Internet Explorer나 Chrome으로 업그레이드하는 것이 좋습니다.
IE 11로 업그레이드 여기를 클릭
Chrome으로 업그레이드 여기를 클릭
IE 8, 9 또는 10을 계속 사용할 경우 당사가 제공하는 뛰어난 셀프서비스 기능 모두를 최대한으로 활용하실 수 없습니다.
