Search found 459 matches

by T42
Mon Nov 29, 2004 11:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compilation Error: No excclusive access to job ? Solution ??
Replies: 3
Views: 2408

90% of the time I have seen this message, I have the Director's log view enabled for that job.

Get out of the Director's log view for that job, and it should work. If not, Ray offered quite a few other possible reasons for this.
by T42
Mon Nov 29, 2004 11:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What are the new things in Datastage 7.5
Replies: 2
Views: 1538

Yeah. Particularly pay attention to the Job Sequencer's enhancements that should be VERY useful for you.
by T42
Mon Nov 29, 2004 11:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: usage of join,merge and lookup
Replies: 10
Views: 3973

but agin my question remains unanswerd. Are there are certain ranges of volume of data for which we can say if this is range use join. if this is range then use lookup etc. It should be based on the amount of memory you have available to you at that particular moment. This is not a cut n' dry answe...
by T42
Mon Nov 29, 2004 11:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: WHAT IS ORCHESTRATE THAT IS USED IN DATABASE STAGE
Replies: 3
Views: 4064

Okay... Whenever you see Orchestrate, Ignore it. Think of it like a C++ class, a really HUGE C++ class. :-P A struct, if you're a C person. This structure is being used behind the scene to pass data to Oracle from the input link. This structure's metadata have all the fields that you are seeing. Whe...
by T42
Mon Nov 29, 2004 11:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Moving from DataStage Server to Enterprise Edition
Replies: 6
Views: 2554

Re: Moving from DataStage Server to Enterprise Edition

What is the learning curve? You must go away from the Transformer mentality to a wide compliment of stages that handles the same functions (lookup stage for one.) Basically, it requires flexibility on the person learning about the product to handle different concepts. It's like learning Java after ...
by T42
Mon Nov 29, 2004 11:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Req for list of possible values and descrip for Job codes
Replies: 7
Views: 6178

What you have pasted is also exactly how PX jobs will abort.

Can you please paste the log of those 'failure' messages you are observing, please?
by T42
Mon Nov 29, 2004 11:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Use of Reporting Job parameters
Replies: 1
Views: 1728

You are not really paying close attention to the logs, if you think they are reporting the same thing. According to DataStage 7.5 documents: APT_DUMP_SCORE - Print a human-readable representation of how PX will handle the job just before the step is executed. APT_PM_PLAYER_MEMORY - Report on heap me...
by T42
Mon Nov 29, 2004 11:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to check the set of 50 rows
Replies: 5
Views: 2337

Input -> Transformer -> Sort -> Transformer -> Output. First transformer = use a counter method (search for it) that handles your conditions. Pass the counter output appended to each record. Sort the data so that the maximum value of the counter are ranked first. Second transformer would handle the ...
by T42
Mon Nov 29, 2004 10:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing ampersand (&) in a property value
Replies: 2
Views: 1442

I don't understand the problem. I built a wrapped stage and I see this: #!/bin/sh # Generated on 11/29/2004 at 11:39:55 PM ... command = \"wget -o 'logfilepath/logfilename' 'http://server:port/dir/.../file.xml&report=REPORTNAME'\", status = {default_good} ... I'm doing this on 7.0.1, a...
by T42
Mon Nov 29, 2004 10:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to use the orchestrate.columnname in the database stage
Replies: 1
Views: 4489

orchestrate.[column_name] is basically Orchestrate's method in passing on data values that are provided on the input link to this database stage. If you ever coded in PL/SQL, you should understand this concept immediately.
by T42
Mon Nov 29, 2004 10:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Why basic transformer in PX causes serious performance issue
Replies: 2
Views: 1584

Re: Why basic transformer in PX causes serious performance i

can any body tell me why basic transformer casuse serious performance problems in parallel job. Orchestrate is a distinct engine developed beneath Parallel Extender. Basic Transformer is a very fat and very sequential plugin that sit nice n' fat on top of the slim and sleek Orchestrate. And in what...
by T42
Mon Nov 29, 2004 10:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Failed a keylookup for record
Replies: 5
Views: 3687

Because the log msg. says "50% processed". That message only show up on Sequential File load. No matter what you are doing down the stream, the Sequential File being 50% load could still mean that only 30% are being processed down the stream where your lookup stage is. Please observe the ...
by T42
Mon Nov 29, 2004 10:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: run-time error when exporting job executable
Replies: 3
Views: 1669

Dumb question: Did you run out of diskspace for the directory where you are extracting the .DSX file onto?
by T42
Mon Nov 29, 2004 10:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Parent/Child records in CFF - BUG?
Replies: 1
Views: 671

The best people to ask this question is Ascential Support. They have a nice complete log of bug listing and associated patches. Give them a call and be nice to them. :D
by T42
Mon Nov 29, 2004 10:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in using Informix CLI stage against informix (9.31)
Replies: 1
Views: 1192

Have you read the parjdev.pdf document (Parallel Extender Developer Guide), particularly the chapter on "Informix Enterprise Stage"? Please ensure that everything (including ensuring that configurations are set up correctly) are properly done. Let us know how you are coming along with this...