As guest blogger, Russ Stocker shares useful tips on DB2 Large Object (LOB) performance. Part 1: Inlining
In February 2016 the DB2 12 Editorial Committee was formed, comprised of volunteers from IDUG’s worldwide community of DB2 users and consultants. This White Paper contains their findings, including practical experiences and independent evaluations of the new features.
In this article we are going to examine some tuning options that a DBA has available to help improve dynamic SQL performance on DB2 LUW.
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.
Database administration refers to a set of tasks that is related to the setup, configuration and maintenance of a database and/or its software. Understanding and defining the different tasks and roles within database administration is critical; learn about best practices for a modern company.