Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: To Check the Data in a File that is in use??
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    Post subject:
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: 2360
Location: Israel

PostPosted: Wed Aug 26, 2009 2:26 pm    Post subject:
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    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Wed Aug 26, 2009 4:04 pm    Post subject: Re: To Check the Data in a File that is in use??
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    Post subject:
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    Post subject:
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    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Wed Aug 26, 2009 4:23 pm    Post subject:
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    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Wed Aug 26, 2009 4:55 pm    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Thu Aug 27, 2009 12:01 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
This topic is locked: you cannot edit posts or make replies. How to move a long alphanumeric data ... lind sh COBOL Programming 8 Mon Dec 05, 2016 7:51 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts What is the command to check MODE of ... rohanthengal CLIST & REXX 6 Fri Nov 18, 2016 1:48 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us