Search found 53125 matches

by ray.wurlod
Tue Feb 14, 2006 3:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file read cache limit
Replies: 8
Views: 1601

You can take it to 1000MB in uvconfig. Not that great a gain really. Read the manual dsdskche.pdf (in your Docs folder) for full information.
by ray.wurlod
Tue Feb 14, 2006 3:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to get ascential support?
Replies: 8
Views: 1281

You still need to determine who your support provider is.
by ray.wurlod
Tue Feb 14, 2006 3:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Message PDF for DataStage like in BO
Replies: 1
Views: 744

In the next release, yes. In the current release no. C'est la vie.
by ray.wurlod
Tue Feb 14, 2006 3:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL query with IN clause
Replies: 14
Views: 4137

How about a pivot preceding the lookup so that each lookup is only retrieving one name?
by ray.wurlod
Tue Feb 14, 2006 3:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Interations Methodology CDROM
Replies: 1
Views: 597

No. It must be ordered separately.
by ray.wurlod
Tue Feb 14, 2006 3:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: where is job log stored?
Replies: 8
Views: 1987

It's also in the Parallel Job Developer's Guide, which you are more likely to have open if you're designing parallel jobs.
by ray.wurlod
Tue Feb 14, 2006 3:41 pm
Forum:
Topic: Handling Metadata
Replies: 1
Views: 1295

The best advice I can give is "don't touch it". Use the Import tools. Any time you touch the keyboard you risk introducing error. Table definitions imported through Orchestrate (orchdbutil) seem to be more robust for parallel jobs than those imported through plug-in stages (such as OCI). I find that...
by ray.wurlod
Mon Feb 13, 2006 11:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Set File
Replies: 8
Views: 1815

I don't think this is possible without introducing some boundary, such as a Modify stage, to rename one (or both) of the distinct names back to the single name you require is separate Data Sets. Duplication of column names on outputs of Transformers appears not to be permitted.
by ray.wurlod
Mon Feb 13, 2006 11:39 pm
Forum: IBM QualityStage
Topic: Unable to run Rules Analyzer for new RuleSet
Replies: 7
Views: 3101

Curious. When you used the Copy Rule Set option did it actually copy? That is, did you see another rule set file created? Was anything different in the CTL file in the two scenarios? (If you don't want to go back to the failed scenario because you have one that works, that's OK. I trust that you rep...
by ray.wurlod
Mon Feb 13, 2006 10:20 pm
Forum: IBM QualityStage
Topic: Unable to run Rules Analyzer for new RuleSet
Replies: 7
Views: 3101

Welcome aboard! :D

Even though you think the bttemp files are of no help, can you please post them here (if they're not too long) so we can also take a peek?
by ray.wurlod
Mon Feb 13, 2006 5:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Avoid Concatenate/constants in Transformer
Replies: 7
Views: 1901

Use a Cycle with only one value in the cycle.
by ray.wurlod
Mon Feb 13, 2006 4:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Routines in parallel extender
Replies: 1
Views: 1152

Welcome aboard. :D The correct answer is no. However, DataStage BASIC routines can be used in conjunction with parallel jobs in two scenarios; as Routine activities in job sequences that also invoke parallel jobs, and called from server job components in server shared containers in parallel jobs.
by ray.wurlod
Mon Feb 13, 2006 4:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Tricky Requirement
Replies: 4
Views: 1860

It could be done quite straightforwardly using DataStage BASIC. I refrained from answering in this vein earlier because the question is posted in the parallel forum. The DataStage BASIC (possibly a custom job control routine) would execute a UNIX command (such as find or tree) to return a treewalk o...
by ray.wurlod
Mon Feb 13, 2006 4:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage PX features for Cluster or Grid
Replies: 3
Views: 1983

There was a paper presented at IBM Information Integration Live last November in Las Vegas on using DataStage EE in a grid environment. Can you get access to the papers from this conference?
by ray.wurlod
Sun Feb 12, 2006 10:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Restarting a job with the same parameters
Replies: 15
Views: 4792

The parameters last used are in the log "job started" entry for the previous run. Before the job starts they're also in the RT_STATUSxxx table for the job. Possibly easier to retrieve from there.