Archives of the TeradataForum

Message Posted: Thu, 11 Feb 2011 @ 01:15:55 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

To provide the most hands off restart of abended MLOADs we implement a BTEQ step in advance to RELEASE MLOAD. Knowing that RELEASE MLOAD requires an EXCLUSIVE LOCK we first check for the presence of the (job-specific) MLOAD LOGTABLE. If the LOGTABLE is present, we then attempt the RELEASE MLOAD (with appropriate error checking for return codes 2571, 2572, and 2580). If not present, we skip the (unnecessary) RELEASE MLOAD thus eliminating the likelihood of contention between users holding the many access locks found in a 24x7 environment.

Steve Hager

	<Prev	Next>		<<First	<Prev	Next>	Last>>