Search found 376 matches

by jerome_rajan
Thu Jan 15, 2015 5:21 am
Forum: General
Topic: Multiple DataStage Versions on Same Server
Replies: 12
Views: 5464

Just have one final follow-up question. We actually managed to execute using the below command. We did this so that there wouldn't be a need to use the auth file. dsjob -server :31539 -run -mode ...... My question is - what needs to be done to run the dsjob without even the server parameter just lik...
by jerome_rajan
Fri Jan 09, 2015 1:12 am
Forum: General
Topic: Multiple DataStage Versions on Same Server
Replies: 12
Views: 5464

Awesome! Used the auth file to store all domain/server/user/pass details and managed to get it running. Thank you all
by jerome_rajan
Tue Jan 06, 2015 9:51 pm
Forum: General
Topic: Multiple DataStage Versions on Same Server
Replies: 12
Views: 5464

Thank you, Craig.
I sourced the 9.1 dsenv file using

Code: Select all

 . `cat /.9.1dshome`/dsenv
I also checked the $DSHOME and it points correctly to the DS9 home.

Image
by jerome_rajan
Tue Jan 06, 2015 9:23 pm
Forum: General
Topic: Multiple DataStage Versions on Same Server
Replies: 12
Views: 5464

I'm sorry Craig. I am yet to renew my membership.
If you're asking me what environment I've loaded then I'm not sure how that needs to be done. Which probably means we are still on 8.1.
by jerome_rajan
Tue Jan 06, 2015 9:01 pm
Forum: General
Topic: Multiple DataStage Versions on Same Server
Replies: 12
Views: 5464

Nope. I ran

Code: Select all

`cat /.9.1dshome`/bin/dsjob
by jerome_rajan
Tue Jan 06, 2015 7:37 am
Forum: General
Topic: Multiple DataStage Versions on Same Server
Replies: 12
Views: 5464

I renamed the /.dshome to /.8.1dshome and /.9.1dshome for the respective versions. Checked the $DSHOME variable. Was as expected.

I'm not sure I understand what should go into the -domain and -server arguments since both installations are on the same server
by jerome_rajan
Tue Jan 06, 2015 4:40 am
Forum: General
Topic: Multiple DataStage Versions on Same Server
Replies: 12
Views: 5464

Multiple DataStage Versions on Same Server

We have DataStage 8.1 and DataStage 9.1 installed on the same server. All jobs were migrated from 8.1 to 9.1. When I try to execute a job from CLI using dsjob, the job in 8.1 repository runs and not the one in 9.1.

Am I missing something?
by jerome_rajan
Thu Dec 18, 2014 12:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need logic for Rank generation
Replies: 12
Views: 9681

Do you HAVE to use DataStage? What is the source - Table or file?
by jerome_rajan
Wed Nov 26, 2014 1:12 am
Forum: General
Topic: Running Multiple Jobs in Parallel in DataStage Sequencer
Replies: 6
Views: 10057

Awesome Awesome Awesome! The background execution did the trick for me.
Mike's first reply definitely made me a tad wiser than before. Thank you ! :D
by jerome_rajan
Tue Nov 25, 2014 1:27 am
Forum: General
Topic: Running Multiple Jobs in Parallel in DataStage Sequencer
Replies: 6
Views: 10057

..... But if your job 2 is something other than a job activity stage (e.g. routine activity or execute command activity), then job 3 won't start until job 2 is completed. ... Mike Thank you for the elaborate response, Mike. Job 2, in my case is an 'Execute Command' activity which means that my desi...
by jerome_rajan
Mon Nov 24, 2014 3:30 am
Forum: General
Topic: Running Multiple Jobs in Parallel in DataStage Sequencer
Replies: 6
Views: 10057

Running Multiple Jobs in Parallel in DataStage Sequencer

Hi, I created a sequencer that does something runs a job and upon completion triggers 2 other jobs in parallel. The problem is that the jobs do not trigger in parallel but in sequence. What am I doing wrong? This is how the code looks. Job 2 and Job 3 should trigger at the same time since the trigge...
by jerome_rajan
Mon Oct 20, 2014 9:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: One generic job to extract data from all tables
Replies: 4
Views: 3952

I posted an answer here for a generic file to table process. The flow for a table to table process shouldn't be too different.
by jerome_rajan
Tue Oct 14, 2014 3:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage slow performance
Replies: 14
Views: 12548

Also have a peek into the &PH& directory to ensure that the number of files isn't too much. You decide how much is too much.
by jerome_rajan
Tue Oct 14, 2014 3:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RCP job unable to read from oracle
Replies: 2
Views: 2741

Anyone? :roll:

Could this be an issue with the connector or am I doing something wrong?
by jerome_rajan
Thu Oct 09, 2014 3:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RCP job unable to read from oracle
Replies: 2
Views: 2741

RCP job unable to read from oracle

I have a RCP enabled job that reads from an Oracle table and loads a dataset. I have not defined any columns in the connector metadata but have RCP enabled. I get the error:

Code: Select all

The connector could not validate the input schema. Specify at least one column in the input schema
What could the reason be?