DB2 Magazine E-Newsletter

November 15, 2006

DB2 Magazine Email Newsletter
Volume 7, Issue 11
http://www.db2mag.com/

IN THIS ISSUE:

1. From the Editor
* Hot List
2. Asked and Answered
* Making the right stored procedure call
3. Poll Positions
* What's driving security?
4. New DB2 Magazine E-Book
* XML for Java Developers
5. Must Read
* Understanding DB2 Security
6. Skills Set
* Free materials, tutorials, and discounts for IBM certification programs
7. In the Zone
* The latest information management articles from developerWorks

****SPONSOR: Quest Software ****

Multiple DB2 Platforms. One Toad
Toad for IBM DB2 v2.0 supports DB2 for Linux, Unix, Windows and now z/OS. With its customizable user interface and features such as built-in DB2 client and connect, Toad simplifies database development and improves user productivity.
While supplies last, get a free Toad t-shirt with a trial download of Toad for DB2.

http://www.quest.com/landing/?id=755

**************************************

1. FROM THE EDITOR

* Hot List
I mentioned last month that DB2 Magazine is celebrating its 10th anniversary. Looking back through the rich archives, I was reminded what a knowledgeable and talented group of writers lend their expertise to these pages. Did you know that industry experts Craig Mullins and David Beulke have written for the magazine from the very first issue? Shortly thereafter, Bonnie Baker launched her Programmers Only column, which remains a reader favorite. The prolific duo of Robert Catterall and Roger Sanders continue to write popular columns that serve the changing DBA role (and they tirelessly answer reader questions like the one below). Then there are the newer contributors (including Lester Knutsen, Stuart Litel, and Jean George Perrin) who serve our expanding Informix audience. Add to these industry voices the IBM experts who lend their considerable knowledge-- and we've got a pretty incredible roster. Space prevents me from naming every amazing contributor, but glance at the latest table of contents for the current all-star lineup. You can send suggestions and appreciation to the writers via the contact information provided at the end of each article. Here's a short list of some recent highlights. --Kim Moutsos

* Browse Jean George Perrin's day-by-day recap (complete with photos) of the Information on Demand and IDUG/IIUG Europe conferences.
http://db2mag.com/postcards2.shtml
http://db2mag.com/postcards.shtml

* Read Roger Sanders' guide to cloning DB2 databases.
http://db2mag.com/story/showArticle.jhtml?articleID=193105319

* Check out Lester Knutsen's article on embedding SQL in Unix scripts.
http://db2mag.com/story/showArticle.jhtml?articleID=193105293

* Read the latest from Bonnie Baker, "REBIND Magic with V8."
http://db2mag.com/story/showArticle.jhtml?articleID=193105270

* Browse all the latest articles online.
http://www.db2mag.com/

2. ASKED AND ANSWERED

* The application I work on currently uses COBOL DB2 stored procedures on z/OS running under the WLM address space. Would you recommend a plain COBOL sub-routine call or an exec SQL call? Can I return a result from the called stored procedure along with a result-set from the calling procedure? Also, please elaborate on the PROGRAM TYPE key word in the CREATE STORED PROCEDURE statement.
--Find out what Robert Catterall recommends.
http://www.db2mag.com/story/showArticle.jhtml?articleID=194300674
--Read the column "Stored Procedures go Mainstream."
http://www.db2mag.com/showArticle.jhtml?articleID=15300097

3. POLL POSITIONS

* What's driving security efforts at your company? Let us know, and find out what's going on at other companies.
--Participate in the poll.
http://www.db2magazine.com/
--Browse the archives of past poll results.
http://db2mag.com/poll_results/

4. NEW DB2 MAGAZINE E-BOOK

* XML for Java Developers
DB2 9 introduced powerful XML management capabilities. Download this new e-book from DB2 Magazine to find out how the techniques you use every day can help you put that power to work. You'll learn XML programming tips for Java developers, see detailed Java application examples, and get a recap of all the new features and functions that ease Java development.

Download the e-book today.
http://cmp.ebookhost.net/db2/quest/3/

5. MUST READ

* Understanding DB2 9 Security
by Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan
This new book explains how to create (and build support for) a security policy that can become a blueprint for DBAs and systems analysts. The authors explain how to implement key aspects of any security policy, including authentication, authorities, privileges, and encryption. Chapters on auditing and intrusion detection cover the ongoing monitoring necessary to ensure compliance.
--Find out more.
http://www.db2mag.com/bookstore/

6. SKILLS SET

* New Course: Fast Path to DB2 9 for Experienced Relational DBAs (CF282)
This three-day course covers how to perform basic DB2 database administration tasks, including creating and populating databases and implementing a logical design to support recovery requirements.
--Learn about this exam.
http://www-304.ibm.com/jct03001c/services/learning/ ites.wss/us/en?pageType= course_description&courseCode=CF282

* Updated Course: An Introduction to DB2 Document Manager V8 Implementation and Administration (DM470) Formerly known as DM401, this newly updated four-day course covers the tools, processes, and tasks required to implement and administer a document management system using DB2 Document Manager Version 8.
--Find out more about the course.
http://www-304.ibm.com/jct03001c/services/learning/ ites.wss/us/en?pageType=course_description&include NotScheduled=y&courseCode=DM470

* New Redbook: Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries
Released last month, this IBM Redbook includes suggestions, guidelines, and practical examples for stored procedures, triggers, and UDFs in V5R1, V5R2, V5R3, and V5R4.
--Download the Redbook.
http://www.redbooks.ibm.com/abstracts/sg246503.html?Open

* DB2 Content Manager V8.3 Certification Preparation Articles
This series of articles is designed to prepare you for taking the DB2 Content Manager V8.3 certification exam 443, and covers requirements gathering, tuning, administration, and troubleshooting.
--Explore the articles.
http://www-128.ibm.com/developerworks/db2/library/long/cmcertification/

* Now Available: FileNet Education
FileNet training can provide the skills and knowledge needed to fully utilize a FileNet solution. Courses are offered in a public classroom environment, at customer locations, or in a self-study e-learning format.
--Find out about FileNet courses.
http://www-306.ibm.com/software/data/education/filenet.html

* IBM Fall 2006 Training eCatalog
The new Web-based, interactive training catalog includes new or updated courses in 26 curriculum areas in addition to money saving offers.
--Download the catalog.
http://www-304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType= page&c=a0004805

7. IN THE ZONE

* Annotated XML schema decomposition using DB2 Visual Studio 2005
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0611farahbod/

* Query XML data that contains namespaces
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0611saracco/

* DB2 for i5/OS query optimizer and database engine feedback
mechanisms
http://www-128.ibm.com/developerworks/systems/library/es-db2i5os/index.html

* Shrink your database using DB2 9 row compression
http://www-128.ibm.com/developerworks/edu/dm-dw-dm-0611read-i.html?S_ TACT=105AGX11&S_CMP=FP

* Exploit XML indexes for XML query performance in DB2 9
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0611nicola/

* Leverage your Oracle 10g skills to learn DB2 9 for Linux, UNIX, and
Windows
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0401gupta/

**************************

SUBSCRIBE TO DB2 MAGAZINE
If you like what you read in this newsletter, you'll love DB2 Magazine. It's free. It's filled with expert advice.
Don't miss a single issue issue. Sign up today! http://www.db2mag.com/subscribe/

Get your own copy of this DB2 Email delivered directly to your inbox each month.
http://www.db2mag.com/newsletter/