|
|
Archives of the TeradataForum
Message Posted: Fri, 14 Oct 2011 @ 08:06:06 GMT
Subj: | | Re: Release mload is taking long time |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, October 13, 2011 21:20 -->
libin.jose wrote:
| I had tried with our data stage team members on this issue. When they removed the start up property from 'clean' to 'keep', I count not
fine release mload statement in the query logs. | |
| Please try this with your datastage teams and verify. | |
| I believe clean mode in datastage issues drop temp tables (_ET, _UV, _log etc) and also issue Relase mload statement as well. | |
| Please confirm if you get same results with your team. | |
Hi Libin,
Thanks a lot for your solution. I was the one who raised this problem.
After no proper solution from IBM Datastage support and from Teradata support we tested on our own and did investigations. You are abosolutely
right.
After we changed the startup property from start up property from 'clean' to 'RESTART' the release mload statement is no more seen in the
accesslog and looks like the problem is solved for us. Our datastage team will be testing it soon.
Thx.
| |