Glad you found the maths stuff in DFSORT (presumably looong ago). BTW IFTHEN might help with ciel - but I wouldn't say it was any simpler, just a tad clearer. (And I've a feeling we did MAX / MIN which might help here.)
Martin Martin Packer Performance Consultant IBM United Kingdom Ltd +44-20-8832-5167 +44-7802-245-584 email: [email protected] Twitter ID: MartinPacker "They're figuring out that collaboration isn't a productivity hit, it makes them smarter." Sam Palmisano on BlogCentral, 26 November 2008 From: "McKown, John" <[email protected]> To: [email protected] Date: 25/06/2009 16:14 Subject: Re: DCOLLECT output - convert KB to tracks? Sent by: IBM Mainframe Discussion List <[email protected]> > -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:[email protected]] On Behalf Of Vernooij, CP - SPLXM > Sent: Thursday, June 25, 2009 9:32 AM > To: [email protected] > Subject: Re: DCOLLECT output - convert KB to tracks? > > > > "McKown, John" <[email protected]> wrote in message > news:<[email protected] > cnrh.dom>. > .. > > DCOLLECT outputs dataset sizes in KB (or KiB?). Anyway, management > wants the output in TRACKS. But I've noticed that the > conversion is not > as simple as "divide by ???" where ??? is an integer. What is the real > conversion factor for a 3390? Will it be simple to do in > ICETOOL, which > is what I am using for the report. It is all that I have left > since they > killed SAS. > > > > John McKown > > Systems Engineer IV > > IT > > > > This is how I do it in SAS: > aloctrks = ceil(dcdallsp/56664) > usedtrks = ceil(dcdusesp/56664) > > Kees. Thanks. But I had to multiply DCDALLSP by 1024 to make it work. If anybody is interested, I did this via an INREC OVERLAY similar to: INREC OVERLAY=(93:(93,4,BI,MUL,+1024,ADD,+56663),DIV,+56664,TO=BI,LENGTH=4) I had to ADD 56663 to emulate the effect of the CEIL function. -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * (817)-961-6183 cell [email protected] * www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM ---------------------------------------------------------------------- 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 Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU ---------------------------------------------------------------------- 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
