Database Blogs

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...

read more

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...

read more

DB2 LUW Error Message: SQL1024N

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...

read more

Understanding DB2 LUW Error Messages

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...

read more

DB2’s Self-Tuning Memory Manager (STMM)

DB2's Self-Tuning Memory Manager (STMM) was introduced in DB2 9.1. The default for new, single-partition databases was ON from the beginning. What is STMM? DB2's Self-Tuning Memory Manager can allocate and change the size of specific memory areas including the total...

read more

Need more information? Let's Talk Today!

XTIVIA needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at anytime, read our Privacy Policy here.