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:…
Find and delete log files older than specific days on Linux or Unix
Find log files older than specific days: find /app/logs/ -name "*.log" -type f -mtime +[number_of_days] -ls Delete log files older…
Linux file rename
To change the character(s) in the file name at the folder: for file in *; do mv “$file” echo $file…
Restart ttyUSB* on Linux
The below seems to solve problem, but not always. Find the driver associated to your ttyUSBx device. [email protected]:/# sudo cat…
Serial port on Linux ttyUSBx
Set the baud speed: stty -F /dev/ttyUSB0 9600 Get the port info: stty < /dev/ttyUSB0 Use the stty command to…
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…
