SAP Online Portal

Latest SAP News, Solutions, Error Codes, Help Files, Jobs, Documentations, Articles

SQL1092N DB2SID does not have the authority to perform the requested command

Case

You perform in SAP some actions which should access to the dabatase but it brings following error:

SQL1092N “DB2<SID> ” does not have the authority to perform the requested command

Solution

The Os-group of user must be assigned to Admin-Group in Db-level

Check auth&groups at db level by command:

db2 get dbm cfg

You get something similar as follows:

SYSADM group name (SYSADM_GROUP) = DB<SID>ADM

SYSCTRL group name (SYSCTRL_GROUP) = DB<SID>CTL

SYSMAINT group name (SYSMAINT_GROUP) = DB<SID>MNT

Please update dbm via command:

db2 update dbm cfg using SYSADM_GROUP etc <group name>

Leave a Reply

Your email address will not be published.

Related topics

SQL1641N The db2start command failed on sap server

Case You are installing a sap server with DB2 database on Unix/Linux System. During executing db2 binaries, for example db2start you get following error: SQL1641N […]

Could not obtain version info from start service in sum

Case in SAP Java Application Server you are applying patches via SUM and getting following error: Error getting the supported web methods. com.sun.xml.internal.ws.client.ClientTransportException: HTTP transport […]

Exporting and importing sap tables with controlfile

Exporting client In order to export sap tables, create a controlfile (under /usr/sap/trans/bin/controlfile_export) with following content. EXPORT client = 500 file = export_file select * […]

No main memory available twrtab reached memory limit during tp

Case: During Client import you get an error something like that: No main memory available (42500000) twrtab reached memory limit; memory usage 42000000 139596 entries […]

SQL30082N Security processing failed with reason 15 PROCESSING FAILURE

Case During installing  SAP on Linux with DB2 database you get the following error: ERROR      2014-02-05 10:48:52 [iax6bnodeg.cpp:139] CDB6NodeGroups::Create(const map<iastring,iastring>&) Lib=iamoddb6 module=CDB6NodeGroups MDB-01052  Could not […]