DB2 for z/OS is no longer about the traditional relational structured data only. The evolution brought us not only binary objects, or XML and JSON, but also other non-structured data living in a distributed file system such as HDFS.
Have you ever thought about using XML in DB2 for z/OS, but were afraid that you would need to study a lot of material before you could actually begin? Don’t worry! You do not need to know much before you start. You can get by with basic DB2 for z/OS knowledge.
The IBM DB2 Analytics Accelerator (IDAA) has proven to be a big success in enabling analytics on DB2 z/OS data. Roberta Barnabè gave a well-received presentation at IDUG EMEA 2015 in Dublin on how her company implemented IDAA. Get practical advice to help have a successful implementation.
XMLModify function: sub-document update on an XML document
In DB2 9 for z/OS, an update on an XML document is a delete of whole document following by a new insert. Since DB2 10 for z/OS, we are able to do sub-document update using XMLModify function.
Some DBAs end up creating dozens of views on the same table just to manage the security requirements. It can be difficult to track the purpose of all these views and manage them accordingly. Row and column access control may be used as an alternative to views to manage security requirements.