Date: Tue, 18 Dec 2001 11:56:16 -0800 From: "DB2 Today" Subject: Welcome to Issue XXIII of DB2 Today ****************************************************************** ********* DB2 Today Issue XXIII - December 2001 *********** ****************************************************************** Dear IBM, Read about how IBM Data Management Software continues to win customers, from Coca-Cola for Digital Media Management System to HNC for Advanced Marketing Analytics to FHT Esslingen University for DB2 Skills. Also, see the many great product download offers! 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. ****************************************************************** ************ TABLE OF CONTENT ********** ****************************************************************** GENERAL News < 1 > The Coca-Cola Company and IBM Create Unique Digital Media Management System < 2 > HNC points the way to incremental revenues with DB2 data store < 3 > FHT Esslingen University students gain DB2 skills for real-world edge. < 4 > IBM Delivers the Industry's First Database Available on InfiniBand Offers < 5 > IBM DB2 Universal Database Version7.2 Newest Version Available for Free Download and on CD < 6 > IBM DB2 Migration Toolkit Free Download < 7 > DB2 Intelligent Miner Scoring Download < 8 > IBM DB2 OLAP Server Analyzer Download < 9 > DB2 Intelligent Miner for Data Download < 10 > IBM Business Intelligence Solutions CD Conferences < 11 > Save the Date for the 2002 IBM DB2 & BI Technical Conference < 12 > DB2 and BI Technical Conference - CD-ROM now available for purchase < 13 > Save the date for the 2002 Content Management Technical Conference < 14 > Save the date for the 2002 IMS Technical Conference International DB2 Users Group(IDUG) < 15 > IDUG...Driving DB2 Education Across Europe--Share Your Knowledge < 16 > IDUG Calendar of Events International Informix Users Group(IIUG) < 17 > IIUG PRESIDENT'S LETTER. < 18 > IIUG QUARTERLY ENEWS AND ALERTS. IIUG promotes Informix product DB2 PRODUCT FAMILY DB2 UDB for Windows < 19 > Migrating a Microsoft Access 2000 Database to DB2 Universal Database 7.2 DB2 Library < 20 > IBM Video Central for e-business: Web Services Privacy, Security, and Accuracy < 21 > Building Federated Systems with Relational Connect and Database Views < 22 > Meet the Experts: Terry Purcell on Outer Joins < 23 > DB2 is the top performing Database in the Industry < 24 > Sample Application using Web Services on WebSphere < 25 > Tutorial: Building a C/C++ Embedded SQL Stored Procedure < 26 > Meet the Experts: Curt Cotner, Lead Architect, DB2 for z/OS and OS/390 SOLUTIONS Business Intelligence < 27 > Product announcement: DB2 OLAP Server Miner < 28 > Webcast: "Discovering New Opportunities with OLAP" e-business < 29 > InterTrade creates value chains using DB2 for collaborative commerce platform. Enterprise Applications from IBM Partners < 30 > DB2 Extends Record Performance with PeopleSoft 8 General Ledger SAP < 31 > Brann Worldwide Chooses IBM DB2 for SAP Solutions Applications < 32 > Customer Reference Story: Liechtensteinische Landesbank Ag Better Control Of The Business With IBM DB2 Database And Sap R/3 Applications. Content Manager < 33 > Customer Reference Story: Statens Museum for Kunst takes art online with IBM Content Manager and DB2. INFORMIX PRODUCT FAMILY < 34 > Office Connect allows Informix users to connect securely and effectively from Microsoft Office to Informix: < 35 > Informix users can now order product updates online: SKILL AND EDUCATION CLASSES (DB2 & Informix) < 36 > The "DB2 Fastpath for Experienced Relational DBA's" self study is still available. < 37 > DB2 UDB Programming Fastpath self study download available at no charge! ****************************************************************** ************ ARTICLES ********** ****************************************************************** ================================================================== GENERAL ================================================================== ************ News ************************************************ < 1 > The Coca-Cola Company and IBM Create Unique Digital Media Management System IBM and The Coca-Cola Company announced today that Coca-Cola is leveraging IBM's most advanced digital asset management technology to create a powerful resource for managing archival information. The new Coca-Cola digital media system makes a century's worth of corporate marketing and advertising icons available at the desktop through a worldwide internal network, allowing Coca-Cola employees to more easily access and use the material for future projects. http://ibm1.rjs0.net/servlet/cc4?pItEWWZ*pHgQhlWlpmLEJht*z*U*y*VUYDAAA < 2 > HNC points the way to incremental revenues with DB2 data store HNC was able to increase their sales revenue by using their Opportunity Suite, a suite of advanced marketing analytics and optimization solutions based on proprietary neural-network and other predictive models. Using these tools, HNC's customers-- mainly financial services and telecommunications companies-have collectively generated over $100 million in incremental revenue over the past two years. http://ibm1.rjs0.net/servlet/cc4?pItEWWZ*pHgQhlWlpmLEJht*z*V*y*VUYDAAA < 3 > FHT Esslingen University students gain DB2 skills for real-world edge. At FHT Esslingen University (FHT), IT students begin tackling business technology challenges soon after they set foot in the classroom. A German technical institute located in the state of Baden-Württemberg in Southwest Germany, FHT works closely with local companies on joint projects that provide its students access to the latest technologies. Many of its students already work part-time in various industries. http://ibm1.rjs0.net/servlet/cc4?pItEWWZ*pHgQhlWlpmLEJht*z*W*y*VUYDAAA < 4 > IBM Delivers the Industry's First Database Available on InfiniBand IBM announced the availability of DB2 Universal Database to customers on the InfiniBand fabric. DB2 is the industry's first database to support the innovative InfiniBand architecture in the marketplace. http://www-916.ibm.com/press/prnews.nsf/print/F30E4D2988601A8B85256B1200701B98 ************** Offers ******************************************** < 5 > IBM DB2 Universal Database Version7.2 Newest Version Available for Free Download and on CD IBM DB2 Version 7.2 delivers enhanced Business Intelligence Solutions along with a new DB2 Connect Web Starter Kit and DB2 Life Sciences Data Connect. This new release for DB2 Universal Database (UDB) further enhances it as the first multimedia, Web-ready relational database management system, strong enough to meet the demands of large corporations and flexible enough to serve small- and medium-sized businesses. With DB2 UDB Version 7, IBM continues its role as the database innovator in e-business, business intelligence, data management and the DB2 family. Download 32- and 64-bit trial versions of DB2 at: http://ibm1.rjs0.net/servlet/cc4?pItEWWZ*pHgQhlWlpmLEJht*z*X*y*VUYDAAA Order your free trial code CD of DB2 at: http://www6.software.ibm.com/dl/db2udbcd/db2udbcd-p?S_TACT=__S_TACT__&S_CMP=__S_CMP__ < 6 > IBM DB2 Migration Toolkit Free Download The IBM DB2 Migration Toolkit helps you migrate from Sybase and Microsoft SQL Server (Versions 6 and 7) databases to DB2 UDB V7.2 databases on any supported DB2 UDB workstation platform. The toolkit can also aid in your migration to DB2 UDB Server for OS/390 and z/OS, and DB2 UDB for AS/400. It runs on Windows NT or Windows 2000 and is available only in English. Download a copy of the IBM DB2 V7.2 Migration Toolkit Beta at: http://ibm1.rjs0.net/servlet/cc4?pItEWWZ*pHgQhlWlpmLEJht*z*Y*y*VUYDAAA < 7 > DB2 Intelligent Miner Scoring Download DB2 Intelligent Miner Scoring extends DB2 analysis capabilities and enables users to deploy mining in real-time applications with a simple SQL call. With DB2 Intelligent Miner Scoring, your applications can better serve business and consumer users alike - providing more informed recommendations, personalizing customer and supplier treatment, building more efficiencies into the online experience; to, in general, be more responsive to the specific situation at hand. For more information on IBM DB2 Intelligent Miner Scoring visit http://www.ibm.com/software/data/iminer/scoring/ Register now for the IBM DB2 Intelligent MinerScoring 90 Day Trial Download: http://ibm1.rjs0.net/servlet/cc4?pItEWWZ*pHgQhlWlpmLEJht*z*Z*y*VUYDAAA < 8 > IBM DB2 OLAP Server Analyzer Download Get a free try and buy version of IBM DB2 OLAP Server Analyzer for the OLAP Starter Kit in DB2 Version 7. The combination of Analyzer, and the OLAP Starter Kit in DB2 Version 7, is a great platform to quickly develop a complete Windows or Web-based multidimensional analysis application. Download a try and buy copy of Analyzer for the OLAP Starter Kit in DB2 V7. http://www-4.ibm.com/software/data/bi/downloads.html < 9 > DB2 Intelligent Miner for Data Download IBM DB2 Intelligent Miner for Data helps identify and extract high-value business intelligence from enterprise data assets, including high-volume transaction data generated by point-of-sale, ATM, credit card, call center, or e-commerce applications, to name a few. Register now for the IBM DB2 Intelligent Miner for Data 90 Day Trial Download: http://www-4.ibm.com/software/data/bi/downloads.html < 10 > IBM Business Intelligence Solutions CD The IBM Business Intelligence Solutions CD contains over 60 stories of how companies and organizations are using IBM Business Intelligence solutions to gain very exciting results. Viewing these stories you will quickly see how you can benefit using IBM Business Intelligence. To request a free BM Business Intelligence Solutions CD go to: http://www-4.ibm.com/software/data/bi/downloads.html ************** Conferences *************************************** < 11 > Save the Date for the 2002 IBM DB2 & BI Technical Conference Save the date for next year's 2002 DB2 & Business Intelligence Technical Conference, September 9-13, 2002 in Anaheim, California. In 2002, the conference will be a part of a much larger event - the NEW IBM Data Management Technical Conference which will also include the 2002 IBM Informix Conference. Feel free to bookmark the Learning Services conference Web site and check back periodically as we'll be updating this site with new and exciting information in the coming months - the conference date is sooner than you think! http://www-3.ibm.com/services/learning/conf/us/index.html?c=IBM_DB2Today&n=various&t=aff < 12 > DB2 and BI Technical Conference - CD-ROM now available for purchase IBM Learning Services announces the availability of the DB2 & BI Technical Conference CD containing most of the available Breakout session presentations that were given at the recently completed event in Orlando, Oct 1-5, 2001. The conference CD contains over 150 presentations which will be particularly valuable for those customers who were unable to attend the event or for those who might need additional copies for use in their company or organization. It is priced at $300 for Customers and $200 for IBM employees. If you have any questions please call Gene Bruczkowski at (847) 272-9433. You can order the CD at the following website and then select the "DB2 & BI Technical Conference CD" line item. http://www.confservices.com/?c=IBM_DB2Today&n=various&t=aff < 13 > Save the date for the 2002 Content Management Technical Conference The 2002 Content Management Technical conference will be held June 17 - 18 in San Diego, California. We will be updating our Web site in coming months with highlights, agendas, keynote presentations, Expo participants, hotel and travel information,... Please bookmark our conference web site to get the details as they happen at: http://www-3.ibm.com/services/learning/conf/us/index.html?c=IBM_DB2Today&n=various&t=aff < 14 > Save the date for the 2002 IMS Technical Conference The 2002 IMS Management Technical conference will be held September 30 - October 3 in St. Louis, Missouri. We will be updating our Web site in coming months with highlights, agendas, keynote presentations, Expo participants, hotel and travel information, ... Please bookmark our conference web site to get all the details as they happen at: http://www-3.ibm.com/services/learning/conf/us/index.html?c=IBM_DB2Today&n=various&t=aff ******** International DB2 Users Group(IDUG) ********************* < 15 > IDUG...Driving DB2 Education Across Europe--Share Your Knowledge Share your DB2 knowledge and successes with colleagues at IDUG 2002--Europe, 21-24 October 2002, in Lisbon, Portugal. Respond to the Call for Presentations found on http://www.idug.org no later than 22 February 2002, and if your presentation is selected for the technical program you will receive a complimentary registration to the conference. For more information on upcoming IDUG events in 2002, visit , or send an email to idug@idug.org. < 16 > IDUG Calendar of Events IDUG 2002--North America 12-16 May 2002 San Diego, CA, USA IDUG 2002--Europe 21-24 October 2002 Lisbon, Portugal IDUG 2002--Technical Symposium Dates to be Announced Toronto, ON, Canada IDUG 2002--Asia Pacific Dates and Location to be Announced *** International Informix Users Group(IIUG) www.iiug.org ******* < 17 > IIUG PRESIDENT'S LETTER. New surveys, conference advocacy, new local user groups and regular e-publications -- these are some of IIUG's accomplishments for 2001 that benefited the Informix user community. For more details, read the IIUG President's letter: http://www.iiug.org/ver3/news/letter_rh_26nov01.html < 18 > IIUG QUARTERLY ENEWS AND ALERTS. IIUG promotes Informix product knowledge and user experiences primarily through its Web site, SIG e-mail lists, and e-publications. November's E-Newsletter provides news from last quarter. For more, please see: November Enewsletter: http://www.iiug.org/ver3/news/enews/enews113001.html Enewsletter home: http://www.iiug.org/ver3/news/newsletter.html Alert home: http://www.iiug.org/ver3/news/alert.html ================================================================== DB2 PRODUCT FAMILY ================================================================== ************* DB2 UDB for Windows ******************************** < 19 > Migrating a Microsoft Access 2000 Database to DB2 Universal Database 7.2 This article describes and evaluates two methods for migrating a Microsoft Access database to DB2 and uses a customized case study to trace the steps involved in the two methodologies: Migration using the MS Access Export to ODBC Tool, and migration using the IBM OLE DB Table UDF Wizard. http://www7b.boulder.ibm.com/dmdd/library/techarticle/alazzawe/0112alazzawe2.html *********** DB2 Library ******************************************* < 20 > IBM Video Central for e-business: Web Services Privacy, Security, and Accuracy IBM Video Central for e-business is an end-to-end sample solution offering a set of business-to-business (B2B) Web services to access a DB2 central repository of data. This article focuses on data privacy, security, and accuracy issues related to implementing such a solution. http://www7b.boulder.ibm.com/dmdd/library/techarticle/alazzawe/0112alazzawe.html < 21 > Building Federated Systems with Relational Connect and Database Views Integrating data from diverse backend sources is always a challenge. This article describes the appropriate architectural contexts for using data federation and database views to achieve this end. Scripts and samples for a proof-of-concept using DB2 Relational Connect are included. http://www7b.boulder.ibm.com/dmdd/library/techarticle/rutledge/0112rutledge.pdf < 22 > Meet the Experts: Terry Purcell on Outer Joins In this first of two parts, 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 advice on coding predicates in outer joins. http://www7b.boulder.ibm.com/dmdd/library/techarticle/purcell/0112purcell.html < 23 > DB2 is the top performing Database in the Industry Do you need a reality check on DB2? IBM DB2 Universal Database is the top performing database in the industry. But check the facts on performance for yourself: http://www.ibm.com/software/data/highlights/db2leads.html < 24 > Sample Application using Web Services on WebSphere Exchanging data between organizations can be difficult because different organizations collect, store, and process information differently. Using a sample application, this article describes a step-by-step approach to solving this problem using XML for data exchange using IBM's Web Services Object Runtime Framework (WORF). http://www7b.boulder.ibm.com/dmdd/library/techarticle/preisig/0111preisig.html < 25 > Tutorial: Building a C/C++ Embedded SQL Stored Procedure This tutorial guides you through the steps required to code, build, and deploy a sample stored procedure. This tutorial also provides a sample C/C++ console application that calls the stored procedure, passes it the required parameters, then outputs the result of the invocation to the console. This application is implemented using embedded static SQL. http://www7b.boulder.ibm.com/dmdd/library/techarticle/packham/csql-sp02.htm < 26 > Meet the Experts: Curt Cotner, Lead Architect, DB2 for z/OS and OS/390 If you are interested in the future of DB2 for z/OS and OS/390, then you will be interested in what Curt Cotner, lead technical architect for the product, has to say about DB2's current and future focus on Java and Web applications. http://www7b.boulder.ibm.com/dmdd/library/techarticle/cotner/0111cotner.html ================================================================== SOLUTIONS ================================================================== ********** Business Intelligence ********************************* < 27 > Product announcement: DB2 OLAP Server Miner DB2 OLAP Server V7.1 now includes DB2 OLAP Server Miner, a new no-cost feature that provides an unparalleled partnership of OLAP and data mining technology. OLAP Miner automatically mines through large volumes of OLAP data and identifies and reports on specific elements that represent the most outstanding, and unexpected, pieces of information. http://www-4.ibm.com/software/data/db2/db2olap/ < 28 > Webcast: "Discovering New Opportunities with OLAP" This webcast will highlight how the new data mining feature of DB2 OLAP Server can add a whole new dimension to decision making by quickly identifying anomalies that can result in unique opportunities. This webcast will provide an overview of the offering and explore two in-depth, real-life examples of how this new capability can solve today's pressing business issues with advanced technology. This webcast presentation is available for viewing on demand, 24 x 7 at anytime. This webcast is available for viewing until March 6, 2002 but we encourage you to view it right away-- it's a presentation you don't want to miss! How: REGISTER HERE! http://webevents.broadcast.com/ibm/olap ********** e-business ******************************************** < 29 > InterTrade creates value chains using DB2 for collaborative commerce platform. InterTrade's TradeLinks, an integrated, collaborative B2B e-commerce platform connecting multiple trading partners produced for InterTrade more than 500% increase in user base expected in one year. For InterTrade's customers: 100% ROI expected in 0-20 months; up to 99% saved on purchase order processing; 50-75% decrease in order error; 75% acceleration in order-to-cash cycle time; and more. http://www2.software.ibm.com/casestudies/swcsdm.nsf/cs/navo-53fpkz ********** Enterprise Applications from IBM Partners ************* < 30 > DB2 Extends Record Performance with PeopleSoft 8 General Ledger PeopleSoft recently certified DB2 UDB as the leading benchmark result for their PeopleSoft 8 General Ledger application. This certification represents a world record performance benchmark for PeopleSoft's pure-internet enterprise application with a result of twice the throughput and two time the response time as recorded by the competition. http://www-4.ibm.com/software/data/db2/benchmarks/111301.html **************** SAP ********************************************* < 31 > Brann Worldwide Chooses IBM DB2 for SAP Solutions Applications IBM today announced that Brann Worldwide, one of the largest direct marketing agencies in the world, has chosen an integrated DB2 database /SAP application as the foundation for running its SAP solutions. Brann joins the growing roster of corporate businesses including Whirlpool and Buckbee-Mears Cortland, that have recently chosen DB2 to run its SAP solutions. http://www-916.ibm.com/press/prnews.nsf/jan/4F03F8FD3598C6FD85256B21000698A5 < 32 > Customer Reference Story: Liechtensteinische Landesbank Ag Better Control Of The Business With IBM DB2 Database And Sap R/3 Applications. http://www-4.ibm.com/software/data/solutions/pdf2/lichtenstein.pdf *********** Content Manager ************************************** < 33 > Customer Reference Story: Statens Museum for Kunst takes art online with IBM Content Manager and DB2. IBM Content Manager provides Statens Museum for Kunst with a fully searchable museum with digital images of 5,000 works of art. http://www-4.ibm.com/software/data/solutions/pdf2/statensmuseum.pdf ================================================================== INFORMIX PRODUCT FAMILY ================================================================== ************** Other Informix Products *************************** < 34 > Office Connect allows Informix users to connect securely and effectively from Microsoft Office to Informix: http://www.iiug.org/ver3/news/alerts/alert_16nov01.html#4 < 35 > Informix users can now order product updates online: http://www.iiug.org/ver3/news/alerts/alert_16nov01.html#6 ================================================================== SKILL AND EDUCATION ================================================================== ************** CLASSES (DB2 & Informix) ************************** < 36 > The "DB2 Fastpath for Experienced Relational DBA's" self study is still available. It is for DBAs who are already proficient in one or more non-IBM relational database products and want to learn to use DB2 quickly. To download: http://www.ibm.com/software/data/db2/selfstudy/ For additional information on this and other skill related topics see: http://www.ibm.com/software/data/db2/skills/ < 37 > DB2 UDB Programming Fastpath self study download available at no charge! The DB2 UDB Programming Fastpath download is designed to teach experienced relational database programmers how to create applications that access data in a DB2 Universal Database system. It provides a fast path for acquiring the skills necessary to write programs against a DB2 UDB Database. To download DB2 UDB Programming Fastpath now at: http://www.ibm.com/software/data/db2/ct10crs/ ================================================================== 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, 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. This email was sent to deadmail 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/