As a Database Administrator, Monitoring of database is the most important part. As all we know Prevention is better than cure, So. I am …
Read More »Ioctl ASYNC_CONFIG error, errno = 1 (HP-UX)
You can encounter this problem on HP-UX platforms. PROBLEM: Many trace files are being created with the error “Ioctl ASYNC_CONFIG error, errno = 1”. …
Read More »Sybase ASE Migration from Physical to Virtual Machine
Pre-Migration : Questionnaire That need to ask from the client before planning to migrate SAP Sybase ASE database servers from physical machines to virtual. …
Read More »Archive data using pt-archiver
The Percona Toolkit contains many tools for MySQL. Usually, we use the pt-archive to archive our data. Pt-archive can archive the table data to …
Read More »Hash Functions to Identify Skewed Data
On day to day activity we often get situation when the database has a lot of space left but query fails with “2644: No …
Read More »SAP Sybase ASE Warm Standby Database using Replication Server
We are going to create warm standby backup of SAP Sybase ASE Prod1 server to Standby1 server using Sybase Replication Server REP15_7 for a database …
Read More »How To Configure Viewpoint Service In Teradata
To configure Viewpoint follow below steps: [crayon-662808c670a3a530199928/] After running the above steps then do the below service restart: [crayon-662808c670a3f454644591/] Teradata Alerts contains …
Read More »How To Improve Database Performance on MongoDB Part2
This article is the second part of the article named “How to improve database performance on MongoDB part 1“ Ensure you have enough RAM. …
Read More »MongoDB Resync stale replica member
In a replica set if one of the members is in RECOVERING state and in the log file of that member if you see: [crayon-662808c670f21730436986/] …
Read More »ORA-01187 and ORA-01110 errors Regarding Temp Files
Assume that the default temp table space of the system is TMP. ERROR: ORA-01187: can not read from file because it failed verification tests …
Read More »