by XTIVIA | Jan 2, 2013 | Blog, Databases
I’m working on a data purging project for one of our clients and I’ll blog as it progresses. The first step was to find the oldest data in the database and let the application team look it over to decide what can be purged. I came up with the handy...
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 Kathleen Long | Dec 20, 2012 | Blog, Data Management, Databases
This feature in the maintenance plans in SQL Server seems to be either ignored or over used. Either people do not put this step into any maintenance plan causing MSDB database to grow large over time. Or they have this step placed in every maintenance plan not fully...
by Kathleen Long | Dec 19, 2012 | Blog, Data Management, Databases
An interesting request came in the other day, is there a way to tell how much memory each database is using on an instance. You can always use properties to see how much memory is allocated to the SQL Server and there are performance counters available to track how...
by XTIVIA | Dec 12, 2012 | Blog, Data Management, Databases
Recently I received a call concerning failing backup jobs being taken via Expdp. I logged in to our Virtual-DBA client’s site and immediately checked the alertlog for errors. The below errors were found in the alertlog. Exporting orcl on DBHOST01 Sun Dec 16...
by XTIVIA | Dec 11, 2012 | Blog, Databases
Seeing a database in any state other than “online” makes me a little nervous. For one thing, it’s one of those things I don’t see often, so I have to rub a few brain cells together to remember what I did the last time. For another,...
by Doug Groves | Nov 28, 2012 | Blog, Databases
To me making sure your database is backed up is the most important task for a dba. But not only is it backed up, but it’s backed up correctly. I just encountered a situation where a client started receiving numerous errors in their production system. There...
by XTIVIA | Nov 27, 2012 | Blog, Databases
Hi. I recently finished a project for a client who needed Update-Anywhere Repliction on one table between 4 DB2 version 9.1 databases at different locations. I thought I would share a high-level overview of the process I used, starting with 2-way...
by XTIVIA | Nov 20, 2012 | Blog, Databases
Here at XTIVIA, we have standardized on an agile process we’ve coined as XDLC (XTIVIA Development Lifecycle). XDLC is largely based on Scrum and other agile techniques that enable us to quickly deliver maximum value for our Enterprise Portal/Java...
by XTIVIA | Nov 19, 2012 | Blog, Databases
Liferay v6.1 introduced a new end-user customization capability wherein we can create a customizable page in a site that allows an end-user to add or remove portlets on the page or drag and drop portlets in different places on the page. In order to enable...
