Search found 42189 matches

by chulett
Tue Sep 08, 2009 7:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Failed to open RT_STATUS...file - when server load is heavy
Replies: 10
Views: 6120

D'oh, I meant T30FILES and as Arnd mentions, problems with it being too low are typically pointed out directly in any error message. :(
by chulett
Mon Sep 07, 2009 11:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Perf Issue when reading .csv file using sequential Stage
Replies: 16
Views: 5587

And you're certain all it is doing is a truncate? That sound take... moments. Perhaps it is doing a transactional delete of records in the table instead. :?
by chulett
Mon Sep 07, 2009 10:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Doubt regarding rank...
Replies: 6
Views: 1903

Yes. And while there are upwards of 30,000 users here and only 6 or 7 of us, I would say it would be a worthy investment in your ETL future. However, anyone who feels like contributing can take a shot at helping you out. To that end... It's generally best to answer any questions asked rather than s...
by chulett
Mon Sep 07, 2009 10:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup error
Replies: 8
Views: 2980

Don't really see how this can be a 'sometimes' thing, unless you mean you only use the Lookup stage sometimes or do lookups with this particular config file sometimes. Or are you saying that your problematic job sometimes works correctly and sometimes generates this error? :?
by chulett
Mon Sep 07, 2009 10:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Perf Issue when reading .csv file using sequential Stage
Replies: 16
Views: 5587

When the job took 1 hour 13 minutes, how much of that time was spent running the before script? You can tell from the detail in the logs.
by chulett
Mon Sep 07, 2009 5:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Perf Issue when reading .csv file using sequential Stage
Replies: 16
Views: 5587

:!: Don't blame the sequential file reads for that. 'Plain inserts' are not speedy and it can also be affected by the indexes on your target table, extents, system load, etc etc.
by chulett
Mon Sep 07, 2009 5:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: uvsh not working
Replies: 6
Views: 1628

Sreenivasulu wrote:You need to source your dsenv by executing . ./dsenv
I'm always curious why someone would feel the need to come in later and post the exact same advice as someone else. :?
by chulett
Mon Sep 07, 2009 4:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: istool not able find
Replies: 8
Views: 1617

What is your 8.x version?
by chulett
Mon Sep 07, 2009 4:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Doubt regarding rank...
Replies: 6
Views: 1903

Sounds like a Sort stage is in order, perhaps sorting descending. Do you actually have to assign a 'rank' as well or simply sort them in ranking order?
by chulett
Mon Sep 07, 2009 4:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Excel ODBC read error
Replies: 1
Views: 1178

Change the metadata to VarChar.
by chulett
Mon Sep 07, 2009 4:54 pm
Forum: General
Topic: Merge Sequential Files - handling missing files
Replies: 7
Views: 1870

In other words, you cannot 'ignore' the missing ones like that. How about a simple 'cat' instead using wildcards? It won't care.
by chulett
Mon Sep 07, 2009 9:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data driven output selection of files
Replies: 7
Views: 1601

So that seems like that should simplify things somewhat. I'm not exactly sure how, exactly, off the top of my head. Holiday today in the States so need to head out, hopefully someone else will step in here with their thoughts.
by chulett
Mon Sep 07, 2009 8:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data driven output selection of files
Replies: 7
Views: 1601

OK... another clarification. So, it's not one or some combination of output directories, it's either one specific one or all of them? Meaning you may be able to trigger off a single output directory or something else to signify 'all' in your hashed lookup.
by chulett
Mon Sep 07, 2009 8:25 am
Forum: General
Topic: Configuration of Information Server V 8.0.1 on Windows XP
Replies: 14
Views: 6016

Obligatory message re: Windows XP not being a supported Server platform.
by chulett
Mon Sep 07, 2009 8:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-12571 TNS:Packet Writer Failure
Replies: 8
Views: 2249

I'd go this route as suggested by 'oerr': $ oerr ORA 12571 12571, 00000, "TNS:packet writer failure" // *Cause: An error occurred during a data send. // *Action: Not normally visible to the user. For further details, turn // on tracing and reexecute the operation. If error persists, contac...