Search found 53125 matches

by ray.wurlod
Thu Jan 28, 2016 4:01 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: ISD job priority and WLM queues
Replies: 4
Views: 7844

Basically by tweaking (balancing) the CPU and memory limits for each of the queues. Allow ISD queue to start jobs even though CPU/memory might be 100%, but don't allow this for the other queues.
You may also be able to fiddle with the maximum jobs setting.
by ray.wurlod
Wed Jan 27, 2016 8:55 pm
Forum: General
Topic: Passing parameter from Value file to execute command activit
Replies: 1
Views: 850

Each parameter set lives in an eponymous directory within the ParameterSets subdirectory in the project. Each values file is indeed a file in that directory. Let's assume your Parameter Set is called psDWConnections and the values file you want to use is called "DEV". You want to read the ...
by ray.wurlod
Wed Jan 27, 2016 5:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date conversion from 1/1/2014 to 2014-01-01
Replies: 3
Views: 2170

Format string "%m/%d/%yyyy" is not a good general solution. It's OK if you are only dealing with the first day of the month, but fails when the number of digits in the day or month reaches two. Search DSXchange or review the documentation for a format string that will handle one- or two-di...
by ray.wurlod
Wed Jan 27, 2016 4:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: algorith for loading a Dimension table in Data Stage
Replies: 2
Views: 3258

Welcome aboard.

Use a Slowly Changing Dimension stage, which does all of that and, further, handles Type 2 and Type 1 (or some combination thereof).
by ray.wurlod
Wed Jan 27, 2016 4:07 pm
Forum: General
Topic: TFS configuration with IIS
Replies: 7
Views: 1917

Information Server Manager invokes functions in the Eclipse plug-in to the source code control system to effect check-in and check-out of selected artefacts. That's about the extent of the interaction.
by ray.wurlod
Tue Jan 26, 2016 4:15 pm
Forum: General
Topic: sequence job failure
Replies: 16
Views: 5427

I assumed that it was a specific question because of the lack of any "for example" or similar in the question.
by ray.wurlod
Sun Jan 24, 2016 10:49 pm
Forum: General
Topic: Can we customize the operations console
Replies: 4
Views: 1829

I concur with what Andy posted. They (IBM) made the operations database open and, as well, exposed part of the common metadata repository through views, so that you can "roll your own".
by ray.wurlod
Sun Jan 24, 2016 3:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to suppress the sequential stage schema warnings?
Replies: 3
Views: 2088

Welcome aboard. If you want to read the entire string, then make the max length of the string sufficiently large. If you want only part of the string, better practice would be to read the entire string, then use a Transformer or Modify stage to reduce it. If you want only to suppress the warning (de...
by ray.wurlod
Sun Jan 24, 2016 3:46 pm
Forum: General
Topic: sequence job failure
Replies: 16
Views: 5427

The second half of my earlier post somehow did not make it onto the forum. In it was the advice to mark the third activity "do not checkpoint run".
by ray.wurlod
Fri Jan 22, 2016 2:54 pm
Forum: General
Topic: sequence job failure
Replies: 16
Views: 5427

Don't reset. Reset will clear the checkpoints. If the sequence status is "Aborted / Restartable" simply re-start it.
by ray.wurlod
Thu Jan 21, 2016 4:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading excel file using Unstructured data stage
Replies: 10
Views: 5722

Are there any warnings in the job log?
by ray.wurlod
Thu Jan 21, 2016 3:54 pm
Forum: General
Topic: Websphere MQ Connector Error while calling Queue
Replies: 2
Views: 1079

Make sure that the MQ client libraries can be found in your library search list.
by ray.wurlod
Thu Jan 21, 2016 3:52 pm
Forum: General
Topic: Operations Console Errors
Replies: 19
Views: 8602

The Ops Console itself should show (in the top right hand corner by default) whether or not all required services are running.
by ray.wurlod
Thu Jan 21, 2016 3:50 pm
Forum: General
Topic: Sneaky way to get the failed job names
Replies: 3
Views: 1297

0 = running
1 = finished OK
2 = finished with warnings
3 = aborted

Your more complete solutions, therefore, is

Code: Select all

$DSHOME/bin/dsjob -ljobs -status 2 {ProjectName} ; $DSHOME/bin/dsjob -ljobs -status 3 {ProjectName}
by ray.wurlod
Wed Jan 20, 2016 5:59 pm
Forum: General
Topic: Set global variable from file
Replies: 5
Views: 2314

Get "them" to allow you to create and use temporary tables.