DB2 Magazine E-Newsletter

November 25, 2002

DB2 MAGAZINE EMAIL NEWSLETTER
VOLUME 3, ISSUE 11
http://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. The Automated Future: "Techno bigots" need not apply
2. Asked and Answered: DB2 and Linux
3. IBM News
  * IBM acquires Tarian Software
  * IBM/Crystal Decisions Webinar
4. Skills and Certification
  * Free Content Manager Study Guide
  * New V.8 Certification Guides
  * DB2 UDB for Oracle Administrators Class
5. Now Playing at the DB2 Developer Domain
6. At the Bookstore: Impossible Data Warehouse Situations

**********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/

*****SUBSCRIBE TO DB2 MAGAZINE MONTHLY NEWSLETTER*****
Are you relying on your colleagues to share this valuable DB2 newsletter with you? You can have your own copy delivered directly to your inbox each month. It's free, and signing up is easy. Try it today!
http://www.db2mag.com/newsletter/ ******************************

1. THE AUTOMATED FUTURE
IBM wants automation and self-management in DB2 to take some of the performance burden off DBAs. But if performance and tuning is no longer the heart of the DBA's role, what will be? DB2 Magazine asked several industry experts to voice their opinion about whether DBAs will be needed at all and, if so, for what. The article " Where Do You Want to Go Next? " summarizes the experts' views. Now you can read the full interview with consultant and DBA Howard Fosdick, in which he dishes on how multimedia and XML projects will impact DBAs and why "techno bigots" will be left behind http://www.db2mag.com/db_area/archives/2002/q4/fosdick.shtml

2. ASKED AND ANSWERED
I have some questions about DB2 and Linux:

1. What Linux kernel parameters need to be tuned for DB2 on Red Hat Linux Professional 7.2, 7.3/Advanced Server 2.1?

2. What files compile DB2 stored procedures on Linux? When I compile a stored procedure, DB2 generates a package, Pnnnnnnn, but I don't want a system-generated package name. I want to name the package myself.

IBM Canada's Paul Zikopoulos sets readers straight at http://www.db2mag.com/qanda/021120.shtml

3. IBM NEWS
IBM Acquires Tarian Software
IBM acquired all assets of Canadian records management provider Tarian Software. The acquisition is expected to close in the fourth quarter, 2002. IBM says the Tarian acquisition will let Big Blue address customers' need to digitize, integrate, and manage information. Records management software enables organizations to apply record retention and disposal policies to electronically stored information. The software integrates with a company's existing technology infrastructure, enabling them to apply rules by which organizations can comply with record retention policies and meet regulatory requirements. Tarian operations and staff will be integrated in the IBM's Data Management Software Group. For details, go to http://www-3.ibm.com/software/data/news/

Webinar: IBM DB2 Relational Connect & Crystal Reports
Many companies struggle to develop meaningful reports. Often, data is stored in separate silos throughout the organization and existing reporting tools are either unable to amalgamate data from these multiple sources or are slow and cumbersome. IBM and Crystal Decisions have teamed up to help solve this problem. Find out how on Dec. 3, 2002 at 9:00 a.m. PST, when Richard Hedges, program director of IBM Information Integration Products, and Trevor Smith, group program manager for business development at Crystal Decisions present "High speed reporting across multiple data sources with Crystal Reports and IBM DB2 Relational Connect." For information or to register, go to http://www.crystaldecisions.com/about/events/seminars/schedule.asp?sid=235&ls=OnlineLive

4. SKILLS AND CERTIFICATION
Free Content Manager Multiplatform Study Guide
A free self-study certification guide for exam 442, IBM Content Manager Version 8 is now available for download from the IBM site. The guide covers installation, configuration, and management of the Content Manager system. http://www-1.ibm.com/certify/tests/edu442.shtml

New DB2 V.8 Exams
Three new DB2 UDB v.8 exams will be available starting December 16, 2002: DB2 UDB v.8.1 Family Fundamentals (Exam 700), DB2 UDB v.8.1 for Linux, Unix, and Windows Database Administration (Exam 701), and DB2 UDB v.8.1 Family Application Development (Exam 703). For details on these and other DB2 UDB exams, go to http://www-1.ibm.com/certify/tests/edu442.shtml

DB2 UDB for Oracle System Administrators Class
Oracle administrators have an edge in becoming DB2 UDB system administrators. And now IBM is offering a class tailored specifically for experienced Oracle administrators who want to understand DB2 UDB. For more information about the DB2 UDB for Oracle administrators class, which will be held December 17th in Vienna, VA, go to http://www-3.ibm.com/software/data/education/sysadmin.html

5. NOW PLAYING AT THE DB2 DEVELOPER DOMAIN
Tutorial: Efficient ways to publish your DB2 data as XML
https://www6.software.ibm.com/reg/devworks/dw-db2sqlx-i?S_TACT=102B7W84&S_CMP=DB2DD

Tutorial: Optimal DB2 Performance with SQLJ and JDBC
https://www6.software.ibm.com/reg/devworks/dw-db2sqlj-i?S_TACT=102B7W81&S_CMP=DB2DD

Tutorial: Using SQL Assist to Generate SQL Queries in DB2
http://www7b.software.ibm.com/dmdd/library/tutorials/0211jarzebowicz/

Yet Another Article on Advanced Scripting
http://www7b.software.ibm.com/dmdd/library/techarticle/0211yip/0211yip4.html

Creating SQL Queries the Easy Way with SQL Assist for DB2 UDB v.8.1
http://www7b.software.ibm.com/dmdd/library/techarticle/0211jarzebowicz/0211jarzebowicz.html

Writing a Web-based Table Editor GUI for DB2
http://www7b.software.ibm.com/dmdd/library/techarticle/0211bhopuli/0211bhopuli.html

DB2 Basics: Fun With Dates and Times
http://www7b.software.ibm.com/dmdd/library/techarticle/0211yip/0211yip3.html

6. AT THE BOOKSTORE
Impossible Data Warehouse Situations: Solutions from the Experts, by Sid Adelman, et al.
Building and maintaining a data warehouse is fraught with managerial and technical pitfalls. Impossible Data Warehouse Situations introduces possible solutions to 91 common crises that confront companies of all types, sizes, and structures. Nine leading data warehousing experts provide detailed guidance for corporate executives, IT managers and staff, and users. The book serves as a quick reference for resolving specific data warehouse problems and as a practical introduction to the realities of data warehousing not covered in basic texts. Find out more at http://www.db2mag.com/bookstore/