Re: estimating number of records.
Ah... Kicking and scratching all the way, huh... On Wed May 14 13:56 , 'McKown, John' <[EMAIL PROTECTED]> sent: >> -Original Message- >> From: IBM Mainframe Discussion List >> [EMAIL PROTECTED]','','','')">[EMAIL PROTECTED] On Behalf Of Gary Green >> Sent: Wednesday, May 14, 2008 1:53 PM >> To: IBM-MAIN@BAMA.UA.EDU >> Subject: Re: estimating number of records. >> >> If it the file were VSAM, could you not call the CSI to get >> that information, somewhat, directly? > >Yes, if I were to use IGGCSI00. But I, personally, consider the calling >to be "difficult" and simply don't want to bother with it. Again, that >is me. Others disagree. I'm doing this more "quick and dirty" to get >some end users off my back. > >-- >John McKown >Senior Systems Programmer >HealthMarkets >Keeping the Promise of Affordable Coverage >Administrative Services Group >Information Technology > >The information contained in this e-mail message may be privileged >and/or confidential. It is for intended addressee(s) only. If you are >not the intended recipient, you are hereby notified that any disclosure, >reproduction, distribution or other use of this communication is >strictly prohibited and could, in certain circumstances, be a criminal >offense. If you have received this e-mail in error, please notify the >sender by reply and delete this message without copying or disclosing >it. > >-- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO >Search the archives at http://bama.ua.edu/archives/ibm-main.html > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: estimating number of records.
> -Original Message- > From: IBM Mainframe Discussion List > [mailto:[EMAIL PROTECTED] On Behalf Of Gary Green > Sent: Wednesday, May 14, 2008 1:53 PM > To: IBM-MAIN@BAMA.UA.EDU > Subject: Re: estimating number of records. > > If it the file were VSAM, could you not call the CSI to get > that information, somewhat, directly? Yes, if I were to use IGGCSI00. But I, personally, consider the calling to be "difficult" and simply don't want to bother with it. Again, that is me. Others disagree. I'm doing this more "quick and dirty" to get some end users off my back. -- John McKown Senior Systems Programmer HealthMarkets Keeping the Promise of Affordable Coverage Administrative Services Group Information Technology The information contained in this e-mail message may be privileged and/or confidential. It is for intended addressee(s) only. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited and could, in certain circumstances, be a criminal offense. If you have received this e-mail in error, please notify the sender by reply and delete this message without copying or disclosing it. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: estimating number of records.
If it the file were VSAM, could you not call the CSI to get that information, somewhat, directly? On Wed May 14 13:49 , 'McKown, John' <[EMAIL PROTECTED]> sent: >> -Original Message- >> From: IBM Mainframe Discussion List >> [EMAIL PROTECTED]','','','')">[EMAIL PROTECTED] On Behalf Of Tony Harminc >> Sent: Wednesday, May 14, 2008 1:02 PM >> To: IBM-MAIN@BAMA.UA.EDU >> Subject: Re: estimating number of records. >> >> 2008/5/14 Gary Green [EMAIL PROTECTED]>: >> > Well, disk datasets should be relatively easy... (if the >> information is returned from the LMDIST call) >> > >> > Number of tracks used * % of space used * blocks per track >> divided by record length. >> > >> > Or am I missing something in the question? >> >> RECFM=V ? >> >> Tony H. > >And VSAM. I'm giving up and just saying "No!" > >-- >John McKown >Senior Systems Programmer >HealthMarkets >Keeping the Promise of Affordable Coverage >Administrative Services Group >Information Technology > >The information contained in this e-mail message may be privileged >and/or confidential. It is for intended addressee(s) only. If you are >not the intended recipient, you are hereby notified that any disclosure, >reproduction, distribution or other use of this communication is >strictly prohibited and could, in certain circumstances, be a criminal >offense. If you have received this e-mail in error, please notify the >sender by reply and delete this message without copying or disclosing >it. > >-- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO >Search the archives at http://bama.ua.edu/archives/ibm-main.html > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: estimating number of records.
> -Original Message- > From: IBM Mainframe Discussion List > [mailto:[EMAIL PROTECTED] On Behalf Of Tony Harminc > Sent: Wednesday, May 14, 2008 1:02 PM > To: IBM-MAIN@BAMA.UA.EDU > Subject: Re: estimating number of records. > > 2008/5/14 Gary Green <[EMAIL PROTECTED]>: > > Well, disk datasets should be relatively easy... (if the > information is returned from the LMDIST call) > > > > Number of tracks used * % of space used * blocks per track > divided by record length. > > > > Or am I missing something in the question? > > RECFM=V ? > > Tony H. And VSAM. I'm giving up and just saying "No!" -- John McKown Senior Systems Programmer HealthMarkets Keeping the Promise of Affordable Coverage Administrative Services Group Information Technology The information contained in this e-mail message may be privileged and/or confidential. It is for intended addressee(s) only. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited and could, in certain circumstances, be a criminal offense. If you have received this e-mail in error, please notify the sender by reply and delete this message without copying or disclosing it. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: estimating number of records.
Okay, okay, you found the flaw in my suggestion... grumble, grumble, grumble... ;) On Wed May 14 14:01 , Tony Harminc <[EMAIL PROTECTED]> sent: >2008/5/14 Gary Green [EMAIL PROTECTED]>: >> Well, disk datasets should be relatively easy... (if the information is >> returned from the LMDIST call) >> >> Number of tracks used * % of space used * blocks per track divided by record >> length. >> >> Or am I missing something in the question? > >RECFM=V ? > >Tony H. > >-- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO >Search the archives at http://bama.ua.edu/archives/ibm-main.html > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: estimating number of records.
2008/5/14 Gary Green <[EMAIL PROTECTED]>: > Well, disk datasets should be relatively easy... (if the information is > returned from the LMDIST call) > > Number of tracks used * % of space used * blocks per track divided by record > length. > > Or am I missing something in the question? RECFM=V ? Tony H. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: estimating number of records.
> -Original Message- > From: IBM Mainframe Discussion List > [mailto:[EMAIL PROTECTED] On Behalf Of Gary Green > Sent: Wednesday, May 14, 2008 11:49 AM > To: IBM-MAIN@BAMA.UA.EDU > Subject: Re: estimating number of records. > > Well, disk datasets should be relatively easy... (if the > information is returned from the LMDIST call) > > Number of tracks used * % of space used * blocks per track > divided by record length. > > Or am I missing something in the question? That's what I planned. The difficult part was estimating the same for tape. I should have been more explicit. But I've gotten a good idea on that as well from others (use the same interface that DFSORT does). -- John McKown Senior Systems Programmer HealthMarkets Keeping the Promise of Affordable Coverage Administrative Services Group Information Technology The information contained in this e-mail message may be privileged and/or confidential. It is for intended addressee(s) only. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited and could, in certain circumstances, be a criminal offense. If you have received this e-mail in error, please notify the sender by reply and delete this message without copying or disclosing it. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: estimating number of records.
Well, disk datasets should be relatively easy... (if the information is returned from the LMDIST call) Number of tracks used * % of space used * blocks per track divided by record length. Or am I missing something in the question? On Wed May 14 10:31 , 'McKown, John' <[EMAIL PROTECTED]> sent: >I know that DFSORT and other products can estimate the number of input >records, given a disk dataset or even a tape. Is there some GUPI >interface where I can get this information myself, easily? > >Reason: I have a web page which can list datasets. It uses the ISPF >LMDLIST function to get the datset information. For disk datasets, it >can get the number of tracks, and creation date. I have been asked if it >could also get the create date for tape datasets from CA-1 as well as an >estimate of the probable number of input records for both disk and tape. >I don't really want to do this, but I said that I'd ask. > >-- >John McKown >Senior Systems Programmer >HealthMarkets >Keeping the Promise of Affordable Coverage >Administrative Services Group >Information Technology > >The information contained in this e-mail message may be privileged >and/or confidential. It is for intended addressee(s) only. If you are >not the intended recipient, you are hereby notified that any disclosure, >reproduction, distribution or other use of this communication is >strictly prohibited and could, in certain circumstances, be a criminal >offense. If you have received this e-mail in error, please notify the >sender by reply and delete this message without copying or disclosing >it. > >-- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO >Search the archives at http://bama.ua.edu/archives/ibm-main.html > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: estimating number of records.
For DFSORT, there is a documented exit ICETPEX which supplies tape dataset size information to DFSORT. I think that typically the tape management software would include a version of this exit for use by DFSORT. Bill On Wed, 14 May 2008 10:31:11 -0500, McKown, John <[EMAIL PROTECTED]> wrote: >I know that DFSORT and other products can estimate the number of input >records, given a disk dataset or even a tape. Is there some GUPI >interface where I can get this information myself, easily? > >Reason: I have a web page which can list datasets. It uses the ISPF >LMDLIST function to get the datset information. For disk datasets, it >can get the number of tracks, and creation date. I have been asked if it >could also get the create date for tape datasets from CA-1 as well as an >estimate of the probable number of input records for both disk and tape. >I don't really want to do this, but I said that I'd ask. > >-- >John McKown >Senior Systems Programmer >HealthMarkets >Keeping the Promise of Affordable Coverage >Administrative Services Group >Information Technology > >The information contained in this e-mail message may be privileged >and/or confidential. It is for intended addressee(s) only. If you are >not the intended recipient, you are hereby notified that any disclosure, >reproduction, distribution or other use of this communication is >strictly prohibited and could, in certain circumstances, be a criminal >offense. If you have received this e-mail in error, please notify the >sender by reply and delete this message without copying or disclosing >it. > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html