473,320 Members | 1,946 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SQL1092N while starting database on linux


Folks,

I installed DB2 UBD 8.1 plus FP 5 on Redhat Fedora. I
created instances without any problem, but when I try to start the instance
I get SQL1092N. The instance user belongs to db2adm group and the
database manager configuration also say SYSADM_GROUP group is DB2ADM.

Here is how I created instance:

db2icrt -a server -p 20000 -s ese -u db2fenc1 dbdev1
[[dbdev1]]/home/dbdev1> groups
db2adm
[[dbdev1]]/home/dbdev1> db2 get dbm cfg | grep SYSADM_GROUP
SYSADM group name (SYSADM_GROUP) = DB2ADM
[[dbdev1]]/home/dbdev1> db2start
SQL1092N "DBDEV1" does not have the authority to perform the requested command.
What am I missing?

--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: No************@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.
Nov 12 '05 #1
4 8491
Your steps look good. Is there anything in the diag.log file? If not,
your next best step is to contact service.

Hemant Shah wrote:
Folks,

I installed DB2 UBD 8.1 plus FP 5 on Redhat Fedora. I
created instances without any problem, but when I try to start the instance
I get SQL1092N. The instance user belongs to db2adm group and the
database manager configuration also say SYSADM_GROUP group is DB2ADM.

Here is how I created instance:

db2icrt -a server -p 20000 -s ese -u db2fenc1 dbdev1
[[dbdev1]]/home/dbdev1> groups
db2adm
[[dbdev1]]/home/dbdev1> db2 get dbm cfg | grep SYSADM_GROUP
SYSADM group name (SYSADM_GROUP) = DB2ADM
[[dbdev1]]/home/dbdev1> db2start
SQL1092N "DBDEV1" does not have the authority to perform the requested command.
What am I missing?

Nov 12 '05 #2
While stranded on information super highway Sean McKeough wrote:
Your steps look good. Is there anything in the diag.log file? If not,
your next best step is to contact service.
I figured out the problem, I looked thorugh my notes and found out that I had
same problem on another Linux system. Apparently, when db2_setup adds
instance users, it does not add the username to the groups file.

Example: /etc/passwd contains fillowing:

dbdev1:x:6602:2300:DB2 Instance for dev1:/home/dbdev1:/bin/ksh

/etc/group contains:

db2adm:x:2300:
It should contain following:

db2adm:x:2300:dbdev1


Hemant Shah wrote:
Folks,

I installed DB2 UBD 8.1 plus FP 5 on Redhat Fedora. I
created instances without any problem, but when I try to start the instance
I get SQL1092N. The instance user belongs to db2adm group and the
database manager configuration also say SYSADM_GROUP group is DB2ADM.

Here is how I created instance:

db2icrt -a server -p 20000 -s ese -u db2fenc1 dbdev1
[[dbdev1]]/home/dbdev1> groups
db2adm
[[dbdev1]]/home/dbdev1> db2 get dbm cfg | grep SYSADM_GROUP
SYSADM group name (SYSADM_GROUP) = DB2ADM
[[dbdev1]]/home/dbdev1> db2start
SQL1092N "DBDEV1" does not have the authority to perform the requested command.
What am I missing?


--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: No************@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.
Nov 12 '05 #3
Ian
Hemant Shah wrote:
While stranded on information super highway Sean McKeough wrote:
Your steps look good. Is there anything in the diag.log file? If not,
your next best step is to contact service.

I figured out the problem, I looked thorugh my notes and found out that I had
same problem on another Linux system. Apparently, when db2_setup adds
instance users, it does not add the username to the groups file.

Example: /etc/passwd contains fillowing:

dbdev1:x:6602:2300:DB2 Instance for dev1:/home/dbdev1:/bin/ksh

/etc/group contains:

db2adm:x:2300:
It should contain following:

db2adm:x:2300:dbdev1


That should not be necessary.

The primary group for dbdev1 is GID 2300 (stored in /etc/passwd). As you
saw, issuing the 'groups' command shows that the user is part of the
db2adm group. When users are listed in /etc/group these are secondary
group assignments, not primary.

If your fix actually solved the problem I would still contact IBM support,
as something is wrong here.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #4
While stranded on information super highway Ian wrote:
Hemant Shah wrote:
While stranded on information super highway Sean McKeough wrote:
Your steps look good. Is there anything in the diag.log file? If not,
your next best step is to contact service.

I figured out the problem, I looked thorugh my notes and found out that I had
same problem on another Linux system. Apparently, when db2_setup adds
instance users, it does not add the username to the groups file.

Example: /etc/passwd contains fillowing:

dbdev1:x:6602:2300:DB2 Instance for dev1:/home/dbdev1:/bin/ksh

/etc/group contains:

db2adm:x:2300:
It should contain following:

db2adm:x:2300:dbdev1


That should not be necessary.

The primary group for dbdev1 is GID 2300 (stored in /etc/passwd). As you
saw, issuing the 'groups' command shows that the user is part of the
db2adm group. When users are listed in /etc/group these are secondary
group assignments, not primary.


That is correct, groups command told me that the user's promary group was
db2adm.

If your fix actually solved the problem I would still contact IBM support,
as something is wrong here.
Adding the user to the /etc/group file solved the problem. I had exactly
same problem with db2 install on another linux system.

I will send the problem to IBM.


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----


--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: No************@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jens Fudge | last post by:
Hi Setup is: WinXP Pro on 1300 MHz Machine with 766MB RAM. After installing Oracle 9i a test of some sort was performed: The "database configuration assistent" sent the following...
0
by: Jagdip Singh | last post by:
Hi all, I wanted to created sample database and issued db2sampl command which gave me error SQL1032N No start database manager command was issued. SQLSTATE=57019 I issued db2start command to...
4
by: Klemens | last post by:
One database tells on every connect statement: SQL1092N "" does not have the authority to perform the requested command. Another database at the same instance works fine. One day before the...
11
by: Jep | last post by:
Any help or advice appreciated. We have just installed and configured a new DB2 v.8.1 with latest FixPack. Just a few days later it dies and now we have a DB that is totally unusable. - - - -...
0
by: scotdb | last post by:
Just installed Developer Workbench on my Linux box (OpenSUSE 10.1). I can start the "Updater" facility without problems. However when I try to start the Workbench itself the splash screen...
3
by: Bruno LIVERNAIS | last post by:
Hi, We are currently installing a DB2 V9 ESE on a Linux server (RHEL4U4-x86_64). Installation runs successfully on each node. Database user environment is OK and the instance is well created. To...
0
by: he59 | last post by:
Hi, We are currently installing a DB2 V9 ESE on a Linux server (RHEL4U4-x86_64). Installation runs successfully on each node. Database user environment is OK and the instance is well created....
0
by: db2user24 | last post by:
Hello, I just gave this command to convert the instance to 64 bit: ./db2iupdt -w 64 instance1 the command executes successfully but when I try to start the db, I get this: db2start...
1
by: ktilcu | last post by:
I have the great task of starting and managing a database of clients at my office. We have 2200 records of information in an excel spreadsheet with almost 23 columns of fields. Now my question is,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.