This site represent my personal views & findings on SAP Technology.
Is your DB2 11.1 database running slower than usual? One way to improve its performance is by running offline reorg, runstats, and reducing the tablespace size. In this article, we will guide you through the process step by step and provide an example to help you get started. Additionally, we will discuss the pros and cons of these actions to help you decide if they are right for your database.
BCT (Block Change Tracking) is a feature in Oracle that helps to improve the speed and efficiency of incremental backups. When BCT is enabled, the database tracks changes to blocks of data, allowing RMAN to quickly identify which blocks have been modified and need to be backed up. This reduces the time required to perform incremental backups and reduces the amount of data that needs to be backed up, making the backup process faster and more efficient. The benefits of enabling BCT in Oracle include improved backup performance, reduced storage requirements, faster recovery times, and simplified backup processes.
Tomcat is a popular open-source Java Servlet Container that is widely used to deploy web applications. One common issue that users may encounter is that the Tomcat server may crash when the SMS Agent Host service is using the same port (8005) as Tomcat. In this post, we will discuss some steps that you can take to resolve this issue and get your Tomcat server running smoothly again.
Recently we have an requirement to copy data from 1 Region to 2 Region in Azure VM’s running on SUSE Linux. DB is getting synced via DB internal HA/DR functionality but other directories (i.e. -/sapmnt, /usr/sap/trans, /interface etc), rsync utility has been configured to transfer the incremental data between decided interval. There are 2 options … Read more
During our SAP Refresh Activity, we have seen it’s taking too much time on VBAP table while performing the BDLS activity. OS – SUSE SP12 DB2 Version – 11.1.3.3 SAP NW Version – 7.01 There are 2 ways to create, either you can create via SE11 then use SE14 to create in DB or else … Read more
Recently I test my knowledge by giving GCP Digital Leader Exam on 21st May 2022. This is the basic exam which test you knowledge in Google Cloud space. This exam helps you to understand the services and offering by GCP and understanding of basic concepts. This exam doesn’t test your working technical skills. it’s mainly … Read more
We have an SAP ECC system running on Oracle 19 with 4 TB DB in Cloud environment. Users has reported performance issue on some of the FI Tcodes where it is getting Time Out issues. Present DIA time out set for 1800 seconds. We did some analysis and found that there is an issue in … Read more
Recently there is an requirement to to send schedule reports from SAP BO 4.1 SP7 to two different SFTP locations. For configuring SFTP, you requires fingerprint. There are multiple ways to generate, you can get more details from here – https://blogs.sap.com/2015/07/23/sftp-destination-for-sap-businessobjects-bi-platform-41/ This can be achieved by configuring SFTP destination in Servers – Adaptive Job Server … Read more
We have recently installed a new PO 7.5 landscape & want to add this system to web dispatcher. While adding in Web Dispatcher, we have checked System is showing in Web Disp with Error “Resource Temporary Unavailable”. We have checked through multiple SAP notes & it’s an error related to Groups. As we are on … Read more
Recently we are getting issue in our SSO connectivity between SAP Business Objects 4.2 SP5 to SAP BW system. We have crosscheck the SSO certificate & it’s valid till 2025 but still it’s throwing the below error for all end users – JCO_ERROR_LOGON_FAILUREL:Initialization of destination custom_xxxxxxxxxxxxxx failed: System received an expired SSO ticket on xx.xx.xxx.xxx. … Read more