With the current interest in DevOps, a renewed focus on streamlining database change and integrating it with associated application change has been evident in recent times.In this paper we will look at one part of the overall topic of agile database development – the concept of database refactoring.
When you exchange XML documents between different systems or applications, you may need a construct that ensures your applications will “understand” the XML documents that are being exchanged. And this is where XML schema comes into a play!
Let’s start this discussion candidly – I am a big fan of the FETCH FIRST n ROWS ONLY clause coded in a SQL statement. That assertion will require some clarification, since there are some valid use cases, and others that make little sense. Regardless, I will try not to over-complicate the discussion.
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.