DB2 login issue

[Veera1978]

I used a root account during DB2 UDB 9.7 in the RHEL system. Installation has been finished successfully. In the DB2 prompt, I tried to create a database.
db2 => CREATE DATABASE VEERA AUTOMATIC STORAGE YES
SQL1092N "ROOT" does not have the authority to perform the requested command or operation.

How to resolve this issue?

Anyone help greatly appreciated.

[vijay2082]

Hi Veera,

You need to login as the instance owner and then try creating the database. If you are not aware of the instance then use below command to check the user and su to the user from root.

ps -ef|grep -i sysc

The user attached to the db2sysc process is your instance owner which has all rights and privileges to create a database.

Cheers, Vijay

@Veera1978

[Veera1978]

Hi Vijay,

Thank you for the details. I run the command and found the following details. What I need to do further to solve the issue?

[root@localhost ~]# ps -ef|grep -i sysc
root 6215 6179 0 10:08 pts/2 00:00:00 grep -i sysc
[root@localhost ~]#



-----------------------------------
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 9.7.4

You can issue database manager commands and SQL statements from the command
prompt. For example:
db2 => connect to sample
db2 => bind sample.bnd

For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
? CATALOG DATABASE for help on the CATALOG DATABASE command
? CATALOG for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 => create database veera automatic storage yes
SQL1092N "ROOT" does not have the authority to perform the requested command
or operation.
db2 =>


Kind regards,
Veera

[Veera1978]

Dear Vijay,

Can you help me to fix this issue?

Thanks,
Veera