Hi,
Background: We have 150+ tables are being loaded on daily basis from One DB2 instance to Other DB2 instance. The volume ranges from 100 to 2 million rows. All these jobs are running in sequencer with the following parameters.
$SRCDBTYPE = IBM DB2 [$PROJDEF]
$TARRAY = 500 [$PROJDEF] - Target Array Size
$SARRAY = 500 [$PROJDEF] - Source Array Size
$TRANSIZE = 5000 [$PROJDEF]
Last 3 days one of the jobs (TAX_BALANCE) is failing with following error after loading 700,000 rows. The current volume of the job is 1298822. This job ran successfully till the volume was 1297853. As for as I know there were no changes made in the environment.
TAX_BALANCE..TAX_BALANCE: SQLFetch: Error retrieving results from server.
TAX_BALANCE..TAX_BALANCE: [IBM][CLI Driver][DB2] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000
Our Findings: This job runs without any errors if we change the source array to something different (200, 1000, and 5000). But again that number is not consistent either. Every time we ran we had to change Source Array to something different.
Any ideas ?
Appreciate your help.
Regards
Venkat
DB2-Fetch Issue ( load fails in-between)
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
-
- Participant
- Posts: 15
- Joined: Thu Sep 23, 2004 2:18 pm
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