Monthly Stats

[DDP021]

Got another off the wall question...Our management is looking for us to provide some statistics...Basically looking for a "total" count of pages,  across ALL Applicatons, we are loading on a monthly basis...Does anyone know if it's possible to retrieve that kind of number?..And if so, how would you go about doing so?...

[Frederick Tybalt]

Hello,
Does the application group have any fields defined for page count? if then that field can be summed up from AG table.

[DDP021]

Most of our newer definitions are using the PAGE COUNT Field, but there are many older ones that came over from the conversion from ODE2.1 that don't...

[Alessandro Perucchi]

Hello DDP021,

well in that case... I see only 2 solutions:

1) export documents and count the pages on each one (and maybe save the value for future reference for each document)
2) do some extrapolations... like... this kind of document use in average 759 bytes per pages, so if my document is 38293 byte, it means I have around 51 pages ( 38293 / 759 = 50.5 )

Hope that helps a little bit...

Sincerely yours,
Alessandro

[Justin Derrick]

I understand that this sort of metric helps the non-technical types visualize how large the data in CMOD is, I caution against using this as a measure for anything important (capacity planning, etc.).  Page sizes can vary dramatically between text (2k), PDF(2k to 2MB or more), and image types (typically 50k), and there's no such thing as a '5000 page hard drive' or a '100 page per second processor'.

-JD.

[DDP021]

Thanks as always Justin and Alessandro for all the input...


We just received another request, this time from auditing...They want us to provide a listing of users defined to CMOD and what access they have..The issue we are having is, we use RACF for security..They were originally imported to CMOD when we converted off of ODE on the mainframe...We now just manually add them to CMOD (but they must exist on RACF)...But essentially the ID will remain on CMOD for eternity even if it's removed from RACF..Unless we receive a request to delete an id...We don't have any way of doing an automated removal of the ID's from CMOD..We also use defined GROUPS for access to Folders in CMOD...So basically, we need to supply them a listing of all the id's and what Groups they have access to...We then have to supply a listing of the defined Groups that shows what Folders they have access to..We found, via the Administrator Client, we can run a "summary" on the users and groups choosing the options for both that will give us the information we need...With over 22,000 user defined (again not knowing how many are actually valid anymore) and over 267 access groups, the summary results for both are quite large...The issue we face now is trying to "merge" the two separate files into one need one that would basically show the user id, their name, the groups they are defined to and what Folders they have access to..We think this is what auditing is looking for so they can then go back to the owners of the folders and sign off indicating the users that are viewing their data are valid...Not sure how others using CMOD are working with this kind of issue???

[ewirtz]

Hi,
you can read all users defined in CMOD. For all this users you have to look whether they are still defined in RACF. If not you can generate an arsxml delete of the user process this arsxml.

regards

Egon

[DDP021]

Thanks Egon....I guess the first thing is to try and determine what users defined to CMOD aren't defined to RACF anymore....Just not sure how to go about doing that...If/when we ever resolve that issue, we then need to determine how to obtain the access the valid users have...We found how to run the SUMMARY out of the admin client to retrieve what access groups each user is defined to and we also were able to run a summary on the groups themselves to determine what user ids are defined to the group and what folders they have access to..From the Group summary all we need is the folder information....Just need to somehow figure out how to "merge" the to so it list the information in a manner auditing will like...Basically needs look like:

USER ID:         USER NAME:        GROUP(S) defined to:         FOLDER ACCESS

[Frederick Tybalt]

What about obtaining these details from the below table hierarchy in CMOD for valid users on RACF?  Hope the z/os version too have same table structure

ARSUSER
ARSUSRGRP
ARSUSRGRPID
ARSFOL
ARSFOLPERMS

[DDP021]

Thanks Rick...Do you know where to find these?...Like I said, the trick is getting the information into a CSV file structure that they want...Basically they want a listing of the Folders, from there, they want a listing of what GROUPS have access to that folder, and from there a listing of the user ids/names of people defined to the groups....So the .csv file will have headings for FolderName, GroupName, ID's/names defined to that group....