Search found 53125 matches

by ray.wurlod
Wed Apr 07, 2010 2:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: what is draw back of surrogate key generator
Replies: 4
Views: 2491

Why don't you re-initialize it?
by ray.wurlod
Wed Apr 07, 2010 2:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: db2 xmeta Issue:- Max log file utilization (heapsize)
Replies: 2
Views: 3280

If your transaction logs fill, everything stops. It is nice to have pre-warning that this might be happening.
by ray.wurlod
Wed Apr 07, 2010 2:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: difference in Sort w/RD and Remove Duplicate w/Sort
Replies: 2
Views: 1677

You can avoid the Remove Duplicates stage if you don't care which record from each group is kept; if you want to specify that the first or last record from each group is kept then you need a Remove Duplicates stage. Remove Duplicates relies on data being sorted and partitioned on the key that identi...
by ray.wurlod
Wed Apr 07, 2010 2:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to start Orchestrate job:APT_PMwaitForPlayersToStart
Replies: 1
Views: 1668

For whatever reason the conductor node was unable to communicate with, or get a response from, node1 within an acceptable time interval. Without knowing your topology it's not easy to say more, but I'd guess some process continuing to be bound to a port number in the 10000 range.
by ray.wurlod
Wed Apr 07, 2010 2:25 pm
Forum: IBM QualityStage
Topic: Compilation Error: Mapping failed to copy attributes
Replies: 8
Views: 6990

Did you provision any modified rule sets or match specifications? You really have not provided enough information. What stage types does this job use? Why do you accuse the QualityStage stage? The error suggests a problem copying within/into the unified metadata repository.
by ray.wurlod
Wed Apr 07, 2010 2:21 pm
Forum: IBM QualityStage
Topic: QS match Jobs takes more time to run
Replies: 2
Views: 1474

More? More than what? Why do you think that the time is not acceptable?

Faster hardware may help. More memory may help. Sorted data may help.
by ray.wurlod
Wed Apr 07, 2010 2:20 pm
Forum: IBM QualityStage
Topic: UK Address Standardization
Replies: 10
Views: 5047

CHISWICK belongs in UKAREA, not in UKADDR. Check how you have configured the UKPREP run.
by ray.wurlod
Wed Apr 07, 2010 3:58 am
Forum: General
Topic: Convert number from US_NLS to EUROPEAN_NLS
Replies: 5
Views: 2175

OK, then Convert(".", ",", InLink.TheValue) will convert the dot to a comma.
by ray.wurlod
Wed Apr 07, 2010 1:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Re-creating the job sequence with all the jobs
Replies: 4
Views: 1277

Unless you have been strict about which folders you store components in, there is no easy way.
by ray.wurlod
Wed Apr 07, 2010 12:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Re-creating the job sequence with all the jobs
Replies: 4
Views: 1277

What controller problem? If your controller is the sequence and the controller problem is being caused by an overloaded server, making an identical copy is not going to solve anything. You must first address the cause of the problems, the solution to which will probably involve being more selective ...
by ray.wurlod
Wed Apr 07, 2010 12:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: restart sequence from checkpoint without aborting other job
Replies: 28
Views: 15273

Ultimately, yes, but you will be gathering this information while the sequence is running and making decisions then about which parts of the sequence the process may need to abandon, as well as keeping records of everything that is happening.
by ray.wurlod
Tue Apr 06, 2010 9:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: restart sequence from checkpoint without aborting other job
Replies: 28
Views: 15273

Don't use a Terminator, for the reasons you've stated. Record-keeping is the clue here - the sequence must record the success or otherwise of each activity and make decisions on restart about which activities to skip. You have to build the logic.
by ray.wurlod
Tue Apr 06, 2010 9:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: count record based on key field without droping nonkey field
Replies: 3
Views: 1290

What alternative is there?

If your answer to that question is "none", then my answer to your question is "yes".
by ray.wurlod
Tue Apr 06, 2010 9:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue using write method on SQLServer Enterprise Stage
Replies: 1
Views: 1367

Welcome aboard.

Read the error message carefully. It's nothing at all to do with NLS.

Take a look at the control file that was produced, particularly around line 37, and see if you can spot a syntax error.