By using SAP HANA SQL Commands, we can perform following job Finding index and primary keys of tables SELECT IFNULL(CONSTRAINT,’NUNIQUE’), INDEX_NAME,COLUMN_NAME FROM INDEX_COLUMNS WHERE SCHEMA_NAME = ‘%s’ AND TABLE_NAME = ‘%s’ ORDER BY INDEX_OID,POSITION Show details of users that have been logged-in select * from “SYS”.”USERS” where “LAST_SUCCESSFUL_CONNECT” is not…
Read MoreUnderstanding HANA Licensing Model for Multiple Tenants
SAP
The HANA Licensing Landscape for Multi-Tenant Environments A common query among HANA administrators is how system-wide and tenant-specific licenses interact in multi-tenant setups. Let’s delve into the intricacies of HANA licensing to clarify these aspects. Read also – Reclaim HANA Log to avoid log full situation. Scenario: A 750 GB…
Read MoreGenerate a System Information XML File for SAP JAVA stack
SAP
How to Generate a System Information XML File (Stack XML) from SAP JAVA stack SUM: Generating a System Information XML File (stack XML)from JAVA Stack for use with SAP Maintenance Planner See also – JAVA system Performance Issue Proceed as follows: 1. Download and unpack a new SUM 1.0/2.0 instance…
Read MoreConfigure SAML Integration in Okta with Cloud Identity
SAP
1. Prerequisites: – You need an active license for Identity Authentication. – Ensure that you have the necessary authorizations (e.g., “Manage Applications” and “Manage Corporate Identity Providers”) assigned to your Identity Authentication account. – Access the Okta Admin portal. 2. Create a SAML 2.0 Application in Okta: – Log in…
Read MoreSAP Cloud ALM vs Solution Manager: 5 Critical Functions for SAP IT Team
SAP
SAP Cloud ALM vs Solution Manager: 5 Critical Functions SAP IT Teams Will Miss | SAP Transition Guide SAP Cloud ALM vs Solution Manager: 5 Critical Functions SAP IT Teams Will Miss As SAP teams prepare for their S/4 HANA transition, they’re facing another challenge: migrating from Solution Manager to…
Read MoreOracle BRTOOLS SSFS Configuration
SAP
If you are still managing an SAP system with an Oracle database. If so, understanding how to configure BRTOOLS SSFS (Secure Storage in File System) is crucial. SSFS provides a secure way to store sensitive data such as database passwords. Let’s dive into the key steps: Avoid using OPS$ mechanism, locking/deleting OPS$…
Read MoreOracle Database 19c | Enable Automatic Indexing
SAP
What is Automatic Indexing? Automatic Indexing is a feature introduced in Oracle 19c that automates index management. It analyzes workloads, recommends creating or dropping indexes, and can even implement those recommendations. This can improve query performance without requiring a DBA to manually manage indexes. Pros of Enabling Automatic Indexing: Improved…
Read MoreSAP | Cleaning Up the Transport Directory: Best Practices
SAP
Introduction of SAP Transport Over time, the global transport directory in SAP systems can accumulate a large number of files. These files reside in subdirectories such as ‘cofiles’, ‘data’, and ‘log’. While these files contain important information, they can also consume valuable disk space and become obsolete. In this article,…
Read MoreOS Memory and Kernel Parameters for SAP DB & Application Installation
SAP
Optimizing OS Memory and Kernel for SAP DB and Application Installation In the world of SAP applications, the performance of your system is heavily dependent on how well your OS Memory and Kernel are configured. This blog post will delve into the intricacies of OS Memory and Kernel parameters for…
Read More