DB2 for z/OS Version Polls (2008)

DB2 for z/OS Year in Review 2007

Hi DB2 user,

Here is the list of 2007 DB2usa Blog posts:

- z/Journal (October - November 2006 issue)
- IBM DB2 for z/OS Technotes
- Asked and Answered (Robert Catterall) part 2
- Optimization with DB2 for z/OS Version 8
- IDUG Solution Journal (Winter 2006)
- DB2 for z/OS Versions
- Expert Answer Center (Craig Mullins)
- DB2 for z/OS Stored Procedures
- DB2 9 for z/OS will be GA on March, 16th 2007
- IBM presentations about DB2 9 for z/OS

- IDUG's Audio and Video Materials
- DB2 for z/OS Version 8 Polls
- z/Journal (February - March 2007 issue)
- Asked and Answered (Robert Catterall) part 3
- Security in DB2 for z/OS Versions 8 and 9
- SQL Presentations
- IDUG Solutions Journal (Spring 2007)
- DB2 Catalog Presentations
- DB2mag: Spring 2007 issue
- More SQL presentations with DB2 for z/OS Version 8

- Expert Answer Center (Craig Mullins) Part 2
- z/Journal (April - May 2007 issue)
- Redbook DB2 9 for z/OS Technical Overview
- Access Path Selection presentations
- Two new Redbooks about SAP and DB2 9 for z/OS
- DB2 for z/OS V8 Migration (podcasts)
- DB2 9 for z/OS by Craig Mullins
- DB2 9 for z/OS by Willie Favero
- DB2mag: Summer 2007 issue
- Redbook DB2 9 for z/OS Performance Topics

- z/Journal (June - July 2007 and August - September issues)
- DB2 articles from IBM Systems Magazine
- SQL presentations from Tampa Bay Relational Users Group
- IDUG Solutions Journal (Summer 2007)
- Redbook DB2 9 for z/OS: New Tools for Query Optimization
- DB2mag: Fall 2007 issue
- Presentations from DB2 for z/OS Technical Forum (China)
- Robert Catterall's Blog
- z/Journal (October - November 2007 issue)
- Troy Coleman's Blog
- Craig Mullins and Sheryl Larsen presentations
- Bryan Smith presentations
- Presentations from DB2 for z/OS Technical Forum (Taiwan)


Regards,

DB2usa.

Many more IBM Technotes (FAQ) about DB2 for z/OS

Hi DB2 user,

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

- Functions available in conversion mode vs. new-function mode
- DSNE345I warning message from SPUFI
- How are duplicates in an IN-list handled? Is it a performance problem?
- SQLCODE189 returned on SELECT with a CAST function specifying a numeric CCSID
- How will my stored procedures be impacted by migration to Version 9.1?

- DB2 coprocessor/precompiler: Generated structures for LOB and XML host variables
- Improving the performance of incremental image copies
- Future direction for the BookManager format
- DSSIZE and number of partitions
- CLOB columns are not always indexed

- How do I get a copy of DB2 Estimator?
- Results of Querying Catalog are in Unicode
- IBM-supplied stored procedure package versions
- Parser changes the logical not sign character to the circumflex accent character
- Keywords for searching APAR text


Regards,

DB2usa.

DB2mag Sumer 2008

Hi DB2 user,

Summer 2008 issue of DB2mag is available online: http://ibmdatabasemag.com/db_area/archives/2008/3

Note: DB2mag became IBMDatabasemag.

- IBM Data Studio pureQuery Runtime for z/OS Performance by Rajesh Sambandhan and Simon Harris
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=208802229

- Get On the Enterprise Service Bus by Robert Catterall
It's no magic bullet, but enterprise service bus technology hits the mark for certain transactions.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=209900050

- DB2 Leads with Innovation by David Beulke
DB2 for z/OS financial incentive programs open new horizons for data warehousing and other applications.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=209900069

- The Mystery of DB2 for z/OS Index-only Updates and Deletes by Bonnie Baker
Can a DB2 for z/OS index-only UPDATE or DELETE really be index only?
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=209900061


Regards,

DB2usa.