Re: How to invalidate informix' db-cache

Markus Pfadenhauer wrote: > > hi all, > > is it possible to invalide the whole internal database cache. > By now I create some dummy tables and do a relationscan on them but > this is not the very best solution. There is no way to do this except to bounce the server. However, why do you want to do this? BTW what aspects of the cache do you want to invalidate, Informix actually has several caches: data buffers, data dictionary cache, stored procedure cache, etc. Art S. Kagel