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
Security Secrets for DB2 LUW DBAs (G14)

DATE: 2011-5-6 (09:15 AM - 10:15 AM) SPEAKERS: Rebecca Bond (R Bond Consulting,Inc ) Security Setup Can Be EasyRoles- Separation of Duties. Less is More- Auditing -- Security and Performance. Execute 'em. Latest Auditing Enhancements- Classified -- Security and PII (not PIE). What, When and Why...

NA11G14.pdf


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


Library Entry
SQL Search and Scroll Techniques in DB2 for z/OS (F14)

DATE: 2011-5-6 (09:15 AM - 10:15 AM) SPEAKERS: Daniel Luksetich (YL&A) This presentation will address the many different ways you can search of data in DB2 for z/OS. It's concentration will be on table and index design to support searching and scrolling, as well as various SQL coding...

NA11F14.pdf


Library Entry
BITs and Pieces of the DB2 Log (A13)

DATE: 2011-5-6 (08:00 AM - 09:00 AM) SPEAKERS: Ken McDonald (BMC Software ) This is a geek level crawl through the DB2 Log looking primarily at DSN1LOGP output and mapping the content, significance, and relationship between records in the DB2 Log.This presentation is targeted to individuals...

NA11A13.pdf


Library Entry
DB2 9 LUW Core Engine Data Movement Utilities Overview: with Oracle database comparisons (G13)

DATE: 2011-5-6 (08:00 AM - 09:00 AM) SPEAKERS: Burt Vialpando (IBM ) This presentation will give you an overview of each of the DB2 core engine data movement utilities: Load, Import, Export, db2move, admin copy schema, admin move table, db2relocatedb, restore from backup, split mirror and SQL...

NA11G13.pdf