Search found 53125 matches

by ray.wurlod
Tue Sep 13, 2011 7:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file performance issue
Replies: 11
Views: 6799

Hashed files - and note that there's no such thing as a "hash file" - are accessed randomly, not sequentially. The unit of data transfer is the hashed file's group size (by default 2KB, tunable to other values). A particular "group" is identified by its offset from the beginning ...
by ray.wurlod
Tue Sep 13, 2011 7:47 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: WAS docs and web service security questions
Replies: 6
Views: 4262

WAS for Information Server is intended to be a black box, save for the single step of identifying the authentication method (which is documented in the Planning, Installation and Configuration Guide). You can find out anything you need to know about WAS from the IBM web site - particularly the Infor...
by ray.wurlod
Tue Sep 13, 2011 7:44 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: MQ Connector Usage in an always-on Job
Replies: 16
Views: 16161

Yes there is, and it's really simple. Just don't use either of the -jobstatus or -wait options.
by ray.wurlod
Tue Sep 13, 2011 4:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job abort during AGG OR SORT
Replies: 24
Views: 6267

The DS.TUNEPROPS command applies only to a server job that contains an Aggregator stage. It allows the memory allocation model for the Aggregator to be modified. The single argument for this command is the name of the job. >DS.TUNEPROPS SummarizeProduct Stages in job: SummarizeProduct Stage# Stage n...
by ray.wurlod
Tue Sep 13, 2011 2:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generate 4 different table structre records into single File
Replies: 1
Views: 624

Use the Column Export stage to generate common format, then Funnel stage to bring them together.
by ray.wurlod
Tue Sep 13, 2011 2:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Record delimiter and field delimiter in dataset
Replies: 1
Views: 916

None. The record schema describes the structure completely. For example an int32 is precisely four bytes long.
by ray.wurlod
Tue Sep 13, 2011 2:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job abort during AGG OR SORT
Replies: 24
Views: 6267

Occasionally I like to sleep, particularly during the night. There are some tools for tuning the Aggregator stage memory table but, if you don't have that memory, you're only going to aggravate your disk issues. I'll need to research the command - it used to be available from the DS.TOOLS menu, but ...
by ray.wurlod
Tue Sep 13, 2011 4:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capture Ora Error in the reject link
Replies: 2
Views: 1942

What's the value of the Write Method property?
by ray.wurlod
Tue Sep 13, 2011 4:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: logic needed
Replies: 1
Views: 1068

Search DSXchange for "vertical pivot" for that is what you seek to perform.
by ray.wurlod
Tue Sep 13, 2011 4:51 am
Forum: General
Topic: Sequencer that a parallel job is part of
Replies: 2
Views: 822

In the log event from the job there is a "job under control finished" event that names the controller. Within the job itself you can use the macro DSController.
by ray.wurlod
Tue Sep 13, 2011 4:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pivot Stage
Replies: 3
Views: 1630

What does your source actually (physically) look like? Is there, for example, a final delimiter or an empty line following the data line?
by ray.wurlod
Tue Sep 13, 2011 1:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Afterjob Subroutine in parallel job paramete
Replies: 3
Views: 1330

In an after-job subroutine, as Susanne noted, setting ErrorCode to a non-zero value will cause the job to abort when the subroutine returns. Do NOT try to abort the job from within the subroutine. It leaves locks if you do.
by ray.wurlod
Sun Sep 11, 2011 10:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal error shared library xmloenu.dll failed to load
Replies: 12
Views: 4291

Has the XML Pack been installed in the new location? Is your shared library search list set correctly?
by ray.wurlod
Sun Sep 11, 2011 10:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Record Dropped
Replies: 18
Views: 7618

... which is exactly the same as NullToValue(DSLink18.copysno,1)
by ray.wurlod
Sun Sep 11, 2011 2:29 pm
Forum: General
Topic: validating number of files
Replies: 14
Views: 3262

You can use a routine (passing argument values to it) to write whatever you like to the log.