XTIVIA BLOG
SQL2032N When Backing Up a DB2 Database
When taking a backup of a DB2 LUW database, there are a lot of options to choose from. I like to specify as many as possible to make it clear exactly what I want, even if I am specifying the defaults. Though I very rarely specify the number or size of backup buffers, as DB2...
ENOMEM by db2fmp in db2diag.log
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 diagnostic log, I saw...
DB2 LUW Error Message: SQL0964C
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 the...
Warning: Custom Code Rendering Liferay Web Content Might Not Be Cached
If you have custom code for rendering Liferay web content, you may not know it but you may not be leveraging Liferay caching for the rendered web content, and this may be at the root of some performance problems in your Liferay environment. Recently, one of our clients ran into...
DB2 LUW Error Message: SQL0968C
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 cases, it...
SQL Server Database Encryption Status
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 allow the...
SQL Toolbox – SQL Server Management Studio SSMS Shortcut Alt + F1
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. Highlighting a...
SQL Server Migration and Upgrade Strategies
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 that utilize...
SQL Server 2005 End of Support
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 with no way to fix...
How to Enable HTTPS on Apache in CentOS
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 theory the steps are...