SQL30082N with reason "19"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

edmundleungs@gmail.com - 29 Jun 2006 10:03 GMT

I have a db2 account on AIX.

After connecting to AIX using SSH, i use the account to connect to DB.

When I use "db2 connect <DB name>", it works fine.

However, when i use "db2 connect to <DB name> user <DB account> using
<PASSWD>",

the following error exist:

SQL30082N Attempt to establish connection failed with security reason
"19"
("USERID DISABLED or RESTRICTED"). SQLSTATE=08001

I have tried to use the db2 account to login. It works and the
password is not expired.

Do you have any solution?

Thanks

Reply to this Message

Challenge - 29 Jun 2006 15:56 GMT

We have the same issue before. It's solved by enabling the 'remote
access' of the <DB account> on the AIX server.

> I have a db2 account on AIX.
>
[quoted text clipped - 17 lines]
>
> Thanks

Reply to this Message

edmundleungs@gmail.com - 03 Jul 2006 04:02 GMT

rlogin is already given to DB account by our default.

So, what's indeed, the problem?

Challenge

> We have the same issue before. It's solved by enabling the 'remote
> access' of the <DB account> on the AIX server.
[quoted text clipped - 19 lines]
> >
> > Thanks

Reply to this Message

bala_e - 03 Jul 2006 07:51 GMT

Hi,

The SQL code & reason code tells clearly that this particular user id
has been disabled or the user id has been restricted from accessing the
operating environment....

Check id is present on the proper group which is having db2 access.

In AIX shell prompt issue the following command to findout the groups

id idname

With Regards

Balakrishnan Ethiraju

> rlogin is already given to DB account by our default.
>
[quoted text clipped - 25 lines]
> > >
> > > Thanks

Reply to this Message