ERROR: When opmn services are started, the following error is being received. BIND (Address already in use) x.x.x.x: 393478144 – listener BIND failed [crayon-6908f1a4a8517939437268/] When …
Read More »How To Install SQL Server
In this article, we will install SQL Server 2014. Other versions can be installed in similar ways. Stand-Alone means installing only one instance on a …
Read More »Script for MySQL Replication Monitoring
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-6908f1a4b1b10918827856/] After running the above steps then do the below service restart: [crayon-6908f1a4b1b16976512474/] 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 »
Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 