Unable to start multiload process

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
arun_im4u
Premium Member
Premium Member
Posts: 104
Joined: Mon Nov 08, 2004 8:42 am

Unable to start multiload process

Post by arun_im4u »

Hello all,

I am getting this error when I try to use the Teradata mload stage. Its been working fine till now and no changes have been made to the job.

Teradata_Multiload_2: Unable to start MultiLoad process : MultiLoad failed: Check MultiLoad report /tmp/****

This is wat the report says:

**** 08:24:07 UTY0829 Options in effect for this MultiLoad import task:
. Sessions: One session per available amp.
. Checkpoint: No rate in effect.
. Tenacity: 4 hour limit to successfully connect load sessions.
. Errlimit: No limit in effect.
. AmpCheck: In effect for apply phase transitions.
**** 08:24:12 UTY0817 MultiLoad submitting the following request:
Select NULL from CDW_SPOOL.log_table111 where (LogType = 125) and (Seq = 1)
and (MloadSeq = 0);
**** 08:24:12 UTY0817 MultiLoad submitting the following request:
Select NULL from CDW_SPOOL.log_table111 where (LogType = 120) and (Seq =
1);
**** 08:24:20 UTY0800 CLI error: DBCHCL returned 215.
text: MTDP: EM_CONNECT(215): Error found in local machine during connect.
**** 08:24:20 UTY1804 Re-starting this MultiLoad task because a retryable error occurred.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I let my sysadmin know but he replied asking me this question:

What dataset names are being used in the JOBLIB and/or STEPLIB ddnames of the job?

Any suggestions will be helpful..

Thanks,
Arun.
Post Reply