Hello DB Experts!
Greetings!
when I am trying to trigger backup on system , I am getting below error , I tried all possibilities to fix the issue, but I didn't .
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: "".
db2pie 60> db2 backup db pir online to /db2/PIE/onlnebkp_9may include logs &
[1] 3456
:db2pie 61> 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: "DB2PIE".
while trying to give GRANT access to DB2PIE user getting below errors
db2pie 61> db2 'grant dbadm on database to user db2pie'
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
group info
SYSADM group name
(SYSADM_GROUP) = DBPIEADM
SYSCTRL group name
(SYSCTRL_GROUP) = DBPIECTL
SYSMAINT group name
(SYSMAINT_GROUP) = DBPIEMNT
SYSMON group name
(SYSMON_GROUP) = DBPIEMON
Version:DB2 10.1 FP-2
Please guide me how we can give access to user .