Recent releases of Db2 have introduced new SQL functionality that improves the functionality and productivity of application developers. But the DBA can also take advantage of some of the “new” Db2 SQL to improve their own productivity.
DBA's are notoriously conservative when it comes to migrating data to new types of objects. Our theme seems to be "if it ain't broke, don't fix it!" IBM has decided to encourage those of us on DB2 for z/OS to migrate our data to Universal Table Spaces (UTS) by essentially deprecating non UTS space
With many high-profile data security breaches, data encryption has become a focus item up to the CIO and CEO levels. Any loss or exposure of sensitive data might cause irreparable damage to the business and might result in high penalties. One of the ways to protect data is using encryption.
Availability of data is a must these days. Everything has to be up and running, data outages are becoming few and far between and preferable non-existing. With every release Db2 for z/OS becomes more highly available; however this requires the usage of new features and structures.
This article explores the settings that take advantage of the Db2 for z/OS continuous delivery features when dynamic SQL applications are using a JDBC type 4 connection.