Howto analyse SQVI and SQ01 usage and tables used
Some companys had choosen to use SQVI and SQ01 widely. The Problem occurs when you try to reduce the usage of S_TABU_DIS authorisations. If you are happy and on a 7.xx release you can choose to use S_TABU_NAM authorisations instead. Still you need to now which tables are used within SQVI and SQ01.
The Package SQUE contains everything related to this transactions
While there are also some usefull Programms to create and maintain Queries of all sorts – there is also the following report to analyze the usage:
Here you can choose wether just to analyze which queries exists or also to analyze which tables are used within:
If you just want to analyze SQVI Queries you have to restrict InfoSet on SYSTQV*