Archives of the TeradataForum

Message Posted: Thu, 24 Sep 2009 @ 19:50:14 GMT

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

Hi Martin,

The information is found in the loader logs. If you have too many loader logs and going through each of them is time consuming, you can use the dbc.sw_event_log which holds this information.

     select *
     from dbc.sw_event_log
     where text like '%Too many Load%'

The text column for all these failures also holds the associated sessionId which can be used to find out the corresponding username and load details. ( qrylog or logonoff)

The delay is determined by the "SLEEP" parameter set in your load job.

For ex - If you set the SLEEP value as 1, the load job that was not able to acquire a load slot will wait for 1 minute and retries.

The default value for this SLEEP is 6 minutes.

If you have one failure for a load job in the sw_event_log that means the job had to wait 'x' minutes where x is the value for SLEEP in the load job)

Thanks,

Sudheer.

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