Search found 394 matches

by samsuf2002
Mon Feb 16, 2009 9:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage login Issue
Replies: 7
Views: 3905

Is this a new installation? Have you ever been able to login? Has your server been rebooted since the last successful login? Mike This not a new installation but I am not sure whether my server has been rebooted. But I can find that out. Do you think if it was rebooted and it dint come up fine afte...
by samsuf2002
Mon Feb 16, 2009 9:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage login Issue
Replies: 7
Views: 3905

DataStage login Issue

Hi All, When I am trying to login to datastage designer,director, or administrator i am getting the following error Failed to authenticate the current user against the selected Domain: java.lang.NullPointerException at org.eclipse.emf.common.util.BasicEMap.entryForKey(BasicEMap.java(Compiled Code)) ...
by samsuf2002
Fri Feb 13, 2009 4:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Columns
Replies: 6
Views: 2148

I did provision all and its working now, Thanks a bunch Ray.

Do we need to do that periodically ?
by samsuf2002
Fri Feb 13, 2009 3:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Columns
Replies: 6
Views: 2148

There is nothing different in production. I am using USADDR.SET in Standardize stage.
by samsuf2002
Fri Feb 13, 2009 2:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Columns
Replies: 6
Views: 2148

Thanks for the reply Ray. Actually I am not much familiar with Quality Stage part. Can you guide me how to check the rule set is provisioned ?
by samsuf2002
Fri Feb 13, 2009 12:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Columns
Replies: 6
Views: 2148

Problem with Columns

I have a PX job with a dataset---->Standardize stage---->Filter----->sort then rest of the stages. Jobs runs fine in test server but when we move it to production it failed with bunch of warnings and errors like errors- Filter_125: StreetName_USADDR is not a valid field name HouseNumber_USADDR is no...
by samsuf2002
Mon Feb 09, 2009 9:22 am
Forum: General
Topic: Parameters in Sequence
Replies: 4
Views: 1484

Thanks for the suggestion Craig.

I noticed that my sequence is using a parameter set, so if I add the new parameter into the parameter set then it looks easy task. Although I am afraid whether I have to re define the parameter set in all the sequence to make the changes effective. :?:
by samsuf2002
Fri Feb 06, 2009 5:00 pm
Forum: General
Topic: Parameters in Sequence
Replies: 4
Views: 1484

Parameters in Sequence

I have a small doubt in defining parameters in sequence. My question is if I have a job X and which is called by a sequence A and seq A is called by seq B and so on .... say sequence Z is the main sequence which runs all sub level sequences. So now I have to created a local parameter in Job X then d...
by samsuf2002
Tue Feb 03, 2009 9:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Handling date in a sqeuence
Replies: 6
Views: 2262

Sainath.Srinivasan wrote:IConv and OConv
I don't think we have Iconv()/Oconv() in parallel jobs.
by samsuf2002
Fri Jan 30, 2009 10:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Get the Input link record count and pass/insert into target
Replies: 8
Views: 6007

Why not use @INROWNUM in the transformer for target rowcount column.....
by samsuf2002
Wed Jan 28, 2009 9:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get full outer join using join stage
Replies: 10
Views: 8271

You can full outer join two tables first using a join stage and then pass the output into another join stage for another full outer join. There should be many other ways if you search the forum. For left and right record (might be your link names), it doesn't really matter unless you are mapping the...
by samsuf2002
Tue Jan 27, 2009 11:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Join stage error
Replies: 2
Views: 1307

Make sure that the sql type for Value1 is same in the job and if you want it to be different then use appropriate function to convert it. Also you need to handle the null values for column Value1 by the following code in the transformer column derivation. If IsNull(trim(Value1)) then '' else trim(Va...
by samsuf2002
Tue Jan 27, 2009 9:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to delete folder from director
Replies: 16
Views: 5287

Did you try refreshing the director ?
by samsuf2002
Tue Jan 27, 2009 9:37 am
Forum: General
Topic: email notification
Replies: 1
Views: 1100

email notification

Hi, If we have a main sequence job which calls other sequences and so on. What will be the best way to implement email notification for such sequence ? I was thinking to provide failure notification to all low level sequences and success notification to the main sequence. Any other ideas or suggesti...
by samsuf2002
Thu Jan 22, 2009 7:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Monitoring
Replies: 4
Views: 1430

Performance in case of extracting data from Oracle by running user defined queries. We improved some performance by creating indexes on the source tables and we want to try some more options in different areas to enhance the performance.

So I was wondering if turning off the Job monitor could help.