Search found 114 matches

by maffan76
Tue Mar 11, 2008 9:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Checkpointing is taking too much time
Replies: 9
Views: 3914

Local Support is not very helpful :( as they are third party and they dont have right skill for DS.
by maffan76
Tue Mar 11, 2008 8:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Checkpointing is taking too much time
Replies: 9
Views: 3914

Yes in most of the cases
by maffan76
Tue Mar 11, 2008 8:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Checkpointing is taking too much time
Replies: 9
Views: 3914

Yes thats what surprising me as well in DS Director the step says "Checkpointing Job" and if you see the timings then the the taken by this step is 15-20 Minutes and the rest of the steps finish in 1-2 Minutes. Where does DS do the checkpointing and is there any housekeeping required for D...
by maffan76
Tue Mar 11, 2008 7:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Checkpointing is taking too much time
Replies: 9
Views: 3914

Checkpointing is taking too much time

Hi,
I am facing a problem in DS in execution of Job that Job take a minute to finish but the checkpointing is taking approx. 15-20 Mins to complete. I am clueless where to look for the slowness of the checkpointing. Any clue and guidance would be helpful.

Thanks in Advance.
by maffan76
Mon Aug 14, 2006 4:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read Access for DS Jobs
Replies: 6
Views: 3061

But i want the Operator to see the job names/Logs in Director. Can you please exlpain to which repository tables do i need to give permissions as i could not find anything related to this.

Thanks in advance.
by maffan76
Mon Aug 14, 2006 2:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read Access for DS Jobs
Replies: 6
Views: 3061

Hi, I am facing a problem related to this as when i make a user DS Operator he cannot see the job list in Director. ALthough Documentation says that DSOperator can run jobs. Am i missing something here. how can i make a user DS Operator so that he can see the jobs/Logs and run the operations. Thanks...
by maffan76
Mon May 08, 2006 5:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: End Date Calculation
Replies: 7
Views: 2961

But i have to transform the other columns as well i-e applying business rules to other columns, so is it a good idea to put the modify stage and then pass the data to transformaer for applying the business rules. Also whats the best practice for the situation where mix of rules exist e.g. Data type ...
by maffan76
Sun May 07, 2006 4:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: End Date Calculation
Replies: 7
Views: 2961

hi
Done it using TimestampFromDateTime & TimestampFromSecondsSince. The only question left is that is this an efficient way of calculating the end datetime?
by maffan76
Sun May 07, 2006 12:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: End Date Calculation
Replies: 7
Views: 2961

hi,
The duration is in Seconds and want to calculate the end date based on that.
by maffan76
Sat May 06, 2006 1:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: End Date Calculation
Replies: 7
Views: 2961

End Date Calculation

hi, I have 2 columns Date, Time and third column contains duration. i want to calculate the end date time based on these 3 columns. Can someone please throw some light to how to accomplish it efficiently as i ahve to process large amount of data. Also hows does PX internally manipulates the Datetime...
by maffan76
Fri Dec 16, 2005 11:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Fast Export Stage Giving Error
Replies: 2
Views: 1402

Actually, by upgrading it to 7.5 the issue has been resolved.

Thanks for the reply.
by maffan76
Sun Nov 27, 2005 3:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: OCI plugin error-ACESS DENIED
Replies: 4
Views: 1636

Hi Poornagirija ,
Can you please specify that what previliges you set to get rid of this problem.

Thanks in advance.
by maffan76
Wed Nov 16, 2005 9:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Tranformer compilation error
Replies: 19
Views: 14529

No there should be one cd which comes with your VS.NET installation, its called Pre-Requisite. Just put that CD in Drive and it will automatically update all the required components.

HTH
by maffan76
Wed Nov 16, 2005 5:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Tranformer compilation error
Replies: 19
Views: 14529

Yes,
.NET has to upgrade some components to make OS compatible and i did upgrade the components and it worked fine
by maffan76
Tue Nov 15, 2005 9:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple Keys join of Files
Replies: 4
Views: 1742

Thanks for the clarification, Now coming to the second part of the question is that if have to join source table data coming in a file with some target table in database, whats the optimal way of doing it, i mean one ways is to make a hash file and then join those or is there anyother way of doing i...