Search found 42189 matches

by chulett
Thu Apr 02, 2009 7:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Which is valid option to restrict the access to the Project
Replies: 1
Views: 837

Through the use of permissions are noted in this FAQ posting. Adjust as necessary for use in a Windows environment as it is UNIX specific, but the concept holds true regardless.
by chulett
Thu Apr 02, 2009 7:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot get exclusive access to executable file for job xxx..
Replies: 1
Views: 2194

If you're sure no-one is monitoring it, have you tried using Cleanup Resources from the Director? Look for both the job name or files with the job number (RT_LOGnnnn, for instance) to find the culprit.
by chulett
Thu Apr 02, 2009 7:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage-Unix I/O transfer problem ?
Replies: 16
Views: 5150

:? Still confused. Projects cannot "run 24x7" so what exactly does that mean? "RTI Enabled" jobs can be set to be "always on" and thus run constantly as a web service, is that what you are doing? It doesn't sound like it, since there seems to be a script involved. What ...
by chulett
Thu Apr 02, 2009 7:20 am
Forum: General
Topic: generate HTML report in datastage
Replies: 22
Views: 17973

Do you not have the pdf mentioned? Check the link I posted? Both places show the syntax.
by chulett
Thu Apr 02, 2009 7:18 am
Forum: General
Topic: download
Replies: 3
Views: 1136

No such thing.
by chulett
Thu Apr 02, 2009 7:16 am
Forum: General
Topic: record end
Replies: 1
Views: 793

Assuming you meant CR/LF and that it can occur as 'data' inside a text field, yes? Is the string field quoted in the file? Search here (PX forum) for 'contains terminators' for other discussions on the subject.
by chulett
Thu Apr 02, 2009 12:34 am
Forum: General
Topic: The file system is full
Replies: 2
Views: 4394

Except isn't the error coming from the DB2 database, so perhaps... temp space? Is there an order by in your sql? :?
by chulett
Wed Apr 01, 2009 11:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: confusion and request for help setup Windows UNIX datastage
Replies: 9
Views: 5656

A couple of things... one is that you don't need multiple processors to "use the parallel configuration capabilities". Node <> cpu.

The other is you have a Windows version of the tool, so no UNIX anything for you. Not without a license purchase for your flavor of UNIX, that is.
by chulett
Wed Apr 01, 2009 11:26 pm
Forum: General
Topic: Issue with KeyMgtGetNextValue routine
Replies: 3
Views: 1537

Right, the "current value" we talked about in the other threads is the next value that will be used. Not the last one used. Sorry, didn't realize there was a confusion there or that that was why you wanted to fetch it.
by chulett
Wed Apr 01, 2009 3:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage-Unix I/O transfer problem ?
Replies: 16
Views: 5150

Hopefully it's not, seeing as how they marked their Release as 7x in the opening post. I know where you're going, though... :wink:
by chulett
Wed Apr 01, 2009 3:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe Query -
Replies: 23
Views: 5745

sarjushah wrote:Let me search the forum but if you have it handy please pass it on.
It, what "it"? The link to Ken's post I already provided to you?
by chulett
Wed Apr 01, 2009 11:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Different ways to recover scd type 2 data load failure
Replies: 4
Views: 1109

You might want to explain what you mean by 'the recovery of the data' here.
by chulett
Wed Apr 01, 2009 11:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe Query -
Replies: 23
Views: 5745

I've used the technique and routines Ken discusses here and it worked out well for me.
by chulett
Wed Apr 01, 2009 10:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe Query -
Replies: 23
Views: 5745

You cannot.

They mention those two stages together - UV/OBDC - as they are the only two stages that allow you to return 'multiple row' results rather than a singelton row. And the performance comments were related to direct database reference lookups.
by chulett
Wed Apr 01, 2009 10:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to connect Oracle 11g through 7.5 PX Jobs
Replies: 10
Views: 3943

Sure, "officially", but I would still think that you could be successful using an older client to connect to it. Worked well with 9i to 10g, for example.