How to find user ID number

15 pts.
Tags:
User Management
User profiles
V5R4
We are installing a package whose vendor (for whatever reason) wants the "user" created to connect to the data to have User ID # 248, but that ID # isa already in use. How do I find what user profile that number belongs to without having to search through all the user profiles?

Software/Hardware used:
V5R4
ASKED: May 25, 2010  1:22 PM
UPDATED: May 25, 2010  8:46 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can use the the DSPUSRPRF command to output the data into an OUTFILE and then run a query on that file for the id number.

<pre>DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE) OUTFILE(QTEMP/USRPRF)</pre>

Do a RUNQRY <pre>RUNQRY QRYFILE((USRPRF)) RCDSLT(*YES) </pre> and add the following to the query <pre>UPUID EQ 248 </pre>

======================================================

As noted above, a simple query of a DSPUSRPRF outfile can show all of your assigned UIDs and GIDs. In your case, you want to assign a specific UID to a profile, but another profile already has that UID assigned.

If you have authority to the profiles that are involved, you can use CHGUSRPRF UID(nnn) to change the UID() value to some new unique value. Change the offending profile to a different value in order to make 248 available.

Note that in theory you ought to be managing UID/GID numbers. It’s unlikely that you’ll have any problems, but these can be important to UNIX-like applications. It seems a little unusual that an explicit UID value was requested. You ought to be free to choose which value is used in your network and free to keep it private.

Tom

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following