Symptom
Backups taken using the DBA Planning Calendar in transaction DBACOCKPIT (or directly calling transaction DB13) finish with the following errors:
SQL Message: SQL1092N Therequested command or operation failed because the user ID does not have the authority toperform the requested command or operation. User ID
The error in the job log looks like:
Exception CX_DB6_CON in program CL_DB6_JOB_BACKUP=============CP / CL_DB6_JOB_BACKUP=============CM002 at line ADBC error with r
Backup_Dev:Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method line 0
Backup_Dev: Kernel Error ID:
Backup_Dev: Message: ADBC error
Backup_Dev: Database:
Backup_Dev:caused by
Backup_Dev:Exception CX_DB6_ADMINCMD in class CL_DB6_ADMIN_CMD method SSV_BACKUP
Backup_Dev: Message: ADBC error
Backup_Dev:caused by
Backup_Dev:Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT
Backup_Dev: Kernel Error ID:
Backup_Dev: DB Error: Yes
Backup_Dev: SQL Code: 1092-
Backup_Dev: SQL Message: SQL1092N Therequested command or operation failed bec
Backup_Dev: ause the user ID does not have the authority toperform the requested
Backup_Dev: command or operation. User ID: "xxx row=1
Exception CX_DBA_JOB in class CL_DB6_JOB_BACKUP method line 40
Backup_Dev:terminated with error
REASON=ADBC error
In the database log db2diag.log, the following error comes up:
<Timestamp> LEVEL: Severe
PID : TID : PROC : db2fmp64.exe
INSTANCE: NODE : 000
HOSTNAME:
EDUID :
FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1291
MESSAGE : 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: "".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1092 sqlerrml: 6
sqlerrmc: SAPPID
sqlerrp : sqlubCon
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
Read more...
Keywords
permissions, DB13, SYSADM_GROUP, SYSCTRL_GROUP, SYSMAINT_GROUP , KBA , BC-DB-DB6-DBA , Database Administration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.