Search found 53125 matches

by ray.wurlod
Mon Nov 26, 2007 2:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fork Error
Replies: 5
Views: 1618

fork() is a function used to create a child process. If there is insufficient resource (for example memory, places in the O/S process table) then fork() will fail. The only way "permanently" to remove these messages is to guarantee at all times that there are sufficient resources; that is, by not ov...
by ray.wurlod
Mon Nov 26, 2007 2:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Establishing remote connectivity to OracleDB inLinux server
Replies: 0
Views: 832

The PXEngine directory needs to be mounted on, or copied to, all processing nodes. That's the initial problem. Then, since section leader processes are started using rsh/ssh, you need to configure a trusted connection for rsh. Oracle client software also needs to be installed and configured on every...
by ray.wurlod
Mon Nov 26, 2007 2:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ereplace in parallel
Replies: 8
Views: 1726

The code not only has to be compiled, it also has to be linked to construct either a shared object or a function in a shared library. The "parallel routine" that you create in DataStage is merely an interlude that provides instructions about the location of your (external) routine and its arguments.
by ray.wurlod
Mon Nov 26, 2007 2:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Parameters override
Replies: 11
Views: 2384

Turning the logic around, if the Job activity sets the job parameter value using the value of the sequence's parameter, then it is the sequence's parameter value that ends up being used. If the Job activity sets the job parameter value using some other expression then the sequence parameter value is...
by ray.wurlod
Mon Nov 26, 2007 2:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: project location
Replies: 5
Views: 2080

Ah. Missed that. The answer is a qualified yes - you need to be on version 5.2 or earlier (one of the versions built on genuine UniVerse) - then you could use UV/Net. But, for version 6.0 or later, the answer is that the project must be on a local disk - not even on an NFS mount - on the machine whe...
by ray.wurlod
Mon Nov 26, 2007 1:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash look up Very Slow...
Replies: 14
Views: 4942

With a hashed file that you are not re-creating and which is growing, prefer dynamic. But do try re-creating, see how long it takes to populate the 10GB. I am surprised at your assertion that it is the hashed file lookup that is slow. You have a row size of less than 30 bytes, which should mean quit...
by ray.wurlod
Mon Nov 26, 2007 1:51 pm
Forum: General
Topic: Issue in reading Hash file data
Replies: 3
Views: 1660

Try looking in a job that uses a Hashed File stage, rather than in the table defintiion in the Repository.
by ray.wurlod
Mon Nov 26, 2007 3:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Certification
Replies: 6
Views: 3451

SO search the IBM India web site. Learning services (India) can be found here
Contact Learning Services (India) by phone on +91-80-22063489
by ray.wurlod
Mon Nov 26, 2007 3:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash look up Very Slow...
Replies: 14
Views: 4942

Consider using a static hashed file for very large sizes. Try initially with type 18. Keep the separation small, perhaps 2 or 4.
by ray.wurlod
Mon Nov 26, 2007 3:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to load incremental loading
Replies: 5
Views: 1949

In short, a lookup against the target, or a copy of it.
by ray.wurlod
Mon Nov 26, 2007 3:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: project location
Replies: 5
Views: 2080

Yes.

The directory you specify must not exist.
Its parent directory must exist, and you must have read, write and execute permission to it.
by ray.wurlod
Mon Nov 26, 2007 3:39 am
Forum: General
Topic: Oracle Retail Embedded Database Support.......
Replies: 2
Views: 1225

Is this the same question as this one?
by ray.wurlod
Mon Nov 26, 2007 1:04 am
Forum: General
Topic: DATASTAGE SUPPORTS OREDB ?
Replies: 7
Views: 3326

There is no direct support. That is, no-one (including IBM) has advertised that they've created anything. You can, of course, access the underlying Oracle tables and their metadata.
by ray.wurlod
Mon Nov 26, 2007 1:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: px version of Ereplace()
Replies: 51
Views: 66643

What would really make a good FAQ would be step by step instructions for creating a parallel routine to invoke this function. Begin with the steps for getting it compiled, linked and tested external to DataStage (a small main() program, of course). You might even discuss the relative merits of creat...
by ray.wurlod
Mon Nov 26, 2007 12:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Access User Defined variables in Parallel Routine
Replies: 3
Views: 1629

Technically this is not a solution to the original question, though I believe I provided one in my response.