What on earth is Smart Cache?
Though we never SQL data in to the database, some of you may have come across instances where you are err… directly updating the database with your favourite tool, and yet nothing changes in Smart Office. I never ran across this with DB2 on an AS400, only Windows with SQL Server so far.
Several months ago, when making some significant changes to some existing processes for one of my customers we had need to mass update records as we were embarking on testing. The interesting thing that we came across was, we would execute the SQL statement and we would then looking in Smart Office to verify the data had indeed changed. It didn’t, we’d have the bounce the environment to get M3 to recognise the changes.
As part of this change, we were also going from SES003 to SES400 security, if you look in Companion it explicitly tells you to run a couple of queries directly against the database. Dutifully, this task was executed, however the changes again didn’t appear to be reflected in Smart Office or the M3BE.
I decided to do some digging, and I found something interesting.
In LCM, M3BE application -> Manage Application -> Tools we have Smart Cache
Clicking on Smart Cache we see some interesting information
And most importantly, a Clear button.
After running my SQL statements against the database, I found that I could hit this clear button and Smart Office would now display the updated values.
I did try to track down specifically what it did in InforXtreme, but aside from incidents logged, there wasn’t really much interesting.
Eitherway, if you’re in the situation where you need to manipulate data directly and the BE doesn’t recognise the changes – clearing the Smart Cache is the first place I’d look.