by XTIVIA | Sep 12, 2019 | Blog, Db2
While I’ve covered this topic in detail, and blogged about a specific backup performance problem, I’ve never talked about this at the basic level. What is a Backup? A backup is a binary image of the entire Db2 database. It is, therefore, the size of the...
by XTIVIA | Aug 29, 2019 | Blog, SQL Server
One of the most common missed configuration settings in SQL Server is the cost threshold for parallelism. By default it is set to 5, meaning that when SQL estimates that the cost of a query will be greater than 5 running a serial plan, SQL will split the plan into...
by XTIVIA | Aug 22, 2019 | Blog, SQL Server
There may be a situation when you need to move one of your servers that is part of an Availability Group to a different data center and the IP address for that server will change. In this example, we will be moving a DR node from one data center to another and change...
by XTIVIA | Aug 8, 2019 | Blog, MongoDB
MongoDB is one of the world’s most popular object-oriented NoSQL databases. But like any other database, MongoDB has specific places where it flourishes and areas where it falters. The Question: To Use Or Not To Use Some of the best ways to utilize MongoDB is...
by XTIVIA | Jul 18, 2019 | Blog, Informix
It’s been a little more than two years since IBM and HCL Technologies entered into their 15-year partnership, but there’s still a lot of confusion around their collaborative motives. Putting their efforts toward marginal software hasn’t been a...
by XTIVIA | Jul 12, 2019 | Blog, Informix
The Informix -908 error is returned when an attempted connection to an Informix server is unsuccessful. The vagueness of the message can be frustrating, but knowing what to look for can help to pinpoint the problem and resolve the connection issues. When setting up an...
