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
Permanent Connection: Untick
Database Name: <DBSID>
Schema name: SAP<SAPSID>
We tried to modify it as follows
User Name: DB2<DBSID>
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,
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
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.