DB2 Magazine E-Newsletter

May 19, 2005

DB2 Magazine Email Newsletter
Volume 6, Issue 5
www.db2mag.com

*****************************
This message has been sent to you as a valued subscriber of DB2 Magazine by the editors. List removal and subscription information appears at the bottom of this message.
*****************************
IN THIS ISSUE:

1. Now Online: DB2 Magazine Quarter 2
* Autonomic computing: It's here, it's real, and it's about to
change the way you work
2. Asked and Answered
* The mysteries of row-level and table-level locking 3. DB2 Magazine Trivia Contest
* Do you know how badly will employers want to hire DBAs? Your
correct answer earns you a chance at $100 4. Skills and Certification News
* Free certification, conference discounts, and new IBM courses 5. At the Bookstore
* Rexx Programmers Reference
6. Now Playing at the developerWorks DB2 Zone
* The latest technical articles from developerWorks experts

****SPONSOR: DB2 Magazine****

Renew your subscription to DB2 Magazine today and be entered into a drawing for an Apple iPod. It costs nothing but a few minutes of your time.

http://www.db2mag.com/q1sub/
*****************************

1. NOW ONLINE: DB2 MAGAZINE QUARTER 2 ISSUE

* More work, not enough staff. That's a common complaint in the IT industry these days. Even if your company is hiring, candidates with just the right skills aren't always easy to find (a situation that will intensify once experienced baby boomers start retiring). That's why IBM is working to enable DB2 and other software to sense trouble and respond without human intervention. But how real is this "autonomic" computing? And, how will it affect your job? Read the feature articles in the latest DB2 Magazine to find out.

--In "The New DBA: Conquering a World of Opportunity," former Meta Group analyst Charles Garry explains how DBA shortages, increasing data volumes, and cost-cutting pressures are driving the development of autonomic RDBMSs -- and how DBAs can reshape their roles to their advantage.
http://www.db2mag.com/story/showArticle.jhtml?articleID=161601927

--One of DB2's most advanced autonomic features, the DB2 Design Advisor analyzes performance options and makes recommendations faster than any human. As Merrill Lynchs Howard Goldberg explains, though, the final decisions are all up to you.
http://www.db2mag.com/story/showArticle.jhtml?articleID=161601934

--Performance guru Scott Hayes explains how a simple methodology ensures accurate input to the autonomic DB2 Design Advisor for optimum performance results.
http://www.db2mag.com/story/showArticle.jhtml;?articleID=161601940

--Other features in this issue include a look at the newest release of
DB2 UDB, which is optimized for SAP and contains improvements for everyone, plus an analysis of features introduced in DB2 UDB v.8.1 to help DBAs move tables faster.
http://www.db2mag.com/

2. ASKED AND ANSWERED

* How (or when) does DB2 decide to change from row-level to table-level locking, and how can I avoid deadlocks in my environment without increasing application run time?
--Find out what Distributed DBA columnist Roger E. Sanders recommends.
http://www.db2mag.com/story/showArticle.jhtml?articleID=162100158

3. DB2 MAGAZINE TRIVIA CONTEST

The U.S. Bureau of Labor Statistics predicts that demand for DBAs will increase by what percent by the end of the decade? Answer correctly for a chance to win a $100 American Express Gift Cheque.(Congratulations to T. Wegienek of Grosse Point, Mich., winner of four IBM Press books in the most recent drawing.) --Answer the trivia question.
http://www.db2magazine.com/
--Read "The New DBA: Conquering a World of Opportunity" to find the
correct answer.
http://www.db2mag.com/story/showArticle.jhtml?articleID=161601927

4. SKILLS AND CERTIFICATION NEWS
* Get the latest news on certification offers, conference discounts, and new courses from IBM, plus the latest certification column by Howard Fosdick, User Views columns from IDUG and IIUG reps, and more.
http://www.db2mag.com/education

5. AT THE BOOKSTORE

* Rexx Programmer's Reference
by Howard Fosdick

DB2 Magazine columnist and DBA consultant Howard Fosdick adds another line to his resume with the recent publication of Rexx Programmer's Reference (Wrox, 2005), the first book to cover the modern Rexx language. Fosdick's book covers:
* Rexx interpreters for specialized functions (such as
object-oriented, mainframe, and handheld applications)
* Scripting for GUIs, databases, Web servers, XML, and other
interfaces
* Rexx tools and interfaces, with examples for both Linux and
Windows.
http://www.db2mag.com/bookstore/

6. NOW PLAYING AT THE DEVELOPERWORKS DB2 ZONE

* Q replication to Oracle and Sybase
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0505burner/index.html

* Tutorial: Fast track to federated replication http://www-128.ibm.com/developerworks/edu/dm-dw-dm-0505anderson-i.html

* Introduction to the DB2 UDB SQL administrative routines http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0505melnyk/index.html

* DB2 UDB versus Oracle data movement: A comparative guide
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0505tham/index.html

* Which distributed edition of DB2 V8 is right for you?
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0505tham/index.html

* Comparing the distributed DB2 UDB servers
http://www-128.ibm.com/developerworks/db2/library/techarticle/0301zikopoulos/0301zikopoulos1.html

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

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/