Hi All,
We are having SAP SRM 7.01 on IBM DB2 9.7 04 LUW on Windows Server 2008 R2 Enterprise.
DB and CI in on same host.
In DB13, we are unable to schedule Backups.
We are getting message on screen: Maintenance is not allowed for role SAPMON
where as we can take backup through db2cmd successfully.
Current SAP_BASIS level is 702 10
In DB13 DB Connection the following entries found:
Database connection Details:
Connection Name: +++DB6ADM
Database Syatem: DB2 for LUW
Connection Maximum:0
Connection Optimum:0
Permanent Connection: Untick
User Name:
Connection Parameter:DB6_DB_NAME=<DBSID>;DB6_DB_SCHEMA=SAP<SAPSID>;DB6_DB_HOST=<HOSTNAME>
Database Host:<HOSTNAME>
Database Name: <DBSID>
Port Number:
Schema name: SAP<SAPSID>
We tried to modify it as follows
User Name: DB2<DBSID>
Password:****
Confirm Pasword:****
Port Number: sapdb2SRD
but no success message "Maintenance is not allowed for role SAPMON" still persist.
and after login again all changes we maintained roll-backed.
We also tried following SAP Notes: 1681496, 1684460 both notes are of SAPMON/SAPTOOLS
We also tried command db6_update_db.bat -d <DBSID> -enable_roles
and followed steps. but no success.
Please suggest us solution for this.
Thanks and Regards,
Ishan
Hi
Check the command db2 get dbm cfg | grep -i authentication
If there is Database manager authentication (AUTHENTICATION) = SERVER_ENCRYPT
Then change it to Database manager authentication (AUTHENTICATION) = SERVER
and add the user sap<sid> and/or sap<sid>db to db<sid>mon OS group.
Try this may help you
Thanks
Sadiq
Hi,
I fired the command:
db2 update DATABASE MANAGER CONFIGURATION USING AUTHENTICATION SERVER
And checked OS groups. All are set correctly.
Let U know what happens as it needs restart DB Instance.
Thanks,
Ishan
Hi,
implement Note 1456402 - DB6: DBA Cockpit Corrections for SAP Basis 7.02/7.30/7.31
kind regards,
Roland
Hi All,
The problem is solved.
I implemented SAP Note 1456402 - DB6: DBA Cockpit Corrections for SAP Basis 7.02/7.30/7.31
AS suggested by Roland.
Thanks Roland and Sadiq for replying.
Regards,
Ishan