Search found 53125 matches

by ray.wurlod
Wed Apr 04, 2007 7:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance while loading target database table
Replies: 30
Views: 10134

Only taking 1.23% CPU indicates that CPU is not the bottleneck. However, dsapi_slave is an agent of your client process - it is not the process executing the job. Processes running jobs usually run uvsh. I suspect (lacking other processes) that pid 1267 is the one running your job. Even this process...
by ray.wurlod
Wed Apr 04, 2007 6:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Amount of memory that Aggregator consumes
Replies: 4
Views: 1332

You can tune the amount of memory that the Aggregator stage uses (for a particular job) using the final option in the DS.TOOLS menu on the server. However, if you actually run out of memory, all bets are off - you can tune for 16GB but, on a system with only 4GB, this would be foolish in the extreme.
by ray.wurlod
Wed Apr 04, 2007 6:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Strange Behaviour of Jobs...
Replies: 2
Views: 1491

In short, your project is getting larger. T30 relates to the number of hashed files (including repository tables) open simultaneously; the first message relates to a job not being in a runnable state - maybe because it's aborted or was stopped, maybe because it's been changed but not recompiled.
by ray.wurlod
Wed Apr 04, 2007 6:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Install
Replies: 5
Views: 1793

You can read about them in the Installation and Upgrade Guide. However, all the questions are asked by install.sh before it invokes the setup script.
by ray.wurlod
Wed Apr 04, 2007 6:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: transaction grouping
Replies: 12
Views: 3725

The multiple input links I had - transaction grouping on one link is silly. Enabling it I missed. But I can not see the control described in the help (which, incidentally, contains a description of what "on skip" does). The only control on the Transaction Grouping page is Rows per transaction - the ...
by ray.wurlod
Wed Apr 04, 2007 6:15 pm
Forum: IBM QualityStage
Topic: Unduplicate Match
Replies: 7
Views: 2902

Welcome aboard. :D

This is one of the standard fields, a NYSIIS match on the first primary word. What is your output file? Have you done anything to construct its file description?
by ray.wurlod
Wed Apr 04, 2007 8:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Copy Stage Error with Oracle Enterprise
Replies: 7
Views: 2479

Why did it resolve the problem? What exactly was the problem?
by ray.wurlod
Wed Apr 04, 2007 8:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Insert rows in between the data
Replies: 4
Views: 1470

There's no-one registered on this site called "U".
by ray.wurlod
Wed Apr 04, 2007 8:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Could not locate ... "dscapiop" in parallel job w
Replies: 4
Views: 1583

Welcome aboard. :D

Have you corrected LD_LIBRARY_PATH in dsenv to include the directory in which dscapiop is located?
by ray.wurlod
Wed Apr 04, 2007 8:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get rid of such a warning
Replies: 1
Views: 1443

This is simply an alert. The upstream stage has its "preserve partitioning" flag (on Advanced tab in stage properties) set to "Propagate". Change it to "Clear".
by ray.wurlod
Wed Apr 04, 2007 8:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS 7.5 has new capability to run sequencer from the Middle
Replies: 1
Views: 716

Open the job properties of the job sequence. Check the two left-hand check boxes (or all four) on the General tab Compilation Options frame.

Click on Help while on that page to learn more. And/or search the forum for the terms you find on that page.
by ray.wurlod
Wed Apr 04, 2007 7:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Install
Replies: 5
Views: 1793

You must create the "config" file, which is really just a text file containing answers to the questions that install.sh will ask, one line at a time. Read through install.sh to figure out what questions will be asked.
by ray.wurlod
Wed Apr 04, 2007 7:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using multiple Hash file in one job
Replies: 5
Views: 1241

There is no technical upper limit on the number of hashed files in a job. There is the practical limit of being able to maintain them. Every unit of work you add to a job necessarily lengthens its exection time, all else being equal.
by ray.wurlod
Wed Apr 04, 2007 7:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem while passing parameter from one job to another
Replies: 5
Views: 1692

Code -3 (DSJE.BADPARAM) means "bad parameter name" - that is, the parameter NAME that you are giving is not the name of a parameter in that job. Check both spelling and casing.