Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Location
    Bangalore
    Posts
    57

    Unanswered: Query To Get I/O Uses

    Hi All,

    I am looking for some query in db2 to fetch I/O operations and wait time for last 10 minuts from curent time.

    Its there any query to get this info?
    Ritesh Kumar Singh
    IBM Certified DB2 DBA for LUW
    **Knowledge Is Theft If Not Shared !!**

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    That depends on the DB2 server version.

  3. #3
    Join Date
    Jul 2006
    Location
    Bangalore
    Posts
    57
    I am using DB2 9.7 and used below sql to get the info.

    Could any body please confirm if this si correct.

    Code:
    select 
    to_char(current timestamp,'HH:MI:SS') as time,
    sum(DIRECT_READ_REQS) as DIRECT_READ_REQS, 
    sum(DIRECT_WRITE_REQS) as DIRECT_WRITE_REQS,
    sum(pool_data_l_reads + pool_temp_data_l_reads + pool_index_l_reads + pool_temp_index_l_reads + pool_xda_l_reads + pool_temp_xda_l_reads) as logical_reads,
    sum(pool_data_p_reads + pool_temp_data_p_reads + pool_index_p_reads + pool_temp_index_p_reads + pool_xda_p_reads + pool_temp_xda_p_reads) as physical_reads,
    sum((pool_data_writes + pool_index_writes + pool_xda_writes)) as TOTAL_WRITES
    from table(SYSPROC.MON_GET_BUFFERPOOL('',-1));
    Ritesh Kumar Singh
    IBM Certified DB2 DBA for LUW
    **Knowledge Is Theft If Not Shared !!**

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •