QS job running slow from DS

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
garirt
Participant
Posts: 10
Joined: Thu Mar 31, 2005 6:37 pm

QS job running slow from DS

Post by garirt »

Hi,

I have a QS job which I'm calling from DS using the QS-Datastage plugin. When I run the job directly from QS it gets executed under 1 minute. But when I run the DS job that calls this QS job it is taking about 10mins to complete the QS job. What could be the reason ? I'm trying to find duplicates in data. The record count is about 60k.

Thanks
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

Do you have trace level in DataStage set to 0? Compare the QualityStage log files for each job run. It should give you a timestamp for each step in your QS job. Compare the timestamps from your QS run to your DS run to help narrow down what part of the job is slower.
garirt
Participant
Posts: 10
Joined: Thu Mar 31, 2005 6:37 pm

Post by garirt »

This is what I found in the qsrt manager log :
============ reading ADP FIELDS TO: OUTFILE ============

qsrtserv(14436):05/11/2005 09:37:35 AM
qsrtserv(14436):05/11/2005 09:37:36 AM LOG: binding adp INPFILE:Step000 to callback function
qsrtserv(14436):05/11/2005 09:37:36 AM LOG: binding adp OUTFILE:Step005 to callback function
<<<The following steps take the longest time to execute>>>>
[000]GTF[Run 000/Step001 of DUPDATA]: 1
[002]FRQ[Run 002/Step002 of DUPDATA]: 1
[003]SORT[Run 003/Step002 of DUPDATA]: 1
[004]MAT[Run 004/Step002 of DUPDATA]: 1
[005]XTR[Run 005/Step002 of DUPDATA]: 1
[000]GTF[Run 000/Step001 of DUPDATA]: 1
[002]FRQ[Run 002/Step002 of DUPDATA]: 1
[003]SORT[Run 003/Step002 of DUPDATA]: 1
[004]MAT[Run 004/Step002 of DUPDATA]: 1
[005]XTR[Run 005/Step002 of DUPDATA]: 1
============ Wrapup ============

qsrtserv(14436):05/11/2005 09:48:16 AM

============ [000]GTF[Run 000/Step001 of DUPDATA] ============

qsrtserv(14436):05/11/2005 09:48:16 AM
qsrtserv(14436):05/11/2005 09:48:16 AM LOG: inRecCnt=0, outRecCnt=58282
can anybody make out what is causing the delay ?
Post Reply