XTIVIA BLOG
SQL Server History Cleanup Task
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 understand...
How much memory is a SQL Server database using
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 much memory...
Failed Oracle Backup via Expdp
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 21:03:32 PST 2012...
Recovering From SQL Server ‘recovery pending’ Status
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, there's no guarantee that you'll be able to...
Configure spring:message tags for your Liferay portlet
The blog entry Add a New Language to Liferay contains a note at the bottom about using <spring:message> tags with UTF-8 (Unicode) languages. This entry is meant to expound on those notes a little more. There are two main ways to handle Unicode in properties files: 1) Put...
SELinux and Tomcat Clustering
In this article I’ll briefly explain my experience of how SELinux can affect Tomcat clustering. My setup is a single host with two Tomcat application servers with Liferay Enterprise 6.1.20 installed in a vertical cluster. System Setup OS: Centos 6.3 Webserver: Apache Http...
Add a New Language To Liferay
Liferay currently supports about 40 languages out of the box. The full list of translated languages and their progress may be seen here: http://translate.liferay.com/pootle/ What about adding a language to Liferay that is not one of the ones supported? The Cherokee language...
Liferay 6.1 SAML Custom Assertion
Identity Provider Custom Assertions After a request by a customer to provide custom attributes for an Identity Provider initiated login, I looked into what it would take to provide the attributes that were requested (a brief introduction to SAML can be viewed here). There are...
Ensure your RMAN backups are functional
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 were...
DB2 Update Anywhere Replication For Dummies.
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 replication...