Cómo buscar las tablas con más accesos en DB2

Search more accessed tables in DB2 Oscar_paredes Sun, 01/26/2020 - 19:37

 It’s relatively simple and unfamiliar tool for the novices: db2top.

Using the option “T” (tables) and sorting the list (key “z”) using column 1.

The first position will be for the most accessed table.

If there is much difference between that and the rest during an appreciable period of normal use of the database, these tables would be candidates to improve their access or optimice their access to improve the overall performance,