If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > dbm cfg and sysadm_group

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-18-06, 16:22
mj624 mj624 is offline
Registered User
 
Join Date: Apr 2006
Posts: 1
dbm cfg and sysadm_group

I am trying to create a new user to be used as the sysadm for my db2instance. I have DB2 V7 on an AIX server. I have added the new user, NEWUSER1 to the group specified in the SYSADM_GROUP in the dbm cfg. I am able to start and stop the instance, connect to the database and perform database backups using NEWUSER1. However, when I try to perform a 'db2 update dbm cfg using diaglevel 4', I receive the following error: SQL1092N "" does not have the authority to perform the requested command. I suspect this is a file permission problem somewhere. Can someone possibly give me a starting point? The current instance owner is OLDUSER1. In the /home/NEWUSER1 directory, I have a symbolic links as such: /home/NEWUSER1/.profile => /homeOLDUSER1/.profile
and /home/NEWUSER1/db2 => /home/OLDUSER1/db2 and /home/NEWUSER1/sqllib => /home/OLDUSER1/sqllib

For the life of me, I can't figure out what I am missing. I would appreciate any help.
PS..I've also recycled the instance numerous times. Thanks
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On