on 01-01-2013 11:57 PM
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
HI,
I have changed the permissions of stopdb and startdb in /sapmnt/SID/exe
and problem get resolved
Thanks and Regards
Mohsin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.