We have a need to disable queries against certain tables during our nightly warehouse refresh. Several time in recent months, a really long running report or query has held a lock on a table which caused the update to fail. I'm thinking that we could disable the data source at a certain time and re-enable after the load. I found an SDK option, but was wondering if anyone had done something simiar. Maybe at the command line?
SDK option: http://www-304.ibm.com/support/docview.wss?uid=swg21343038
Thanks for reading!
NOAH