Datastage to Teradata multiload

UDA
Fan

Datastage to Teradata multiload

When using multiload, I am having performance issues.
========================================================================
= =
= MultiLoad Initial Phase =
= =
========================================================================
**** 06:04:16 UTY0829 Options in effect for this MultiLoad import task:
. Sessions: 16 session(s).
. Minimum of 16 load session(s) requested.
. Checkpoint: 2000000 records.
. Tenacity: 4 hour limit to successfully connect load sessions.
. Errlimit: No limit in effect.
. AmpCheck: In effect for apply phase transitions.
**** 06:04:16 UTY0817 MultiLoad submitting the following request:
Select NULL from scott.LOG_GFSTWB1 where (LogType = 125) and (Seq = 1)
and (MloadSeq = 0);
**** 06:04:16 UTY0817 MultiLoad submitting the following request:
Select NULL from scott.LOG_GFSTWB1 where (LogType = 120) and (Seq =
1);
**** 06:46:41 UTY0812 MLOAD session(s) requested: 16.
**** 06:46:41 UTY0815 MLOAD session(s) connected: 16.
==========================================================================
I am not sure why it took 42 min for logtype 120. I don't know what logtype 120 means?
Can somebody please explain what is happening here from logtype 125 to the last stmt.

Thanks a lot
Ravindra

2 REPLIES
Junior Contributor

Re: Datastage to Teradata multiload

Hi Ravindra,

> . Minimum of 16 load session(s) requested.

MLoad can't logon with less than 16 sessions.

> . Tenacity: 4 hour limit to successfully connect load sessions.

If there are less than 16 sessions available (or too many load jobs already running) then retry the logon after SLEEP minutes, with a default of 6.

> **** 06:04:16 UTY0817 MultiLoad submitting the following request:
> Select NULL from scott.LOG_GFSTWB1 where (LogType = 120) and (Seq =
1);

There's no error with that, it's just the last successfull request.

> **** 06:46:41 UTY0812 MLOAD session(s) requested: 16.
> **** 06:46:41 UTY0815 MLOAD session(s) connected: 16.

> I am not sure why it took 42 min

MLoad retried 7 times before there were 16 sessions available:
If you check dbc.logonoff there should be some sessions (<16) logged on and immediately logged off for that job every 6 minutes...

Dieter
Fan

Re: Datastage to Teradata multiload

Dieter--Thanks for taking time to explain. Really appreciate it.