Category: Database

Posted in Database SAP ASE

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…

Posted in Database SAP ASE

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…

Posted in Database SAP ASE

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…

Posted in Database SAP ASE

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…

Posted in Database SAP ASE

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…

Posted in BASIS Database SAP SAP ASE Sybase

Sybase ASE: Extending an Existing Database Device

When the free space in the device where the DB is hosted is exhausted Sybase ASE gives following errors: Msg…

Posted in HANA SAP

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…

Posted in HANA SAP

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…

Posted in HANA SAP

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…

Posted in HANA SAP

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…

Posted in HANA SAP

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,…

Posted in HANA SAP

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…