Discovered in my dusty email archives, information for an undocumented feature from 2009 to provide a server-side mechanism to manipulate the default isolation level for connections issuing dynamic SQL...
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
Data Architecture is not only related to the mere constellation of technical components that should work together. A data architecture should also reply to the needs of an end user and eventually establish an information architecture that is not only fit for use, but also fit for purpose.
Database services in the cloud are gaining increasing popularity for development, test, and production systems. One of the key technical challenges for cloud database adoption is fast and secure movement of large data volumes into the cloud.
With this month’s topic being “locking, concurrency and waits”, it may not be a bad time to review some of the locking basics. It might help your junior colleagues or your developers to get a better understanding.