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

Pulling the list of all users in a PS or VSAM file.


IBM Mainframe Forums -> TSO/ISPF
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Kanishk Sinha

New User


Joined: 24 Nov 2014
Posts: 1
Location: India

PostPosted: Thu Nov 27, 2014 11:47 am
Reply with quote

Hi all! I have a query. I searched the forums but could't get a relavent post. I will try to be elaborate. So here goes.

I have a daily task of creating an ENDEVOR change report through a job and then copying it into an excel file and sending it to the MF support group via e-mail. The task was time consuming, so I tried to automate it. Thankfully this forum helped a lot. The automation was successfull. But there is this thing. This report is an account of "WHO made WHAT changes to the procs, jcl, modules, programs etc". So the report creation job requires a list of all the users registered on mainframes in a form of a VSAM file, just for reference. So, initially, I got it done through TSO USERS command. Got the updated list of all the users and pulled it into a VSAM file. But the problem is that, whenever a new user is added, the job abends with MAXCC 16. Reason being, I dont have the updated list of all the new users that were added after I made my file. So what I do is that I open my VSAM user file and manually add the user MF ID and then restart the job in that step. To get rid from this, I tried using IKJEFT01 pgm in my job, so that I can pull the list of users everytime the job runs in a VSAM file and keep it updated automatically. But my job abends with CC16 saying that command 'USERS' not found. I need help on this. How can I get the list of all the updated users each time my job runs?

P.S. I am not a system admin and I don't have authority to create a user ID. Its just a reference userid file that I'm talking about. The job just uses this file as a reference so that it can validate the userid and pull the username against it and write it in the report.

Thanx.
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Thu Nov 27, 2014 2:50 pm
Reply with quote

Speak to your security people, if they do not already have a list it should be fairly easy to create one.
Back to top
View user's profile Send private message
David Robinson

Active User


Joined: 21 Dec 2011
Posts: 199
Location: UK

PostPosted: Thu Nov 27, 2014 3:44 pm
Reply with quote

Depending on your access level, you may be able to issue a LISTUSER command.

I think the TSO USERS command is something unique to your site, but you can probably still run it in batch. Is the library that it is in allocated to your batch job?
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Thu Nov 27, 2014 4:48 pm
Reply with quote

Quote:
abends with MAXCC 16
abends with CC16


Nope- it ends witha return code (RC) of 16. It does not ABnormaly END but ends normally with a return code.
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1353
Location: Israel

PostPosted: Thu Nov 27, 2014 7:50 pm
Reply with quote

1. In your TSO session, type TSO ISRDDN, then type MEM USERS and locate in which library this program is located.
2. Add a DD with the library in your batch job.

In all cases, you should not terminate with a return code if a user name is missing, you should just leave the userid instead.
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 -> TSO/ISPF

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top