DB2 10.1 and 10.5 offer new and improved SQL features, many of which can benefit existing DB2 LUW applications without disrupting their design. This article highlights some relatively approachable SQL enhancements that, once adopted, could at least simplify if not accelerate older DB2 applications.
Martin Hubel continues the coverage of new features of DB2 for LUW with an analysis of expression-based indexes -
Hi everyone. In the DB2 labs, we've been very busy over the past few months getting our Cancun release (aka 10.5 FP4) ready. Even though it's mechanically a fixpack, this level of DB2 contains some very exciting new capabilities. Please join me as I take you thru them.
In this short article I want to describe a use case in which trusted context is a main part and which allows me to zoom in on a few of the options that are not that commonly described. My use case can also be a good alternative to Oracle and Sybase roles using passwords.
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.