Fast INSERT performance speeds the way to getting new data into DB2, for ETL, bulk ingest jobs, and even just day-to-day transactions. In this new blog entry, we look at several helpful tips for making INSERT run as quickly as possible.
We are getting back on track how to access and manipulate XML documents in DB2 for z/OS. But this time, with focus on more complex XML data manipulation techniques than just selecting/inserting/updating, or deleting the whole XML document.
In Part 2, we will examine how to exploit Application Compatibility (APPLCOMPAT) which was introduced in DB2 11, and Function Levels which is introduced in DB2 12 to safely manage change. The levels of APPLCOMAT you can specify is limited by the Function Level of your system.
Build DB2 for z/OS native services without Data Studio and z/OS Connect
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.