Category: Database
SAP ASE Warm Standby Database using Replication Server
We are going to create warm standby backup of SAP ASE Prod1 server to Standby1 server using Sybase Replication Server…
SAP ASE Tempdb is Full
1. Check error log to find the tempdb full. 2. Find out the space free in tempdb using 3. dum…
Tracking configuration changes in SAP ASE
Introduction A principal component of a protected system is accountability. One way to ensure accountability is to examine events on…
SAP ASE Server Tips & Tricks
1. How to Calculate Memory Usage and Disk Space Usage?There are 2 stored procs which help you to calculate the…
SAP ASE Server Health Check
It will display current running processes: It will display processes which is running by “dbmaint” user id: It will display…
Cumulative Sum / Running Total in HANA Calculation View and the Dangers of It
WARNING: Model can be much more complex based on number of characteristics you take, in this case it was only…
What is the importance of _SYS_BIC, _SYS_REPO, _SYS_BI
A schema is just like a database folder. The relavant tabels are going to group together according to the particular…
HANA Log Volume is full
Symptom The logvolume is full and the database doesn’t accept any new requests. Other Terms HANA, in-Memory, logvolume, full, no…
SAP HANA 403 Forbidden when accessing ALM (Application Lifecycle Management)
I am using SYSTEM login, which is no doubt the most “SAP_ALL” figures in SAP HANA Database. Unfortunately, without proper…
SAP HANA Installation on the SandBox System for Educational Purpose
Preparing system for SAP HANA installation Choosing hostname There are restrictions that apply to host names in SAP systems,…
SAP HANA Platform TCP/IP Ports
Transmission Control Protocol/Internet Protocol (TCP/IP) ports list of SAP HANA platform SAP HANA SQL/MDX Access Name Service in /etc/services…