Skip to Content
Author's profile photo Former Member

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*


Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      This is some good information.  In addition to the security aspect, I work on a lot of upgrade projects and a lot of times these are created by end users directly in their production systems.  This would be very helpful for the planning stages of projects  so customers can identify these and plan for testing, replacement, etc.