Previous ◁ | ▷ Next

Query Tracker

Users are allowed to work with Queries on their own in many installations. This can result in a very large number of different Query definitions, where nobody is able to tell which are used and which may be deleted.

GiAPA offers a Query tracker option. When turned on, it records all uses of the RUNQRY and WRKQRY commands: User name, Query name, and when available also name of the data base file(s) accessed are kept together with date and time.

When the tracker function has been active for some time (e.g. during a full quarter including year end) then it should be fairly safe to delete all Queries not included in the data collected by the tracking function.