Date: Mon, 8 Jul 2002 04:05:24 -0700 From: "DB2 Today" Subject: Welcome to Version XXIII of DB2 Today ****************************************************************** ********* DB2 Today Issue XXVIII - July 2002 ************ ****************************************************************** Dear IBM, IBM recently announced IBM Content Manager version 8 which helps businesses solve a critical problem -- managing and integrating all forms of information located in various data sources, including scanned images, audio, video and information from multiple software vendors' products. The ability to capture this information in digital format allows you to become more efficient, respond faster to your suppliers and your customers, tap into new markets, and ultimately increase profits. For more information on this announcement, visit: http://www-916.ibm.com/press/prnews.nsf/jan/DBED05229B713E7E85256BD4004AC84D 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 ================================================================== ************** Offers ******************************************** <1> Get Smart for No Charge with IBM Data Management Redbooks ************ News ************************************************ <2> IBM named the worldwide leader in Data Management Software <3> Fundamentals of IBM Federated Server and Relational Connect <4> Heidelberg University graduates in high demand following DB2 training. <5> National Digital Mammography Archive: University of Pennsylvania consortium and IBM develop computing grid for breast cancer screening <6> IBM and AirToolz use wireless to speed home construction <7> IBM DB2 EEE v.7.1 Implementation and Certification With Hewlett-Packard's MC/ServiceGuard High Availability Software <8> DB2 for z/OS and OS/390 book in its 4th edition includes V7 features and more <9> IBM Data Management Tools: New Opportunities for Cost-Effective Administration <10> Creating Web Services on Windows to Access DB2 <11> Manipulating SQL and XML Data with WebSphere Studio <12> DB2 Code Sample: Embedded SQL for C <13> DB2 Code Sample: Snapshot Monitoring <14> DB2 Code Sample: VisualBasic Active X Data Objects Sample Files <15> Enforcing Business Logic Using Triggers, Java UDFs, and the JavaMail API <16> Using DB2 Incremental Backup <17> Data Management Presentations from DeveloperWorks Live! 2002 <18> XML and WebSphere Studio Application Developer -- Part 5: Exploring the RDB to XML Mapping Editor <19> Connector for SAP R/3: A Ready-to-use Warehousing Solution <20> Setting the Volume to 11 - Setting DB2 Configuration Parameters <21> IBM Video Online - Inbound XML Data Fragments <22> Split Mirror Using Suspended I/O in DB2 Universal Database Version 7.2 <23> A Quick Reference for Tuning DB2 EEE <24> Using Multiple BCV Copies with IBM Universal Database V7.2 and EMC Timefinder <25> An Honest Car Lot on the Web - Displaying database content dynamically with Java** servlets and JavaScript <26> High Performance Inserts on DB2 UDB EEE Using Java <27> DB2 UDB Family on Common Ground <28> Generating a Non-delimited ASCII File Using the DB2 EXPORT Utility <29> Meet the Experts: Janet Perna <30> Meet the Experts: Sheryl Larsen talks about the Power of Table Expressions <31> Getting Started with WebSphere Performance Benchmark Sample on Windows 2000 <32> DB2 Code Sample: Sample UDFs to Ease Migration from Oracle or Sybase <33> Porting Guide: Oracle to DB2 Version 7.2 <34> User-power and e-mailing: Using the Web, DB2, Java, JDBC, and the JavaMail API to manage bulk e-mail lists <35> DB2 7.2 and Visual Basic 6.0: Bound and Unbound ADO Forms <36> Our Experience with Writing a Table Editor GUI for DB2 <37> How do I call a DB2 administrative API from Visual Basic? <38> Accucard profits from CRM with KANA and IBM infrastructure <39> Announcing new Industry Solutions Web Site for IBM Data Management <40> DB2 for z/OS and OS/390 Data Management Tools Update <41> Siebel 7 Using DB2 UDB V7.x Planning & Installation Guide for AIX/Win2k <42> Top 10 IBM DB2 Redbooks ************** Conferences *************************************** <43> IBM Life Sciences' Seminars <44> IBM Data Management Conference now include DB2 UDB for iSeries topics <45> Keynote and Featured Speakers at the IBM Data Management Technical Conference <46> Tool Time: Hands-On Sessions at the IMS Technical Conference <47> Web Lectures - IBM Life Sciences Web Lecture Series. <48> IBM DB2 User Group's (IDUG) education events around the world. <49> IDUG 2002--Europe Full Programme Information Available ================================================================== DB2 PRODUCT FAMILY ================================================================== *********** Data Management Tools ******************************** <50> IBM DB2 Utilities Migration Toolkit Now Available ================================================================== SOLUTIONS ================================================================== ********** Business Intelligence ********************************* <51> United Airlines positions DB2 data warehouse as its backbone for CRM. *********** Content Manager ************************************** <52> New Content Manager Brochures and updated White Paper <53> General Content Manager News <54> OnDemand: Designing a Solution for Performance and User Satisfaction <55> Customizing the IBM Content Manager OnDemand Administrative Client ================================================================== INFORMIX PRODUCT FAMILY ================================================================== ************** Informix Products ********************************* <56> Informix Developer Zone: Tuning Informix DSS Queries <57> Informix Developer Zone: Query Directives: Examples and Analysis <58> Divide and Conquer: Using Fragmentation for Smart Data Access <59> Load and Attach: Updating Data Warehouse Tables <60> New IIUG Insider Publication Circulates <61> Its So Easy to Join IIUG for Member Benefits <62> New Downloads for IIUG Members <63> A Flexible Way of Using sqlhosts from Your Java Classpath <64> Informix Developer Zone: Bringing Informix Dynamic Server Internals to the Surface <65> DSS Application Processing ================================================================== SKILL AND EDUCATION ================================================================== ************* DB2 CERTIFICATION ********************************** <66> New Certification Exam Guide for DB2 Administration <67> DB2 Certification Program -- Registration and Sample Tests <68> No Charge Voucher for Certification Exam <69> Certification Made Easy with New DB2 Tutorials ************** CLASSES (DB2 & Informix) ************************** <70> No Charge Personalized Skills Plan <71> Data Management Education and Offerings <72> New DM Tutorials and Redbooks Available <73> DB2 UDB family on common ground <74> IBM Learning Services Data Management Classes <75> Fast Path to DB2 UDB for Experienced Relational DBAs (No Charge) <76> DB2 UDB Programming Fastpath Course (No Charge) <77> New Certification Exam Guide for DB2 Administration ================================================================== GENERAL ================================================================== ************** Offers ******************************************** <1> Get Smart for No Charge with IBM Data Management Redbooks Receive a no charge CD with over 100 IBM Data Management Redbooks including DB2, Content Manager, Data Warehouse, z/OS, OS/390, IMS and Tools. This CD provides you with positioning, value guidance, installation, implementation experiences and step-by-step "how-to" guidelines. Sample code and other support materials often included. Order your complimentary CD at: http://www.ibm.com/db2/redbookcd ************ News ************************************************ <2> IBM named the worldwide leader in Data Management Software IBM has become the worldwide leader in database management system software, according to a report released today by Gartner Dataquest. With 34.6 percent market share, IBM became the leading vendor in new license revenue, surpassing the competition. IBM's leadership and momentum in the database market is produced by providing customers with the broadest platform support, open standards, lowest total cost of ownership and wide application development support. http://www.ibm.com/software/data/news/pr3.html <3> Fundamentals of IBM Federated Server and Relational Connect Data federation is a key component to your ability to integrate data from diverse backend data sources. This detailed guide provides you with information to help you get started with DB2 federated capability. http://www7b.software.ibm.com/dmdd/library/techarticle/0206purnell/0206purnell.html <4> Heidelberg University graduates in high demand following DB2 training. "Because so many of Germany's companies have chosen IBM DB2 Universal Database for its reliability and high performance, our students have an edge in the workforce," says Professor Alfred Moos. "They are trained in practical applications on the most modern data management software used in our economy and our industry." http://www-3.ibm.com/software/success/cssdb.nsf/CS/NAVO-59PPQL?OpenDocument&Site=dmmain <5> National Digital Mammography Archive: University of Pennsylvania consortium and IBM develop computing grid for breast cancer screening Just as electricity is delivered to homes over an electrical grid, computing grids allow geographically distributed organizations to share applications, data, and computing resources. A new model of computing, grids are clusters of servers and ther resources joined together over the Internet, using protocols provided by the Globus open source community (Globus.org) and other open technologies, including Linux. Advantages of grid computing for accessing and managing patient data include fast data retrieval, scalability, and cost savings. The University of Pennsylvania Grid system combines IBM eServer UNIX, and Linux(with IBM's DB2 Universal Database) to create a uniquely powerful solution <6> IBM and AirToolz use wireless to speed home construction AirToolz Software has created a powerful application for the residential construction industry running on IBM e-infrastructure software that enables contractors to speed the construction of new homes by wirelessly managing work schedules, inventories and back-end systems from the job site using handheld devices. Powered by a combination of IBM's DB2 database and WebSphere Application Server software, the application manages a master construction schedule in real-time for contractors working at multiple job sites. http://www-3.ibm.com/software/success/cssdb.nsf/CS/MMAA-5BBKQR?OpenDocument&Site=dmmain <7> IBM DB2 EEE v.7.1 Implementation and Certification With Hewlett-Packard's MC/ServiceGuard High Availability Software IBM DB2 Universal Database has been available on the HP-UX platform since 1994. To expand the alliance, IBM and HP have teamed to add DB2 Universal Database V6.1 Enterprise-Extended Edition (EEE) IBM's most robust enterprise database to the portfolio. Together HP and IBM offer a world class combination of market leaders in the corporate Business Intelligence (BI) marketplace. This whie paper discusses the implementation and certification of HP's MC/ServiceGuard with DB2 UDB EEE. http://www.ibm.com/software/data/hp/pdfs/db2eee.pdf <8> DB2 for z/OS and OS/390 book in its 4th edition includes V7 features and more DB2 for z/OS and OS/390 Development for Performance in its fourth edition is the only book to include the features and facilities of V7 integrated into the book. This edition even has V7, V6, or V5 APAR number noted with the first of occurrence of a feature specific to the version or APAR in the index. Three DB2 professionals indexed the now hard cover book. The complete title and ISBN numbers are: DB2 for z/OS and OS/390 Development for Performance Volume 1 of 2 ISBN 0-9668460-5-2 DB2 for z/OS and OS/390 Development for Performance Volume 2 of 2 ISBN 0-9668460-6-0 http://www.gabrielledb2.com/ <9> IBM Data Management Tools: New Opportunities for Cost-Effective Administration In this April 2002 profile entitled "IBM Data Management Tools: New Opportunities for Cost-Effective Administration", Aberdeen Group discusses the latest IBM data management tools and utilities, noting their expansion to UNIX, Windows and Informix. In addition to comprehensive data administration support, reasons cited for customers to consider IBM data management tools are their low price-point, timely integration with new IBM database releases, scalability, and automation to increase database administrator productivity. Also, Aberdeen measures IBM data management tools against the criteria of comprehensiveness, scalability, administrative productivity, robustness and integration. http://www.ibm.com/software/data/pubs/pdfs/aberdeen0402.pdf <10> Creating Web Services on Windows to Access DB2 One of the advantages of Web services is the ability to access existing stored procedures as Web services. This tutorial walks through the process of creating two stored procedures using CLP and the stored procedure builder and then shows you how to turn those procedures into Web services. https://www6.software.ibm.com/reg/devworks/dw-db2wsw-i?S_TACT=102B7W59&S_CMP=DB2DD <11> Manipulating SQL and XML Data with WebSphere Studio This tutorial includes the basics of XML development with WebSphere Studio Site Developer including its ability to generate XML files from SQL statements and to create mappings of XML data to a relational database structure. https://www6.software.ibm.com/reg/devworks/dw-xmlsql-i?S_CMP=DB2DD&S_TACT=102B7W45 <12> DB2 Code Sample: Embedded SQL for C This sample code demonstrates inline SQL procedure language, identity columns, declared temporary tables, and more. http://www7b.software.ibm.com/dmdd/library/samples/db2/0205embedded/0205embedded.html <13> DB2 Code Sample: Snapshot Monitoring This sample code contains snapshot monitoring files for the C programming language. The snapshot monitoring sample code gives you detailed information on database operation. Use snapshots to optimize your database's performance http://www7b.software.ibm.com/dmdd/library/samples/db2/0204snapshot/0204snapshot.html <14> DB2 Code Sample: VisualBasic Active X Data Objects Sample Files The Visual Basic ADO code sample contains files that show you how to execute SQL statements, get and set client level information, retrieve hierarchical data, and much more. http://www7b.software.ibm.com/dmdd/library/samples/db2/0204visualbasic/0204visualbasic.html <15> Enforcing Business Logic Using Triggers, Java UDFs, and the JavaMail API Learn about the power of triggers and UDFs together in this example that automatically triggers a customized e-mail when a customer approaches a credit limit. http://www7b.software.ibm.com/dmdd/library/techarticle/0205bhogal/0205bhogal.html <16> Using DB2 Incremental Backup Are you aware of the many availability enhancements in DB2 7.2? One of the key high availability features in DB2 Universal Database 7.2 for warehousing environments is incremental backup. This article describes the how incremental backup works, when you might want to use it, and strategies for ensuring smooth recoveries. http://www7b.software.ibm.com/dmdd/library/techarticle/0205adamache/0205adamache.html <17> Data Management Presentations from DeveloperWorks Live! 2002 Did you miss the fun at dWlive! in San Francisco? We can't help you with the parties you missed, but at least you can catch up on some of the technical sessions, including DB2 and WebSphere integration, DB2 messaging applications, DB2 trends and directions, developing multimedia Web applications, and much more. http://www7b.software.ibm.com/dmdd/library/events/0205dwlive/ <18> XML and WebSphere Studio Application Developer -- Part 5: Exploring the RDB to XML Mapping Editor This WebSphere Tech Journal article explains how to use the RDB to XML Mapping Editor to map XML data to relational data, and vice versa, and to generate a DAD file to retrieve or store relational data in XML files. :http://www7b.software.ibm.com/wsdd/techjournal/0204_russell/russell.html <19> Connector for SAP R/3: A Ready-to-use Warehousing Solution This article takes you step-by-step through the easy process to integrate critical SAP R/3 data with other important business data for enhanced business intelligence. http://www7b.software.ibm.com/dmdd/library/techarticle/0204agarwal/0204agarwal.html <20> Setting the Volume to 11 - Setting DB2 Configuration Parameters DB2 answer man Blair Adamache offers some useful hints on using and tracking DB2 UDB configuration parameters. http://www7b.software.ibm.com/dmdd/library/techarticle/0204adamache/0204adamache.html <21> IBM Video Online - Inbound XML Data Fragments This sample solution uses XML data fragments as the data exchange mechanism. This article describes the design and implementation of the inbound XML data fragments, in which SQL tabular data is extracted from XML data documents that are passed as input parameters to SQL stored procedures. http://www7b.software.ibm.com/dmdd/library/techarticle/0204alazzawe/0204alazzawe.html <22> Split Mirror Using Suspended I/O in DB2 Universal Database Version 7.2 DB2 is your best bet for high availability! This article provides an overview to the suspended I/O feature of DB2 7.2, which can be used in conjunction with split mirror for warm standby and for creating test sites. http://www7b.software.ibm.com/dmdd/library/techarticle/0204quazi/0204quazi.html <23> A Quick Reference for Tuning DB2 EEE This article presents techniques for tuning DB2 Extended Enterprise Edition (EEE), including memory usage, buffer pools, and tuning tools. Perl scripts are provided to help you collect and analyze the DB2 snapshot data and to provide hints to improve database performance. http://www7b.software.ibm.com/dmdd/library/techarticle/0205parlapalli/0205parlapalli.html <24> Using Multiple BCV Copies with IBM Universal Database V7.2 and EMC Timefinder Build a robust, highly available environment with the instant split feature of EMC TimeFinder and the suspended I/O features available in DB2 EE. http://www7b.software.ibm.com/dmdd/library/techarticle/0204cialini/0204cialini.pdf <25> An Honest Car Lot on the Web - Displaying database content dynamically with Java** servlets and JavaScript This article describes how to give your customers an interactive way to view up-to-date inventory (in DB2) online, using a powerful combination of server-centric Java servlets and client-centric JavaScript. The article gives an in-depth example that relays inventory data to a Web site visitor, and ties together a relational database to a Java servlet using JDBC. http://www-106.ibm.com/developerworks/ibm/library/i-car/ <26> High Performance Inserts on DB2 UDB EEE Using Java Learn the advantages of using buffered inserts on DB2 UDB EEE on partitioned environments and how to leverage this technique from Java applications. http://www7b.software.ibm.com/dmdd/library/techarticle/0204pooloth/0204pooloth.html <27> DB2 UDB Family on Common Ground Interested in developing applications that port across DB2 platforms? It's easier than you think. This article includes information about optimization, administration, and, of particular interest, common SQL features. http://www7b.software.ibm.com/dmdd/library/techarticle/0204milligan/0204milligan.html <28> Generating a Non-delimited ASCII File Using the DB2 EXPORT Utility Here's a simple way to generate a nondelimited ASCII file from DB2. You can load or import this data into another DB2 table. http://www7b.software.ibm.com/dmdd/library/techarticle/0204zikopoulos/0204zikopoulos.html <29> Meet the Experts: Janet Perna When it comes to IBM Data Management, the buck stops with Janet Perna, the General Manager of IBM Data Management Solutions. Read what she has to say about developers, DB2, and what's ahead. http://www7b.software.ibm.com/dmdd/library/techarticle/0205perna/0205perna.html <30> Meet the Experts: Sheryl Larsen talks about the Power of Table Expressions Renowned SQL expert Sheryl Larsen says it's time to get caught up on your SQL skills. Table expressions are particularly underused and yet give you so much capability. Check out the examples and see what table expressions can do for you. http://www7b.software.ibm.com/dmdd/library/techarticle/0204larsen/0204larsen.html <31> Getting Started with WebSphere Performance Benchmark Sample on Windows 2000 The WebSphere Performance Benchmark Sample, a.k.a. Trade2, provides a collection of workloads for characterizing performance of the WebSphere Application Server. This article focuses on the steps for installing Trade2 and configuring the software. It provides an excellent starting point for those who are new to administrating and running WebSphere applications in a WebSphere and DB2 environment. http://www7b.software.ibm.com/dmdd/library/techarticle/0205an/0205an.html <32> DB2 Code Sample: Sample UDFs to Ease Migration from Oracle or Sybase Ready to port your application from Oracle or Sybase to DB2? This handy set of SQL UDFs can help make that move a little bit easier by providing the same or similar functionality in DB2 for certain functions you might be using in Oracle or Sybase. http://www7b.software.ibm.com/dmdd/library/samples/db2/0205udfs/ <33> Porting Guide: Oracle to DB2 Version 7.2 This 89-page porting guide gives you the background you need on everything from architecture to data types. This document is written primarily for application developers who want to convert their applications from Oracle to DB2 UDB, but it also covers topics that are relevant to database administrators. This document starts with the architectures of Oracle and DB2 UDB and ends up with specific details and conversion examples. http://www7b.software.ibm.com/dmdd/library/techarticle/0205wilkins/0205wilkins.html <34> User-power and e-mailing: Using the Web, DB2, Java, JDBC, and the JavaMail API to manage bulk e-mail lists The prequel to this article, Kulvir Bhogal described how to tie together IBM DB2 with a Java Swing-based application that used the JavaMail API to send a message to a mailing list. This article teaches you how to apply your knowledge to build a project that lets users subscribe, unsubscribe, and e-mail to a DB2-centric mailing list. http://www-106.ibm.com/developerworks/library/i-email2/In <35> DB2 7.2 and Visual Basic 6.0: Bound and Unbound ADO Forms This article gives step-by-step directions on how to develop DB2 applications that use bound and unbound data forms, as well as guidance on which type of form to use for your application. http://www7b.software.ibm.com/dmdd/library/techarticle/0206hasin/0206hasin.html <36> Our Experience with Writing a Table Editor GUI for DB2 Ever wanted a simple, user-friendly interface to manipulate data in DB2 tables? Our authors have written a table editor GUI that you can try for yourself, or you can just read about their experiences with coding the Java application. http://www7b.software.ibm.com/dmdd/library/techarticle/0206chaitgal/0206chaitgal.html <37> How do I call a DB2 administrative API from Visual Basic? DB2 expert George Baklarz answers a query about how to call a DB2 administrative client using Visual Basic. http://www7b.software.ibm.com/dmdd/library/techarticle/0206baklarz/0206baklarz.html <38> Accucard profits from CRM with KANA and IBM infrastructure Accucard, the U.K.'s first independent credit card specialist, required a robust, scalable customer-service solution as a critical component of its profitability strategy. A complete customer relationship management system from IBM and KANA is helping Accucard support its growing customer base. For more details read the Accucard case study. http://www-3.ibm.com/software/success/cssdb.nsf/CS/NAVO-582Q6Q?OpenDocument&Site=default <39> Announcing new Industry Solutions Web Site for IBM Data Management Looking for information about IBM Data Management tailored to your industry? Visit the new Industry Solutions Web Site to find information on IBM technology and solutions designed specifically for the needs of your industry. Current industries featured include: Banking & Insurance, Financial Markets, Healthcare, Industrial, Life Sciences, Public Sector, Retail & Distribution and Telecommunications. http://www.ibm.com/software/data/dmsolutions/ <40> DB2 for z/OS and OS/390 Data Management Tools Update This Redbook describes the functionality of five new tools enhanced for the current DB2 UDB Server for OS/390 and z/OS. They are: DB2 Archive Log Compression, DB2 Automation Tool, DB2 Change Accumulation, DB2 Log Analysis Tool and DB2 Object Restore. This Redbook is structured so that it can be used to prepare for presentations.To download the Redbook, visit: http:/publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg246406.html?Open <41> Siebel 7 Using DB2 UDB V7.x Planning & Installation Guide for AIX/Win2k This Redbook provides an overview of the planning and installation of Siebel 7 applications using DB2 V7.x as well as migration from Siebel 6.x. This book is particularly helpful for those installing Siebel 7 on AIX and Windows 2000 for the first time. To download, visit: http:/publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg246415.html?Open <42> Top 10 IBM DB2 Redbooks o DB2 Java Stored Procedures Learning by Example(SG24-5945-00) o DB2 UDB V7.1 Performance Tuning Guide(SG24-6012-00) o Cross-Platform DB2 Stored Procedures: Building and Debugging(SG24-5485-01) o DB2 Warehouse Management: High Availability and Problem Determination(SG24-6544-00) o DB2 UDB e-business Guide(SG24-6539-00) o Connecting WebSphere to DB2 UDB Server(SG24-6219-00) o Siebel 7 Using DB2 UDB V7.x Planning & Installation Guide for AIX/Win(SG24-6415-00) o Getting Started with Data Warehouse and Business Intelligence(SG24-5415-00) o Data Modeling Techniques for Data Warehousing(SG24-2238-00) o DB2 UDB Server for OS/390 and z/OS Version 7 Presentation Guide(SG24-6121-00) Go to http://www.redbooks.ibm.com and search on the publication number listed above. ************** Conferences *************************************** <43> IBM Life Sciences' Seminars IBM Life Sciences addresses the IT needs of pharmaceutical R&D, biotech companies, government, and academia as well as opportunities in devices and diagnostics and eHealth. The Life Sciences IT market is driven by the need for high performance computing, large capacity storage, data integration, and knowledge management solutions. Learn more about IBM Life Sciences' High Performance Information Infrastructure and Data and Knowledge Management solutions by attending the seminars described in the links below. To register now or to find out more about the seminar nearest you, simply click the appropriate link below or call 1-800-426-0889. High Performance Information Infrastructure Solutions Seminar http://www-3.ibm.com/solutions/lifesciences/seminars2.html Data and Knowledge Management Solutions Seminar http://www-3.ibm.com/solutions/lifesciences/seminars1.html <44> IBM Data Management Conference now include DB2 UDB for iSeries topics The IBM Data Management conference now includes iSeries (formerly AS/400) integration topics. These are not migration topics but how you can integrate your valuable iSeries assets in with the rest of the DB2 family and Informix to create the manageable and capable mixed IBM relational enterprise. These sessions can also serve as an intro to DB2 for iSeries for the DB2 professional. The topics are entitled: "So you have an iSeries (AS/400) with DB2 UDB in your network - now what?" and "Integrating DB2 UDB Data Management Tools with iSeries (AS/400)." They will be helpful for anyone new to DB2 for iSeries or who is already familiar with DB2 UDB, but just not on the iSeries platform. For more details and to enroll plus early registration discount information, visit our conference Web site at: http://www.ibm.com/services/learning/conf/us/dm?c=IBM_DB2Today&n=various&t=aff <45> Keynote and Featured Speakers at the IBM Data Management Technical Conference Join us at the IBM Data Management Technical Conference on September 9-13, 2002 at the Anaheim Convention Center, Anaheim, California. Hear the latest and greatest from all these executives and industry experts in one special event. Get innovative tips and techniques for harnessing IBM Data Management products as the engines behind all types of application solutions. Learn what's happening now and what's on tap next so you can stay a step ahead of trends and directions. Keynote and Featured speakers include: Janet Perna, GM IBM Data Management Solutions; Donald J. Haderle IBM Fellow & VP of Data Management Architecture and Technology; Bob Picciano, Director, Database Technology, IBM Canada Laboratory; Beth T. Smith, Director of Development, DB2 UDB for OS/390 and z/OS; Dr. Barry Devlin BI Executive Consultant; Don Top, VP, IBM Informix Product Development, IBM Data Management Solutions; and Susie Siegesmund, Business Unit Executive for U2. For more details and to enroll plus early registration discount information, visit our conference Web site at: http://www.ibm.com/services/learning/conf/us/dm?c=IBM_DB2Today&n=various&t=aff <46> Tool Time: Hands-On Sessions at the IMS Technical Conference The 2002 IMS Technical Conference(September 30 - October 3, 2002, Adam's Mark Hotel, St. Louis, Missouri) features a number of new tools hands-on sessions: last year's popular and newly updated -- session: IMS Connect Workshop: Creating Web Services Connecting to IMS with Ken Blackman and Suzie Wendler; Hands-on Workshop: Creating XML and Web Services Using IMS Source Files; and Tool test drives for IMS Performance Analyzer, IMS HALDB Conversion Aid, and IMS Database Control Suite. Although hands-on sessions are just one component of the IMS Technical Conference, they are simply the best way to stay current in a fast-moving technological environment! For more details and to enroll visit: http://www-3.ibm.com/services/learning/conf/us/ims/?c=IBM_DB2Today&N=various&t=aff <47> Web Lectures - IBM Life Sciences Web Lecture Series. On demand Web presentations with audio. Customers can learn about key topic areas and familiarize themselves with IBM Life Sciences solutions right from their desktop. Lectures cover key IBM research topics, and issues involving data & knowledge management....Coming soon: lectures on high performance computing and storage. Customers can register for the full lecture series at http://www.ibm.com/solutions/lifesciences/lectures1 <48> IBM DB2 User Group's (IDUG) education events around the world. IDUG 2002--Technical Symposium, 19-120 September 2002, Toronto, ON, Canada IDUG 2002--Europe, 21-24 October 2002, Lisbon, Portugal IDUG 2003--North America, 19-23 May 2003, Las Vegas, NV, USA http://www.idug.org <49> IDUG 2002--Europe Full Programme Information Available Full Programme information for IDUG 2002--Europe, 21-24 October, in Lisbon, Portugal is available online! This year, IDUG will be the premier DB2-specific education venue in Europe and will provide delegates with nearly 100 technical sessions from which to choose. Visit http://www.idug.org for details ================================================================== DB2 PRODUCT FAMILY ================================================================== *********** Data Management Tools ******************************** <50> IBM DB2 Utilities Migration Toolkit Now Available A combination of software and services, this Toolkit makes it easy for DB2 for z/OS and OS/390 Version 7 users to migrate from non-IBM utilities and successfully deploy IBM DB2 Utilities Suite. The tool automates the conversion process. On-site consulting to assist with the conversion is included in the package. Please contact your your IBM marketing representative for ordering information. http://www-3.ibm.com/software/data/db2imstools/db2tools/db2utilsuite.html ================================================================== SOLUTIONS ================================================================== ********** Business Intelligence ********************************* <51> United Airlines positions DB2 data warehouse as its backbone for CRM. Says Eric Dean, CIO for United Airlines, "We saw DB2 on the pSeries SP server as the best value, with the best price/performance ratio. IBM not only came to the table with this robust database, but also with airline expertise that we could leverage to populate our data warehouse quickly and build the necessary connections." http://www-3.ibm.com/software/success/cssdb.nsf/CS/NAVO-58NTD4?OpenDocument&Site=dmbi *********** Content Manager ************************************** <52> New Content Manager Brochures and updated White Paper Six new brochures and a significantly updated white paper "Generating return on information with an IBM enterprise content management infrastructure" will be posted at http://www-3.ibm.com/software/data/cm/library.html <53> General Content Manager News o Updated CD tells the story of IBM enterprise content management at https://www6.software.ibm.com/reg/cmcd/cmcd-i?S_TACT=102BGD50&S_CMP=__S_CMP__ o Enteprise Information Portal Brief at http://www-3.ibm.com/software/data/cm/pubs/ibm_ecm.pdf o An IDC brief describes Digital Asset Management at Coca-Cola' at https://www6.software.ibm.com/reg/cm/aimebus-i?S_PKG=OFFER_2 o A timely records management solution and white paper for the public sector at http://www-3.ibm.com/software/data/cm/erecords.html o New skills and technical resources for Content Manager OnDemand for Multiplatforms at http://www-3.ibm.com/software/data/ondemand/mp/ <54> OnDemand: Designing a Solution for Performance and User Satisfaction Tired of all that paper? IBM Content Manager OnDemand allows companies to manage large quantities of printed output, such as reports, invoices, or statements. This article is an introduction to OnDemand and gives scenarios for how to make OnDemand solutions user friendly and high performing. http://www7b.software.ibm.com/dmdd/library/techarticle/0205hann/0205hann.html <55> Customizing the IBM Content Manager OnDemand Administrative Client IBM Content Manager OnDemand allows companies to manage large quantities of printed output, such as reports, invoices, or statements. This article is your source for customizing the administrative client, in a matter of minutes. http://www7b.software.ibm.com/dmdd/library/techarticle/0206wagner/0206wagner.html ================================================================== INFORMIX PRODUCT FAMILY ================================================================== ************** Informix Products ********************************* <56> Informix Developer Zone: Tuning Informix DSS Queries Author Jack Parker describes how he was able to use the tuning techniques described in this article to bring the response time for one query down from 40 days to 15 minutes! http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/parker/part-1.pdf <57> Informix Developer Zone: Query Directives: Examples and Analysis Query directives offers us a world of opportunities to directly influence the optimizer's decision upon query execution plan. Unfortunately, not many programmers and developers pay attention to query directives and even fewer use query directives in their SQL statements and programs. In this article, author Jianing Fan describes in detail what query directives are and their role in query optimizing and performance and demonstrates how they work with some concrete examples. http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/0502fan/0502fan.html <58> Divide and Conquer: Using Fragmentation for Smart Data Access Table fragmentation is a major factor in the ability to process XPS queries efficiently. This article uses examples to explain the advantages and disadvantages of the different types of fragmentation. http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/0206metzger/0206metzger1.html <59> Load and Attach: Updating Data Warehouse Tables This article describes how to use external tables to load data quickly and efficiently into an XPS database. Tips and examples are provided for specific situations such as loading COBOL-formatted data and scrubbing data as you load it. http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/0206metzger/0206metzger2.html <60> New IIUG Insider Publication Circulates The IIUG Insider has replaced the IIUG Alert as IIUG's by-weekly e-mail Publication. Recent IIUG Insider highlights include: European Symposium Discount, SE 7.25 no charge Download, New Product White Paper, Software Repository News, IIUG Webmaster Warning, IBM Now Database King, Need 32 TB of Storage? New IBM Informix Training Web Site. You can find the latest issues at: http://www.iiug.org/news/insider.html <61> Its So Easy to Join IIUG for Member Benefits Take the few moments required to complete and submit the form and you'll join thousands of others who recognize that the IIUG "Speaks Informix". It is so simple to become an IIUG member by going to the IIUG Join page at: http://www.iiug.org/iiug/join.html. <62> New Downloads for IIUG Members International Informix User Group (IIUG) members can now download an evaluation copy of IBM Office Connect v.3.0 and the IBM Informix Product Portfolio v.3 in pdf form! Also available to members: IDS 9.3 SE 7.25, both for Linux or Windows 2000. http://www.iiug.org/members <63> A Flexible Way of Using sqlhosts from Your Java Classpath This article contains a sample program that enables applications to read sqlhosts file information from the Java classpath and by doing so, enable any Java application on your Informix server to read that information without having to make code changes. http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/nair/0204nair.html <64> Informix Developer Zone: Bringing Informix Dynamic Server Internals to the Surface This article highlights a number of fundamental concepts of the internals of Informix Dynamic Server to help you support and maintain it. http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/scranton/0204scranton.html <65> DSS Application Processing If you're an expert at tuning OLTP systems, you might want to forget most of that when you start looking at DSS systems. Using real examples, author Jack Parker walks you through DSS processing of inserts, updates, and deletes, and offers advice to make those processes run much faster http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/parker/0205parker.html ================================================================== SKILL AND EDUCATION ================================================================== ************* DB2 CERTIFICATION ********************************** <66> New Certification Exam Guide for DB2 Administration This authoritative reference offers complete coverage of all material on the DB2 exams. You'll find exam objectives at the beginning of each chapter, helpful exam tips, end-of-chapter practice questions, and photographs and illustrations. The bonus CD-ROM contains practice tests, and hundreds of questions. This guide will help you pass the certification exams, and serve as an on-the-job reference. Published by McGraw-Hill Osborne 01/2002. ISBN: 0072133759. Order it now. http://www.ibm.com/software/data/pubs/certbooks.html <67> DB2 Certification Program -- Registration and Sample Tests For detailed information on the DB2 Universal Database and Business Intelligence, Content Management and Informix certification tracks, including recommended education and sample tests, visit http://www-1.ibm.com/certify/certs/db_index.shtml and select the track you are interested in. Details on the registration process and test enrollment is available on http://www-1.ibm.com/certify/process/check.shtml <68> No Charge Voucher for Certification Exam The DB2 Certification Electronic Voucher Promotion for 2002 is being offered to candidates who score 75% or greater on a DB2 assessment exam. You will automatically be sent a voucher to take the final exam for your DB2 Certification at a testing center at no charge, which has a value up to $120. U.S per exam. This offer is valid for VUE, IBM Learning Services or Prometric test centers, depending on preference and geography. For full program details visit: http://www-3.ibm.com/software/data/db2/skills/voucher.html <69> Certification Made Easy with New DB2 Tutorials Six new Certification tutorials are now available to help you prepare for the DB2 Fundamentals Certification (Exam 512). These tutorials provide a solid base for each section of the exam. Each tutorial includes a link to a no charge DB2 Universal Database Enterprise Edition download. For more information on Data Management certification, visit the certification Web site. ************** CLASSES (DB2 & Informix) ************************** <70> No Charge Personalized Skills Plan Need practical guidance to achieving your individual skills goals or career roadmaps for your departmental organization? Let our Personalized Skill Plan guide you in building the right skills in current or new technologies. For more information visit http://www.ibm.com/software/data/db2/skills/ <71> Data Management Education and Offerings IBM Offers a wealth of Data Management Training and Skills Offerings to familiarize you and keep you up-to-date you on existing or emerging Data Management Technologies. Offerings from classroom courses, e-learning vehicles and self-paced learning are available to help you advance your career on these exciting technologies. For more information visit: http://www.ibm.com/software/data/db2/skills <72> New DM Tutorials and Redbooks Available DB2 for z/OS -- Load vs. Insert The rise of e-business applications have made the performance of mass inserts even more critical. The costs and benefits of LOAD vs. INSERT are presented for DB2 for z/OS. See: http://www-106.ibm.com/developerworks/nlredirects/r-d1151.html?np-115 <73> DB2 UDB family on common ground This tutorial explores the common aspects of the DB2 Universal Database family, including SQL, administration and query optimization. http://www-106.ibm.com/developerworks/nlredirects/r-d1152.html?np-115 <74> IBM Learning Services Data Management Classes For a list of courses scheduled go to the following URL: http://www.ibm.com/services/learning/spotlight/ <75> Fast Path to DB2 UDB for Experienced Relational DBAs (No Charge) This self-study course provides experienced Database Administrators (DBAs) with a way to quickly and easily gain skills in DB2 UDB. This fast path course can be completed in as little as eight hours and can be used to help prepare for certification Exam 513: DB2 UDB V7.1 for Unix, Linux, Windows and OS/2 Database Administration. Review of the DB2 Certification Guides for proper certification preparation is highly recommended following this course. To download the course, visit http://www-4.ibm.com/cgi-bin/software/track3.cgi?file=/software/data/db2/selfstudy/index.html&S_TACT=__S_TACT__&S_CMP=__S_CMP__ <76> DB2 UDB Programming Fastpath Course (No Charge) This computer based self-study course, DB2 UDB Programming Fastpath, is designed to teach experienced relational database programmers how to perform the basic database programming for a DB2 Universal Database system. It provides a fast path for acquiring the skills necessary to write programs against a DB2 UDB Database and can be used to help prepare for Exam 514: DB2 UDB V7.1 Application Development. To download the course, visit: http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=db2fastpath <77> New Certification Exam Guide for DB2 Administration All-In-One DB2 Administration Exam Guide (With CD-ROM) by Roger E. Sanders. This authoritative reference offers complete coverage of all material on the DB2 exams. You'll find exam objectives at the beginning of each chapter, helpful exam tips, end-of-chapter practice questions, and photographs and illustrations. The bonus CD-ROM contains practice tests, and hundreds of questions. This guide will help you pass the certification exams, and serve as an on-the-job reference. Published by McGraw-Hill Osborne 01/2002. ISBN: 0072133759. Order it now. http://www.ibm.com/software/data/pubs/certbooks.html ================================================================== 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 Business Intelligence Portfolio http://www.ibm.com/bi Information Integration http://www-3.ibm.com/software/data/integration/solution/ 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 sent to deadmail ****************************************************************** ______________________________________________________________________ This email was delivered by Responsys on behalf of IBM. Click here to view IBM's privacy practices: http://www.ibm.com/privacy/