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.
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
Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration