[Info-Ingres] Invalidate cache

[Roy Hann]

"Cecil Westerhof" <dummy at dummy.nl> wrote in message 
news:465018e1$0$337$e4fe514c at news.xs4all.nl...
>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? I am not a regular Ingres user. I 
> was
> just asked to solve his performance problem.
> The client is working with Ingres Linux Version II 3.0.2.

If you have permission to run the accessdb utility, go into the "Users" 
submenu, choose your user ID to edit it, and set the "Set trace flags" 
switch to "y".  Don't forget to save the change.  Log back in to pick up the 
new privilege.

Roy