Issue in record Extraction
Moderators: chulett, rschirm, roy
Issue in record Extraction
Hi Folks
Facing a strange problem , extracting data from z/os - DB2 . Link counts show 10000 records and view data shows 10000 , actual dump into a dataset has only 100 records immaterial of data extracted !
Facing a strange problem , extracting data from z/os - DB2 . Link counts show 10000 records and view data shows 10000 , actual dump into a dataset has only 100 records immaterial of data extracted !
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How are you determining the number of rows in the Data Set?
What else is happening in the job design? Is there anything at all in the job design that might prevent records from being passed through? Is the job compiled in trace mode?
What else is happening in the job design? Is there anything at all in the job design that might prevent records from being passed through? Is the job compiled in trace mode?
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.
Hello Ray
I am using DataSet-Management utility to read the dataset and the no:of records in each node.
There are no other stages in the Job , it is just a dump of the table we are taking for processing in the subsequent Jobs.
Job is compiled normally not in trace mode
I am using DataSet-Management utility to read the dataset and the no:of records in each node.
There are no other stages in the Job , it is just a dump of the table we are taking for processing in the subsequent Jobs.
Job is compiled normally not in trace mode
Last edited by ag_ram on Thu Jul 19, 2007 10:32 pm, edited 1 time in total.
Are you sure that you are looking at the actual record counts and not some limit placed by the "view data" in the Data Set Management tool?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I like using the command line tool orchadmin ll {dataset} ; that gives me the number of records per partition, total bytes, etc.
You could try to get a 2nd opinion on the number of the records in the dataset.
You could try
Code: Select all
orchadmin dump {DataSet} | wc -l
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Issue in record Extraction
Did you check the data in DB2? Is 10000 the correct number, or are the 100 records that you are getting, the correct result?