If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Manage a Data Source by time of day?

Started by nws, 22 Nov 2013 10:45:51 AM

Previous topic - Next topic

nws

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