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 ?

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

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.

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.

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.

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 ?

I don't understand.

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

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..

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.