Capturing Oracle Logs

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

Post Reply
Poovalingam
Participant
Posts: 111
Joined: Mon Nov 30, 2009 7:21 am
Location: Bangalore

Capturing Oracle Logs

Post 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.
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Yes. You can do a linkinfo.

If you have followed good naming conventions, you can make it reusable also.
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post 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? :roll:
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Yes.
-craig

"You can never have too many knives" -- Logan Nine Fingers
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post 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. :cry:

Have i missed anything?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post by balajisr »

Craig,

Thanks for the reply.

How do we disable job monitor in server jobs?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post 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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Ah, ok... no problem. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply