IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

To Check the Data in a File that is in use??


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
nareshkareti

New User


Joined: 22 Jul 2008
Posts: 33
Location: Chennai

PostPosted: Wed Aug 26, 2009 2:22 pm
Reply with quote

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
View user's profile Send private message
Ketan Varhade

Active User


Joined: 29 Jun 2009
Posts: 197
Location: Mumbai

PostPosted: Wed Aug 26, 2009 2:26 pm
Reply with quote

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
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2358
Location: Israel

PostPosted: Wed Aug 26, 2009 2:26 pm
Reply with quote

What do you mean by "tables"? What kind of tables?

O.
Back to top
View user's profile Send private message
nareshkareti

New User


Joined: 22 Jul 2008
Posts: 33
Location: Chennai

PostPosted: Wed Aug 26, 2009 3:58 pm
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Aug 26, 2009 4:04 pm
Reply with quote

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
View user's profile Send private message
Ketan Varhade

Active User


Joined: 29 Jun 2009
Posts: 197
Location: Mumbai

PostPosted: Wed Aug 26, 2009 4:06 pm
Reply with quote

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
View user's profile Send private message
nareshkareti

New User


Joined: 22 Jul 2008
Posts: 33
Location: Chennai

PostPosted: Wed Aug 26, 2009 4:16 pm
Reply with quote

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
View user's profile Send private message
Ketan Varhade

Active User


Joined: 29 Jun 2009
Posts: 197
Location: Mumbai

PostPosted: Wed Aug 26, 2009 4:21 pm
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Aug 26, 2009 4:23 pm
Reply with quote

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" icon_cry.gif
Back to top
View user's profile Send private message
nareshkareti

New User


Joined: 22 Jul 2008
Posts: 33
Location: Chennai

PostPosted: Wed Aug 26, 2009 4:32 pm
Reply with quote

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.. icon_sad.gif
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Wed Aug 26, 2009 4:55 pm
Reply with quote

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
View user's profile Send private message
nareshkareti

New User


Joined: 22 Jul 2008
Posts: 33
Location: Chennai

PostPosted: Wed Aug 26, 2009 10:16 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Aug 27, 2009 12:01 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top