IBM Support

Locating the Number of *ENABLED User Profiles on the System

Troubleshooting


Problem

This document provides instruction on determining how many user profiles are currently set to *ENABLED on your system

Resolving The Problem

This document provides instruction on determining how many user profiles are currently set to *ENABLED on your system

To determine how many user profiles are currently set to *ENABLED on your system, you should do the following:

To create an outfile of all the user profiles on your system, run the following command:
QSYS/DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE) OUTFILE(QGPL/USERS)                                     

Start SQL
CHGJOB CCSID(37)
STRSQL

To view all of the user profiles on the system which are enabled, run the following command:
SELECT UPUPRF, UPSTAT from QGPL/USERS where upstat = '*ENABLED'
                                                                
To get a count of all the profiles above, run the following command:
SELECT COUNT(UPSTAT) from QGPL/USERS where upstat = '*ENABLED'

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"}]

Historical Number

654564866

Document Information

Modified date:
18 December 2019

UID

nas8N1010620

Page Feedback