DB2 new isntall - Db2inst1 doesn't have authority to do db2start

dman777 · #1 (**permalink**) 07-20-11, 22:28

I installed DB2 Express C on my Linux system(gentoo). First question is- in /opt/ibm/db2/V9.7/adm none of the binaries have executable permissions....just read. why is this? Do I need to set all of them manually to executable?

I gave db2 start executable permission and I was able to issue the command with my db2inst1 user. However, I get:
SQL1092N "DB2INST1" does not have the authority to perform the requested command or operation.

Why is this? I did the /opt/ibm/db2/V9.7/instance/dascrt -u dasusr1 successfully.

n_i · #2 (**permalink**) 07-21-11, 06:37

DAS is an optional component and is being deprecated. What you should have done is create a DB2 instance with db2icrt.

Did you run the installation as root?

dman777 · #3 (**permalink**) 07-21-11, 09:19

Yes, I did install it as root. This is my home machine for learning, so security is not an issue at all.

Should all those commands be marked executable in the adm directory?

I'm sorry, I gave the wrong information. I created the db2inst1 user with /opt/ibm/db2/V9.7/instance/db2icrt -s client db2inst1

and then /opt/ibm/db2/V9.7/instance/dascrt -u db2inst1 which it didn't let me because it told me that a instance user can not be a administrator.

Something tells me I messed up by using the -s client, am I right? If so how can I fix this?

Thank you,
-Dman

n_i · #4 (**permalink**) 07-21-11, 09:46

I can't tell why the permissions got messed up.

You do not create a db2inst1 user with db2icrt. You need to create the user (and the group) as you normally would in the OS, then create an instance owned by that user.

To have a server instance you need to create a server instance; you created a client instance. Drop it with db2idrop then create a server instance.

dman777 · #5 (**permalink**) 07-21-11, 18:15

Ok, after removing the instance user here is what I did:

Code:

localhost instance # groupadd db2fadm1       
localhost instance # groupadd db2iadm1
groupadd: group 'db2iadm1' already exists
localhost instance # useradd -m -g db2fadm1 db2fenc1
localhost instance # /opt/ibm/db2/V9.7/instance/db2icrt -p db2inst1 -u db2fenc1 db2inst1
DBI1070I  Program db2icrt completed successfully.


localhost instance # man db2icrt
No manual entry for db2icrt
localhost instance # su - db2inst1
db2inst1@localhost ~ $ db2start
SQL1042C  An unexpected system error occurred.
db2inst1@localhost ~ $ db2      
Display all 186 possibilities? (y or n)
db2inst1@localhost ~ $ db2st
db2star2  db2start  db2stop   db2stop2  db2stst   
db2inst1@localhost ~ $ db2st
db2star2  db2start  db2stop   db2stop2  db2stst   
db2inst1@localhost ~ $ db2start
SQL5043N  Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully.
db2inst1@localhost ~ $ db2stop 
SQL1064N  DB2STOP processing was successful.
db2inst1@localhost ~ $ db2stop
SQL1032N  No start database manager command was issued.
db2inst1@localhost ~ $

So, it looks like things are still not right because of the db2start complaints. Any suggestions?

n_i · #6 (**permalink**) 07-21-11, 18:30

May be it's time for you to start reading manuals?

DB2 Servers

Internet Services

Web Development

Digital Marketing

Consumer Tech