Search found 15603 matches

by ArndW
Tue Aug 18, 2009 11:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs Aborts
Replies: 7
Views: 3100

As far as I know, 7.5.2r2 is the only version of 7.x where one can run PX jobs on windows. Server jobs are unaffected. I don't know what the error message would be if you don't have the correct version, but your message is obscure enough to let me think that you do have the wrong version.
by ArndW
Tue Aug 18, 2009 10:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Mismatch using ODBC connector stage
Replies: 18
Views: 3525

Do other dates get loaded correctly or is there always 1 year difference?
by ArndW
Tue Aug 18, 2009 10:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Mismatch using ODBC connector stage
Replies: 18
Views: 3525

No difference between single and double quotes in these stages. But what value is written to a peek stage or sequential file?
by ArndW
Tue Aug 18, 2009 10:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Jobs Aborts
Replies: 7
Views: 3100

Is the version 7.5.2r2 or just 7.5.2? One supports running PX jobs while the other does not.
by ArndW
Tue Aug 18, 2009 4:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage job compiles but does not run
Replies: 10
Views: 5199

What are your source and target stages? Do other jobs run? Are any entries put into your job log at runtime for this job?
by ArndW
Tue Aug 18, 2009 4:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage job compiles but does not run
Replies: 10
Views: 5199

Can you do a "View Data" on your ODBC data from the designer?
by ArndW
Mon Aug 17, 2009 11:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can i recollect deleted jobs
Replies: 8
Views: 2233

ArndW wrote:I'll add my 2 cents as well - No, jobs cannot be undeleted.
by ArndW
Mon Aug 17, 2009 9:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can i recollect deleted jobs
Replies: 8
Views: 2233

I'll add my 2 cents as well - No, jobs cannot be undeleted.
by ArndW
Mon Aug 17, 2009 8:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read a text file of 5GB
Replies: 24
Views: 7927

Yep, usually that magical 2Gb limit, but the OP opined that DS couldn't do this.
by ArndW
Mon Aug 17, 2009 8:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to trigger one link after the other
Replies: 7
Views: 1519

This is thread which Craig suggested you look at.
by ArndW
Mon Aug 17, 2009 7:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read a text file of 5GB
Replies: 24
Views: 7927

I should have added that I tested it today with a 3Gb big file (project export .dsx file). If it can handle 3Gb then 5Gb should not be an issue.
by ArndW
Mon Aug 17, 2009 6:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to trigger one link after the other
Replies: 7
Views: 1519

I responded to that thread and wrote a small test program and it worked. Basically one knows that the reject output link from a database stage doesn't finish until the writes are complete, so if one makes that link go to a funnel (not set to "continuous") then one can force temporal depend...
by ArndW
Mon Aug 17, 2009 6:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read a text file of 5GB
Replies: 24
Views: 7927

I tested it after the post a couple of weeks(running 8) the restriction is still there. But perhaps I didn't get it quite right: (A) One can define multiple readers on a single node with variable lenght records. I played around today and see that one can increase read speed by specifying multiple re...
by ArndW
Mon Aug 17, 2009 3:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: the primary key, unique constraint or unique index
Replies: 4
Views: 4537

This is a basic database function. You are most likely doing an INSERT on a record that already exists.
by ArndW
Mon Aug 17, 2009 2:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read a text file of 5GB
Replies: 24
Views: 7927

That makes multiple readers a nonoption. How many columns does the file have and how long does it take to read the file when the only other stage in your job is a copy stage (or a peek stage)?