Search found 158 matches

by kavuri
Wed Dec 19, 2007 12:31 pm
Forum: General
Topic: After Job subroutine, DSGetLinkInfo()
Replies: 13
Views: 13314

No uotput

Hi, I tried to write rowcount for a single link by passing parameters. I am having the after job routine code like follows: $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF If count(InputArg,',') <> 3 Then k = 2 goto ErrorExit End Else LinkName = field(InputArg,",",1) !Interface...
by kavuri
Tue Dec 18, 2007 9:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: where to call a routine
Replies: 1
Views: 715

where to call a routine

Hi, I had designed a job and created a server routine to find the rowscount for each link . I need to write the data to a seperate file. My Riutine code: $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF hJob=DSAttachJob(DSJ.ME,DSJ.ERRFATAL) If NOT(hJob) Then call DSLogFatal("Job Atta...
by kavuri
Tue Dec 18, 2007 8:30 pm
Forum: General
Topic: After Job subroutine, DSGetLinkInfo()
Replies: 13
Views: 13314

For Testing, I had written the code like this #INCLUDE DSINCLUDE JOBCONTROL.H Ans=DSGetLinkInfo(DSJ.ME,"Transformer_21","InputArg",DSJ.LINKROWCOUNT) Return (Ans) I had created the afterJob subroutine as a server routine. Then I am having the parallel job like following which is a...
by kavuri
Tue Dec 18, 2007 7:20 pm
Forum: General
Topic: After Job subroutine, DSGetLinkInfo()
Replies: 13
Views: 13314

Do we need parallel routine

Hi, My job is a parallel Job. And here I am writing a after Job Subroutine. Do I need actually a parallel routine? or server routine is sufficient. I need to find RowCount for each link seperately, But not sum of all rowscount. Please tell me how can I do this? I had the code from your previous post...
by kavuri
Mon Dec 17, 2007 2:05 pm
Forum: General
Topic: After Job subroutine, DSGetLinkInfo()
Replies: 13
Views: 13314

After Job subroutine, DSGetLinkInfo()

Hi,
I am having a job designed. I would like to find how many number of rows were transferred to the target file. I need to write a after job subroutine and design a job and load the number of rows transferred to the target file in a seperate file.

Thanks
Kavuri
by kavuri
Fri Oct 12, 2007 10:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel routine memory leak?
Replies: 3
Views: 1647

yuiduan,
if you satisfy with the answer please mark the posting as resolved.


Kavuri
by kavuri
Thu Oct 11, 2007 9:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: partitioning
Replies: 2
Views: 1293

Re: partitioning

Thanks Jamach,
i.e we need to opt for preserve partitioning and use same right?

Any other comments are welcome and any more performance issues please let me know.

Thanks
Kavuri
by kavuri
Thu Oct 11, 2007 8:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parallel routine
Replies: 2
Views: 1104

Thanks for your clarification DSGuru2B.
by kavuri
Thu Oct 11, 2007 8:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: partitioning
Replies: 2
Views: 1293

partitioning

Hi, I am working on 7.5.1 EE. I am designing parallel routines. We have so many partitioning methods like hash, auto, DB2, round robin etc. Can anybody tell me in what circumstances which partition we have to use? Are there any specific rule to use a particular partition? And also can anybody tell m...
by kavuri
Thu Oct 11, 2007 8:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parallel routine
Replies: 2
Views: 1104

parallel routine

Hi, I studied thata we can write C++ routines and can be called from Transformer stage in server jobs. I think we can also call routines in parallel jobs also. I had created a parallel job and called a C++ routine from transformer stage in parallel job. When I went for an interview they are arguing ...
by kavuri
Fri Sep 28, 2007 7:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: code review
Replies: 3
Views: 1427

Thanks
Kavuri
by kavuri
Thu Sep 27, 2007 8:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job got struck
Replies: 4
Views: 2750

Job got struck

Hi, I ran a job earlier it work fine. Now I ran the same job but it got struck. It locked the DB2 table as well as job. This is my key job based on which all other jobs are dependents. Can any body tell me how can I Kill it. I want to kill it. But I didn't get the proper PID for this. Can you tell m...
by kavuri
Thu Sep 27, 2007 8:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: code review
Replies: 3
Views: 1427

code review

Hi,
I had designed some jobs. My client want to review code (i.e actually review designed jobs). How he can perform a code review. Is there any way?

Thanks
Kavuri
by kavuri
Fri Sep 21, 2007 7:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob -run
Replies: 14
Views: 3859

Thanks Craig, I appreciate your directions for learning.

Thanks once again.
Kavuri
by kavuri
Thu Sep 20, 2007 4:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob -run
Replies: 14
Views: 3859

Yes, thanks Craig, Now its working fine, I had changed in my C++ routine which I compiled, but I havent compiled job since then. So I am getting this error. Can you tell me how you have identified error for the STATE code? Is there any manual shows for this error this is the reason? One more thing, ...