In the early days of DB2 for z/OS, pretty much every change to a table would result in an unload-drop-recreate-load of the table. This article will talk about how the ALTER table in DB2 12 for z/OS has evolved from DB2 11 for z/OS and what you need to know from a practical point of view.
In DB2 11
In March 2016, IBM introduced a new certification test for DB2 for z/OS - C2090-320 DB2 11 Fundamentals for z/OS. It is an entry level test that opens the door for other more advanced certifications. Let's here go through and review all test sections.
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.
This month’s third article is by John Maenpaa. John provides us with the overview of a real life project. The choice was between JSON, XML and traditional relation structure, in order to store complex forms. John talks about measurements and considerations. This article is a must read.
This month’s second article is by Ludovic Janssens. Ludovic provides us with a DBA’s perspective on JSON. As a consultant, Ludovic talks about the synergy and possibilities JSON provides us with as DBAs. This article will bring JSON closer to our DBA world.