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

[Former Member]

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 .

[Former Member · Accepted solution]

Hi Naveen,

You cannot use db2sid user to grant permission to itself. Use root user or any other super admin user to do so.

The grant command should have double quotes ("), as shown below.

db2pie 61> db2 "grant dbadm on database to user db2pie"

check below sap note.

2158234 - Backup taken using the DBA Planning Calendar in transaction DBACOCKPIT finishes with error...

Regards,

Prithviraj

[Former Member · Accepted solution]

Hi Prithvi,

Thanks for quick reply!

I tried all possibilities to fix the issue including mentioned NOTE -2158234 , all are seems to fine in system.

I followed below steps to fix my issue

1) stop the sap

2) db2sid> db2stop force

3)db2start

4)db2 connect to SID

5)db2 quiesce database immediate force connections

QUIESCE DATABASE results in all objects in the database being in the quiesced mode.    Only the allowed user/group and sysadm, sysmaint, dbadm,   or sysctrl will be able to access the database or its objects.

6)db2 connect reset

7) db2 backup db SID online to path include logs

Thanks ,

Navin