Search found 42189 matches

by chulett
Mon Nov 09, 2009 9:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TD API Load Performance
Replies: 6
Views: 2451

OK. There are some Teradata folks here (I'm not) so hopefully one of them will wander by and be able to help. And there's always your official support provider to ping for help.
by chulett
Mon Nov 09, 2009 9:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: auto purge settings for existing jobs.
Replies: 3
Views: 1447

It that works out for you, don't forget to come back and mark your post as Resolved (big button at the top) please. :wink:
by chulett
Mon Nov 09, 2009 2:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to check byte length of data?
Replies: 10
Views: 4457

ray.wurlod wrote:How about Len(StringToRaw(InLink.TheString)) ?
This I can't even get to compile. Depending on the output data type it either complains about an "Invalid conversion requested from a string to a raw" or "from an int32 to a raw". :?
by chulett
Mon Nov 09, 2009 2:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Input - view XSLT
Replies: 4
Views: 3009

The process to "access" the generated XSLT stylesheet is documented in the XML PACK pdf. Basically, you need to switch to the Tracing tab in the Run dialogue box, select the XML Input stage and check the Subroutine calls box. The stylesheet will be in the job's log after the next run. Now,...
by chulett
Mon Nov 09, 2009 1:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Could not load module libgciudt6.so
Replies: 13
Views: 8066

That's where I figured it would be and why I said it "looks fine" but now wondering why I couldn't find it on my Linux server? :?
by chulett
Mon Nov 09, 2009 1:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance issue in loading to Oracle table
Replies: 1
Views: 933

Be happy with the 40 minutes. I mean - 50 indexes of which 5 are bit-mapped? It is not going to be speedy. And I'll wager dropping/rebuilding them would take even longer. One thought, though - have you tried increasing the array size? Probably won't help much regardless, seeing as how it still takes...
by chulett
Mon Nov 09, 2009 1:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Could not load module libgciudt6.so
Replies: 13
Views: 8066

Hard to say, looks fine but did you check to see where "libgciudt6.so" lives? No AIX here for me to check myself.
by chulett
Mon Nov 09, 2009 11:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Could not load module libgciudt6.so
Replies: 13
Views: 8066

It's not a PATH issue but rather a "shared library path" issue, whatever that is on your system - SHLIB_PATH? Wherever that object lives that 'home' directory needs to be there.
by chulett
Mon Nov 09, 2009 10:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Skipping failed job in Job sequencer
Replies: 1
Views: 1009

Nothing automatic to do this. You can do a couple of things, however. 1. Copy the Sequence job and remove the job that you no longer need to run, including the failed job, then run the copy. 2. Have your Sequence start from a Nested Condition stage that takes a parameter value to specify the startin...
by chulett
Mon Nov 09, 2009 10:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TD API Load Performance
Replies: 6
Views: 2451

Ummm... that was assistance. So, none of those discussions on unbalanced AMPs or duplicates in the data are applicable to you? Have you involved your Teradata DBA as they suggested?
by chulett
Mon Nov 09, 2009 10:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TD API Load Performance
Replies: 6
Views: 2451

There are several other posts here that mention "Logging Delayed Metadata" and some are Resolved, so it might help to check those if you haven't already.
by chulett
Mon Nov 09, 2009 9:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: The server is not responding
Replies: 12
Views: 5385

No, sorry, if I did I would have posted something to it.
by chulett
Mon Nov 09, 2009 6:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to check byte length of data?
Replies: 10
Views: 4457

Thanks guys. I'll check these options out today, hopefully.
by chulett
Mon Nov 09, 2009 6:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Teradata API stage not inserting/updating multiple rows
Replies: 1
Views: 1149

If what you are saying is correct, that sounds awful bug-like and would suggest you should contact your official support provider for guidance.