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...
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...
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...
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...
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...
This article is part 10 in a series on the top 10 most common mistakes that I have seen impact SQL Server Performance and Resiliency. This post is not all-inclusive. Most common mistake #10: Storage For the final post in the top 10 items that influence the performance...
This article is part 9 in a series on the top 10 most common mistakes that I have seen impact SQL Server Performance and Resiliency. This post is not all-inclusive. Most common mistake #9: Automatically Shrinking Your Database This is a topic that has been written...
This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data warehouse applications require a different backup and recovery strategy than a typical online transaction processing...
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...
Ran into an issue today while installing a multi-user EBS Suite install using the latest startCD50. Thought I would share this to help some others if they run into the same problem. The error: Applying one-off patches Using...