Db2 Express C/ Db2inst1 user lacking authority

dman777 · l33t Joined: 10 Jan 2007 Posts: 983

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

jasealpers · n00b Joined: 02 Jan 2006 Posts: 29

I installed DB2 (although not Express C) on gentoo a number of years ago and used this link as a guide.

http://en.gentoo-wiki.com/wiki/Db2

The dascrt command you listed creates an administration server. This is somewhat orthogonal to actually getting DB2 running. The admin server allows you to use some tooling to interface with DB2, but is not required. See details here...

http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/c0004959.htm

To get DB2 running...
Have you created an instance? If not, db2icrt will create an instance.

If you have an instance, you might check the authorities set up in the dbm cfg. You can have a look with the command "db2 get dbm cfg | grep group". My instance has the following...