It's only 20 years old code...
It's more like issue with Aix interaction with db2ckpw I think.
Usual questions:
- did it ever worked before?
- if so - when it stopped working?
- when it stopped working - what has been changed?
When you establish telnet session to Aix as user dsna and source Db2 environment (by executing db2profile), you can connect to DBALIAS by:
db2 connect to DBALIAS
?
What client you are using (local or remote? - what protocol? JDBC, ODBC?
Original Message:
Sent: Wed February 18, 2026 02:45 AM
From: Michel de Kraker
Subject: SQL30082N error
I know this is way too old.....
dsna@xxxxx # db2level
DB21085I Instance "dsna" uses "64" bits and DB2 code release "SQL08027" with
level identifier "03080106".
Informational tokens are "DB2 v8.1.1.128", "s061108", "U810098", and FixPak
"14".
Product is installed at "/usr/opt/db2_08_01".
dsna@xxxxxx # db2set -all
[i] DB2_LOAD_COPY_NO_OVERRIDE=COPY YES TO /dsna/loadcopy
[i] DB2TCPCONNMGRS=1
[i] DB2MEMMAXFREE=2000000
[i] DB2MEMDISCLAIM=YES
[i] DB2COMM=tcpip
[i] DB2AUTOSTART=YES
[g] DB2SYSTEM=xxxxxxx
[g] DB2ADMINSERVER=db2das
rlogin = true for user dsna
strangely enough SQL30082N is not recorded in db2diag.log:
[root@xxxxxx]/dsna/db2dump>grep 30082N db2diag.log
[root@xxxxxx]/dsna/db2dump>
------------------------------
Michel de Kraker
Original Message:
Sent: Tue February 17, 2026 12:48 PM
From: Jan Nelken
Subject: SQL30082N error
It could be an issue with db2ckpw service - on the other hand - better show us:
output of db2level;
output of db2set -all
characteristic of the user dsna from smitty - in particular - whether user is allowed remote login
db2diag.log capturing the SQL30082 error.
------------------------------
Jan Nelken
Db2 (LUW) DBA
Open for work
Katowice or Krakow
+48 783 109 863
Original Message:
Sent: Tue February 17, 2026 10:58 AM
From: Madhusudan S M
Subject: SQL30082N error
Can you log on the AIX server using the user dsna ?
If yes, after login using the user dsna, type "db2 connect to DBALIAS".It won't ask for a password now.Can you connect to the DB successfully? What is the error you are getting?
Original Message:
Sent: 2/17/2026 7:23:00 AM
From: Michel de Kraker
Subject: SQL30082N error
Goodday
I get this error:
SQL30082N Attempt to establish connection failed with security reason "19"
("USERID DISABLED or RESTRICTED"). SQLSTATE=08001
The command is:
dsna@xxxxxx # db2 connect to DBALIAS user dsna using xxxxxxx
SQL30082N Attempt to establish connection failed with security reason "19"
("USERID DISABLED or RESTRICTED"). SQLSTATE=08001
I can login with user dsna on AIX with the same password. So that is OK.
Hints on internet is not getting me to the solution.
I am also not able to db2 connect to DBALIAS, because it is asking for a password which I do not know.
Does anybody have any ideas?
Thankyou,
Kind regards,
Michel.
------------------------------
Michel de Kraker
------------------------------