I spend every day of my life since 1990 as a Db2 DBA both on Db2 for z/OS and Db2 for LUW. During that time, I’ve collected a lot of knowledge that makes my job easier and gets easier and gets the answers to the developer’s questions in a timely fashion.
DevOps is a very popular term, that describes the process of automating the processes involved in the delivery of applications. Including database changes in this can be difficult, but it's possible bring DevOps to your developers using Data Studio using the methods described in this article.
Learn how to manage new releases and fixpacks for IBM Data Studio in this article by Phil Nelson.
IBM’s Data Studio holds a lot of features that are not commonly known by the DB2 audience. Many regard it as the replacement of the old Control Center. IBM Data Studio has got a lot of goodies not included in Control Center. In this article we will focus on the usage of physical data models.
SQL tuning is not just looking at statements and their EXPLAIN plans, but it’s also about verifying whether or not a tuning change actually improves performance. Remember that SQL tuning is about saving elapsed time and/or CPU resources, and there is only one way to really do that: benchmarking!