View previous topic :: View next topic
|
Author |
Message |
nareshkareti
New User
Joined: 22 Jul 2008 Posts: 33 Location: Chennai
|
|
|
|
Hi,
This Q seems to be a silly one, but wanted to confirm on that..
A job is unloading data from tables and writing into a new file (New, catalog, delete). The job is still running and I wanted to see how many records it has written in to the file. If i use traditional methods, it is showing "file in use" .
Is there any way to see the data in that file. |
|
Back to top |
|
|
Ketan Varhade
Active User
Joined: 29 Jun 2009 Posts: 197 Location: Mumbai
|
|
|
|
I dont think so that we can view the number of records while the job is running however you can check the sysout for the count, |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
What do you mean by "tables"? What kind of tables?
O. |
|
Back to top |
|
|
nareshkareti
New User
Joined: 22 Jul 2008 Posts: 33 Location: Chennai
|
|
|
|
Does the type of table matters..
Because my problem is to check the data in the file that is being created in a jcl and in use for writing records into that file.
actually it is not a platinum unload to see the sysout. the cobol pgm does the unload into a file after many validations.. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
nareshkareti wrote: |
A job is unloading data from tables and writing into a new file (New, catalog, delete). The job is still running and I wanted to see how many records it has written in to the file. If i use traditional methods, it is showing "file in use" |
Why not just issue a period count message, e.g. after every x thousand records written, issue a message saying exactly that. |
|
Back to top |
|
|
Ketan Varhade
Active User
Joined: 29 Jun 2009 Posts: 197 Location: Mumbai
|
|
|
|
Hi Naresh,
When you are unloading a the table using a Cobol program , then just put a counter while unloading , put that counter to the display and you will the number of records that have been unloaded to the file.
After the program execution is been completed |
|
Back to top |
|
|
nareshkareti
New User
Joined: 22 Jul 2008 Posts: 33 Location: Chennai
|
|
|
|
Ofcourse these are all the alternatives to check the count of the data.
But the badluck is the programs are implemented into production without any these options and that jcl is running from long time. According the input file the limit is 15000 records.
So I just wanted to check how many records the pgm has written into output file, so that I can calculate the approximate time of its ending. |
|
Back to top |
|
|
Ketan Varhade
Active User
Joined: 29 Jun 2009 Posts: 197 Location: Mumbai
|
|
|
|
For how long is the job running ?
You can try with less number of rec and submit a job and check the functionality, I don’t think so that program will take much time to unload 15000 records? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
nareshkareti wrote: |
But the badluck is the programs are implemented into production without any these options and that jcl is running from long time. |
I would say "bad planning" rather than "bad luck" |
|
Back to top |
|
|
nareshkareti
New User
Joined: 22 Jul 2008 Posts: 33 Location: Chennai
|
|
|
|
We came to know that the records are being fetched using tablespace scan instead of index scan.The table has almost 35 million recods where in it has to fecth only 15K based on some validations.
We have never thought that it would more than 5hrs to unload 15k records.
The main thing is we will get control report only after that cobol pgm step is processed.
So from the above discussion I can confirm that there is no way to check the data in a file(New ctlg del) when it is in use.. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Afraid not, disp = NEW uses exclusive ownership.
Also, we alsways use the Ops Acceptance environment with copies of production data, so the volumes of data processed will will be the same as in production. This is where we discover and resolve issues like this. |
|
Back to top |
|
|
nareshkareti
New User
Joined: 22 Jul 2008 Posts: 33 Location: Chennai
|
|
|
|
Finally i had to cancel to that job.
If someone finds tool or application to chk the data in a file(NCD) which is in use, Please let me know. I guess IBM only have to release such tool.
Thanks a lot for ur suggestions today. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
We came to know that the records are being fetched using tablespace scan instead of index scan. |
Suggest this be corrected. . .
Quote: |
The main thing is we will get control report only after that cobol pgm step is processed. |
If the control report was "written" to a database table, the data could be read while the process was still running. . . |
|
Back to top |
|
|
|