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.
IBM® Data Server Manager is an integrated database management tools platform. In this article, learn how to use the Query Tuning functionality that is included with the Base edition of DSM at no additional charge to tune the queries running in your DB2® for z/OS® environment.
For those of you who use or like db2top, the new dsmtop tool is worth trying out!
Come take a look at the next generation tooling platform that IBM® rolled out in March 2015 to help optimize database performance, detect and solve performance problems, easily administer instances, database objects, and manage data server configurations.