We have a Virtual-DBA client that was rapidly running out of space for one of their databases in VMWare. To rectify the problem we decided to move a few tablespaces to a new LUN/disk presented to the VMWare OS. We had a scheduled downtime window so we didn’t need to leave the database online to perform the move. If we had wanted to leave the database online we could have used RMAN to...
Read More About Moving datafiles to a different disk/lun linux Oracle 10gR2 »

Often times when implementing data integration projects - we come across a need to implement a row/key based lookup and based on the found/not-found condition update or insert a row. I started implementing a simple data flow in SSIS. The idea was simple and has been implemented by quite a few folks and information is available all over the web. Yet when I built the simple workflow, I ran...
Read More About SSIS 2012 Reporting Driver Errors »

Today we had a client ask us to help them patch their Oracle Financials R12
Read More About Patching Oracle Applications R12 »

  Many of our Virtual-DBA clients have DB2 upgrade plans in the works.  One of them wants to move from V9.1 to V10.1 on Windows.  I'll share some of my experience with this project.  Right now I've completed the set up of the 10.1 instance and restored a copy of their database there.  They are now kicking the tires.  Here are some more details:   ...
Read More About A DB2 on Windows Upgrade Adventure »

      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 following error: Unable to open socket to server: ERROR [08001] [IBM]...
Read More About Informix DRDA Connections »

  XTIVIA will be a Bronze sponsor at this year’s International Informix Users Group (IIUG) 2013  Informix Conference next week (April 21-24) in San Diego, California.  This conference is the largest IBM Informix gathering in the world and is a technical conference for IBM Informix users.  The IIUG Conference offers a unique opportunity to network with a large...
Read More About 2013 IIUG Informix Conference »

We have a client who needs to run monthly reports from their financial application.  When we first started working for them, the monthly report took nearly a week to complete.  We noticed a huge amount of logfile waits and did the classic tuning task of increasing the size and number of logfiles, while putting them on alternating disks.  That reduced the processing time from...
Read More About Bad Application Architecture Limits Tuning Ability »

Twitter is now ubiquitous in the social landscape. More and more organizations are showing twitter feeds in their external facing sites. In a recent project, I was tasked with the integration of Twitter tweets into an Enterprise Portal. In this blog post, I am going to walk through the steps for installing and setting up the twitter portlet from the Liferay Marketplace. As you explore the...
Read More About Tweet! Tweet! Need to Integrate Twitter feeds into Liferay? »

SQL Server 2005/2008 : Error: 9002, Severity: 17, State: 2   Error: 9002, Severity: 17, State: 2 The transaction log for database 'mydatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases   Very often clients come to us requesting assistance because the log file is full and the...
Read More About How to shrink the SQL Server log file? »

SQL Server 2005/2008: Find backup and restore status/progress   Ever wondered how long it would take to complete a backup or restore that is running in the background. I, for one, do not want to keep looking at the job or TSQL that is taking the backup or doing the restore.   I found this neat TSQL that will give you the progress report of the backup/restore and...
Read More About SQL Server backup or restore progress »