Search found 53125 matches

by ray.wurlod
Thu Jan 19, 2012 3:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Parser Issue
Replies: 12
Views: 4399

Please share the resolution. That's what DSXchange is about. If someone else gets the same problem in the future, your solution will be there for the searching! :)
by ray.wurlod
Thu Jan 19, 2012 3:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading & Writing using different configuration file
Replies: 11
Views: 2803

You can always use node pools to force things to run on the nodes you require.
by ray.wurlod
Thu Jan 19, 2012 3:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to delete a job in queue with status 'dr'
Replies: 4
Views: 3224

Presumably some kind of command like qdel. I still have no idea what kind of queue you are talking about. It's not part of DataStage.
by ray.wurlod
Thu Jan 19, 2012 2:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compare tables data
Replies: 5
Views: 2201

You need a special component from Unseen University School of Inadvisably Applied Magic.
by ray.wurlod
Thu Jan 19, 2012 2:55 pm
Forum: General
Topic: Complier and SDK
Replies: 3
Views: 1212

We installed: .NET Framework 4.0 sp1 (64-bit version) plus Knowledge Base components KB2468871 and KB2478663 and KB2518870 .NET Framework 3.5.1 because it is required by the Platform SDK SDK for Windows 7 and .NET Framework 3.5 sp1 selecting Developer Tools as an installation option (compiler) Micro...
by ray.wurlod
Thu Jan 19, 2012 2:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to delete a job in queue with status 'dr'
Replies: 4
Views: 3224

What kind of queue would that be?
by ray.wurlod
Thu Jan 19, 2012 2:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to run job --14
Replies: 1
Views: 1797

Search DSXchange for error code -14. Generically there is too great a load on the server, for whatever reason.
by ray.wurlod
Thu Jan 19, 2012 2:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading & Writing using different configuration file
Replies: 11
Views: 2803

How do you know that?

Dump the score to learn definitively which operators are processing on which nodes.
by ray.wurlod
Thu Jan 19, 2012 2:41 am
Forum: General
Topic: Expiry date issue in Datastage administrator
Replies: 7
Views: 1983

Officially, yes, it's a problem. However, others have been able to install (unsupported) on Windows XP sp2. Can you open a CMD shell, cd to the installation directory, then to Server\DSEngine? (For example C:\IBM\InformationServer\Server\DSEngine) Once there, execute the command bin\uv This should t...
by ray.wurlod
Wed Jan 18, 2012 10:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with 'Ceil' function
Replies: 7
Views: 3251

That's a matter of semantic interpretation (of "next higher"). You may prefer

Code: Select all

Int((noMonths - 1) / 12) + 1
with a constraint that noMonths > 0.
by ray.wurlod
Wed Jan 18, 2012 8:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading & Writing using different configuration file
Replies: 11
Views: 2803

That partitioning is occurring on the input link of the Join stage and therefore will use the job's current configuration file.
by ray.wurlod
Wed Jan 18, 2012 8:38 pm
Forum:
Topic: Need help in using metadata workbench
Replies: 39
Views: 14459

No, but why not leave the default ("None") in place?
by ray.wurlod
Wed Jan 18, 2012 4:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading & Writing using different configuration file
Replies: 11
Views: 2803

When you read a Data Set and the configuration file you're using is not the one with which the Data Set was written, a temporary configuration file is used by the copy operator that reads from the Data Set.

You can achieve the same with the -x option of the orchadmin command.
by ray.wurlod
Wed Jan 18, 2012 4:57 pm
Forum: General
Topic: Implementation Diffferences Shell Script vs Datastage
Replies: 3
Views: 1387

What is "best"? You can do it either way (a job (sequence) or a script). What's best for you? What will be easier to maintain (for example parameterising the wait periods)?
by ray.wurlod
Wed Jan 18, 2012 4:55 pm
Forum: General
Topic: Run Designer from command line
Replies: 2
Views: 977

The job type does not matter. The command is dsjob (you can search here or in the documentation for details, such as how to have the exit status returned to the controlling script, how to pass values to parameters, etc.)

To get silent mode simply redirect stdout and stderr to a file.