Page 1 of 1
Capturing Oracle Logs
Posted: Mon Dec 07, 2009 5:05 am
by Poovalingam
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.
Posted: Mon Dec 07, 2009 6:12 am
by Sainath.Srinivasan
Yes. You can do a linkinfo.
If you have followed good naming conventions, you can make it reusable also.
Posted: Mon Dec 07, 2009 6:17 am
by balajisr
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?
Posted: Mon Dec 07, 2009 7:57 am
by chulett
Yes.
Posted: Mon Dec 07, 2009 10:27 pm
by balajisr
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?
Posted: Tue Dec 08, 2009 6:43 am
by chulett
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.
Posted: Tue Dec 08, 2009 9:36 pm
by balajisr
Craig,
Thanks for the reply.
How do we disable job monitor in server jobs?
Posted: Tue Dec 08, 2009 10:55 pm
by chulett
You can't, it's not a separate app like it is in PX. Why would you want to?
Posted: Tue Dec 08, 2009 11:21 pm
by balajisr
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.
Posted: Tue Dec 08, 2009 11:28 pm
by chulett
Ah, ok... no problem.
