Search found 78 matches

by tehavele
Tue Jul 13, 2010 12:48 am
Forum: General
Topic: Status code = -9999 DSJE_DSJOB_ERROR
Replies: 10
Views: 9882

I can't see anything that stands out as being wrong. I'd recommend starting with just running the job with no parameters and then adding in parameters one at a time until it "breaks" so you know what is causing the problem. Andy , I used this approach. I started with no parameters. After ...
by tehavele
Mon Jul 12, 2010 11:49 pm
Forum: General
Topic: Status code = -9999 DSJE_DSJOB_ERROR
Replies: 10
Views: 9882

I ran the job successfully through director. Now When I am trying to run through dsjob utility it is giving same error. {cdsusr@cdhiiad1:/opt/IBM/InformationServer/Server/DSEngine/bin}FLOC -param GENERATION_PARAMETER=Gen_Param DMD < Invalid arguments: dsjob -run [-mode <NORMAL | RESET | VALIDATE>] [...
by tehavele
Mon Jul 12, 2010 11:39 pm
Forum: General
Topic: Status code = -9999 DSJE_DSJOB_ERROR
Replies: 10
Views: 9882

He meant -jobinfo rather than status. Thanks for correcting Craig. {cdsusr@cdhiiad1:/opt/IBM/InformationServer/Server/DSEngine/bin}dsjob -jobinfo DMDev RECON_STG1_2_STG2_tej Job Status : RESET (21) Job Controller : not available Job Start Time : Tue Jul 13 00:43:52 2010 Job Wave Number : 0 User Sta...
by tehavele
Mon Jul 12, 2010 8:54 am
Forum: General
Topic: Status code = -9999 DSJE_DSJOB_ERROR
Replies: 10
Views: 9882

Command "dsjob -jobstatus DMDev RECON_STG1_2_STG2" returned {cdsusr@cdhiiad1:/opt/IBM/InformationServer/Server/DSEngine/bin}dsjob -jobstatus DMDev RECON_STG1_2_STG2 Invalid/unknown primary command switch. Command Syntax: dsjob [-file <file> <domain> <DataStage server> | -domain <domain> -u...
by tehavele
Mon Jul 12, 2010 8:28 am
Forum: General
Topic: Status code = -9999 DSJE_DSJOB_ERROR
Replies: 10
Views: 9882

Status code = -9999 DSJE_DSJOB_ERROR

I am trying to execute job through unix using dsjob command. I hava a job which I am able to execute through dsjob command as below. dsjob -run -param Value=abc -param Value1=12 -param test=Tejas DMDev Student_2 But when I am trying to run another job with below syntax dsjob -run -param ET_JOB_NAME=...
by tehavele
Sun Mar 21, 2010 1:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job control process (pid 2100) has failed ?????
Replies: 7
Views: 6983

Hi Kaushal,
I faced the same problem.
As I had the dsx file of the job I re-imported the job and then It was run successfully. You can re-create the job or re-import it.
by tehavele
Mon Jan 11, 2010 2:45 am
Forum: General
Topic: PATH search failure
Replies: 4
Views: 7773

Thanks Craig. The problem is solved now. This system was already there running on vendor's system. Now we have moved system to our environment. So , this is the first tiime we are running this system in our dev environment. In this problem file 'operator.apt' was mssing , which is linking the datast...
by tehavele
Fri Jan 08, 2010 8:33 am
Forum: General
Topic: PATH search failure
Replies: 4
Views: 7773

Thanks for reply Craig. I did change the PATH variable and added the path where buildop.so file is located. But It is still throwing the same error.
Am I missing something here ? What change I have to add in PATH variable ?



Regards,
Tejas
by tehavele
Fri Jan 08, 2010 4:31 am
Forum: General
Topic: PATH search failure
Replies: 4
Views: 7773

PATH search failure

Hi , I am running in some of datastage jobs in dev env.Jobs have only executables.In one of the jobs buildop is used. This job is not getting aborted with following errors. main_program: PATH search failure: main_program: Could not locate operator definition, wrapper, or Unix command for "Crypt...
by tehavele
Wed Nov 25, 2009 11:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to handle reject in Join
Replies: 5
Views: 7858

Use Transformer stage after join stage. Capture reject rows using Null handling function IsNull.
by tehavele
Tue Oct 27, 2009 6:14 am
Forum: General
Topic: Null handling in Transfomer
Replies: 6
Views: 2154

No.It's there in 7.5 versions as well. I am working on 7.5.1
by tehavele
Tue Oct 27, 2009 12:32 am
Forum: General
Topic: Input tables in Join Stage
Replies: 3
Views: 1659

You will have to change the names of all non key columns on the either of the links.Only Key column names should be same.
by tehavele
Mon Oct 26, 2009 11:23 pm
Forum: General
Topic: Null handling in Transfomer
Replies: 6
Views: 2154

In the transformart constraint add below constraints.

Code: Select all

IsNotNull(C_ID) And IsNotNull(A_ID)
by tehavele
Wed Oct 21, 2009 5:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to Find months between date and load to history table
Replies: 1
Views: 640

I have come across this sort of calculation.For this I had created a buildop which would create duplicate rows equal to difference of the months and then in the following transformer after build op calculate dates.This is just a general idea.
by tehavele
Thu Oct 15, 2009 5:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Look Up Stage Problem
Replies: 2
Views: 1418

In parallel job use lookup stage and take all the locations with their ids in one row with cross join.and then in the transformer Use If and else logic to derive employee location based on the priority.