The concept of automating routine database tasks is not new. It has been theorized, discussed and written about for several decades. But, true self-managing or autonomic capabilities have been slow. We discuss some of those distinct pain points and how IBM has helped to solve them.
Today we will discuss how LOAD and UNLOAD utilities and file reference variables can help you to overcome inefficiencies in XML document maintenance with standard SQL statements.
Each new release of DB2 brings changes to the utilities suite, and new release DB2 11 is no exception. The importance of these changes can have a big impact on the work of a DBA. The purpose of this article is to introduce some of those features.