Hope some of you can assist with any advice or point us in the right direction:
We installed Solution Manager 7.1 recently and before all of this we were fine in respect of transaction logging on DB2 etc.
We have ECC 6.0, 720 Kernel, and DB2 V9.7.5 on all our Managed and managing systems.
Before we installed solution manager and configured monitoring and alerting all our managed systems were running DB2 V9.7.0
After configuring monitoring and partially setting up earlywatch alerts we found out that we were running an unsupported db and sap combo.
So we upgraded all the databases on the satellite systems to DB2 V9.7.5 (FP5) to fix the issue above.
We also implemented all the DB2 9.7.5 settings according to the central SAP Note.
Also we upgraded the satellite systems with ST-Tools (ST / ST-API) to ensure we eliminated all other issues, ran the RTCCTOOL on all systems and ready to go.
All diagnostics agents were installed with 7.30 as they did not exist. That is all configured no problems with that. We are able to start and stop at will from the Agent Framework in Solution Manager.
We have all the Solution Manager Central Notes along with the central DB Notes all of the latest version.
Once we started the monitoring from the managed system (Solution Manager) we have noticed that DB2 Admin Task Scheduler in DBA Cockpit holds all the transaction log files as it is always the oldest application, forcing the application via DB2 CLI releases all the log files, and system logging returns to normal with application id then being 0. After a while it returns and this leaves us in a sticky situation as we could reach transaction log full on our Production System.
We run online backups with logs every night, so we were expecting the logs to be all normal the next day but not so.
We have stopped all the extractors from the extractor framework in Solution Manager, removed the RFC's from Solution Manager (SM59), disabled the backend update in the collector configuration on DBA Cockpit, removed the System from Technical monitoring, still the DB2ATS runs with UOW executing and holds all the transaction logs until full.
We initially configured solution manager with the previous 9.7.0 on Development before the upgrade to 9.7.5 and all seemed to work fine, but the early-watch report on the unsupported DB led us to upgrading to DB2 9.7.5.
At the time when doing the initial investigation when the problems started was that collector configuration on the DEV System was set to External Scheduler instead of DB2 Admin Scheduler, along-with an option to Migrate to DB2 Admin scheduler which we chose supposedly being available after the upgrade to 9.7.5. I suppose thats when the problems started, as we experienced DB2 transaction log full on all our downstream managed systems after that.
We also have intermittent issues with SAPTOOLS running forever on the Solution Manager SM50 processes and this sometimes leads to massive CPU activity if not manually killing them via SM50 or dpmon.
Right now we would like to stop all monitoring of our Production System until we can resolve the problem on Development.
Having removed the monitoring, deleting the extractors, removed the SM59 RFC Dest and as well as removing the users on the target client in production, DB2ATS still runs and holds all the transaction logs.
Right now as a work-around we are manually forcing the application id from DB2 CLI to release the logging. We have since configured large logging so that we can survive a few days.
The last step would be to disconnect the systems from SLD.
I cannot remove the Production System from the Central SLD (Which is on Solution Manager) with the associated Production Portal as this would cause the Production Portal to stop if the connection to the Central SLD does not exist.
Thanks in advance, hope someone has experienced and resolved this issue previously and could assist us with some sage advice.
Ironically it seems that we are monitoring the monitoring system all the time and this is the system which supposed to be safeguarding our SAP Environment 😊
Thanks so much, any help would be greatly appreciated.