by XTIVIA | Apr 25, 2013 | Blog, Databases
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...
by XTIVIA | Apr 5, 2013 | Blog, Databases
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...
by XTIVIA | Mar 29, 2013 | Blog, Enterprise Java, Portals
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...
by XTIVIA | Mar 27, 2013 | Blog, Databases
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...
by XTIVIA | Mar 27, 2013 | Blog, Databases
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...
by XTIVIA | Mar 20, 2013 | News
03-20-13 XTIVIA, Inc. is a proud Silver Sponsor of the Gartner Portals, Content & Collaboration Summit 2013 XTIVIA, Inc., a Liferay Platinum Partner and the 2012 Liferay North America Partner of the Year, is a proud Silver Sponsor of the Gartner Portals, Content...
by XTIVIA | Mar 6, 2013 | News
03-06-13 XTIVIA, Inc. announced today that XTIVIA will be a Bronze sponsor at this year’s International Informix Users Group (IIUG) 2013 Informix Conference, the largest IBM Informix gathering in the world. The IIUG Conference is a technical conference for IBM...
by XTIVIA | Mar 1, 2013 | Blog, Business Intelligence
I am not a regular ETL developer but I do “dabble” in developing code from time to time. One requirement that I come across is looping (while, for, infinite) in a job and performing a task based on condition and then going to sleep for a period of time....
by XTIVIA | Feb 26, 2013 | Blog, Data Management, Databases
Often I am asked about the importance of a security audit, with the majority of these questions being asked by representatives of smaller organizations. The questions are centered around if there is a need to perform a security audit when the organization has taken...
by XTIVIA | Feb 24, 2013 | Blog, Portals
Microsoft Excel is the de facto standard spreadsheet tool used by businesses around the world and houses some of the most critical business information. However businesses often struggle to make this information available to employees and other stakeholders that would...
by XTIVIA | Feb 22, 2013 | Blog, Databases
One of the important performance metrics we monitor for our Virtual-DBA and consulting customers is Page Life Expectancy (PLE). We look for low values as well as values that are trending lower over time. A drop in PLE is a prime indicator of memory pressure. PLE is...
by XTIVIA | Feb 20, 2013 | Blog, Data Management, Databases
We had a Virtual-DBA customer request that we install and configure a new Grid Control agent on a new server with existing databases. While there are several ways to do this, we wanted the customer to be able to perform this task by themselves in the future. The...
by XTIVIA | Feb 20, 2013 | Blog, Databases
At XTIVIA, we monitor and support multiple clients that use Lawson applications with a DB2 LUW (Linux, Unix and Windows) database back end. I wanted to share some of my experience and lessons learned over the years. Schema Layout: Out of the box, Lawson uses...
by XTIVIA | Feb 18, 2013 | Blog, Business Intelligence
It is refreshing to see Microsoft finally acknowledging the business as well as technical framework under which Business Intelligence projects are typically run. By taking this approach, Microsoft is definitely building upon the core competence it has gained over the...
