Hi all,
While i am trying to load the db2 using the db2/udp stage i got these errors ,at the time i set write method is load and deflault server and database is set to false.
errors:
dbW_IIPNT0_Tgt,0: DB2 Load Binary Error.
main_program: Invalid character conversion found converting to ASCL_MS1252, substituting.
dbW_IIPNT0_Tgt,0: SQLCODE = -3508; SQLSTATE= ?V??0.
dbW_IIPNT0_Tgt,0: SQL3508N Error in accessing a file or path of type "TEMP_FILE" during load or load query. Reason code: "1". Path: "/data/Scratch/APT_DB2_LOADMSG_db2inst10_REMOTE/DB20000C.PI".
dbW_IIPNT0_Tgt,0: Failed opening fifo /data/Scratch/ordb2228821eacca78_.000 after 90 seconds: No such device or address.
dbW_IIPNT0_Tgt,0: The runLocally() of the operator failed.
dbW_IIPNT0_Tgt,0: Operator terminated abnormally: runLocally did not return APT_StatusOk.
please give me input
thanksinadvance
Praveen
db2 Loading Problem
Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”
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