Optimizing SAP DB2 11.1 Performance: Running Offline Reorg, Runstats, and Reducing Tablespace

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.

SAP on Oracle 19 Backup Performance

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 Crash due to port 8005 conflict in Windows

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.

Rsync Utility for SAP DR Solutions on Azure VM

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

How I passed Google Cloud Digital Leader Exam

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

Configure 2 SFTP Destinations in SAP BO

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

JCO_ERROR_LOGON_FAILURE – SSO Issue

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