I have a quick question. Our systems programmers have installed DB/2 UDB for LINUX s/390 on to our mainframe and we are running SuSE 10.0. The installed went well as did the creation of SAMPLE (DB2SAMPL). I am confused however when trying to log on to the database. I have changed the LINUX user to DB2INST1 i.e. su DDB2INST1 - which the systems programmer says was the ID they created (Password was DB2INST1). However - I get the error:
SQL30082N Attempt to establish connection failed with security reason "24"
("USERNAME and/or Password invalid")
when I use the command CONNECT to SAMPLE USER DB2INST1 using DB2INST1. However, if I simply use CONNECT TO SAMPLE - I have no problems. I am assuming that 8.2 is using some kind of authentication from LINUX - is this true?. Also, how can I verify what the password is for this ID. After I federate this database with our DB/2 for VM database I will need the password for DB2INST1 in order to compile and run mainframe COBOL and EASYTRIEVE programs against this database or for case - any connection to the database via TCP/IP. Any information will be of help!
db2iupdt is executed from root to update the sqllib and everthing below in the instance owner.
from root : you can set the password for db2inst1 (use lower case)
with passwd db2inst1
from vm you can connect with mixcase userid password
define it in ucomdir names in the correct case..
in db2inst1 : you can : connect to sample
or connect to sample user db2inst1 using xxxxx
as long as xxxxx is the correct pw in the correct case
same for remote : only connect to sample user xx using yyy
ay user that is defined in linux390 and allowed to connect to sample
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be