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 SAP

Activate &SAP_EDIT in SE16N

The function code &SAP_EDIT, which enables the change mode of transaction SE16N, is deactivated due to security breaches that were…

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 BASIS SAP

SAP Router Certificate Renewal

Login to SAP Router Server and stop Router service. Take a backup of file in usr/sap/saprouter : Cred_v2, srcert, certreq,…

Posted in SAP

ERROR: HTTP 500 after upgrade of BI or Add-ons

ERROR: HTTP 500 “while trying to invoke the method java.util.Properties.entrySet() of an object loaded from local variable ‘globalProperties’ ” after…

Posted in BASIS SAP

Workload: Application Performance Analysis

Causes, Impacts The utilization of system resources often constitutes the system workload which can be measured using programs, transactions, jobs,…

Posted in BASIS SAP

Application Locks and Enqueue

Causes, Impacts SAP enqueue server administers the lock table by checking if requested locks do not conflict with existing locks…

Posted in BASIS SAP

Backup / Restore Information

Causes, Impacts The following are some of the factors to be considered when looking for the best method for system…