Search found 53125 matches

by ray.wurlod
Mon Apr 30, 2007 4:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problems with dsjob running VERY slow
Replies: 5
Views: 3741

Every background process ("phantom") that DataStage runs redirects its output to a subdirectory called &PH& in the project directory on the server. If &PH& contains thousands of files, job startup can be negatively impacted. The VCS reconfiguration might very well have cause the symp...
by ray.wurlod
Mon Apr 30, 2007 3:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UNIX and project permissions for multi-users
Replies: 10
Views: 2469

All DataStage user belong to one group, which gives them access to the DataStage software. There is a separate group for each project. Only the developers who need to access that project are members of that group. Any particular developer can belong to any combination of groups. Protect the DataStag...
by ray.wurlod
Mon Apr 30, 2007 3:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Autosys Job
Replies: 14
Views: 10600

Google will help, and there are probably Autosys analogues of DSXchange (that is, user fora) out there also.
by ray.wurlod
Mon Apr 30, 2007 3:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Best approach for unknown varied source
Replies: 19
Views: 5646

Nah, you just thought it. We said it. 8)
by ray.wurlod
Mon Apr 30, 2007 3:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to Read from Oracle Enterprise Stage
Replies: 2
Views: 1439

Make sure that $APT_ORCHHOME/lib precedes any Oracle libraries in the shared library search path.
by ray.wurlod
Mon Apr 30, 2007 3:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hash Partitioning
Replies: 3
Views: 1109

What happens is entirely dependent upon the requirements of the downstream operator. If it's a regular (parallel) operator, with no requirement for partitioned input, Auto should use "Same". If there's no repartitioning icon on the link, you can be comfortable that this is the case. But if you want ...
by ray.wurlod
Mon Apr 30, 2007 3:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with join stage and compilation error
Replies: 2
Views: 964

Try renaming your links to meaningful names. There is always the hazard, when using the default names (DSLink1, DSLink2, and so on) that components copy/pasted or imported will cause name clashes.
by ray.wurlod
Mon Apr 30, 2007 3:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: This Item has no deign time information
Replies: 6
Views: 1264

Did you import the job design as well as the job executables?
by ray.wurlod
Mon Apr 30, 2007 3:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem in implementing pivot stage
Replies: 11
Views: 3024

I infer from your note that the error occurs when dragging a link from the Pivot stage to the downstream Oracle Enterprise stage. Is this correct? I was not able to reproduce this problem using version 7.5.1A. My guess is that you already have an output link from the Pivot stage (look carefully for ...
by ray.wurlod
Mon Apr 30, 2007 3:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem in implementing pivot stage
Replies: 11
Views: 3024

I infer from your note that the error occurs when dragging a link from the Pivot stage to the downstream Oracle Enterprise stage. Is this correct?
by ray.wurlod
Mon Apr 30, 2007 3:36 pm
Forum: General
Topic: Batch Password change?
Replies: 12
Views: 3451

Set up the job parameters (in the jobs) that use environment variables to have the special value $PROJDEF as their default values.
by ray.wurlod
Mon Apr 30, 2007 3:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL for Last value in a universe field
Replies: 3
Views: 901

SELECT @ID, "KEY", DTC, CREATOR, PREVDTD, PREVDELETOR, EVAL "FIELD(DTM,@VM,COUNT(DTM,@VM)+1,1)" AS DTMOD FMT '19T', EVAL "FIELD(MODIFIER,@VM,COUNT(MODIFIER,@VM)+1,1)" AS MODBY FMT '30T' FROM DS_AUDIT WHERE ("KEY" = '2\' || ...
by ray.wurlod
Mon Apr 30, 2007 3:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Possibility of running many Mutiple Instances concurrently
Replies: 13
Views: 4076

Worse. Link partitioner uses inter process communication (IPC) which introduces an additional possible point of failure.
by ray.wurlod
Mon Apr 30, 2007 3:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: pivot dyanmic user
Replies: 2
Views: 711

You have an ongoing thread on this topic, in which you will find an answer. The current thread is redundant.
by ray.wurlod
Mon Apr 30, 2007 3:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IPC & Manageing resource contention
Replies: 11
Views: 2797

So with 8 dual node cpus, there are 16 processes available? Will the server dynamically adjust the number of processes when the second job is submitted or will test1 keep all the processes until it is finished? You're operating on an incorrect assumption. The number of processes available is not go...