Search

1 to 10 of 944
Sort by


Blog Entry
XMLModify function: sub-document update on an XML document by Jane Man

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...

Jane Man's profile image




Library Entry
DB2 LUW - db2advis - Miracle Worker or Monster-In-Law? (C15)

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


Library Entry
DB2 Design - Selected (controversial?) topics (B15)

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

Suresh Sane's profile image


Library Entry
SQL/PL made Easy for the DBA (D14)

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