Continuing this month's theme of Temporal Data (Time Travel Query), IDUG Content Committee chair Dan Luksetich goes behind the scenes to look at how DB2 processes temporal queries. Check out his article here -
Support for the declaration and manipulation of temporal data was added to the SQL standards in the revision of the standard formally adopted in December 2011 (SQL:2011 and ISO/IEC 9075:2011). Since then support has been added in both DB2 for z/OS (10 onwards) and DB2 for LUW (V10.1 onward).
Join Judy Ruby-Brown has she gives a thorough overview of system level backup and using FlashCopy for disaster recovery as provided by various vendors. Judy explains the types of services that need to be setup for disaster recovery as well as easy implementation scenarios for the DBA.
This article sheds a little light on the inner workings of dynamic workload balancing of distributed connections, and how this can benefit the performance, scalability and availability of your DB2 for z/OS solutions.
When the term high availability is brought up, most DBAs reflexively think of technical solutions to help keep a system or database available for users – However, there is so much more to availability than simply ensuring that a database is available for a user to connect to.