Skip to Content
0

DB2LUW performance

Aug 14, 2017 at 12:19 PM

62

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sabine Reich
Aug 15, 2017 at 08:22 AM
0

Have you tried transaction DBACOCKPIT?

Share
10 |10000 characters needed characters left characters exceeded
Maria Shen
Aug 15, 2017 at 08:27 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded