A lot of DB2 LUW DBAs spend significantly more time working with DB2 on Linux and UNIX than they do working with DB2 on Microsoft Windows. This can lead to frustration when administering DB2 on Windows. Using a PowerShell command line for DB2 instead of a DB2 Command...
Database Blogs
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...
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...
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...
Before you restore!
There are several times that you may 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 the id you used to restore has...
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...
How to Extract Data Using db2audit
One of our customers recently wanted to extract data using db2audit, but the documentation on this topic is very limited and scarce. Moreover, the commands have changed after V9.7 and finding documentation or following it could be tricky. After some testing, we were...
Tip #7 – Disaster Recovery Plans – Top 10 Tips for SQL Server Performance and Resiliency
This article is part 7 of a 10 part series explaining the most common mistakes that I have seen in reference to SQL Server Performance and Resiliency. However, this post is not all-inclusive. Most common mistake #7: Disaster Recovery Plans Often when people hear...
DBCC CHECKDB() Error 17053
During routine integrity checks one of our Virtual-DBA customers encountered an error 17053 was encountered causing the job performing these tasks to fail. Investigating the problem further this information was also included with the error in the SQL Error Log:...
Informix onclean – Rescue command for Informix DBAs
The Informix “onclean” command was introduced in Informix 11. I am sure that most Informix DBAs have occasionally faced a situation where the Informix instance won’t come online due to an improper shutdown, killed process, interrupted restore, or an instance...