Presentations from Guide Share France

Hi DB2 user,

Here are several presentations from Guide Share France, available on GSE France website:

- DB2 9 for z/OS for Database Administrators
by Namik Hrle

- DB2 9 for z/OS for Application Programmers
by Namik Hrle

- Access Path Stability for Dynamic Queries
by Thomas Baumann

- Recursive SQL from a Performance Perspective
by Thomas Baumann


Regards,

DB2usa.

Presentations from Baltimore/Washington DB2 Users Group

Hi DB2 user,

Here are several presentations from Baltimore/Washington DB2 Users Group, available on BWDB2UG website:

- Improving Performance with DB2 V9 for z/OS
by David Beulke

- What's New in DB2 9 for Applications
by Patrick Bossman

- DB2 Performance Primer
by Michael Murray

- Index Design in a Busy System
by Larry Kintisch and Tapio Lahdenmäki

- ATS DB2 Health Check
by John Iczkovits

- A List of DB2 Top Ten Lists
by Craig Mullins

- Null & Void? Dealing with Nulls in DB2 for z/OS
by Craig Mullins


More information

- New to DB2 LUW but for experienced z/OS DBAs
by Chris Eaton

- Database Trends
by Craig Mullins


Regards,

DB2usa.

IBM 2009 Technotes (FAQ) about DB2 for z/OS

Hi DB2 user,

Here are several new Technotes (FAQ), available on IBM DB2 for z/OS website:

- What is DB2 Accounting Class 2 Not Accounted Time?​
- Keywords for searching APAR text
- BIND ERROR SQLCODE109 TOKENS=INTO in Version 9 CM
- Converting an external SQL procedure to a native SQL procedure​
- Preallocate EDITUTL1 and EDITUL2 datasets before you run DB2 V9 DSNTINST CLIST

- Partition error 00C90099 during REORG
- Explicit SECQTY for DB2 work file table space generator program (DSNTWFG)
- Misleading SQLCODE -104
- DIAGNOSE DISPLAY MEPL: report seems to be built from SDSNLOAD or memory
- DSNU007I when running job DSNTITC to install a new Version 8 or 9

- Loading output from a SELECT statement
- What is DB2 Estimator and what can it do for me?
- Authorizations required for OSC (Optimization Service Center)
- DB2 supplied stored procedures required for OSC tasks
- Enabling multiple OSC users to work with a DB2 subsystem

- Enabling a DB2 for z/OS subsystem for OSC
- Setting up OSC with the same configuration on multiple workstations
- DSNL030I: How do I trace the TCP/IP address to catch an unauthorized user?
- Should I use the traditional DB2 security or RACF access control?
- How to collect frequency and cardinality statistics used for access path selection



Regards,

DB2usa.

Roger Miller's presentations about DB2 9 for z/OS

Hi DB2 user,

Here are several Roger Miller's presentations about DB2 for z/OS available on IBM website:

- DB2 9 for z/OS and Beyond
by Roger Miller

- DB2 for z/OS Selected Performance Topics
by Roger Miller

- Planning Your Migration to DB2 9 for z/OS
by Roger Miller

- Best Practices in DB2 for z/OS Security
by Roger Miller


More information

- DB2 9 for z/OS System Performance Topics
by Greg Dyck

- IBM DB2 for z/OS Utility Update: Best Practices
by Bryan Smith

- Maximizing the DB2 9 for z/OS Optimizer and SQL Performance Enhancements
by James Guo


Regards,

DB2usa.