Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2006

    Question Unanswered: Loggining in to DB/2 for LINUX s/390

    Hi Everyone,

    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!

    Thanks in advance ...


  2. #2
    Join Date
    Aug 2001
    Are you sure your db2inst1's password is correct ????

    If yes, then I assume there is a problem with db2ckpw file in sqllib/security ..

    I would suggest that you do a db2iupdt on the instance and retry


    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jul 2006
    Problem is that I am not sure of the password - also LINUX is obviously case sensitive. What does the db2iupdt command do (I am somewhat new to UDB)



  4. #4
    Join Date
    Apr 2006
    Provided Answers: 11


    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-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts