Skip to Content
avatar image
Former Member

DB2LUW performance

How to determine top 20 tables in DB2 database where read operations were highest since the instance was started.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 15, 2017 at 08:22 AM

    Have you tried transaction DBACOCKPIT?

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 15, 2017 at 08:27 AM

    Hello Suman Kundu,

    You can use the Web Dynrpo dbacockpit to check it.

    dbacockpit (Web Dynrpo) => Performance => Snapshot => Tables => Time frame: Since DB start => Apply selection.

    Kind regards
    Maria

    Add comment
    10|10000 characters needed characters exceeded