IBM Support

Error SQL30082N Reason Code 19 or 24

Technote (troubleshooting)


What should I do if I receive the following error when trying to log-in to my DB2 instance:

SQL30082N Security processing failed with reason "19" ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001


SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR

Resolving the problem

1.) Make sure that your user ID connecting to the DB2 database is not locked. (If the user id is locked out or disabled please contact your system administrator as this is outside of DB2 support scope.)

2.) Please make sure that the User ID in questions meets the following requirement:

  • Must have a primary group other than guests, admins, users, and local
  • Can include lowercase letters (a-z), numbers (0-9), and the underscore character ( _ )
  • Cannot be longer than eight characters. You can use long User ID starting from v10.fp5
  • Cannot begin with IBM , SYS, SQL, or a number
  • Cannot be a DB2 reserved word (USERS, ADMINS, GUESTS, PUBLIC, or LOCAL), or an SQL reserved word
  • Cannot use any User IDs with root privilege for the DB2 instance ID, DAS ID or fenced ID.
  • Cannot include accented characters
  • If existing user IDs are specified instead of creating new user IDs, make sure that the user IDs:
  • Do not have expired passwords
  • Is allowed to login (lsuser reports login=true)

3.) On AIX, you can try setting the following DB2 System Environment Variable:

4.) If you are on Windows please make sure that the group the user is apart of is added to: "Access this computer from network". To check this please do the following:
  • Click on Start->Run from the Windows start menu
  • Type "secpol.msc"
  • Go to Local Policies->User Rights Assignments.
  • Double-click on "Access this computer from network"

    For more information on this topic please see the "Related URL" for more information

Related information

System environment variables
SQL30082N new installation of DB2

Document information

More support for: DB2 for Linux, UNIX and Windows
Database Objects/Config - Instance

Software version: 9.7, 10.1, 10.5, 11.1

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: Advanced Enterprise Server, Advanced Workgroup Server, Enterprise Server, Workgroup Server

Reference #: 1409496

Modified date: 22 March 2011