sql30082n while connecting to DB2

Technote (troubleshooting)
Problem (Abstract)

Websphere message Broker Message flow fails to connect to a DB2 datasource, failing with error ' sql30082n '.

Symptom

These errors can be seen in a user level trace of the The execution group:

Databaseexception bip2393e:database error:odbc return code '-1 ' from data source ' <DSN> ' using ODBC driver Manag Er ' libbipodbc.a (odbc.so) '.

Databaseexception bip2322e:database error:sql state ' 08001 '; Native Error Code '-30082 '; Error Text ' [ibm][cli Driver] sql30082n Security processing failed with reason "+" ("USERID DISABLED or RESTRICTED"). Sqlstate=08001 '.

Cause

DB2 makes an internal call to the Operating System API Command ' loginrestrictions () ' to verify whether a particular user I s allowed to access the system. If a user does not has appropriate permissions, then the connection would fail.

Diagnosing the problem

If you suspect this is a problem, attempt to manually connect to your database via the DB2 Connect command. If your user is restricted, you'll see a error, such as:

DB2 Connect to MYDB user MyUser using XXXXXX

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

Resolving the problem

To allow access from your user, you'll need to either speak with your system administrator to allow login Permissions/at Tributes, or disable the login restrictions with the ' db2set ' command:

Db2set-g Db2loginrestrictions=none

Then, restart DB2 and attempt to connect again, to confirm.

The setting of db2loginrestrictions is in the preference of the user for their environment, and can be treated as a Perman ENT solution, as long as it adheres to company policies.

Some users prefer not to has this attribute ' s restrictions enforced so they can override this enforcement by setting:
Db2loginrestrictions=none.

The variable is documented in the DB2 information Center.

Related information

DB2 System Environment Variables
DB2 Technote regarding Error sql30082n

Product alias/synonym

WMB MB Message Broker MQ Integrator wbimb wbi-mb MQSI Wmqi

Rate this page: (2 users) Average rating do the information help you achieve your goal?

Yesnodon ' t know

comments:*

Rate this page:

(2 users) Average Rating

ADD commentsdocument Information more support For:websphere Message Broker
DB CONNECTIVITY/ODBC/JDBC
Software version:6.0, 6.1, 7.0, 8.0 Operating system (s): AIX, HP-UX, Linux, Solaris, Windows Reference #:1590562 Modified D Ate:

2013-04-29

Translate my Page

sql30082n while connecting to DB2