We are recently facing 'Query timeout expired ' error on one of our BODS jobs. This and all other jobs were defined and running successfully for last 10 years.On investigation by one of the team members it is being suggested that we should not use the DB link and opt for the 'Do not Link' option. I understand the purpose of defining a DB link and unsure as to using the other option can help with the timeout error. I am not much experienced in BODS, can anyone explain in what situation we should use 'Do not Link' option and if it can be better than DB link in any way ?
Any pointers would be helpful.
TIA