DB2mag Spring 2008

Hi DB2 user,

Spring 2008 issue of DB2mag is available online: http://ibmdatabasemag.com/db_area/archives/2008/2

Note: DB2mag became IBMDatabasemag.

- Exploring pureXML in DB2 9 for z/OS by Kirsten Larsen and Michael Schwartzbach
http://ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801115

- Can SOA Perform? by Robert Catterall
The answer is yes, but only if you leave old-school application ideas behind.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801123

- Common DB2 Performance Pitfalls by David Beulke
Build your applications right from the start by avoiding these typical missteps.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801294

- The Mystery of the DB2 SIX Lock by Bonnie Baker
The truth behind this enigmatic lock and other DB2 for z/OS stumpers.
http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=207801138


Regards,

DB2usa.

New 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:

- SQLCODE -104 on a CREATE TRIGGER statement
- How does Oracle's Real Application Clusters (RAC) compare with Data Sharing?
- Checklist for ABEND04E RC00E30099 on -START DB2 or ABEND=S04F
- Can encryption be turned on in SYSIBM.USERNAMES for the password column?

- BIND PLAN ... ACTION(ADD), why do I receive message DSNT220I?
- What is the scope of the RETRY parameter for the REORG utility?
- ALTER table space to TRACKMOD NO
- What are DB2 SQL Procedures?

- Why can't I order REXX in Version 8?
- Keywords for searching APAR text
- How do I find the code page that a specific DB2 table is using?
- EDM POOL FULL condition after migrating to V8 NFM

- Finding DECLARE CURSOR statements in the DB2 catalog in DB2 Version 8
- Running the RACF access control exit routine for one DB2 version ...
- DESCSTAT=YES
- User catalog is out of space

- Does MODIFY RECOVERY always gets an exclusive DBD lock to update a DBD?
- Comma as decimal point
- Packages versus plans
- Can I use the cross-loader function with LOB columns?


Regards,

DB2usa.