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
s_porkalai
Participant
Posts: 38 Joined: Sun Mar 25, 2007 11:05 pm
Location: chennai
Post
by s_porkalai » Fri Jul 20, 2007 11:33 pm
Hi all,
i have to find the row count of no of rows coming from the source and no of rows rejected and no of rows inserted into target.
is there any option for finding row count in parallel extender 7.5 version.
can anyone help me regarding this
thanks in advance
thanks & Regards
A.S.Porkalai Lakshmi
vikasjawa
Participant
Posts: 13 Joined: Tue Aug 29, 2006 3:20 am
Location: Gurgaon
Post
by vikasjawa » Sat Jul 21, 2007 4:26 am
Hi,
Apart from the visual check, you cen get this stat from the log files in the DS Director.You need to set the enviornment variable:APT_DUMP_SCORE
to "true" for this.
Vikas Jawa
Minhajuddin
Participant
Posts: 467 Joined: Tue Mar 20, 2007 6:36 am
Location: Chennai
Contact:
Post
by Minhajuddin » Sat Jul 21, 2007 4:47 am
If you have links coming from the source, going to the Target DB and a reject link. Then you can find the number of rows processed on those links by a simple routine. Search the forum for DSLinkInfo and you'll get a lot of ways to do it.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Sat Jul 21, 2007 7:04 am
DSGetLinkInfo actually.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Sat Jul 21, 2007 5:34 pm
There is an environment variable (something like APT_PM_ROWCOUNTS) that causes each player process to display its row counts.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
s_porkalai
Participant
Posts: 38 Joined: Sun Mar 25, 2007 11:05 pm
Location: chennai
Post
by s_porkalai » Mon Jul 30, 2007 10:06 pm
Is there any way of using DSLinkInfo to capture the row count in After job routine
thanks & Regards
A.S.Porkalai Lakshmi
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Mon Jul 30, 2007 10:23 pm
s_porkelai - whyever not?
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Jul 31, 2007 12:10 am
s_porkalai wrote: Is there any way of using DSLinkInfo to capture the row count in After job routine
DSGetLinkInfo()
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.