Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2011
    Posts
    3

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

    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.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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?

  3. #3
    Join Date
    Jul 2011
    Posts
    3
    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
    Last edited by dman777; 07-21-11 at 10:32.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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.

  5. #5
    Join Date
    Jul 2011
    Posts
    3
    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?

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    May be it's time for you to start reading manuals?

    DB2 Servers

Posting Permissions

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