To All,
We go down every night and run an offline backup of our DB2 database.
Then we come back online and one of our procedures is supposed to run.
It starts to run and we get a timeout and bombs out. Then we run the
procedure a second time and it runs successfully. Does anyone knows
what is causing this to happen? Does it have something to do with
prefetch or recompiling? We tried rebinding all procedures using the
db2rbind command but that did not help. Thanks.


BTW, a Visual Basic 6.0 application is calling this procedure. The
error message is: Run-time error '3172' : Operation has been cancelled
by user.

As I said earlier, we rerun the Visual Basic 6.0 application again and
it works. Thanks.


Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]

DB2 & UDB email list listserv db2-l LazyDBA home page