Search found 53125 matches

by ray.wurlod
Thu Apr 16, 2015 1:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to convert date in Datastage internal format in Parallel
Replies: 4
Views: 3635

Parallel jobs automatically use their own internal format for dates (indeed for most other data types too). See chapter 2 of Parallel Job Developer's Guide for details. The parallel job internal format is not the same as the server job internal format, but why would you need the latter in a parallel...
by ray.wurlod
Thu Apr 16, 2015 1:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding RCP Enabled Job
Replies: 6
Views: 2353

I must presume that your selection was of the form Select #Parameter# From #Parameter# A, #Parameter# B Where A.column=B.column rather than what you provided. You can use the data from the Data Set, materialized via the Modify stage, to delete, provided that the column is identified as Key in DataSt...
by ray.wurlod
Thu Apr 16, 2015 1:37 am
Forum: General
Topic: Unix Sript calling in After Sub routine
Replies: 13
Views: 2415

You could have used an activity variable from the Job activity, and avoided the overhead of creating and invoking an operating system process. Just a thought.
by ray.wurlod
Wed Apr 15, 2015 5:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple messages at project level Message handler
Replies: 3
Views: 1748

You can only have one. Build that Message Handler to handle all of the message IDs that you need to handle.
by ray.wurlod
Tue Apr 14, 2015 5:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning in lookup stage in version 11.3
Replies: 4
Views: 2272

Since there's no more recent patch than R2, the answer to your patch question is currently "no". Version 11.3 is being more rigorous at detecting various things (such as duplicates in the reference data set) than version 8.5. You have been relying upon a deficiency in the older version. Yo...
by ray.wurlod
Tue Apr 14, 2015 5:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can't open hash via Account, only Directory Path
Replies: 3
Views: 3832

There is, though it might be a bit convoluted depending on the VOC entries. You say that the physical D_hashedfilename files have gone (presumably deleted by someone at the operating system level), but that the VOC entry continues to have the (path)name of D_hashedfilename. If that summary is correc...
by ray.wurlod
Tue Apr 14, 2015 4:57 pm
Forum: General
Topic: DS 9.1 - independent WAS Cluster - start/stop procedures
Replies: 4
Views: 1227

It really depends on what you want to do. In general, though, it's best to stop all processes, otherwise the Deployment Manager will continue to accept requests from Information Server processes, and then throw errors if the associated service can't be found on any node.
by ray.wurlod
Mon Apr 13, 2015 9:49 pm
Forum: General
Topic: DS 9.1 - independent WAS Cluster - start/stop procedures
Replies: 4
Views: 1227

Yes. The separate node agents and the Domain Manager are separate processes.
by ray.wurlod
Mon Apr 13, 2015 4:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning in lookup stage in version 11.3
Replies: 4
Views: 2272

Insert a Remove Duplicates stage in the Reference input link to the Lookup stage.
by ray.wurlod
Mon Apr 13, 2015 4:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential operator cannot preserve partitioning of parallel
Replies: 10
Views: 25974

Try clearing in the immediately upstream stage.
by ray.wurlod
Mon Apr 13, 2015 4:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can't open hash via Account, only Directory Path
Replies: 3
Views: 3832

Review which hashed files are account-based and which are pathed. To be able to access a file dictionary there must be a VOC entry in which the data file pathname is in field #2 and the dictionary file pathname is in field #3. A dictionary is necessary to perform filtering in the hashed file stage. ...
by ray.wurlod
Mon Apr 13, 2015 4:07 pm
Forum: General
Topic: Regarding Invocation id
Replies: 4
Views: 1440

Re your second question: Probably your job log auto purge is set to a too small value. If you want to keep 30 instances worth of logs, then it needs to be at least 30, or time-based.
by ray.wurlod
Sun Apr 12, 2015 11:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Invoke Oracle Query - Performance Issue
Replies: 4
Views: 1782

Welcome aboart. The query verifies that the table METASTAGE_LOC_INFO, which contains locality information used when updating information in the common metadata repository, exists. A fatal error will be thrown if this table is found not to exist. That it doesn't work in the non-production environment...
by ray.wurlod
Thu Apr 09, 2015 11:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with XML stage mapping
Replies: 5
Views: 4783

:idea:
Why don't you (Ernie) propose "Mysteries of the new XML Stage... Revealed!!" as a paper for Insight 2015?
by ray.wurlod
Thu Apr 09, 2015 4:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Calling SOAP services from datastage
Replies: 3
Views: 2619

Do you get the same timeouts when using another client, such as SOAPUI? Sometimes it's just that the web service itself is slow to respond (for whatever reason). You can test the turnaround time with various tools.