Recently we Upgraded the database from 126.96.36.199.0 to 188.8.131.52.0 version. We are facing the issue after upgradation in Advanced Reporting.
While we execute Adhoc view and Reports the page is loading but not getting the data after some time timeout error occurred.
Our DBA Increased the memory allocation from 4GB to 6GB and changed some DB parameter as well.
First two or three times adhoc views and report data getting displayed. Next time same issue has happened.
Kindly advice on this..is there any specific DB parameter need to change?
Hello Muthukumaran, I think you opened the question in the wrong CA Community, this the CA Database Management for Db2 and IMS (for z/OS) Community, this question should be opened in the CA PPM Community. https://communities.ca.com/community/ca-ppm Thanks.
Thank You Josep...
Database memory of 6GB seems too low, however there could be some database tuning that can be done. Can you share the oracle init.ora