Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2010
    Posts
    2

    Unanswered: DB2PD in Table Function on 9.7

    All does anyone know if there is a table function that contains the same data as db2pd -d <db_name>?

    specifically I'm looking for the section that has TCB table stats. More specifically I'm looking for RTSUDI, Reads, Inserts, Updates, Deletes and OvFlReads


    TCB Table Stats:
    Address TableName SchemaNm Scans UDI RTSUDI PgReorgs NoChgUpdts Reads FscrUpdates Inserts Updates Deletes OvFlReads OvFlCrtes RowsComp RowsUncomp CCLogReads StoreBytes BytesSaved

    -Jason

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    MON_GET_TABLE() system function.

  3. #3
    Join Date
    Aug 2010
    Posts
    2
    Quote Originally Posted by n_i View Post
    MON_GET_TABLE() system function.
    Close but I did not see the RTSUDI although if I understand the value I may just be able to use the INSERT,UPDATE and DELETE counts...

    thanks

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You realize, of course, that all those counters are reset by the collection of statistics.

  5. #5
    Join Date
    Feb 2012
    Posts
    1
    Hi, the mon_get_table function is almost what I need but not quite. What I am after is the number of times a table is queried on? I've tried mon_get_table but I'm getting results where a table has 0 table scans but rows read = 50.
    Any help would be appreciated.

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by OziBoy View Post
    a table has 0 table scans but rows read = 50.
    Surely, there are other access methods aside from table scans.

Tags for this Thread

Posting Permissions

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