Date: Wed, 13 Mar 2002 15:18:34 -0800 From: "DB2 Today" Subject: Welcome to Version XXV of DB2 Today ****************************************************************** ********* DB2 Today Issue XXV - March 2002 ************ ****************************************************************** Dear IBM, The big news of the month is IBM's Announcement of a "Clean Sweep" of the industry standard decision support benchmarks. IBM's DB2 software boasts the number one performance in all of the published Transaction Processing Performance Council's TPC-H (tm)benchmark scale factors: 100GB, 300GB, 1000GB, and 3000GB (TPC-H is trademark of the Transaction Processing Performance Council). Read on below for more details. We are interested in your FEEDBACK. Please send your comments to: db2today@us.ibm.com >>> Create your own version of this newsletter If you are only interested in some of the topics of this newsletter, you have the option to customize DB2 Today Newsletter. Simply go to the URL below and select the topics you would like to hear more about: http://www6.software.ibm.com/reg/newsletter/db2todayn-i To UNSUBSCRIBE from IBM's DB2 Today newsletter, click REPLY to this e-mail & change the subject line to "Cancel". Your name will be removed from future mailings. Thank you. HAPPY 25TH Issue This is the 25th issue of DB2 Today newsletter. The first issue of DB2 Today came out in May of 1999. Currently there are over 70,000 subscribers to DB2 Today. To see past newsletters, go to http://www-3.ibm.com/software/data/db2today/ ****************************************************************** ************ TABLE OF CONTENTS ********** ****************************************************************** ================================================================== GENERAL ================================================================== ************** Offers ******************************************** <1> IBM DB2 Universal Database Version7.2--Newest Version Now Available for Free Download <2> No cost copy of IBM's Linux Software Evaluation Kit <3> Web Services Tutorial Now Available <4> IBM DB2 Universal Database Itanium 64-bit Developer's Kit ************ News ************************************************ <5> IBM's Announces "Clean Sweep" of Decision Support Benchmarks <6> Database Technology Leadership Examined in New Issue of DB2 Magazine <7> Installing DB2 Products Across your Enterprise <8> A Scalability Study for WebSphere Application Server and DB2 Universal Database <9> WebSphere and DB2 Clustering and Scalability Study: Installation and Configuration Guide <10> Creating a Database Application Using WebSphere Studio Application Developer <11> InfiniBand Opens the Throttle. By Boris Bialek, DB2 Magazine <12> Partitioning in DB2 Using the UNION ALL View <13> Developing Java Applications Using DB2 Extenders (Part 2) <14> Choosing an Administration Model for Content Manager OnDemand <15> Understand the Not-So-Silent Strengths of IBM DB2 Universal Database <16> Knowledge is Power -- IBM Scholars Program <17> Meet the Experts: John Campbell on Java Performance for DB2 Applications <18> Meet the Experts: Terry Purcell on Outer Joins (Part 2) <19> Meet the Experts: Shawn Bay, IBM Gold Consultant <20> To read more about the newest in technology innovation with ************** Conferences *************************************** <21> IBM Data Management Technical Conference <22> IMS Technical Conference <23> IDUG 2002--Technical Symposium Dates Announced <24> International DB2 User's Group Conference and Membership Information ================================================================== DB2 PRODUCT FAMILY ================================================================== ************ DB2 UDB for Linux *********************************** <25> IBM DB2 Linux for Intel-Based Machines Only Offering Now Available Via Passport Advantage *********** Data Management Tools ******************************** <26> Fifteen IBM Data Management Tools announced March 5, 2002 ================================================================== SOLUTIONS ================================================================== ********** Business Intelligence ********************************* <27> Metro Nashville maps its future with DB2 spatial data warehouse <28> IBM Red Brick Warehouse ********** e-business ******************************************** <29> Caroline Kovac , General Manager, IBM Life Sciences Solutions <30> Vitea starts small, grows big with IBM DB2 Universal Database *********** Content Manager ************************************** <31> IBM Content Management Technical Conference <32> ABN AMRO whips the paper trail with electronic data management <33> CSS Versicherung claims better service and cost savings with IBM Content Manager and DB2. ================================================================== SKILL AND EDUCATION ================================================================== ************* DB2 CERTIFICATION ********************************** <34> DB2 CERTIFICATION ELECTRONIC VOUCHER PROGRAM AVAILABLE IN 2002 ************** CLASSES (DB2 & Informix) ************************** <35> Need a course on DB2? <36> IM340: IBM Content Manager Implementation and Administration <37> Ready to implement Data Sharing or looking for advanced Skills with DB2 UDB OS/390 Data Sharing? <38> To develop hands-on skills with a Federated Database Environment: <39> Looking for hands-on skills with DB2 XML Extender? <40> Develop your OLAP skills with our expanded curriculum: <41> DW230: Managing Geographic Data with DB2 Spatial Extender ================================================================== GENERAL ================================================================== ************** Offers ******************************************** <1> IBM DB2 Universal Database Version7.2--Newest Version Now Available for Free Download IBM is committed to bringing you the latest in technology innovation. DB2 v7.2 is the first multi-platform, multimedia, Web-ready relational database management system delivering enhanced Business Intelligence Solutions along with a new DB2 Connect Web Starter Kit. Download a trial versions of DB2 v 7.2 at ibm.com/cgi-bin/software/track3.cgi?file=/software/data/db2/udb/downloads.html&S_TACT=__S_TACT__&S_CMP=__S_CMP__ To read more about the newest in technology innovation with DB2 UDB 7.2 go to: http://ibm.com/software/data/db2/udb/pdfs/db2v72whatsnew.pdf <2> No cost copy of IBM's Linux Software Evaluation Kit IBM is committed to supporting the open source community and the Linux operating system, so we have created the IBM Software Evaluation Kit for Linux. This kit contains our industry leading middleware for Linux including IBM DB2 Universal Database, Enterprise Edition, WebSphere Application Server, Lotus Domino and award-winning, proven development tools for Windows such as Visual Age for Java. Order your no cost copy of the IBM Software Evaluation Kit for Linux: http://ibm1.rjs0.net/servlet/cc?pItDUVUEqpsLOpgFNlDpItDJhtE0EAESE181300 <3> Web Services Tutorial Now Available IBM is committed to bringing you the latest in technology innovation. Now IBM offers you a step-by-step guide demonstrating DB2 v 7.2 as a Web services provider. Web services are based on emerging technologies including: SOAP, WSDL, and UDDI. SOAP Simple Object Access Protocol). The IBM Video Central tutorial is a complete working application. Download at http://ibm.com/software/data/developer/samples/video/ <4> IBM DB2 Universal Database Itanium 64-bit Developer's Kit IBM's is committed to bringing you the latest in technology innovation. Now IBM DB2 Developer's Kit on Intel Itanium for Windows and Linux are available. This Kit allows you to develop and test 64-bit applications using DB2 on Itanium-based servers running 64-bit versions of Linux and Windows. Download at http://ibm.com/software/data/db2/itanium/ ************ News ************************************************ <5> IBM's Announces "Clean Sweep" of Decision Support Benchmarks IBM recently announced that its DB2 database software has set three new world-records for business intelligence performance, based on the industry standard TPC-H(tm) benchmark. With these new results DB2 boasts a "clean sweep" of the number one performance in all of the published TPC-H(tm)benchmark scale factors: 100GB, 300GB, 1000GB, and 3000GB. (TPC-H is trademark of the Transaction Processing Performance Council) For more information go to: http://www-3.ibm.com/software/data/highlights/db2leads.html To read the Press Release go to: http://www-3.ibm.com/software/swnews/swnews.nsf/dae45dddc62e830f002568e3004ff070/7f87b8351aacb29a87256b680079f751?OpenDocument <6> Database Technology Leadership Examined in New Issue of DB2 Magazine The Quarter 1, 2002 Issue of DB2 Magazine began distribution and is also available on-line. This issue focuses on DATABASE TECHNOLOGY LEADERSHIP with a look at some of the technology trends such as clustering, federated databases and the Infiniband's impact on database performance. http://www.db2mag.com/ <7> Installing DB2 Products Across your Enterprise This article helps you install DB2 products across an enterprise solution. You'll learn the pros and cons of using interactive, response file, Citrix, and code server installations. http://www7b.boulder.ibm.com/dmdd/library/techarticle/0202zikopoulos/0202zikopoulos.html <8> A Scalability Study for WebSphere Application Server and DB2 Universal Database This benchmarking effort provides compelling evidence that IBM's WebSphere and DB2 provide the scalability and integration required to deliver predictable scalability for demanding e-business workloads. Configuration recommendations are included. http://www7b.boulder.ibm.com/dmdd/library/techarticle/0202an/0202an.pdf <9> WebSphere and DB2 Clustering and Scalability Study: Installation and Configuration Guide This paper demonstrates the basic concepts and steps to set up an enterprise-strength e-business site using the WebSphere Performance Benchmark Sample (the Trade2 application) with DB2 EE and a cluster of WebSphere nodes (WebSphere Advanced Server 3.5.4) on Windows 2000. Alternative configurations are explored. http://www7b.boulder.ibm.com/dmdd/library/techarticle/0202an/0202an2.pdf <10> Creating a Database Application Using WebSphere Studio Application Developer This WebSphere Tech Journal article shows you how to generate Web pages that access and display data stored in a DB2 database. http://www7b.boulder.ibm.com/wsdd/techjournal/0201_kirkham/kirkham.html <11> InfiniBand Opens the Throttle. By Boris Bialek, DB2 Magazine At first glance, InfiniBand appears to be just another interconnect between servers and storage. But its new upper-layer software interfaces combined with new technologies in applications (such as DB2 with SAP or PeopleSoft) make InfiniBand much more than simply a new networking protocol. It changes the way information is exchanged in applications and removes unnecessary overhead from the system. http://www.db2mag.com/db_area/archives/2002/q1/bialek.shtml <12> Partitioning in DB2 Using the UNION ALL View You don't have a partitioned database, but your table just doesn't stop growing? Check out this creative solution that enables you store data in separate tables but query it as a single relation. http://www7b.software.ibm.com/dmdd/library/techarticle/0202zuzarte/0202zuzarte.pd <13> Developing Java Applications Using DB2 Extenders (Part 2) Part 2 of an "how to" article on developing Java applications that use the DB2 Image and Audio Extenders, illustrated by a sample application. http://www7b.software.ibm.com/dmdd/library/techarticle/0202cox/0202cox.html <14> Choosing an Administration Model for Content Manager OnDemand Content Manager OnDemand manages large quantities of printed output. This article offers recommendations on choosing a systems management model. http://www7b.software.ibm.com/dmdd/library/techarticle/0202wagner/0202wagner.ht <15> Understand the Not-So-Silent Strengths of IBM DB2 Universal Database IBM is committed to bringing you the latest in technology innovation. Find out for yourself why IBM DB2 UDB 7.2 is ideal for your business. With the new white paper "Not-So-Silent Strengths" of DB2 you will learn about DB2 power on UNIX, Windows and OS/2 and it's growing strength on platforms like eServer iSeries and zSeries. Download at http://ibm.com/software/data/pubs/papers/db2strengths/db2strengths.pdf <16> Knowledge is Power -- IBM Scholars Program Looking for an easy way to provide your database students with the best educational environment and access to the latest software in the industry? Look to the IBM Data Management Scholars Program, which provides higher education institutions with access to IBM data management software for academic use in teaching and research. Register today and let the DM Scholars team help you help your students succeed in the fast-growing information technology market. For more information and to register, visit http://www-3.ibm.com/software/info/university/scholarsprogram/ http://www.ibm.com/software/data/highered <17> Meet the Experts: John Campbell on Java Performance for DB2 Applications Don't miss these tips from John Campbell, DB2 for z/OS Java performance expert, about getting the best performance from your Java applications. http://www7b.software.ibm.com/dmdd/library/techarticle/0202campbell/0202campbell.html <18> Meet the Experts: Terry Purcell on Outer Joins (Part 2) Terry Purcell, an IBM Gold Consultant with Yevich, Lawson, and Associates, and the winner of the Best Overall Speaker Award at the 2001 IDUG Asia Pacific conference in Canberra, Australia, offers more advice on coding predicates in outer joins. http://www7b.boulder.ibm.com/dmdd/library/techarticle/purcell/0201purcell.html <19> Meet the Experts: Shawn Bay, IBM Gold Consultant IBM Gold Consultant Shawn Bay says that database optimizers don't get the attention they deserve. Read his views on the subject. http://www7b.boulder.ibm.com/dmdd/library/techarticle/0202bay/0202bay.html <20> To read more about the newest in technology innovation with DB2 UDB 7.2 go to: http://www-3.ibm.com/software/data/db2/udb/pdfs/db2v72whatsnew.pdf ************** Conferences *************************************** <21> IBM Data Management Technical Conference (includes DB2 and Business Intelligence Conference and Informix User Conference) September 9-13, 2002 Anaheim, California http://www-3.ibm.com/services/learning/conf/us/?c=IBM_DB2Today&n=various&t=aff <22> IMS Technical Conference September 30 - October 3, 2002 St. Louis, Missouri http://www.ibm.com/services/learning/conf/us/?c=IBM_DB2Today&n=various&t=aff <23> IDUG 2002--Technical Symposium Dates Announced Mark your calendars for IDUG 2002--Technical Symposium, September 19-20,2002 in Toronto, Canada. Visit www.idug.org often for updated details on this and all educational events and informational resources provided by the International DB2 Users Group. IDUG 2002--North America 12-16 May 2002 San Diego, CA, USA IDUG 2002--Europe 21-24 October 2001 Lisbon, Portugal IDUG 2002--Technical Symposium 19 - 20 September 2002 Toronto, ON, Canada IDUG 2002--Asia Pacific Dates and Location to be Announced http://www.idug.org <24> International DB2 User's Group Conference and Membership Information Enroll now in an IDUG Conference and receive one free year's membership in IDUG. IDUG Membership benefits include direct access to the largest, most innovative group of DB2 Product Family users in the world. You also receive complete access to the variety of benefits here on the IDUG web site, including discussion forums and solutions journal articles, a one-year subscription to the IDUG Solutions Journal, a quarterly publication featuring technical information on the DB2 product family and a set of conference proceedings. For further information on IDUG, please visit http://www.idug.org ================================================================== DB2 PRODUCT FAMILY ================================================================== ************ DB2 UDB for Linux *********************************** <25> IBM DB2 Linux for Intel-Based Machines Only Offering Now Available Via Passport Advantage There has never been a better time to buy DB2 Universal Database (UDB) for Linux! DB2 UDB Workgroup Edition and Enterprise Edition for Intel-based machines is being offered at significantly reduced pricing through Passport Advantage. Ordering information for this product offering can be found here. http://www-3.ibm.com/software/data/db2/linux/passport.html *********** Data Management Tools ******************************** <26> Fifteen IBM Data Management Tools announced March 5, 2002 In the 4th major tools announcement in 18 months, IBM adds 15 new and enhanced database tools for DB2 for z/OS and IMS to its growing portfolio of more than 50 tools. Included in this announcement are DB2 Performance Expert and IMS HALDB Conversion Aid. IBM's database tools business reports 325% YTY growth for its popular tools. http://www.ibm.com/software/data/db2imstools/ ================================================================== SOLUTIONS ================================================================== ********** Business Intelligence ********************************* <27> Metro Nashville maps its future with DB2 spatial data warehouse "DB2 and DB2 Spatial Extender have enhanced our ability to show our planning commissioners how to best utilize our land resources without diminishing quality of life. At the same time, because so many of our departments are using our spatial data warehouse, this technology is also assisting us in the areas of health and safety, land-use regulations and much more, notes Jennifer Higgs, a planning manager with Metro Nashville. http://www2.software.ibm.com/casestudies/swcsdm.nsf/cs/navo-5733fx <28> IBM Red Brick Warehouse IBM Red Brick Warehouse is a database server designed to meet the specialized requirements for business-critical, high-demand data analysis. It provides a robust and scalable platform for developing star schema-based decision support applications, through the application of innovative technology. Designed to be practical, cost effective, and scalable, the IBM Red Brick Warehouse enables more users to analyze more data and make better decisions faster than with a general-purpose database. http://www-3.ibm.com/software/data/informix/redbrick/ ********** e-business ******************************************** <29> Caroline Kovac , General Manager, IBM Life Sciences Solutions Carol discusses the explosive growth ahead for life sciences and the roles of data gathering, computational challenges, and open standards in the current convergence of IT and biology. Read the full Frost & Sullivan "Movers and Shakers" interview on frost.com (hotlink http://www2.frost.com/prod/news.nsf/LuPages/HCDDT-ibm/) For more information on IBM Life Sciences Solutions visit http://ibm.com/solutions/lifesciences/ <30> Vitea starts small, grows big with IBM DB2 Universal Database "We evaluated Sun, Oracle and Microsoft. But in the end, IBM had the best price/performance, the best financing, the best solution altogether; and it was the only one that could offer an end-to-end solution, " says Vitea CEO and Co-founder Paul Kallenius http://www2.software.ibm.com/casestudies/swcsdm.nsf/cs/navo-56xuf6 *********** Content Manager ************************************** <31> IBM Content Management Technical Conference June 17 - 19, 2002 Sheraton San Diego, San Diego California Don't be the 'Weakest Link' in your company. The IBM Content Management Technical Conference is where you can get all the latest information and technical details on The IBM Content Manager Portfolio family of products. This event can help you make great strides in developing robust, cost-saving e-business solutions to manage reports, documents, HTML, XML, images, e-mail, audio and video across your enterprise. For more details and to enroll visit: http://www.ibm.com/services/learning/conf/us/content?c=IBM_DB2Today&n=various&t=aff <32> ABN AMRO whips the paper trail with electronic data management ABN AMRO is a global bank and financial services provider that traces its roots back to 1824. Headquartered in the Netherlands, its insurance division provides property, life and health insurance products for the domestic Dutch market. "Content Manager...has eliminated time-consuming research and follow-up calls.... This enabled us to achieve a 100 percent return on our investment in just 8 months", says Hans De Ru, Senior Information Consultant, Insurance Division, ABN AMRO Bank http://www2.software.ibm.com/casestudies/swcsdm.nsf/cs/navo-4gmqup <33> CSS Versicherung claims better service and cost savings with IBM Content Manager and DB2. "The integration of Content Manager into our claims processing system has significantly improved customer service and employee productivity while reducing operating costs", says Hanspeter Weber, project manager at CSS. http://www2.software.ibm.com/casestudies/swcsdm.nsf/cs/navo-4z6vxk ================================================================== SKILL AND EDUCATION ================================================================== ************* DB2 CERTIFICATION ********************************** <34> DB2 CERTIFICATION ELECTRONIC VOUCHER PROGRAM AVAILABLE IN 2002 The DB2 Certification Electronic Voucher Promotion for 2002 will be offered during the months of February, April, June, August, October and November. Candidates who score 75% or greater on a DB2 assessment exam will automatically be sent a voucher to take the real certification exam. You must qualify for a voucher during one of the 6 offering months and use the voucher as a fee for the exam before the expiry date that is listed with the voucher. http://www.ibm.com/software/data/db2/skills ************** CLASSES (DB2 & Informix) ************************** <35> Need a course on DB2? Learning Services offers a wide variety of courses on database management topics including: Application Programming, Database Administration, Database Design, Fundamentals and SQL, Querying and Reporting, Application Programming, Data Sharing, DB2 Transition, QMF Administration and Support, DB2 Connect and Performance. http://www.ibm.com/services/learning/spotlight/db2/all.html <36> IM340: IBM Content Manager Implementation and Administration In the US go to: http://www-3.ibm.com/servlet/com.ibm.ls.lsow.servlets.CourseDescriptionServlet?coursecode=IM340 Outside the US, go to: http://www.ibm.com/training and select your country of interest and search on IM34 <37> Ready to implement Data Sharing or looking for advanced Skills with DB2 UDB OS/390 Data Sharing? CF350: DB2 UDB for OS/390 Data Sharing Implementation Workshop CF320: DB2 for OS/390 Data Sharing Recovery and Restart CF340: DB2 UDB for OS/390 Data Sharing Performance and Tuning In the US go to: http://www-3.ibm.com/services/learning/spotlight/db2/all.html#DataSharingOS390 Outside the US, go to: http://www.ibm.com/training and select your country of interest and search on CF35 and CF32 <38> To develop hands-on skills with a Federated Database Environment: CF471: DB2 Federated Database: Integrating Diverse Data In the US go to: http://www-3.ibm.com/servlet/com.ibm.ls.lsow.servlets.CourseDescriptionServlet?coursecode=CF471 Outside the US, go to: http://www.ibm.com/training and select your country of interest and search on CF47 <39> Looking for hands-on skills with DB2 XML Extender? In the US go to: http://www-3.ibm.com/servlet/com.ibm.ls.lsow.servlets.CourseDescriptionServlet?coursecode=CG120 Outside the US, go to: http://www.ibm.com/training and select your country of interest and search on CG12 <40> Develop your OLAP skills with our expanded curriculum: In the US go to http://www-3.ibm.com/services/learning/spotlight/db2/db2olapserver.html <41> DW230: Managing Geographic Data with DB2 Spatial Extender In the US go to: http://www-3.ibm.com/servlet/com.ibm.ls.lsow.servlets.CourseDescriptionServlet?coursecode=DW230 Outside the US go to http://www.ibm.com/training and select your country of interest and search on DW23 ================================================================== HELPFUL WEBSITES ================================================================== To see back issues of DB2 Today, please visit: http://www.ibm.com/software/data/db2today/ IBM Data Management Home Page: http://www.ibm.com/software/data/ Events Calendar: http://www.ibm.com/software/data/events/ Case Studies: http://www.ibm.com/software/data/solutions IBM Faculty Portal: http://www.ibm.com/university/visit6 Business Partners Solutions: http://www.ibm.com/software/data/partners/solutions DB2 UDB for Windows: http://www.ibm.com/software/data/db2/udb/udb-nt/ IBM Data Management Tools: http://www.ibm.com/software/data/db2imstools DB2 Magazine (register for a free subscription): http://www.db2mag.com IBM Data Management Education: http://www.ibm.com/software/data/education.html IBM Informix Product Family: http://www.ibm.com/software/data/informix/ IBM Content Manager portfolio: http://www.ibm.com/software/data/cm/ IBM & Siebel for Customer Relationships: http://www.ibm-siebel.com/us/ DB2 with the PeopleSoft application: http://www.ibm.com/software/db2psoft DB2 with the SAP application: http://www.ibm.com/software/db2sap DB2 with the Baan application: http://www.ibm.com/software/db2baan Global Learning Services: http://www.ibm.com/services/learning DB2 Developer Domain: http://www.ibm.com/software/data/developer ================================================================== YOUR PRIVACY ================================================================== We know you're concerned about your privacy, and so is IBM. If you provide IBM with information about yourself, such as name, postal address, or other personal data, we may add it to our records. This data may be used to provide you with information from IBM or selected organizations worldwide about products, services, or activities that may be of interest to you. IBM is a global organization; therefore, we may transfer your personal information to countries in the world, which provide various levels of legal protection. Please realize that when you give us personal information, IBM will handle it according to its internal privacy practices which are designed to provide a high level of protection for your personal data worldwide. If you prefer that IBM no longer send you this newsletter by e-mail, you can UNSUBSCRIBE by simply choosing REPLY to this e-mail & change the subject line to "Cancel". Your name will be removed from future mailings. Thank you. We apologize for any inconvenience. IBM Software, Route 100, Building 1, Somers, NY 10589 ****************************************************************** ______________________________________________________________________ This email was delivered by Responsys on behalf of IBM. Click here to view IBM's privacy practices: http://www.ibm.com/privacy/