by XTIVIA | Mar 22, 2016 | News
CENTENNIAL, Colo. – March 22, 2016 – PRLog — XTIVIA Inc. is sixth on the Denver Business Journal’s list of Top Software Development companies as ranked by ‘local area’ revenue. XTIVIA’s Denver office makes up about a fifth of company revenue with other offices across...
by XTIVIA | Mar 17, 2016 | Blog, Databases
I can’t remember the last time a ulimit bit me, but the time has come again. Everyone is used to removing all the limits for the instance ID at this point, I hope, but have you ever considered the ulimits for your fenced user id? The Problem In the DB2...
by XTIVIA | Mar 3, 2016 | Blog, Databases
Error Message SQL0964C The transaction log for the database is full. SQLSTATE=57011 or DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0964C The transaction log for...
by XTIVIA | Feb 18, 2016 | Blog, Databases
Error Message SQL0968C The file system is full. This is frequently an error that is returned to an application and reported simply as -968 When You Might Encounter This Error Message This error typically is encountered when updating or inserting data, though in some...
by XTIVIA | Feb 17, 2016 | Blog, Databases
Securing your data is very important and database encryption is just part of that landscape. Taking advantage SQL Server database encryption can be a daunting task but once it is configured it is also important to monitor it. This query is intended to...
by XTIVIA | Feb 17, 2016 | Blog, Databases
SSMS Shortcut is what we are going to be learning about in this blog post. When writing T-SQL it can be quite distracting to go look up a table definition or information on a database object. Enter the SQL Server Management Studio (SSMS) shortcut key ALT + F1....
by XTIVIA | Feb 17, 2016 | Blog, Databases
Abstract Upgrading or migrating your SQL Server can seem like a very daunting task. And it certainly can be especially when we start to look at hardware requirements, size and space needs, time constraints, and the numerous impacts to the the users and applications...
by XTIVIA | Feb 15, 2016 | Blog, Databases
SQL Server 2005 extended support ends April 12, 2016. What this means to SQL 2005 users is no more security updates or hotfixes. What it means to us as DBA’s is we’re in a situation we never want to be in, where our database platform is down or compromised...
by XTIVIA | Feb 11, 2016 | Blog, Customer Relationship Management, Portals
Many of our customers host SugarCRM on Apache on CentOS. We strongly recommend enabling HTTPS in any production environment and I’d like to share the steps to enable this. In this blog we would be using a signed SSL certificate not a self-signed one but in...
by XTIVIA | Feb 10, 2016 | Blog, Portals
This blog shows you how to create a portlet to be able to zoom in and out of an image. This portlet is web content driven using Liferay 6.2, jquery and animate.css. I have included all the source code for this project at the bottom of this page. How it Looks: When you...
by XTIVIA | Feb 8, 2016 | Blog, Portals
In this post, I am going to show you how to enable site wide settings for the Language Portlet, so you can add the portlet to your header or footer without having to edit the settings for each and every page. The Problem In Liferay, the Language...
by XTIVIA | Feb 4, 2016 | Blog, Databases
Error Message SQL1024N A database connection does not exist. SQLSTATE=08003 or sometimes: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL1024N A database...
by XTIVIA | Jan 27, 2016 | Blog, Data Management, Databases
Recently, we noticed on a staging environment that the LOGPRIMARY setting was set to 35, yet the number of logs on the log path was only 21. Number of primary log files (LOGPRIMARY) = 35 35 Number of secondary log files (LOGSECOND) = 45 45 db2inst1# ls -ltr total...
by XTIVIA | Jan 21, 2016 | Blog, Databases
DB2 LUW Error Messages are some of the more descriptive ones I have seen in the computing world, but maybe everyone thinks that about their chosen specialty. Truly understanding error messages can take a bit of practice and knowledge, so I thought I would share a few...
