by Brad Patterson | Jul 1, 2013 | Blog, Databases
In the past, using a client-server architecture with IBM Informix database software required adding an entry on the database server with the client details, either in a .rhosts file in a specific user directory or the/etc/hosts.equiv file. If one of these was not...
by Barrie Shaw | Apr 17, 2013 | Blog, Databases
One of our Virtual-DBA clients recently contacted me for assistance in setting up connections using the DRDA protocol. They are moving from Java to .NET for their development work, and when they tried to connect via the .NET drivers, they received the...
by XTIVIA | Feb 6, 2013 | Blog, Data Warehousing, Databases
We all worry about the performance of our servers. It is what separates the DBA’s from the pretenders. You just never know just what setting will be the one that makes the big difference. The worst part is, the setting that works today may...
by Barrie Shaw | Dec 20, 2012 | Blog, Databases
Informix software has a hard limit of 16,777,134 for the number of data pages that can be used in a single table partition. This is true for all versions of Informix software from 7.31 to 11.70. Unfortunately, if you hit this limit, the message that is...
by Tony Salerno | Jul 25, 2012 | Blog, Databases, Perspectives
How do you know if you have the right number of database administrators (DBAs) on staff to properly take care of your environment? All your organization’s databases need to be kept operational and properly tuned, which probably requires around the clock...
by XTIVIA | Mar 16, 2012 | Blog, Databases
I gave my third presentation today for the finals of the DB2’s Got Talent contest given by the good folks at the DB2Night Show. I found out that I’ve made it to the final round! Thanks to everyone that voted for me! (I’ll have to...
by Barrie Shaw | Aug 10, 2011 | Blog, Databases
One of our clients was experiencing an issue with their production Informix Online 5.05.UC11 databases running on SCO Unix 3.24 and we had the opportunity to help them a couple of weeks ago. It is surprising how many old installations of Informix you find still...
by XTIVIA | Jun 4, 2011 | Blog, Databases
Is your company considering using CommVault’s Simpana Backup software to backup your database’s and other applications? I am a certified CommVault Software Engineer and also an Oracle Certified (OCP) 10g Database Administrator. Having previously worked for...
by Dennis Robinson | Apr 27, 2011 | Blog, Databases
The following are observations and recommendations from one of our clients experiencing issues with Informix Database Replication. 1.) The session thread was doing quite a bit of sleeping. This normally occurs when control is handed off to another thread. The...
