Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I changed a DB procedure but the old version is still being run. Whats wrong?

April 26, 2017changed DB procedure run version wrong

0

Posted

I changed a DB procedure but the old version is still being run. Whats wrong?

1 Answer

0

Posted

The reason this problem exists is that each DBMS has its own QSF cache where it stores compiled Query Plans and a Database Procedure is a compiled Query Plan. So when you recreate the ‘‘ in server A, server B still has the old version in it’s cache. The way around this is to force each server to refresh its QSF cache. There are three ways to do this: 1. Restart/re-cycle Ingres 2. Run the drop/create SQL against each server. 3. Run trace point qs506 against each server. qs506 forces a flush of QSF cache.