cancel
Showing results for 
Search instead for 
Did you mean: 

DB2 - startsap - not have the authority

mohsin_m3
Participant
0 Kudos

HI,

Continue with stop procedure

SQL1092N  The requested command or operation failed because the user ID does

not have the authority to perform the requested command or operation.  User

ID: "SIDADM".

SQL1092N  The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation.  User ID: "SIDADM".

/usr/sap/SID/SYS/exe/run/stopdb completed successfully

OS :: AIX 6.1

DB2 :: 10.1

Manually I am starting db2 >> login as db2adm and db2start then login as sidadm and startsap r3

How to resolve this startsap issue with ID sidadm

Thanks and Regards

Mohsin

Accepted Solutions (1)

Accepted Solutions (1)

mohsin_m3
Participant
0 Kudos

HI,

I have changed the permissions of stopdb and startdb in /sapmnt/SID/exe

and problem get resolved

Thanks and Regards

Mohsin

Former Member
0 Kudos

This message was moderated.

Answers (3)

Answers (3)

mohsin_m3
Participant
0 Kudos

Hi,

This is new migrated system (from Oracle to DB2) .system is up and running on DB2 database .

Only startsap have problem with sidadm .

geqsim02:db2qa2 1> db2 connect to QA2

   Database Connection Information

Database server        = DB2/AIX64 10.1.0

SQL authorization ID   = DB2QA2

Local database alias   = QA2

geqsim02:db2qa2 2>

**************************************************

sapinst:!:202:root,qa2adm,oraqa2,db2qa2,sapadm,daaadm

dbqa2ctl:!:203:qa2adm

dbqa2mnt:!:208:sapqa2,sapqa2db

dbqa2adm:!:211:db2qa2

dbqa2mon:!:212:sapqa2,sapqa2db

sapint:!:213:sapsdt

***************************************************

geqsim02:qa2adm 8> R3trans -d

This is R3trans version 6.23 (release 721 - 17.09.12 - 20:12:05 ).

unicode enabled version

R3trans finished (0000).

geqsim02:qa2adm 9>

**********************************************************

Please help me to resolve the issue

Thanks and Regards

Mohsin

Former Member
0 Kudos

Hi Mohsin,

Please paste the complete log when u try the following command with SIDADM user:

startsap all <hostname >

BR,

DVRK

Former Member
0 Kudos

Hi Mohsin,

Fisrt of all check wheather db2sid can connect or not ?

$ db2 connect to SID

Next check the /etc/group file for secondary group for the user -- sidadm . User sidadm should be part of db<sid>ctl and db<sid>mnt group.

After check R3trans -d ( is this working ) ?

Also you can assign the following authorization to sidadm user check the result

db2 grant create on database to user <schema-owner>

db2 grant dbadm on database to user sidadm  ( this must the last option).

By the way - is it a new system or exiting system ?

Good luck

Regards,

Dipam

Former Member
0 Kudos

Hi All,

After system refresh

I am trying to give grant permission to user db2bis

I am getting below issue

Please advise how to fix it.

db2bis>db2 "grant dbadm on database to user db2bis"

DB21034E  The command was processed as an SQL statement because it was not a

valid Command Line Processor command.  During SQL processing it returned:

SQL0554N  An authorization ID cannot grant a privilege or authority to itself.

SQLSTATE=42502

martin_mikala
Participant
0 Kudos

Hi, You must connect into DB like source db2<sid> user.

example


db2 connect to QAS user db2prd

Martin

nicholas_chang
Active Contributor
0 Kudos

Hi,


Is this a new installation? Please check is DB group assigned to SIDADM user, by checking /etc/group

Just take any DB2 system as refence (if any), else let me know and i'll post for you.


Cheers,

Nichoas Chang