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 select lct_admin(‘logsegment_freepages’dbid)…
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: 1> sp_who2> go It will display processes which is running by “dbmaint” user id:…
PostgreSQL: Password authentication failed for user “postgres”
When logging into PostgreSQL, an error message may appear like this: Password authentication failed for user "postgres". When PostgreSQL installs…
PostgreSQL: Allow Remote Connection to Connect Database
When a client machine tried to connect the PostgreSQL Server, it got an error like “psql:could not connect to server:Connection…
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…
Difference Between 2k, 4k, 8k, 16k Logical Page Size in SAP ASE
The main difference between a 2K, 4K, 8K, 16K page size is the amount of data stored on it. The…
SAP HANA in-Memory Computing Engine Architecture Overview
The memory computing engine is responsible for the server activities. It would take care of the memory management Read and…
