by XTIVIA | Feb 11, 2014 | Blog, Business Intelligence, Data Warehousing, Databases, Perspectives
This is an important question that anyone responsible for a data warehouse should ask periodically and with some frequency as well. The following table will give you some concrete ideas on what to look for and how to use the metrics. The details of how you collect...
by Barrie Shaw | Feb 11, 2014 | Blog, Databases
During my 14+ years of providing Informix services and support for XTIVIA’s Virtual-DBA remote database administration service, this is one of the more common errors that I am asked to address. I want to share three possible fixes for this problem....
by XTIVIA | Jan 31, 2014 | Blog, Databases
I have been working with Informix for just over 15 years. This has caused me to stop, pause and think about all the changes in the industry that have happened in that time. Back when I started, databases were still small. Databases were maintained to...
by XTIVIA | Jan 31, 2014 | Blog, Data Management, Databases
If you have ever tried to install a Linux distro on XenServer you have probably run into the installation showing the non-GUI version. Which is perfectly useable, but sometimes it’s just faster and easier to click through the install. So how I get around this issue is...
by XTIVIA | Jan 30, 2014 | Blog, Data Management, Databases
So at one time or another most of us have run into an issue where no matter what we install or try we just can’t get a unix system to throw an x window for anything. Well I personally have run into this issue often enough that I thought I would throw together a...
by Kathleen Long | Jan 23, 2014 | Blog, Data Management, Databases
Bloated Transaction log in Simple recovery mode will not shrink Received a request today from a Virtual-DBA customer asking XTIVIA to help troubleshoot why a database which is only 50MBs in size would have a transaction log of 181GB. My first thought fell to an open...
by XTIVIA | Jan 15, 2014 | Blog, Data Management, Databases
What you need to know about Database Mirroring In recent months I have set up database mirroring for a number of clients. Why you may ask? It is a great option for disaster recovery and even gives the organization additional options when it comes to maintenance...
by XTIVIA | Oct 7, 2013 | Blog, Business Intelligence, Databases
At XTIVIA we often receive requests from clients who require somewhat more than the average database administration tasks. Recently I had a request to help a client pull normalized data from one object in one data source and merge that data with data in two...
by Brad Patterson | Aug 20, 2013 | Blog, Databases
XTIVIA has a client who runs an old Informix database product, Standard Engine (SE) version 5.01.UD3, on SCO UNIX version 5.0.5. Both have been running well for at least twenty years without much in the way of outages. Over the years XTIVIA has assisted...
by XTIVIA | Jul 30, 2013 | Blog, Databases
In recent times, database migrations have become a way of life for most database administrators. Whether moving to new hardware or into the world of virtual machines, what once was a rare project is becoming an almost everyday concern for database environments...
