XTIVIA BLOG
VirtualBox Networks: DHCP vs Static IP
On my third day at XTIVIA, it was recommended I tinker with Oracle's free VirtualBox. The following week, I was hooked! A Unix guy at heart, I can launch whichever flavor of Linux desktop I'm in the mood for, while Windows keeps running and all the tools there remain available....
Query Liferay’s database to find documents marked searchable
This post shows you how to query Liferay's database and see which Documents and Media files are marked 'searchable'. For these examples, I was using SQL Server and did not validate the queries work on other databases. They are simple enough to port if you...
Profiling Data with SSIS
SQL Server Integration Services offers a useful tool to analyze data before you bring it into your Data Warehouse. The Profile Task will store the analysis in an XML file, which you can view using the Data Profile Viewer. Before we review how to use the Profile Task,...
Managing DB2 Transaction Log Files
Logging method There are two methods of logging that DB2 supports: Circular and Archive. Other RDBMSes have similar modes. Circular The default that DB2 uses if you don't change anything is Circular logging. Circular logging is more often appropriate for databases where you...
Stopping DB2 Processes For a DB2 Fix Pack Upgrade
When upgrading DB2 fix pack, you need to make sure that all DB2 related processes have been shut down clean. In normal circumstances, you would: db2stop (if that does not work, try db2stop force) db2licd –end ipclean Even after following the steps, you may still see some...
Move data from a custom module when converting a lead in SugarCRM
In SugarCRM a Lead Conversion will not handle data from a custom module. Converting a lead that has data associated to it in a custom module will cause the data to be lost. In my personal opinion this should be done automatically as long as you add this module on to the Lead...
Accessing InforCRM Control Values From JavaScript
Often when one needs to access the value set in an HTML control from the client side script it is tempting to reach into the DOM object and retrieve it directly, using something like this for example: var c =...
Before you restore!
There are several times that you may have DB2 restore authorization errors and have to restore from a production box to a beta or a QA environment as a different user. In that scenario, the restore commands will work just fine but you will receive authorization errors even when...
Unspecified Error logging into Infor CRM / SalesLogix
If you've worked with Infor CRM / SalesLogix for a while, you've probably run into the issue where you enter your username and password (correctly!) and all you get is an Unspecified error! Very descriptive, isn't it? Cause: Essentially what the error means is that the...
What are Page Splits?
Are you noticing a drop in performance? Are you seeing a large percentage of index fragmentation? If your data page fill factor value set to a high number, page splits could be the culprit. We have helped many of our VDBA customers with these problems. What are Page Splits?...