DB2 Magazine E-Newsletter

September 23, 2003

DB2 Magazine Email Newsletter
Volume 4, Issue 10
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. Asked and Answered: How much can the DDF handle?
2. IBM News: Free Web seminars
3. Trivia Contest: Another chance to win DB2 books
4. Skills and Certification News
5. At the Bookstore: Teach Yourself DB2 UDB in 21 Days
6. Now Playing at the DB2 Developer Domain

1. ASKED AND ANSWERED
We're starting a new branch project built on Unix and WebSphere Application Server with WebSphere Business Components Composer (WSBCC). The project will produce 3, 000,000 logs daily with 1,000 concurrent users, and the staff wants to put the logs on DB2 for OS/390. WSBCC uses JDBC and dynamic SQL. Is the DB2 Distributed Data Facility (DDF) designed for such a heavy process? What possible problems should we be aware of?

Find out what DB2 DBA columnist Robert Catterall thinks.
http://www.db2mag.com/qanda/030923.shtml

2. IBM NEWS
Free Web seminar: IBM Information Integrator: More than DataJoiner Learn how DB2 Information Integrator can open a wealth of e-commerce and business intelligence opportunities for organizations that need access to heterogeneous sources of data. Sponsored by the International DB2 Users Group, this free Web seminar features Ray Houle, senior consultant with The Fillmore Group, Inc. The Web cast is offered three times over September 25-26.
http://win11029.dn.net/displayavailablecourses.jsp

IBM Web Seminar:
"Records Management in a Complex Compliance-Driven Setting" Legislation such as the Sarbanes-Oxley Act and regulators such as the SEC and NASD demand that structured records management be applied to electronic business records. Record keeping is no longer optional, it's a critical component of any enterprise business software deployment. This Web seminar is an in-depth, advanced tutorial on compliance regulations and tackling e-records deployment within a compliance-driven setting. Panelists include:
* Bruce Miller, e-Records Strategy and Business Development Executive, IBM
* Robert F. Williams, President, Cohasset Associates, Inc.
* Jim Coulson, Principal, Records Improvement Institute LLC
http://webevents.broadcast.com/cmp/wcs/index.asp?event_id=7579

3. DB2 MAGAZINE TRIVIA CONTEST: YOUR CHANCE TO WIN FREE DB2 BOOKS
Play the DB2 Magazine Trivia Contest on DB2mag.com for another chance to win four free DB2 books from Prentice Hall: DB2 Universal Database v8 for Linux, Unix, and Windows Database Administration Certification Guide (5th edition); DB2 UDB v8 Handbook for Windows, Unix, and Linux; DB2 SQL Procedural Language for Linux, Unix, and Windows; and the just-published DB2 Universal Database v8 Application Development Certification Guide (2nd Edition). This month's contest is sponsored by BMC Software
http://www.bmc.com/

Enter the contest:
http://www.db2magazine.com/
Find out more about the Prentice Hall titles:
http://www.db2mag.com/trivia.shtml

4. SKILLS AND CERTIFICATION NEWS
Free Testing at the Data Management Technical Conference IBM is offering complimentary IBM DB2 UDB professional certification testing at the Data Management Technical Conference October 27-31, 2003 in Las Vegas. Candidates for all five certification tests, including the new Advanced Database Administrator certification role, are eligible for the free exam. Also free at the conference is the new Problem Determination Exam, which tests the skills needed to master problem determination and resolution.
http://www-3.ibm.com/services/learning/conf/us/dm/certification.html

Save $250 Off a Classroom IBM Course
For a limited time, you can qualify for $250 off any IBM IT Education Services (US) public course offering by registering for the Data Management Technical Conference. The $250 off coupons will be distributed at the conference and can be used by anyone in your company. See details in the offers area of the IBM Information Management Training and Certification Web site.
http://www-3.ibm.com/services/learning/us/landing/conf_promo.html

New DB2 Information Management Training and Certification Web Site
Keep track of all the new training and certification offers and promotions happening this fall at the completely revamped Training and Certification Web site.
http://www-3.ibm.com/software/data/education/

5. AT THE BOOKSTORE
Teach Yourself DB2 Universal Database in 21 Days
by Susan Visser and Bill Wong
A practical, hands-on approach to learning to use DB2 UDB, Teach Yourself DB2 Universal Database in 21 Days provides scenarios and step-by-step examples to help readers build skills easily. The book focuses on the most commonly used tasks and is designed for anyone learning about databases for the first time or changing careers from another database product or platform. The book, which includes a trial-version of DB2 UDB v.8.1, walks readers through the steps to create a library database to store information about a CD collection, including:
* Installing, configuring, and setting up DB2
* Designing a database, including normalizing data and choosing a primary key
* Using wizards to create the database, tables, and relationships between the tables
* Adding data to the tables using SQL or by loading or importing from other sources
* Accessing data using SQL, Java, or other applications
* Setting up security
* Automating and scheduling tasks
* Backing up and restoring
* Tuning performance parameters
* Solving problems.

The book is available from major online retailers and from the DB2Mag.com and IBM bookstores. http://www.db2mag.com/bookstore/
http://www7b.boulder.ibm.com/dmdd/library/books/learndb2/index.html

6. NOW PLAYING AT THE DB2 DEVELOPER DOMAIN
IBM DB2 Intelligent Miner Tutorials
http://www7b.software.ibm.com/dmdd/library/tutorials/iminer/iminer.html

User-defined Aggregate Functions in DB2 UDB
http://www7b.software.ibm.com/dmdd/library/techarticle/0309stolze/0309stolze.html

DB2 Data Bound ASP .NET Form using VS.NET
http://news.db2mag.com/cgi-bin4/DM/y/ec1g0FKfDh0FLd0B8pP0Av

Converting Oracle Pro*C Programs to DB2 UDB
http://www7b.software.ibm.com/dmdd/library/techarticle/0309greenstein/0309greenstein.html

Moving from the BDE and dbExpress to ADO.NET and the Borland Data Provider
http://www7b.software.ibm.com/dmdd/library/techarticle/0309mcgee/0309mcgee.html

Performance Considerations for the Information Mining Service of IBM DB2 Information Integrator for Content
http://www7b.software.ibm.com/dmdd/library/techarticle/0309baeurle/0309baeurle.html

Sample Programs for Adding and Deleting Annotations in DB2 Content Manager
http://www7b.software.ibm.com/dmdd/zones/db2cm/samples/0309zhang/0309zhang.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/