Temporal Support of Db2 for z/OS – Part III Temporal RI By Xiaohong Fu, Db2 for z/OS Development, Silicon Valley Lab, IBM Background and Motivation What is referential integrity (RI)? Referential integrity (RI) is the state in which all values of all foreign keys are...
“As time goes by…..” DB2 for z/OS continues to enhance support for temporal data. Since the availability of the initial temporal support with DB2 10 for z/OS, the functionality has been extended several times. The subject of this article is one of the temporal extensions, the temporal special...
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. As you may know, DB2 for z/OS stores...
Our performance thread continues this month with another IDUG Tech Talk webinar. Query tuning is an essential piece to the database performance puzzle. While the database engine on either DB2 platform does a good job of access path selection, there are still situations where a DBA or developer...
DATE: 2011-5-6 (10:30 AM - 11:30 AM) SPEAKERS: John Mallonee (Highmark Inc. ) We were faced with the daunting task of modernizing an aging COBOL/mainframe system. This session will describe how we used a simplified, generic DB2 structure to replace the old IMS database. Additionally, you'll see...
NA11E15.pdf
DATE: 2011-5-6 (09:15 AM - 10:15 AM) SPEAKERS: Melanie Stopfer (IBM) DB2 9.7 Fix Pack 1 is stuffed full of new enhancements to help you maximize performance, recoverability, security and operational management. Get the technical information about the new functions and features available in DB2...
NA11C14.pdf
DATE: 2011-5-6 (10:30 AM - 11:30 AM) SPEAKERS: Alexander Kopac (Home Depot) The DB2 LUW Design Advisor is cool tool designed to help define suitable indexes and for testing SQL workloads. Here's a presentation that covers both the command line syntax basics and the GUI approach for making both...
NA11C15.pdf
DATE: 2011-5-6 (10:30 AM - 11:30 AM) SPEAKERS: Suresh Sane (DST Systems Inc.) This presentation focuses on several important design decisions and provides a balanced view based on real-life experiences. The knowledge you gain will allow you to improve your DB2 environment. We will cover ALL...
NA11B15.pdf
DATE: 2011-5-6 (08:00 AM - 09:00 AM) SPEAKERS: Vladimir Bacvanski (InferData ), Dan Galvin (Galvin Consulting, Inc) The terms Java developers use when they talk about database access often sound unfamiliar to database professionals. In this talk you will learn what are the key modern Java data...
NA11E13.pdf
DATE: 2011-5-6 (09:15 AM - 10:15 AM) SPEAKERS: James Surber (CSC) Stored Procedures are being used by Application groups and DBA's more for many reasons. We will cover some of the differences of z-OS and LUW. I will talk writing a single return Stored Procedures in three easy steps. We will...
NA11D14.pdf