I have created MQT on DB2 AIX. I have used the option refresh deffered. And each time when I issue refresh table command the table is refreshed. But I need to know ..How can I automate this refresh? as the users are asking?
I have tried refresh immediate option but the MQT is not getting created as we used Left out join of Many tables (nearly 40 tables) in the sql query. I need to use Inner joins to use Immediate refresh..which is little hard to rewrite the query again..
Please help me with this to use refresh deferred option or any other best apporach to refresh the table in regular intervals..I need this process to get automated is there any option in DB2?