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

How to find total space used by individual tso userids


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

New User


Joined: 20 Sep 2006
Posts: 63
Location: pune

PostPosted: Fri Jun 10, 2011 7:08 pm
Reply with quote

Hi All,

I want to create a report on monthly basis to find out total space utilizaton by individual tso userids for my team.

How this can achieved are there any system logs from there we can fetch this information for all tso user ids.


Thanks,
Sandip Walsinge
Pune
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1787
Location: Bloomington, IL

PostPosted: Fri Jun 10, 2011 7:21 pm
Reply with quote

Why yes, there are a multitude of data available.

Now, are you looking for high-water mark usage, time-weighted average usafe, point-in-time usage, or something else?
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India

PostPosted: Fri Jun 10, 2011 7:39 pm
Reply with quote

Possibly, get a report of obselete/current DSNs created by someone else, which are huge in nature - (tell, I've found them, and claim for DASD savings! not memory by the way)
Back to top
View user's profile Send private message
sandip_mainframe
Warnings : 2

New User


Joined: 20 Sep 2006
Posts: 63
Location: pune

PostPosted: Fri Jun 10, 2011 7:41 pm
Reply with quote

I am looking for a total memory sapce utilised by datasets which are created by that tso user id.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jun 10, 2011 7:49 pm
Reply with quote

Quote:
I am looking for a total memory sapce utilised by datasets which are created by that tso user id.


total memory utilized will only be during execution of a program/utility
that accesses these ds.

so, unless a job is running that utilize one of these datasets
during the time you collect your statistics (how ever you do it)
total memory utilized will be zero.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA

PostPosted: Fri Jun 10, 2011 7:52 pm
Reply with quote

Quote:
total memory sapce utilised by datasets
The answer to this is quite simple -- the total memory used will be ZERO. Memory is part of the CPU and is only accessed by the system. Disk space is used by the data sets and is not memory.

Terminology is critical in IT, where similar terms may mean very different things. Memory and disk space are not interchangeable terms.

Further, even if you meant disk space -- you still have not clearly indicated what you are wanting. Do you want to know what the user ids have allocated today -- at a particular time or just whenever the collection job gets its information? The average allocated space for a day / week /month / year / some other time period? The maximum allocated space by the user id for a day / week / month / year / some other time period? Something else entirely?
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Fri Jun 10, 2011 7:56 pm
Reply with quote

the best thing to do is to ask Your storage support,
unless they are completely <...> this kind of accounting has been in place every where for ages
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1787
Location: Bloomington, IL

PostPosted: Fri Jun 10, 2011 7:58 pm
Reply with quote

sandip_mainframe wrote:
I am looking for a total memory sapce utilised by datasets which are created by that tso user id.

No doubt. However, consider the following scenario: TSO ID LUSER has, at 1 September 0001, a single data set LUSER.FOO that uses one cylinder. At 29 September 0001, it creates a second data set LUSER.BAR that uses 100 cylinders; that data set is deleted at 30 September 0001. If the report is run 1 October 0001, should it show LUSER as using:
  1. 1 cylinder
  2. 101 cylinders
  3. 4.33 cylinders/day
  4. 130 cylinder-days
  5. Something else


(Data sets, of course, do not use memory, they use DASD or tape. However, I'm passing over this mere misuse of terminology to start getting at more fundamental questions.)
Back to top
View user's profile Send private message
sandip_mainframe
Warnings : 2

New User


Joined: 20 Sep 2006
Posts: 63
Location: pune

PostPosted: Mon Jun 13, 2011 7:41 pm
Reply with quote

Thanks to all of you for your suggestions, I got to the way to do it.


Let's say my userid is - ABCD123, by giving my user id like

ABCD123.* it will give list of all datasets created by my userid and by save as command it will save all then info in dataset

ABCD123.AS.DATASETS it will have information about how tracks are alloacted and how much % is used. Form that dataset by sort job I can find the total space used.

Thanks,
Sandip Walsinge
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India

PostPosted: Mon Jun 13, 2011 7:53 pm
Reply with quote

sandip_mainframe wrote:
ABCD123.AS.DATASETS
?? icon_confused.gif
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1353
Location: Israel

PostPosted: Mon Jun 13, 2011 8:08 pm
Reply with quote

My userid is ABCD123, but I'm working on project XYZ, and I have created a huge file named XYZ.MY.DATA
Will you be able to catch me ??? icon_wink.gif
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Mon Jun 13, 2011 8:56 pm
Reply with quote

Hello,

Did you consider the questions asked by Akatsukami?

Your solution will get a "snapshot" of what is allocated at that exact moment but may not show what you are looking for. If all you need is a "current use", this may work well for you.

The AS may be their local convention.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India

PostPosted: Mon Jun 13, 2011 9:00 pm
Reply with quote

But
dick scherrer wrote:
The AS may be their local convention.
ISPF 3.4/SAVE LIST won't tell you all this:
Quote:
ABCD123.AS.DATASETS it will have information about how tracks are alloacted and how much % is used.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Mon Jun 13, 2011 9:23 pm
Reply with quote

Hi Anuj,

Quote:
ISPF 3.4/SAVE LIST won't tell you all this:
Quote:
ABCD123.AS.DATASETS it will have information about how tracks are alloacted and how much % is used.


With the exception of the "AS" a SAVE of a list does tell us "all this". I've used this on quite a few systems, so possibly i misunderstand something?

d
Back to top
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 590
Location: London

PostPosted: Wed Jun 15, 2011 1:57 am
Reply with quote

The previous suggestion to talk to you Storage people should be heeded first

but...

ISPF 3.4 now has an option to total the tracks allocated by all the datasets in the list (at that point in time). Just page right once the list comes up.

Option ===>

blank Display data set list P Print data set list
V Display VTOC information PV Print VTOC informati

Enter one or both of the parameters below:
Dsname Level . . . ABCD123.**
Volume serial . .

Data set list options
Initial View Enter "/" to select option
1 1. Volume / Confirm Data Set Delete
2. Space / Confirm Member Delete
3. Attrib / Include Additional Qualifiers
4. Total Display Catalog Name
Display Total Tracks


You can also get totals from ISMF;1 by entering LISTPRT on a resultant list. The output file has totals at the end (in KB I think)
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Wed Jun 15, 2011 2:33 am
Reply with quote

Hi Anuj,

Quote:
ISPF 3.4/SAVE LIST won't tell you all this:
I believe i may have caused a bit of confusion icon_redface.gif

If 4 is used here (along with the "select option" slashes):
Code:
Data set list options                                           
   Initial View                 Enter "/" to select option       
   1  1. Volume                 /  Confirm Data Set Delete       
      2. Space                  /  Confirm Member Delete         
      3. Attrib                 /  Include Additional Qualifiers
      4. Total                  /  Display Catalog Name         
                                /  Display Total Tracks         
                                   Prefix Dsname Level           
   

the space info as well as other info is saved into the file.
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Wed Jun 15, 2011 1:40 pm
Reply with quote

Do you also need to include datasets that have been migrated ?
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India

PostPosted: Wed Jun 15, 2011 3:08 pm
Reply with quote

Thanks Dick.

"option 4" was never used as default among others, at the shops I had been to, so it was not that obvious to me.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Wed Jun 15, 2011 8:32 pm
Reply with quote

Hi Expat,

Quote:
Do you also need to include datasets that have been migrated ?
Sure as so much is migrated these days icon_smile.gif

d
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 Get RECORD LENGTH, allocated space of... CLIST & REXX 7
No new posts sort to find out the char which repea... Mainframe Interview Questions 10
No new posts Compare 2 alphabets in a REXX and fin... CLIST & REXX 2
No new posts Replace each space in cobol string wi... COBOL Programming 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
Search our Forums:

Back to Top