Link Count
Moderators: chulett, rschirm, roy
Link Count
Hi All,
We created XML job reports using DSJobReport in After-job routine.
when we looked at XML data, what we found is for same job name & link name it's returning multiple counts some are right count and some are not.
Is there a way I can get exact count or any other method I can get this information.
We created XML job reports using DSJobReport in After-job routine.
when we looked at XML data, what we found is for same job name & link name it's returning multiple counts some are right count and some are not.
Is there a way I can get exact count or any other method I can get this information.
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you can't get exact counts, how do you know that the counts you are getting are not the correct ones?!!
You can use the API or dsjob after the job has completed to get link row counts. But this uses the same mechanism that DSJobReport uses.
You can use the API or dsjob after the job has completed to get link row counts. But this uses the same mechanism that DSJobReport uses.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks Ray for the reply.
For same JOB_NAME, STAGE_NAME & LINK_NAME the ROW_COUNT is different and count on either of them are true.
LEDW_EDW_agreement DS_ES_Agreement Lnk_Agreement_file_in_cnt 5
LEDW_EDW_agreement DS_ES_Agreement Lnk_Agreement_file_in_cnt 467
True count is supposed to be like this.
LEDW_EDW_agreement DS_ES_Agreement Lnk_Agreement_file_in_cnt 871.
Any thoughts why I am not getting right row count.
SriMitta
For same JOB_NAME, STAGE_NAME & LINK_NAME the ROW_COUNT is different and count on either of them are true.
LEDW_EDW_agreement DS_ES_Agreement Lnk_Agreement_file_in_cnt 5
LEDW_EDW_agreement DS_ES_Agreement Lnk_Agreement_file_in_cnt 467
True count is supposed to be like this.
LEDW_EDW_agreement DS_ES_Agreement Lnk_Agreement_file_in_cnt 871.
Any thoughts why I am not getting right row count.
SriMitta
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You still haven't explained where the three different sets of values come from, and how you know that 871 is correct.
For example, were the values obtained on two separate runs? Have you verified by performing a line count on the output file?
For example, were the values obtained on two separate runs? Have you verified by performing a line count on the output file?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
If look at Performance Stastics in the job & record count in the file are same, but I don't find correct row count in XML created by DSJobReport in After-job Subroutine.
Plese let me know if I am missing any details, for better help.
Thanks
SriMitta
Plese let me know if I am missing any details, for better help.
Thanks
SriMitta
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I tried to run job with format option in DSJobRport as 1;/home/srmt002,
job created a job detail text file.
And also I ran job without file option, job returned below warning.
<Job Name>..AfterJob (DoJobReport): Failed to open directory
Thanks
SriMitta
job created a job detail text file.
And also I ran job without file option, job returned below warning.
<Job Name>..AfterJob (DoJobReport): Failed to open directory
Thanks
SriMitta
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Without file format option below is the Report generated by job.
**************************************************
STATUS REPORT FOR JOB: Audit_Job
Generated: 2008-03-17 18:56:26
Job start time=2008-03-17 18:56:23
Job end time=2008-03-17 18:56:26
Job elapsed time=00:00:03
Job status=1 (Finished OK)
Stage: Copy_of_Sequential_File_6.IDENT1, 28 rows input
Stage start time=2008-03-17 18:56:24, end time=2008-03-17 18:56:24, elapsed=00:00:00
Link: ppp, 28 rows
Link: ppp, 28 rows
Stage: Transformer_3, 49 rows input
Stage start time=2008-03-17 18:56:24, end time=2008-03-17 18:56:24, elapsed=00:00:00
Link: DSLink2, 49 rows
Link: DSLink5, 37 rows
Any idea how to design a job to read this file
**************************************************
STATUS REPORT FOR JOB: Audit_Job
Generated: 2008-03-17 18:56:26
Job start time=2008-03-17 18:56:23
Job end time=2008-03-17 18:56:26
Job elapsed time=00:00:03
Job status=1 (Finished OK)
Stage: Copy_of_Sequential_File_6.IDENT1, 28 rows input
Stage start time=2008-03-17 18:56:24, end time=2008-03-17 18:56:24, elapsed=00:00:00
Link: ppp, 28 rows
Link: ppp, 28 rows
Stage: Transformer_3, 49 rows input
Stage start time=2008-03-17 18:56:24, end time=2008-03-17 18:56:24, elapsed=00:00:00
Link: DSLink2, 49 rows
Link: DSLink5, 37 rows
Any idea how to design a job to read this file
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
I know what you mean to say.
Read as a single column with max column width.
This is what I need from job report, any idea how to get this info.
STATUS REPORT FOR JOB: Audit_Job
Job start time=2008-03-17 18:56:23
Job end time=2008-03-17 18:56:26
Job status=1 (Finished OK)
Stage: Copy_of_Sequential_File_6.IDENT1, 28 rows input
Link: ppp, 28 rows
Link: ppp, 28 rows
Stage: Transformer_3, 49 rows input
Link: DSLink2, 49 rows
Link: DSLink5, 37 rows
Thanks
SriMitta
Read as a single column with max column width.
This is what I need from job report, any idea how to get this info.
STATUS REPORT FOR JOB: Audit_Job
Job start time=2008-03-17 18:56:23
Job end time=2008-03-17 18:56:26
Job status=1 (Finished OK)
Stage: Copy_of_Sequential_File_6.IDENT1, 28 rows input
Link: ppp, 28 rows
Link: ppp, 28 rows
Stage: Transformer_3, 49 rows input
Link: DSLink2, 49 rows
Link: DSLink5, 37 rows
Thanks
SriMitta
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
Sorry earlier reply was not complete, here what I exactly what you needed from it.
JOB_NAME
JOB_START_TIME
JOB_END_TIME
STAGE_NAME
LINK_NAME
ROW_COUNT
JOB_STATUS
Thanks
SriMitta
JOB_NAME
JOB_START_TIME
JOB_END_TIME
STAGE_NAME
LINK_NAME
ROW_COUNT
JOB_STATUS
Thanks
SriMitta
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't need anything from it. You do. You use the Field() function and substring techniques to extract the various pieces. The delimiter character between lines is the system variable @FM.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.