Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
Poovalingam
Participant
Posts: 111 Joined: Mon Nov 30, 2009 7:21 am
Location: Bangalore
Post
by Poovalingam » Mon Dec 07, 2009 5:05 am
Hi all,
I'm using DS 8.1 in AIX. I'm having a set of jobs and for all the jobs Oracle table is the target and the job doing insert/udpate on those tables. Now one of my requirement is to have a shells script that should get the oracle information such as no. of records inserted, updated, rejected & total records read on the Oracle for the particular job.
Will the dsjob script help in this case?
Pls suggest me any ideas.
Thanks,
Poova.
Sainath.Srinivasan
Participant
Posts: 3337 Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom
Post
by Sainath.Srinivasan » Mon Dec 07, 2009 6:12 am
Yes. You can do a linkinfo.
If you have followed good naming conventions, you can make it reusable also.
balajisr
Charter Member
Posts: 785 Joined: Thu Jul 28, 2005 8:58 am
Post
by balajisr » Mon Dec 07, 2009 6:17 am
Sainath.Srinivasan wrote: Yes. You can do a linkinfo.
If you have followed good naming conventions, you can make it reusable also. ...
Is it possible to retrieve these information if the job monitor is switched off?
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Dec 07, 2009 7:57 am
Yes.
-craig
"You can never have too many knives" -- Logan Nine Fingers
balajisr
Charter Member
Posts: 785 Joined: Thu Jul 28, 2005 8:58 am
Post
by balajisr » Mon Dec 07, 2009 10:27 pm
chulett wrote: Yes. ...
I wrote a simple routine to fetch link row count using DSGetLinkInfo().
When I ran job with job monitor switched on, link row count is ok. But when i rerun the job with job monitor switched off i get link row count (using DSGetLinkInfo()) as 0.
Have i missed anything?
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Dec 08, 2009 6:43 am
Maybe not. That makes no sense to me, but perhaps the job monitor must indeed be enabled for that to work for a PX job and I lied.
Hopefully someone knows for sure.
-craig
"You can never have too many knives" -- Logan Nine Fingers
balajisr
Charter Member
Posts: 785 Joined: Thu Jul 28, 2005 8:58 am
Post
by balajisr » Tue Dec 08, 2009 9:36 pm
Craig,
Thanks for the reply.
How do we disable job monitor in server jobs?
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Dec 08, 2009 10:55 pm
You can't, it's not a separate app like it is in PX. Why would you want to?
-craig
"You can never have too many knives" -- Logan Nine Fingers
balajisr
Charter Member
Posts: 785 Joined: Thu Jul 28, 2005 8:58 am
Post
by balajisr » Tue Dec 08, 2009 11:21 pm
chulett wrote: You can't, it's not a separate app like it is in PX. Why would you want to?
...
Thanks. Just wanted to know.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Dec 08, 2009 11:28 pm
Ah, ok... no problem.
-craig
"You can never have too many knives" -- Logan Nine Fingers