Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Db2 Express C/ Db2inst1 user lacking authority
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Unsupported Software
View previous topic :: View next topic  
Author Message
dman777
l33t
l33t


Joined: 10 Jan 2007
Posts: 941

PostPosted: Thu Jul 21, 2011 2:32 am    Post subject: Db2 Express C/ Db2inst1 user lacking authority Reply with quote

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
View user's profile Send private message
jasealpers
n00b
n00b


Joined: 02 Jan 2006
Posts: 29

PostPosted: Mon Aug 01, 2011 5:42 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Unsupported Software All times are GMT
Page 1 of 1

 
Jump to:  
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