More information about DB2 10 for z/OS

Hi DB2 user,

Here are several presentations and technical documents about DB2 10 for z/OS (formally known as DB2 X) available on several IBM websites:

- DB2 10 for z/OS: How can it help you? (70 pages with notes)
by Roger Miller

- Planning Your Migration to DB2 9 for z/OS (updated version with DB2 10 information)
by Roger Miller

- Technote (FAQ): When should I migrate to DB2 for z/OS Version 8? DB2 9? DB2 10?


More information

- II14477: DB2 V9 Migration/Fallback Infoapar to/from DB2 10

- II14474: DB2 V8 Migration/Fallback Infoapar to/from DB2 10

- SPE Migration and Fallback from DB2 9 (R910) or from DB2 V8 (R810)

- PM04968: New function for premigration checkout (DSNTIJPM)


Regards,

DB2usa.

DB2 10 for z/OS Presentations and Beta Program

Hi DB2 user,

Here are several articles and presentations about DB2 10 for z/OS (formally known as DB2 X) available on several websites:


- DB2 10 for z/OS technical preview (65 pages with notes)
by Roger Miller

- DB2 Trends and Directions (Version X)
by Gareth Jones

- What's Ahead?
DB2 X leads the industry to minimize complexity and maximize productivity
by Terrie Jacopi and Jeff Josten

- DB2 9 for z/OS and Beyond (pages 29-52 with notes)
by Roger Miller

- The next DB2 for z/OS: First glimpse into the future
by David Beulke

- Deprecated Features Planned for DB2 X for z/OS
by Craig Mullins


More information

- IBM DB2 10 for z/OS launches beta program
Beta Program: March 12, 2010
General Availability (GA): not announced

- IBM DB2 V9.1 for z/OS launches beta program
Beta Program (QPP): June 9, 2006
General Availability (GA): March 16, 2007

- IBM DB2 Universal Database for z/OS, V8 — Reengineered for e-business Leadership
Beta Program (ESP): January 31, 2003
General Availability (GA): March 26, 2004

- DB2 z/OS Product Lifecycle
(General availability, End of Marketing, End of Support)

- DB2 Distributed End of Support (EOS) dates
(including DB2 Connect)


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.

IDUG Solutions Journal (Summer 2009)

Hi DB2 user,

Summer 2009 issue of IDUG Solutions Journal is available on line:


Current issue contains following articles:

- Escaping the REBIND blues in DB2 9 for z/OS
by Adarsh Pannu and Terry Purcell

- Best practices- DB2 9 for z/OS migration
by Roger Miller

- An Overview of Mainframe Specialty Processors
by Craig Mullins


Regards,

DB2usa.

Presentations from New England DB2 Users Group

Hi DB2 user,

Here are several presentations from New England DB2 Users Group, available on NEDB2UG website:


- DB2 9 for z/OS: For Developers only!
by Craig Mullins

- Not Logged Table Spaces
by Jay Yothers

- SQL Optimization & Access Paths: What’s Old & New - Part 1
by David Simpson

- SQL Optimization & Access Paths: What’s Old & New - Part 2
by David Simpson

- Native XML support in DB2 9 for z/OS
by Phil Grainger

- DB2 9 for DBAs and Future Direction
by Roger Miller


Regards,

DB2usa.

DB2 articles from z/OS Hot Topics newsletter

Hi DB2 user,

Here are some DB2 articles from z/OS Hot Topics newsletter:


- The latest thrilling celebrity hook-up DB2 and DFSORT!
by R. David Boenig II

- How to use role-based security with z/OS
by Mark Nelson, Randy Love and Adrian Lobo

- Safety first zCDP for DB2
by Glenn Wilcok and Laura Kunioka-Weis

- Can you hear us now? High availability for DB2 on z/OS
by Jery Buczak

- Tales from de-crypt How secure is your DB2 data?
by Jeffrey Berger and Jeff Novak

- DB2 phone home: IMS/TM is on the line
by Blake Bauman and Jack Yuan

- DB2 RELOADED: DB2 V8 meets zSeries and z/OS
by Roger Miller

- Database on demand
by Jim Porell

- DB2: Easier to use, easier to manage
by Bryan Smith, Jim Ruddy and Dave Schwartz


More information about z/OS features

- Would you like to hear about our specials?
Prelude to the zIIP and zAAP specialty processors
by Bob Rogers

- The zIIP is a chip that’s hip!
The System z9 Integrated Information Processor
by Gita Berg

- z/OS and XML—a different approach
by Joe Bostian

- History of the mainframe poster


Regards,

DB2usa.

IDUG Solutions Journal (Winter 2008)

Hi DB2 user,

Winter 2008 issue of IDUG Solutions Journal is available on line:

IDUG Solutions Journal Winter 2008 (PDF format)

Current issue contains following articles:

- Star Gazing from atop your DB2 z/OS Database Server
by Terry Purcell and Gene Fuh

- Selected Performance Features of DB2 9 for z/OS, tested in a PeopleSoft Enterprise Applications Environment - Part 2
by Brian Holroyd

- Recent DB2 for z/OS Performance Measurements
by Roger Miller

- Database Fundamentals
by Craig Mullins


Regards,

DB2usa.

IDUG Solutions Journal (Summer 2008)

Hi DB2 user,

Summer 2008 issue of IDUG Solutions Journal is available on line:

IDUG Solutions Journal Summer 2008 (PDF format)


Current issue contains following articles:

- DB2 9 - XML and the Unprepared DBA
by Mike Sniezek

- Selected Performance Features of DB2 9 for z/OS
, tested in a PeopleSoft Enterprise Applications Environment (Part 1)
by Brian Holroyd

- The Changing Priorities of Database Administration
by Lockwood Lyon

- Time to Plan for Migration Again
by Roger Miller

- Things You’ve Probably Neglected
by Craig Mullins


Regards,

DB2usa.

IDUG Solutions Journal (Spring 2008)

Hi DB2 user,

Spring 2008 issue of IDUG Solutions Journal is available on line:

IDUG Solutions Journal Spring 2008 (PDF format)


Current issue contains following articles:

- DB2 9 Application-Related Enhancements
by Bill Arledge

- Enterprise Spatial Solution with DB2 9 for z/OS
by Frank Butt, Yu Dong and Gene Fuh

- Getting you out of a BIND
by Roger Miller

- On Recovery Service Levels
by Craig Mullins and Brenda Honeycutt


Regards,

DB2usa.

Roger Miller presentations

Hi DB2 user,

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

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

- zIIP, zAAP, and DB2
by Roger Miller

- DB2 for z/OS Security: Protect Your Assets An overview of DB2 security
by Roger Miller

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

- Why z/OS for your Data Warehouse?
by Roger Miller


More information

- DB2 History: from DB2 for MVS V1R1 to DB2 9 for z/OS
by Roger Miller

- DB2 for z/OS Trends and Directions
by Gregory Lotko


Regards,

DB2usa.

DB2 articles from IBM Systems Magazine

Hi DB2 user,

DB2 articles from IBM Systems Magazine are available online: http://www.ibmsystemsmag.com


- DB2 Table Space - Is It Time to Redesign?
by Troy Coleman

- An Intuitive Approach to DB2 for z/OS SQL Query Tuning
by Lee Siegmund

- DB2 for z/OS SQL Query Tuning, Continued
by Lee Siegmund

- The Evolution of DB2 for z/OS Optimization
by Jay Bruce

- Easing the Cost of Compliance
by James Pickel

- DB2 for z/OS Features Contribute to High Availability
by Lee Siegmund

- DB2 for z/OS High Availabilty and Unplanned Outage Recovery
by Lee Siegmund

- Online Even More of the Time
by Kate Langdon

- Good Migrations
by Jeanne Kays and Roger Miller


Regards,

DB2usa.

DB2 for z/OS V8 Migration (podcasts)

Hi DB2 user,

IDUG published audio materials from Willie Favero and Roger Miller on IDUG website:

- DB2 for z/OS V8 Migration Issues (Part 1)
with Willie Favero

- DB2 for z/OS V8 Migration Issues (Part 2)
with Willie Favero

- 10 Minute Tip: DBAs - Face Your Fears!
with Roger Miller


Regards,

DB2usa.

IDUG Solutions Journal (Spring 2007)

Hi DB2 user,

Spring 2007 issue of IDUG Solutions Journal is available on line:

IDUG Solutions Journal Spring 2007 (format PDF)

All issues from IDUG Solutions Journal

Current issue contains following articles:

- DB2 Locking - Success or Failure in Managing DB2
by Bill Arledge and Judy Quenet

- Fastest Reorganization Is No Reorganization
by Peter Plevka

- What Can DB2 9 Data Compression Do For You?
by Martin Hubel

- Tuning Methodology for Demystifying the DB2 z/OS Optimizer (updated)
by Gene Fuh and Terry Purcell

- DB2 9 for z/OS Performance Summary
by Akira Shibamiya and Roger Miller

- Database Performance Fundamentals
by Craig Mullins


Regards,

DB2usa.

Security in DB2 for z/OS Versions 8 and 9

Hi DB2 User,

Here are several technical documents about Security in DB2 for z/OS Versions 8 and 9, available on IBM's website:

- Securing DB2 and Implementing MLS on z/OS (2007 Redbook Versions 8 and 9)
http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/sg246480.html?Open

- Protect, Retain and Comply with Your DB2 Data (Versions 8 and 9 in PDF and MP3)
by Roger Miller
http://www.ibm.com/support/docview.wss?uid=swg27007844

- New DB2 Improvements in Security (Versions 8 and 9)
by Roger Miller
http://www.ibm.com/support/docview.wss?uid=swg27007843


Version 8 only

- For Certain Eyes Only (Article from DB2mag)
by Sasirekha Cota
http://www.db2mag.com/story/showArticle.jhtml?articleID=17602318

- DB2 for z/OS V8 Security Topics, Including Multi-level Security (Version 8)
by Roger Miller
http://www.ibm.com/support/docview.wss?uid=swg27005803

- Best Practices in DB2 Security (Version 8)
by Roger Miller
http://www.ibm.com/support/docview.wss?uid=swg27007842


More Information about Security

- DB2 for z/OS & OS/390 Security: Protect Your Assets (Versions 6, 7 and 8)
by Roger Miller
http://www.ibm.com/support/docview.wss?&uid=swg27001877


IBM Technotes (FAQ) about Security

- Should I use the traditional DB2 security or RACF access control?

- Authority removed from external security definition (RACF), however user is still able to run the SQL statement. Dynamic statement caching is enabled

- Can encryption be turned on in the SYSIBM.USERNAMES table for the password column?

- SPUFI or DSNTEP2 message: NOT AUTHORIZED TO USE DB2 SUBSYSTEM xxxx

- Invalid Authorization ID with onlinecheck parameter when customizing an SQLJ program

- Running the RACF access control exit routine for DB2 Version 8 with the RACF database set up for DB2 Version 7

- Why do I get a RACF message even though the CREATE TABLE was successful?

- What is IBM's plan for internal and external security in DB2?

- Is that true that DB2 for z/OS, Version 8 is the last version that will support the internal security

- Does a DB2 user need the triggered action privilege in order to execute a trigger?

- Secondary authorization IDs from CICS to DB2

- Multilevel security: indexes on the security label column


Regards,

DB2usa.