469,609 Members | 1,276 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

SQL30082N with reason "19"

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

Jun 29 '06 #1
3 15042
We have the same issue before. It's solved by enabling the 'remote
access' of the <DB account> on the AIX server.
ed**********@gmail.com wrote:
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


Jun 29 '06 #2
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 accounton the AIX server.
ed**********@gmail.com wrote:
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 nameuser <DB accountusing
<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
Jul 3 '06 #3
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

ed**********@gmail.com wrote:
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 accounton the AIX server.
ed**********@gmail.com wrote:
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 nameuser <DB accountusing
<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
Jul 3 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

32 posts views Thread by Mike Machuidel | last post: by
35 posts views Thread by David Cleaver | last post: by
48 posts views Thread by mahurshi | last post: by
2 posts views Thread by Angus | last post: by
16 posts views Thread by mj.redfox.mj | last post: by
71 posts views Thread by Jack | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.