Date: Thu, 27 Mar 2003 06:04:58 -0800 From: "DB2 Today" Subject: Welcome to Version 32 of DB2 Today ****************************************************************** ********* DB2 Today Issue 32 - March 2003 *********** ****************************************************************** Dear IBM, Join the IBM DB2 Universal Database .Net Enablement beta program NOW! Participate in the IBM DB2 Universal Database .NET Enablement beta program NOW! The IBM DB2 UDB .NET Data Provider is the first technology available for preview. This beta program is open to all programmers interested in developing applications that use the Microsoft .NET Framework to access DB2 UDB databases. To learn more about this beta program and to download the beta code, visit: http://www.ibm.com/cgi-bin/software/track0.cgi?i=20461&c=31001&o=1&ef=T&cn=1518109 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://www.ibm.com/cgi-bin/software/track0.cgi?i=9144&c=31001&o=2&ef=T&cn=1518109 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)Join the smallpox grid, join the fight (2)DB2 Universal Database for Multiplatforms V8.1 consistently provides a better cost of ownership than either Oracle or Microsoft (3)Autonomic computing: Tactics for a long-term strategy (4)New Student Newsletter (5)DB2 SQL Procedural Language for Linux, UNIX, and Windows by Yip, Bradstock, Curtis, Gao, Janmohamed, Liu, and McArthur (6)Meet the Experts: Irving Wladawsky-Berger on e-business on demand (7)Accessing Federated Databases with Application Server Components (8)Mainframe Total Cost of Ownership: Managing the cost equation (9)Check out The Mainstream -- a single view of up-to-date news for zSeries software. (10)Automatically Generating Sequences of Numeric Values in DB2 Universal Database (11)When We Think That the Optimizer Doesn't Get It Right (12)A UDF for File Output and Debugging from SQL ************************* Conferences **************************** (13)IBM developerWorks Live! the technical conference with more April 9 - 12, 2003 Morial Convention Center, New Orleans (14)IBM Insight Exchange (15)IBM Software Symposium 2003 (16)Content Management & WebSphere Portal Technical Conference June 9 - 11, 2003 Orlando, Florida (17)IMS Technical Conference September 15 - 18, 2003 Las Vegas, Nevada (18)IBM Data Management Technical Conference October 27 - 31, 2003 Las Vegas, Nevada ================================================================== DB2 PRODUCT FAMILY ================================================================== ******************* DB2 UDB for S/390 and z/OS ******************* (19)Check out The Mainstream - inaugural edition ********************** DB2 UDB for iSeries *********************** (20)Order your DB2 UDB for iSeries Informational CD (21)IBM eServer iSeries Announces new On-Demand Era ================================================================== SOLUTIONS ================================================================== ***************** Information Management Tools ******************* (22)New Data Encryption Tool Available from IBM Data Management Tools (23)IMS Seminars Coming to a City Near You Through April 2 (24)A new IMS Webcast Available Now (25)IBM provides an extensive portfolio of cost-effective data management mainframe tools ********************* DB2 Content Manager ************************ (26)IBM Announces DB2 Content Manager V8.2 and DB2 Records Manager V2.1 - Delivering information on demand ************************** e-business **************************** (27)Royal Bank of Canada and IMS Connect - A Winning Combination ================================================================== INFORMIX PRODUCT FAMILY ================================================================== ******************** Other Informix Products ********************* (28)IBM Data Management Chief Janet Perna Writes to the IIUG ================================================================== SKILL AND EDUCATION ================================================================== ********************** DB2 CERTIFICATION ************************* (29)Upgrade your DB2 UDB Certification to V8.1 for half the price! (30)Register today for developerWorks Live and get a free Certification Exam! (31)DB2 V8 Family fundamentals certification prep tutorials (32)NEW DB2 UDB V8.1 Study Guide Available Now! (33)NEW DB2 UDB V8.1 SQL Stored Procedures Guide Available Now! (34)Upgrade your DB2 UDB Certification Today! (35)Prepare for DB2 UDB V8.1 Certification with NEW Family Fundamentals Tutorials! (36)Take your career to the next level with NEW IBM DB2 UDB V8.1 Certification (37)New Education Center for IBM Software Program ************************* CLASSES ******************************* (38)Activate Web services (39)Develop, deploy and integrate on Linux (40)Invoking Web services from SQL: Integrating relational data with Web services (41)Multidimensional clustering in DB2 V8 (42)Using Python to access DB2 for Linux (43)Optimal DB2 performance with SQLJ and JDBC ****************************************************************** ************ ARTICLES *********** ****************************************************************** ================================================================== GENERAL ================================================================== **************************** News ******************************** (1)Join the smallpox grid, join the fight The availability of drugs to counter the smallpox virus after infection would be a major defense against the threat of bio terrorism. With this as the goal, IBM, United Devices, Accelrys and others have joined together in a public service project powered through a massive computing grid that will speed the analysis of approximately 35 million molecules against a series of protein targets related to smallpox. You yourself can participate and assist in this important effort. By downloading and running the United Devices Agent Screensaver, you add your CPU to the worldwide grid. Every time your computer is idle, you contribute your computing resource to the grid, accelerating the screening process while dramatically reducing the cost of the project. The result: Rather than spending years and millions - neither of which is any more affordable to screen hundreds of thousands of molecules, it will be possible to screen hundreds of millions of molecules in just months. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20363&c=31001&o=3&ef=T&cn=1518109 (2)DB2 Universal Database for Multi platforms V8.1 consistently provides a better cost of ownership than either Oracle or Microsoft According to a recent study published by Market Magic Research Ltd. (MMR), DB2 consistently provides a better cost of ownership than either Oracle or Microsoft. The study focuses on three application scenarios: an off-the-shelf application (like SAP, PS, JDE, etc.), a custom built web deployed application, and a BI or data warehouse implementation. In all three scenarios, DB2 provided the lowest cost over the 5 year period. The result is a straightforward comparison that highlights why customers must consider DB2 UDB V8.1. For the complete report visit http://www.ibm.com/cgi-bin/software/track0.cgi?i=20361&c=31001&o=4&ef=T&cn=1518109 (3)Autonomic computing: Tactics for a long-term strategy Autonomic computing represents a collection and integration of technologies that enable the creation of an information technology computing infrastructure for IBM's agenda for the next era of computing - e-business on demand. This paper presents an overview of IBM's autonomic computing initiative. It examines the genesis of autonomic computing, the industry and marketplace drivers, the fundamental characteristics of autonomic systems, a framework for how systems will evolve to become more self-managing, and the key role for open industry standards needed to support autonomic behavior in heterogeneous system environments. Find out more information on autonomic computing. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20362&c=31001&o=5&ef=T&cn=1518109 (4)New Student Newsletter Attention all students! Sign up now to receive the IBM Student Newsletter, an e-mail newsletter with information about special offers and resources specifically for you! http://www.ibm.com/cgi-bin/software/track0.cgi?i=18949&c=31001&o=6&ef=T&cn=1518109 (5)DB2 SQL Procedural Language for Linux, UNIX, and Windows by Yip, Bradstock, Curtis, Gao, Janmohamed, Liu, and McArthur DB2 SQL Procedural Language for Linux, UNIX, and Windows is a comprehensive guide on writing database applications using SQL Procedural Language (or SQL PL in short). SQL PL is an easy to learn language that can be used to write stored procedures, triggers and user-defined functions. Written by experts from the IBM Toronto Lab, this book is filled with examples and expert tips with coverage of everything from basic program structure to advanced techniques. Available now from your favorite online retailer using ISBN: 0-13-100772-6. (6)Meet the Experts: Irving Wladawsky-Berger on e-business on demand Read this Q&A with Dr. Irving Wladasky-Berger,IBM general manager for e-business on demand, for a quick and easy way to get up to speed on the basic technologies behind IBM's directions for the e-business on demand era. http://www.ibm.com/cgi-bin/software/track0.cgi?i=18948&c=31001&o=7&ef=T&cn=1518109 (7)Accessing Federated Databases with Application Server Components A key aspect of e-business on demand is "virtualization" -- the ability to hide the disparity of data sources from a user or application. This experienced-based article describes how a federated DBMS, such as DB2 Information Integrator, and Web application server technologies can be combined to provide Java developers with new options for integrating data from a variety of sources. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20367&c=31001&o=8&ef=T&cn=1518109 (8)Mainframe Total Cost of Ownership: Managing the cost equation The notion of affordability resonates with everyone and drives us to continue to invest more in order to deliver the affordable capability our customers need. The business of reducing TCO by adding value boils down to one word-- affordability. IBM executives share views about a TCO story that is inherent in the technical advantages of the mainframe. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20362&c=31001&o=9&ef=T&cn=1518109 (9)The Mainstream - the IBM zSeries and S/390® software newsletter is designed to shorten your path to the information you need. Published six times a year , the newsletter will offer a snapshot of recent additions to our Web site - a high-altitude overview with links to the down-to-earth details. It includes articles on strategic issues facing businesses. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20362&c=31001&o=10&ef=T&cn=1518109 (10)Automatically Generating Sequences of Numeric Values in DB2 Universal Database Using examples, our SQL experts show you typical uses of identity columns and the recently introduced sequence objects to automatically generate numeric values. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20364&c=31001&o=11&ef=T&cn=1518109 (11)When We Think That the Optimizer Doesn't Get It Right Taken from real life experience, author Alexander Kuznetsov shows you some simple tips to make sure the optimizer makes good decisions for your queries. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20366&c=31001&o=12&ef=T&cn=1518109 (12)A UDF for File Output and Debugging from SQL This sample user-defined function (UDF) makes it easy to write output to a file from SQL. This capability is especially useful in debugging stored procedures. Sample code is included. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20365&c=31001&o=13&ef=T&cn=1518109 ************************* Conferences **************************** (13)IBM developerWorks Live! the technical conference with more April 9 - 12, 2003 Morial Convention Center, New Orleans Join us at IBM developerWorks Live! - the premier technical event of the year. Connect with other DBAs, application developers, I/T architects, and Webmasters who need to federate data, integrate information and manage infrastructure across multiple platforms. We'll explore problem solving and the future of innovation in great depth with great minds. Scalable, available, secure e-business and e-business on demand solutions are the goal. Start planning your conference schedule with the Agenda Builder tool today! Registration is open at http://www.ibm.com/cgi-bin/software/track0.cgi?i=20371&c=31001&o=14&ef=T&cn=1518109 (14)IBM Insight Exchange Do you need the real answers instead of the hype you've heard so often? The IBM Insight Exchange(TM) Business Partner initiative brings you two web cast speakers each month to 1) answer questions to real-world issues for your and your customers' businesses and 2) present the technical topics that can help you stay ahead of the pack. Since the launch of IBM Insight Exchange in January of this year, the feedback and participation has been very positive! Over 1000 people registered for each of the first two inaugural web casts! Join us for the upcoming Insight Exchange web casts that promise to be just as informative and valuable. March 26, 2003 How to Compete in a Chaotic Economy, featuring Todd Buchholz, Former White House Economic Advisor and Renowned Expert on Global Economic Trends 11-12:30 ET, 4-5:30 GMT Sign up today at: http://www.ibm.com/cgi-bin/software/track0.cgi?i=20368&c=31001&o=15&ef=T&cn=1518109 April 11, 2003 (Live event) Autonomic computing and its impact on the future of development (Live event), featuring Alan Ganek, IBM Vice President of Autonomic Computing at developerWorks Live in New Orleans, Louisiana - April 9-12th! Session E1089 For more information to sign up today: http://www.ibm.com/cgi-bin/software/track0.cgi?i=20370&c=31001&o=16&ef=T&cn=1518109 April 23, 2003 Homeland Security -- Emerging IT Opportunities, featuring General Bob Winglass, Distinguished retired member of the US Marine Corps 11-12:30 ET, 4-5:30 GMT Sign up today at: http://www.ibm.com/cgi-bin/software/track0.cgi?i=20369&c=31001&o=17&ef=T&cn=1518109 If you were unable to attend the first 3 events, a replay of each is available for 90 days. Spread the word among your colleagues! Find out more about these speakers and other IBM Insight Exchange events at: http://www.ibm.com/cgi-bin/software/track0.cgi?i=17370&c=31001&o=18&ef=T&cn=1518109 (15)IBM Software Symposium 2003 The IBM Software Symposium (May 19-23,2003,Munich) is an outstanding opportunity for you to gain valuable information about IBM's industry-leading software solutions.There will be more than 100 electives , birds of a feather and hands-on sessions on IBM's Information Management Software. There will be many opportunities to learn more about Lotus, Tivoli, WebSphere and Rational as well as IBM Software Strategy and Solutions. You can also find out more about our new product DB2 Information Integrator and about IBM's e-business on demand strategy. Through the whole programme you will have the opportunity to meet IBM product specialists. Please visit the following link and if you enroll before March 28 you can benefit from "early bird" pricing !!! http://www.ibm.com/cgi-bin/software/track0.cgi?i=16441&c=31001&o=19&ef=T&cn=1518109 (16)Content Management & WebSphere Portal Technical Conference June 9 - 11, 2003 Orlando, Florida Join us for one of 2003's most comprehensive and knowledge packed technical events. Experience the power of DB2 Content Manager & WebSphere Portal, and learn how to capture, store, create, organize, manage, control and publish information on demand. Bookmark and visit our web site in the coming months to get all the latest details at http://www.ibm.com/cgi-bin/software/track0.cgi?i=20372&c=31001&o=20&ef=T&cn=1518109 (17)IMS Technical Conference September 15 - 18, 2003 Las Vegas, Nevada Join us for a unique experience to learn about the new and enhanced IMS V7 and V8 technologies for transforming your business into an e-business superhighway. Hear the hottest topics from key executives and the latest tricks and techniques from product developers and technical experts. Visit our web site in the coming months to get all the latest details at http://www.ibm.com/cgi-bin/software/track0.cgi?i=20374&c=31001&o=21&ef=T&cn=1518109 (18)IBM Data Management Technical Conference October 27 - 31, 2003 Las Vegas, Nevada Experience the best of DB2 UDB, BI, IBM Informix, IBM U2, and Information Integration at the premier educational forum for the DB2 Information Management Software family. Discover how IBM has integrated all these products into a seamless set of solutions and gain a perspective on the latest changes to this IBM product portfolio. Visit our web site to get all the up-to-the-minute details at: http://www.ibm.com/cgi-bin/software/track0.cgi?i=20373&c=31001&o=22&ef=T&cn=1518109 ================================================================== DB2 PRODUCT FAMILY ================================================================== ******************* DB2 UDB for S/390 and z/OS ******************* (19)Check out The Mainstream - inaugural edition The Mainstream - the IBM zSeries and S/390® software newsletter is designed to shorten your path to the information you need. Published six times a year, the newsletter will offer a snapshot of recent additions to our Web site - a high-altitude overview with links to the down-to-earth details. It includes articles on strategic issues facing businesses. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20362&c=31001&o=23&ef=T&cn=1518109 ********************** DB2 UDB for iSeries *********************** (20)Order your DB2 UDB for iSeries Informational CD This informative CD includes video clips from leading DB2 UDB for iSeries engineers detailing the strategy, directions, and unique advantages that the iSeries architecture provides to this Relational Database Management System. Links to pertinent web-sites keep you up to date with the latest information available, including beta programs, trial software, and more http://www.ibm.com/cgi-bin/software/track0.cgi?i=20376&c=31001&o=24&ef=T&cn=1518109 (21)IBM eServer iSeries Announces new On-Demand Era In January, the IBM eServer iSeries announced new models, enhanced software including a new version of DB2 UDB for iSeries, new software packaging options, and new On-Demand features. With DB2 UDB for iSeries, you can leverage common hardware for Linux, Unix, Windows and OS/400 applications with dynamic logical partitioning and On/Off Capacity on demand features. http://www.ibm.com/cgi-bin/software/track0.cgi?i=4221&c=31001&o=25&ef=T&cn=1518109 ================================================================== SOLUTIONS ================================================================== ***************** Information Management Tools ******************* (22)New Data Encryption Tool Available from IBM Data Management Tools IBM Data Encryption for IMS and DB2 Databases is a tool that enables you to protect sensitive and private data for both IMS and DB2 in a single product. Implemented via standard IMS and DB2 exits, it saves you the time and effort required to write and maintain your own encryption software. Enables you to comply with security legislation such as HIPAA and GLBA. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20378&c=31001&o=26&ef=T&cn=1518109 (23)IMS Seminars Coming to a City Near You Through April 2 IBM invites you to attend a seminar to hear the latest news about IMS and IMS Tools. Join us for a power-packed day on leading edge data technology. Learn about the new features of IMS Version 7, what Version 8 has to offer, and how IBM IMS Tools support both versions. See our web site for information on locations and dates (March 11 through April 2). http://www.ibm.com/cgi-bin/software/track0.cgi?i=20377&c=31001&o=27&ef=T&cn=1518109 (24)A new IMS Web cast Available Now A new web cast held on March 18 covered IMS Integration in new application development and the connectivity aspects of IMS V8. A replay of this web cast is now available. See the DM Tools web site for details. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20377&c=31001&o=28&ef=T&cn=1518109 (25)IBM provides an extensive portfolio of cost-effective data management mainframe tools IBM provides an extensive portfolio of cost-effective mainframe tools. IBM data management tools are specially designed to enhance the performance of IBM DB2 Universal Database and IBM IMS for z/OS and OS/390 and are grouped in four functional categories: Database administration - Streamline your database management tasks and improve overall system availability with tools like DB2 Administration Tool and IMS Database Control Suite; Performance management - Facilitate peak operation levels even under high demand using DB2 Performance Expert and IMS Performance Analyzer; Recovery and replication - Address your backup and recovery requirements, with IBM Application Recovery Tool for IMS and DB2 and handle complex replication problems with DB2 DataPropagator and IMS DataPropagator; Application management tools support rapid global data access to your information using DB2 Web Query Tool and IMS Connect. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20379&c=31001&o=29&ef=T&cn=1518109 ********************** DB2 Content Manager *********************** (26)IBM Announces DB2 Content Manager V8.2 and DB2 Records Manager V2.1 - Delivering information on demand On March 11, 2003 IBM publicly announced new software that will provide customers with the most comprehensive offerings to digitize, access and manage all forms of information across the enterprise and link it to core business processes, including Web application integration, Web content publishing and rich media. In addition, IBM is introducing new records management software to help customers digitally manage the entire lifecycle of their business information and more easily comply with record keeping mandates and regulatory guidelines. The enhanced software enables customers to integrate records management functionality into their existing business applications, allowing them to increase productivity and reduce paper costs. For more information go to: http://www.ibm.com/cgi-bin/software/track0.cgi?i=13290&c=31001&o=30&ef=T&cn=1518109 Now Get Certified on Content Manager & Content Manager OnDemand V8: http://www.ibm.com/cgi-bin/software/track0.cgi?i=20381&c=31001&o=31&ef=T&cn=1518109 ************************** e-business **************************** (27)Royal Bank of Canada and IMS Connect - A Winning Combination Canada's largest bank uses IBM IMS Connect and WebSphere Application Server (WAS/390) for its Internet banking application which currently draws up to 3 million page hits per day. Now customers can open new accounts and easily access their legacy data on the Web. RBC's online banking has put a new focus on true 24x7 IMS availability. Read the complete story. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20362&c=31001&o=32&ef=T&cn=1518109 ===================================================================== INFORMIX PRODUCT FAMILY ===================================================================== ********************** Other Informix Products ********************** (28)IBM Data Management Chief Janet Perna Writes to the IIUG The International Informix Users Group (IIUG) has posted an open letter from Janet Perna to the IIUG community to express appreciation for continued support in 2002, review successes during the past year and look forward to the continued support plans for Informix products in 2003. The entire text of Janet's letter may be read at: http://www.ibm.com/cgi-bin/software/track0.cgi?i=20401&c=31001&o=33&ef=T&cn=1518109 ================================================================== SKILL AND EDUCATION ================================================================== ********************* DB2 CERTIFICATION ************************** (29)Upgrade your DB2 UDB Certification to V8.1 for half the price! Take advantage of the new DB2 UDB voucher offer to quickly upgrade your Database Administration V7.1 certification to V8.1. For a limited time, you may qualify for a voucher to receive 50% off the registration fee for the new V8.1 certification exam 706 -- DB2 UD V8.1 for Linux, UNIX and Windows Database Administration Upgrade Exam For more information please visit: http://www.ibm.com/cgi-bin/software/track0.cgi?i=20423&c=31001&o=34&ef=T&cn=1518109 (30)Register today for developerWorks Live and get a free Certification Exam! Join us in New Orleans on April 9th-12th for developerWorks Live! Your conference package includes one opportunity to take an IBM Professional Certification exam at the conference for no additional cost. Take advantage of this complimentary exam and use it toward one of the new DB2 UDB V8.1 exams! You may schedule and take subsequent tests at the conference for additional fees. For more details or to register visit: http://www.ibm.com/cgi-bin/software/track0.cgi?i=20422&c=31001&o=35&ef=T&cn=1518109 (31)DB2 V8 Family fundamentals certification prep tutorials This series of six tutorials is designed to help you prepare for the DB2 (Version 8) Fundamentals Certification (Exam 700). Each tutorial includes a link to download a free trial version of DB2 Universal Database Enterprise Edition. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20427&c=31001&o=36&ef=T&cn=1518109 (32)NEW DB2 UDB V8.1 Study Guide Available Now! Data Management Certification has released a new self study guide for exams 700 and 701, DB2 Universal Database V8.1 for Linux, UNIX, and Windows Database Administration Certification Guide. Take the next step in becoming an IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX and Windows and get the guide today: http://www.ibm.com/cgi-bin/software/track0.cgi?i=20421&c=31001&o=37&ef=T&cn=1518109 (33)NEW DB2 UDB V8.1 SQL Stored Procedures Guide Available Now! A new Data Management Book has just been released, DB2 SQL Procedural Language for Linux, Unix and Windows. This book was written by Yip, Bradstock, Curtis, Gao, Janmohamed, McArthur and Liu. Get this new book today: http://www.ibm.com/cgi-bin/software/track0.cgi?i=20424&c=31001&o=38&ef=T&cn=1518109 (34)Upgrade your DB2 UDB Certification Today! It has never been so easy to upgrade your DBA certification to the current level, V8.1. If you are certified as an IBM Certified Solutions Expert - DB2 UDB V7.1 for UNIX, Linux, or Windows Database Administrator, you can upgrade to V8.1 immediately by taking the DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Upgrade Exam (706). This test is a much shorter in comparison to our other exams with only 30 questions. The exam focuses on the new features and functions of DB2 UDB Version 8 and it is half the price of our traditional DB2 UDB exams. To upgrade today or for more information, please visit: http://www.ibm.com/cgi-bin/software/track0.cgi?i=8012&c=31001&o=39&ef=T&cn=1518109 (35)Prepare for DB2 UDB V8.1 Certification with NEW Family Fundamentals Tutorials! Get a jump-start on becoming an IBM Certified Database Associate for the DB2 Universal Database V8.1 Family with six new tutorials. This series of tutorials will help prepare you for Certification Exam 700, DB2 Family Fundamentals, the exam required to achieve the Database Associate for DB2 Universal Database V8.1 Family level of certification. Register and download the tutorials today: http://www.ibm.com/cgi-bin/software/track0.cgi?i=20427&c=31001&o=40&ef=T&cn=1518109 (36)Take your career to the next level with NEW IBM DB2 UDB V8.1 Certification Give a jump-start to your career in this rapidly growing database marketplace! Becoming IBM certified will validate your skills, and give you a competitive advantage in the job market. Begin your certification experience by taking one of our brand New comprehensive DB2 V8.1 exams. IBM offers a variety of resources specifically designed to help prepare for our exams as well. For complete exam preparation information and the new V8.1 exams available, please visit http://www.ibm.com/cgi-bin/software/track0.cgi?i=20426&c=31001&o=41&ef=T&cn=1518109 (37)New Education Center for IBM Software Program The Education Center for IBM Software Program is a cross-brand education channel powered by IBM Business Partners. The IBM ECIS initiative provides training and enablement designed to help companies grow information technology skills. IBM ECIS addresses the need for rapid employee training to sustain competitive advantage. For more information please visit: http://www.ibm.com/cgi-bin/software/track0.cgi?i=20425&c=31001&o=42&ef=T&cn=1518109 ************************* CLASSES ******************************* (38)Activate Web services The latest release of WebSphere Studio Application Developer and WebSphere Application Server incorporate the technologies necessary to help you create and deploy Web services. Find out more at this 3-day no-charge workshop. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20442&c=31001&o=43&ef=T&cn=1518109 (39)Develop, deploy and integrate on Linux Find out how to install and configure IBM middleware, and to develop on Linux, in this 2-day no-charge workshop. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20441&c=31001&o=44&ef=T&cn=1518109 (40)Invoking Web services from SQL: Integrating relational data with Web services Developing applications that access both Web services and database management systems can be an overwhelming task. It doesn't need to be. This tutorial demonstrates an easier way to generate user-defined functions (UDFs) that provide access to Web services from database applications. The generated UDFs can be used in SQL statements to combine relational data with dynamic data retrieved from a Web service. Several different examples are provided. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20448&c=31001&o=45&ef=T&cn=1518109 (41)Multidimensional clustering in DB2 V8 Multidimensional clustering is a unique new feature in DB2 Version 8.1 that is designed to improve the performance of large DB2 databases, particularly data warehouses and data marts, and dramatically improve the speed for record retrieval. This tutorial is designed to help developers understand the concepts behind multidimensional clusters as well as how to implement them. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20446&c=31001&o=46&ef=T&cn=1518109 (42)Using Python to access DB2 for Linux Python is a great tool to use with DB2 Version 8. It combines the ability to quickly and simply access a DB2 database with the power to perform more complex tasks that require a general-purpose programming language. Learn about the Python DB2 module using the sample that ships with DB2 Version 8.1. By the end of the tutorial developers will have received a thorough introduction to the entire Python DB2 interface. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20447&c=31001&o=47&ef=T&cn=1518109 (43)Optimal DB2 performance with SQLJ and JDBC JDBC and SQLJ are used to access databases in your Java programs. This tutorial introduces SQLJ and JDBC and covers some of the ways to take advantage of the features of SQLJ when accessing DB2 to achieve the best overall performance in your Java programs. http://www.ibm.com/cgi-bin/software/track0.cgi?i=20450&c=31001&o=48&ef=T&cn=1518109 ================================================================== HELPFUL WEBSITES ================================================================== To see back issues of DB2 Today, please visit: http://www.ibm.com/cgi-bin/software/track0.cgi?i=9131&c=31001&o=49&ef=T&cn=1518109 IBM Data Management Home Page: http://www.ibm.com/cgi-bin/software/track0.cgi?i=5523&c=31001&o=50&ef=T&cn=1518109 Events Calendar: http://www.ibm.com/cgi-bin/software/track0.cgi?i=5526&c=31001&o=51&ef=T&cn=1518109 Case Studies: http://www.ibm.com/cgi-bin/software/track0.cgi?i=5529&c=31001&o=52&ef=T&cn=1518109 IBM Business Intelligence Portfolio http://www.ibm.com/cgi-bin/software/track0.cgi?i=9121&c=31001&o=53&ef=T&cn=1518109 Information Integration http://www.ibm.com/cgi-bin/software/track0.cgi?i=9110&c=31001&o=54&ef=T&cn=1518109 IBM Faculty Portal: http://www.ibm.com/cgi-bin/software/track0.cgi?i=9139&c=31001&o=55&ef=T&cn=1518109 Business Partners Solutions: http://www.ibm.com/cgi-bin/software/track0.cgi?i=5528&c=31001&o=56&ef=T&cn=1518109 DB2 UDB for Windows: http://www.ibm.com/cgi-bin/software/track0.cgi?i=9130&c=31001&o=57&ef=T&cn=1518109 IBM Data Management Tools: http://www.ibm.com/cgi-bin/software/track0.cgi?i=4542&c=31001&o=58&ef=T&cn=1518109 DB2 Magazine (register for a free subscription): http://www.ibm.com/cgi-bin/software/track0.cgi?i=9118&c=31001&o=59&ef=T&cn=1518109 IBM Data Management Education: http://www.ibm.com/cgi-bin/software/track0.cgi?i=5525&c=31001&o=60&ef=T&cn=1518109 IBM Informix Product Family: http://www.ibm.com/cgi-bin/software/track0.cgi?i=5527&c=31001&o=61&ef=T&cn=1518109 IBM Content Manager portfolio: http://www.ibm.com/cgi-bin/software/track0.cgi?i=9127&c=31001&o=62&ef=T&cn=1518109 IBM & Siebel for Customer Relationships: http://www.ibm.com/cgi-bin/software/track0.cgi?i=9120&c=31001&o=63&ef=T&cn=1518109 DB2 with the PeopleSoft application: http://www.ibm.com/cgi-bin/software/track0.cgi?i=9136&c=31001&o=64&ef=T&cn=1518109 DB2 with the SAP application: http://www.ibm.com/cgi-bin/software/track0.cgi?i=9137&c=31001&o=65&ef=T&cn=1518109 DB2 with the Baan application: http://www.ibm.com/cgi-bin/software/track0.cgi?i=9135&c=31001&o=66&ef=T&cn=1518109 Global Learning Services: http://www.ibm.com/cgi-bin/software/track0.cgi?i=5522&c=31001&o=67&ef=T&cn=1518109 DB2 Developer Domain: http://www.ibm.com/cgi-bin/software/track0.cgi?i=9132&c=31001&o=68&ef=T&cn=1518109 ================================================================== 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/