Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
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    Post subject: Pulling the list of all users in a PS or VSAM file.
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: 8593
Location: Back in jolly old England

PostPosted: Thu Nov 27, 2014 2:50 pm    Post subject:
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: 175
Location: UK

PostPosted: Thu Nov 27, 2014 3:44 pm    Post subject:
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: 1712
Location: UK

PostPosted: Thu Nov 27, 2014 4:48 pm    Post subject: Reply to: Pulling the list of all users in a PS or VSAM file
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: 1218
Location: Israel

PostPosted: Thu Nov 27, 2014 7:50 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us