[AD - But not really] DB2 z/OS - New newsletter/info available

Roy Boxwell

[AD - But not really] DB2 z/OS - New newsletter/info available
Hi List!

Each month, my fellow developers and I, will be sharing valuable technical
DB2 z/OS information from our labs in a brief newsletter (No marketing
stuff I promise!).
If you think that you or a co-worker may be interested in receiving this
information in the future, please sign up at [login to unmask email]

Here's the list of what's coming up this year!

- APARS for RTS, RUNSTATS, and SQL PERFORMANCE for DB2 z/OS – Which
are needed and why?
- XML Tablespaces – How they work and what you must take care of or
“LOBs - The Next Generation”
- PBG – Recommended usage and REORG strategy
- RTS - data for DBA daily usage
- Virtual Indexes – General usage hints and tips
- Unused index analysis (Uses knowledge from the RTS and Virtual
Indexes above)
- Recursive SQL – Examples (VIEW explode etc)
- Poor mans JCL generator – example use of a simple RUNSTATS JCL
generator using only RTS and SQL
- CRUD – How to find which program is doing what to which table
- PLAN to PACKAGE Migration - Do you have any “bad guys” (Same
Packages but different precompile timestamps in different plans…)
- Index Compression – Which ones are worth it?



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv