[Info-Ingres] Invalidate cache

[Karl & Betty Schendel]

At 11:46 AM +0200 5/20/07, Cecil Westerhof wrote:
>I have to do a performance test on severall different sets of queries. (The
>old queries of the client and my replacement queries.) But to get a
>reliable result the cache does have to be cleared before every query
>offcourse. I understood that I could do this with the following statement:
>        SET TRACE POINT DM421
>
>But when I try to do this, I get 'You do not have permission to set trace
>flags'. How do I set this permission?


You ask your Ingres administrator to give your Ingres user the
trace point privilege.  This is traditionally done with the
accessdb utility;  alternatives are visual DBA or the ALTER USER
sql statement.

Karl