View previous topic :: View next topic |
Author |
Message |
dman777 l33t

Joined: 10 Jan 2007 Posts: 982
|
Posted: Thu Jul 21, 2011 2:32 am Post subject: Db2 Express C/ Db2inst1 user lacking authority |
|
|
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. |
|
Back to top |
|
 |
jasealpers n00b

Joined: 02 Jan 2006 Posts: 29
|
Posted: Mon Aug 01, 2011 5:42 pm Post subject: |
|
|
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...
Code: |
SYSADM group name (SYSADM_GROUP) = DB2IADM1
SYSCTRL group name (SYSCTRL_GROUP) =
SYSMAINT group name (SYSMAINT_GROUP) =
SYSMON group name (SYSMON_GROUP) =
|
Then, I have user db2inst1 in group db2iadm1.
Hope this helps. |
|
Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|