Search found 75 matches

by ajithaselvan
Wed Oct 10, 2012 4:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DRS stage in DS8.5
Replies: 16
Views: 13140

Your assumption is correct. It is TERADATA stage
by ajithaselvan
Wed Oct 10, 2012 3:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DRS stage in DS8.5
Replies: 16
Views: 13140

Hi Arndw, Job is getting aborted. Below are the error message along with pervious one. cs}}}(0),0: Fatal Error: waitForWriteSignal(): Premature EOF on node fcas1820 Interrupted system call node_node1: Player 6 terminated unexpectedly. main_program: APT_PMsectionLeader(1, node1), player 6 - Unexpecte...
by ajithaselvan
Wed Oct 10, 2012 1:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DRS stage in DS8.5
Replies: 16
Views: 13140

Hi Ray/Arndw, Here is to go more. APT_CombinedOperatorController(1),0: 7fef50bfa000-7fef50bfb000 r--p 0001e000 68:03 40245 /lib64/ld-2.11.1.so APT_CombinedOperatorController(1),0: 7fef50bfb000-7fef50bfc000 rw-p 0001f000 68:03 40245 /lib64/ld-2.11.1.so APT_CombinedOperatorController(1),0: 7fef50bfc00...
by ajithaselvan
Tue Oct 09, 2012 4:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DRS stage in DS8.5
Replies: 16
Views: 13140

Re: DRS stage in DS8.5

My apology. Here are warnings tpgtable,0: 2b2c7c0f6000-2b2c7c3da000 r-xp 00000000 fd:17 2083039 /opt/IBM/InformationServer/Server/PXEngine/lib/liborchgeneralx86_64.so tpgtable,0: 2b2c7c3da000-2b2c7c4d9000 ---p 002e4000 fd:17 2083039 /opt/IBM/InformationServer/Server/PXEngine/lib/liborchgeneralx86_64...
by ajithaselvan
Tue Oct 09, 2012 4:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DRS stage in DS8.5
Replies: 16
Views: 13140

DRS stage in DS8.5

Hi, Im working on migrating parallel jobs from DS7.5 to 8.5. one of the jobs is to read a table from SQLSERVER DB using DRS stage. It works fine in 7.5. However, when I ran the same job in 8.5, it got aborted due to warnings mentioned below. I tested by replecing DRS stage with DRS connector in DS8....
by ajithaselvan
Mon Nov 14, 2011 4:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need some idea
Replies: 2
Views: 1604

Need some idea

Hi all, Can anyone help me how to implement? my input is like col1 col2 a a1 a a2 a a3 b b1 b b2 I need to split the values in col2 as separate columns based on col1. ie., if same group of col1 has diff vales in col2, then col2 values will be splited as separate columns Output: out_col1, out_col2, o...
by ajithaselvan
Mon Oct 24, 2011 10:46 pm
Forum: General
Topic: Passing null while importing storedprocedure
Replies: 2
Views: 1136

Re: Passing null while importing storedprocedure

Can anybody help me?

Regards
by ajithaselvan
Mon Oct 24, 2011 5:49 am
Forum: General
Topic: Passing null while importing storedprocedure
Replies: 2
Views: 1136

Passing null while importing storedprocedure

Hi experts, I'm trying to import SQL server stored procedure. I dont have any input parameters but I have 7 output parameters. All are NVarchar datatype. While importing, it is asking for Arguments list. I need to assign null as default values for above parameters. How can I pass it while importing?...
by ajithaselvan
Mon Oct 24, 2011 4:02 am
Forum: General
Topic: DS job is getting failed when executing through shell script
Replies: 11
Views: 5339

H Pandeesh,
I have tried your code... but still getting the same error
ERROR: Failed to open project

Status code = -1010 DSJE_DOMAINLOGTOFAILED
by ajithaselvan
Sat Oct 22, 2011 6:39 am
Forum: General
Topic: DS job is getting failed when executing through shell script
Replies: 11
Views: 5339

One of my other project mates had faced the same issue..... but the solution given to him is to add the user to system user group of his project. Issue got reolved once he added the user to this group. In my case, I have added my userid to the system group of my project. but still the problem persis...
by ajithaselvan
Sat Oct 22, 2011 12:03 am
Forum: General
Topic: DS job is getting failed when executing through shell script
Replies: 11
Views: 5339

Craig,
Pls find my syntax below

/opt/IBM/InformationServer/Server/DSEngine/bin/dsjob -domain $domain -server $server -user $user -password $pwd -run -wait -jobstatus pjt_name job_name
by ajithaselvan
Fri Oct 21, 2011 5:33 am
Forum: General
Topic: DS job is getting failed when executing through shell script
Replies: 11
Views: 5339

Ray,
I tried executing with adding job status and wait. But getting same error

ERROR: Failed to open project
Status code = -1010 DSJE_DOMAINLOGTOFAILED
by ajithaselvan
Thu Oct 20, 2011 11:47 pm
Forum: General
Topic: DS job is getting failed when executing through shell script
Replies: 11
Views: 5339

Job is exiting with error code 0. But it is not at all connected to the job
by ajithaselvan
Thu Oct 20, 2011 7:42 am
Forum: General
Topic: DS job is getting failed when executing through shell script
Replies: 11
Views: 5339

DS job is getting failed when executing through shell script

Hi, Need helping hand for below issue. I'm trying to run DS job using shell scripts.But It fails with below error code. ERROR: Failed to open project Status code = -1010 DSJE_DOMAINLOGTOFAILED. I have done below work around as suggested in this forum. 1. echoing DS command echo DS_HOME_DIR/bin/dsjob...