DB2 Magazine E-Newsletter

March 19, 2003

DB2 Magazine Email Newsletter
Volume 4, Issue 3
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. IBM News:
* Content Manager v.8.2 delivers information on demand
* AIIM 2003 features Janet Perna keynote
* DB2 UDB .Net-enablement beta program begins
* DB2 cost of ownership study
2. Asked and Answered: Optimizing memory for DB2 on Windows 2000 Server
3. Trivia Contest: Find the answer in DB2 Magazine, win $100
4. Skills and Certification News
5. At the Bookstore: Designing Data-Intensive Web Applications
6. Now Playing at the DB2 Developer Domain
7. Events To Note

1. IBM NEWS
IBM Announces DB2 Content Manager V.8.2 and DB2 Records Manager V.2.1
Upgrades to IBM's DB2 Content Manager and DB2 Records Manager products announced this week include several ease-of-use and integration enhancements. Both are newly branded as DB2 products, reflecting the role the DBMS plays under the covers. DB2 Content Manager v.8.2 includes enhanced integration with Siebel and PeopleSoft and new replication support for managing objects in multiple locations. DB2 Records Manager v.2.1 features a new physical records central console, an improved Records Administrative Client, context sensitive help, and DB2 UDB support.
http://www-3.ibm.com/software/data/cm/v8.html

Janet Perna to Address Information on Demand at AIIM 2003
IBM general manager for Data Management Solutions Janet Perna will give a keynote address at the AIIM 2003 conference in New York City on April 8. Her talk will cover how content management technology can help organizations manage and integrate all forms of information, including scanned images, audio, and video, and link it to core business processes.
http://www.aiim2003.com/

DB2 UDB .Net-Enablement Beta Program Begins
Any programmers interested in developing applications that use the Microsoft .NET Framework to access DB2 UDB can participate in the DB2 UDB .Net-enablement beta program. A newsgroup facilitates interaction among beta participants and the DB2 development team, and a "Check for Updates" facility provides a home for any new information or beta code updates.
http://www7b.software.ibm.com/dmdd/downloads/dotnetbeta/

DB2 UDB Aces Cost of Ownership Study
A recent study from Market Magic Research Ltd. (MMR) found that DB2 provides a better cost of ownership than competitive products from Oracle and Microsoft. The study focuses on three application scenarios: an off-the-shelf application (such as SAP or PeopleSoft), a custom built Web-deployed application, and a business intelligence or data warehouse implementation. In all three scenarios, DB2 provided the lowest cost over a five-year period.
http://www-3.ibm.com/software/data/highlights/mmr-db-cco.pdf

2. ASKED AND ANSWERED
Is there any reason to change the default memory optimization setting on Windows 2000 Server from "Maximize data throughput for file sharing" to "Maximize data throughput for network operations" when you have already instructed DB2 to avoid file caching by setting the DB2 registry variable DB2NTNOCACHE to ON? DB2 consultant Chris Fierros explains.
http://www.db2mag.com/qanda/030318.shtml

3. DB2 MAGAZINE TRIVIA CONTEST
Do you know which technology breakthrough author Craig Mullins credits with fixing "the biggest performance problem DB2 ever faced?" Try your luck in the DB2 Trivia contest at DB2mag.com.
http://www.db2mag.com/

Need a quick refresher? Read the article "Eight Breakthroughs that Changed DB2 Forever"
http://www.db2mag.com/db_area/archives/2003/q1/mullins.shtml

This month's trivia contest is sponsored by Quest Software.
http://www.quest.com/

4. SKILLS AND CERTIFICATION NEWS
Upgrading Your DB2 UDB Certification to V.8.1
DBAs who are IBM Certified Solutions Experts on DB2 UDB v.7.1 for Linux, Unix, or Windows can take the short new DB2 UDB v.8.1 upgrade exam. And, IBM is currently offering a voucher for 50 percent off the registration fee for the test, DB2 UDB v.8.1 for Linux, Unix, and Windows Database Administration Upgrade Exam (#706).

Certification Links:
Test and voucher details
http://www-3.ibm.com/software/data/db2/skills/voucher.html

V.8.1 study guide
http://www.db2mag.com/bookstore/feature200302.shtml

Certification advice from columnist Howard Fosdick
http://www.db2mag.com/education/

New Certification Tutorials
Six new tutorials are available to help users prepare for the DB2 Family Fundamentals Certification Exam (700)
http://www7b.software.ibm.com/dmdd/library/tutorials/db2cert/db2cert_V8_tut.html

New Education Center for IBM Software
IBM and its business partners developed the new Education Center for IBM Software (ECIS) program, a cross-brand education channel that provides rapid employee training.
http://www-3.ibm.com/software/data/education/ecis.html

5. AT THE BOOKSTORE
Designing Data-Intensive Web Applications
by Stefano Ceri, Piero Fraternali, Aldo Bongio, Marco Brambilla, Sara Comai, Maristella Matera

Scores of database management systems across the Internet access and maintain large amounts of structured data for e-commerce, online trading, banking, digital libraries, and other high-volume sites. Developing and maintaining these data-intensive applications is an especially complex, multidisciplinary activity, requiring all the tools and techniques that software engineering can provide. These internationally known database researchers present a methodology that exploits the conceptual modeling approach to software engineering. The book includes the methodology and a development process and notation optimized for high-volume Web applications.
http://www.db2mag.com/bookstore/

6. NOW PLAYING AT THE DB2 DEVELOPER DOMAIN
Porting to DB2 UDB V.8 from Microsoft SQL Server 2000
http://www7b.software.ibm.com/dmdd/library/techarticle/0303rada/0303rada.html

Tuning DB2 UDB Using the Statement Event Monitor
http://www7b.software.ibm.com/dmdd/library/techarticle/0303kolluru/0303kolluru.html

How to Call DB2 Stored Procedures in Visual Basic 6.0 Applications
http://www7b.software.ibm.com/dmdd/library/techarticle/0303packowski/0303packowski.html

A Primer on Moving Data In and Out of DB2 Tables Defined with Generated Columns
http://www7b.software.ibm.com/dmdd/library/techarticle/0303zikopoulos/0303zikopoulos.html

Implementing Inter-session Alerts in DB2 UDB
http://www7b.software.ibm.com/dmdd/library/techarticle/0303mukherjee/0303mukherjee.html

Essential Facts about Index Covering in DB2 UDB
http://www7b.software.ibm.com/dmdd/library/techarticle/0303kuznetsov/0303kuznetsov.html

Building Web Services with C# and DB2 UDB
http://www7b.software.ibm.com/dmdd/library/tutorials/0303freeze/

7. EVENTS TO NOTE
Webinar: High speed reporting across multiple data sources with Crystal Reports and IBM DB2 Relational Connect, March 27, 9:00 a.m. PST/12:00 EST
http://www.crystaldecisions.com/seminars/schedule.asp?sid=235&ls=OnlineLive

IBM developerWorks Live!, New Orleans, April 9-12
Conference package includes one complimentary IBM Professional Certification exam
http://www-3.ibm.com/events/ibmdeveloperworkslive/index.html?S_TACT=nltr31db2

IBM Software Symposium 2003, Munich, Germany, May 19-23
http://www-3.ibm.com/events/symposium2003/index.html

IDUG 2003 North America, Las Vegas, May 19-23
Features free IBM Data Management professional certification testing
http://www.idug.org/ or http://conferences.idug.org/namericavegas/certification.cfm

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/