Results 1 to 9 of 9
  1. #1
    Join Date
    Jul 2011
    Posts
    14

    Question Unanswered: DB2 Users under linux

    Hi.

    I'm working under ubuntu 11.04 installed on virtualbox.
    I have installed a db2 express-c 9.74.
    So it creates db2inst1,dasusr1 and db2fenc1 users.
    Under db2inst1, I created a data base DB1.
    So using db vizualizer, I can connect to my DB1 using db2inst1 user.
    It's ok.
    But now I want to create some other users, let say dbuser1.
    I first tried to simply create this user under ubuntu. Tried connecting (db visualizer) ... User id or password invalid.
    I also tried assigning a specific group for this user (dbusers) and under db2cc add this group and grant connect but same problem.
    So what can I do ?

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    what is the complete message when connecting? try also connect from command line in server : connect to db1 user xxx using yyy
    try logon to telnet with this user - maybe the pw needs to be changed ....
    messages are over here :
    IBM DB2 9.7 for Linux, UNIX and Windows Information Center
    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

  3. #3
    Join Date
    Jul 2011
    Posts
    14
    Ok, I tried directly from the command line in server.
    The message is :
    SQL30082N Security processing failed with reason "24" ("USER NAME AND/OR
    PASSWORD INVALID") . SQLSTATE=08001

    For telnet ... don't understand what you mean. But the password is ok. I also tried changing the password to be sure i'm using the good one.
    Last edited by tweetysat; 07-29-11 at 07:56.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as indicated : uid/pw not valid
    try to open a telnet session (with putty or other) and logon with this user/pw not with instance owner.
    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

  5. #5
    Join Date
    Jul 2011
    Posts
    14
    Sorry but how can i do that (i'm not familiar with linux) ?
    The only thing i did is closing the db2inst1 session and try opening a session with the db2user user. Ans it's ok.

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if you opened a session and entered uid and pw and this was accepted - then logon is ok and probably pw also
    so : what was the syntax of connect that resulted in the error message ?
    was this executed in instance owner environment ?
    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

  7. #7
    Join Date
    Jul 2011
    Posts
    14
    I don't understand.

    The syntax is : connect to db1 user dbuser1 using dbuser1
    And yes it's from dbinst1.

  8. #8
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if dbuser1 is also the pw for this user dbuser1 and logon is ok - this is a mystery
    must be something else I don't see immediatly
    I will have a deeper look on it..
    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

  9. #9
    Join Date
    Jul 2011
    Posts
    14
    Hi.

    This morning trying with a brand new ubuntu and db2 installation (still same versions).

    After install, connection with db2inst1 user.
    db2start
    /opt/ibm/V9.7/das/bin/db2admin start
    create database ... db1

    under db visualizer : connection with dbinst1 .. ok

    under ubuntu : create a new user : db2user1 pw db2user1

    under db visualizer : connection with db2user1 .. not ok - username and/or password invalid.

    Do I miss something ?

    - edit -

    under db2 comand line, using ? sql30082n tells me for reason code 24 :
    1- run db2iupdt <instName> to update the instance
    2- ensure the username created is valid. review the db2 general naming rules.
    3- ensure the catalog information is correct.

    So i do 1- and ... nothing changes.
    For 2- i suppose it's ok since I can connect under ubuntu with the user db2user1.
    For 3- ? I don't know what it is.
    Last edited by tweetysat; 08-01-11 at 04:07.

Posting Permissions

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