Date: Thu, 14 Aug 2003 12:44:18 +0000 (CUT) From: IBM DB2 Information Management Software Subject: DB2 Information Management Software Today newsletter DB2 Information Management Software Today newsletter Welcome to the August issue of IBM DB2 Information Management Software Today, delivering the latest exciting news on DB2, Informix, U2 and the DB2 Content Manager portfolio of solutions. Have you made your plans to attend the upcoming IBM Data Management Technical Conference, Oct 27-31, 2003? Don't miss this opportunity to build your data management skills, take advantage of the no-charge professional certification testing, ask questions of a panel of IBM executives, network and learn about all of the IBM DB2 information management software solutions, products and services. Join us in Las Vegas, Nevada and benefit from the challenging sessions by IBM DB2 information management software solutions executives, product developers, prominent practitioners and IBM IT Education Services, Informix and U2 top instructors. Read on to learn more! Don't forget that you can customize your newsletter to receive only the information that interests you. Update your profile to receive the newsletter in a convenient HTML format. https://www6.software.ibm.com/reg/dm-db2modify/dm-db2modify-r Do you have colleagues that would find value in this newsletter? Please forward it on! We welcome new readers to subscribe and customize the newsletter to accommodate their interests in IBM DB2 information management software solutions. http://www.ibm.com/software/data/db2infonews/ We hope you find the information contained within this months newsletter to be valuable. We welcome and encourage your feedback on the information we bring to you monthly. Please send any comments that you may have to imstodayatus.ibm.com. In This Month's Issue: ====================== Offers o IBM OEM Software Agreement - Entry OEM Events o 2003 IMS Technical Conference - September 15-18, Las Vegas, NV o IBM Data Management Technical Conference: Enroll by September 8, 2003 to get the Early Registration Price of $1695 a savings of $150! DB2 Information Mangement Software Product Line o DB2 and zSeries Executive QA IBM Informix Product Line o Just the facts! o FourGen Business Accounting Software Supported by Gillani, Inc. e-business on demand o Delivering the vision: autonomic computing Technical Corner o Overview of Java Development in DB2 UDB for Linux, UNIX, and Windows: Version 8.1 Update o An Introduction to DB2 UDB Express GUI tools (Part 1) o ASP.NET Web Forms With DB2 UDB Tables Using C#Builder and BDP for .NET o Migrating Recursive SQL from Oracle to DB2 UDB o Pagination using DB2 UDB and JSPs o An Introduction to DB2 UDB Scripting on Windows o Leverage Microsoft SQL Server 2000 Skills to Learn DB2 UDB Version 8 o Porting to DB2 Universal Database Version 8.1 from Sybase Adaptive Server Enterprise o An Introduction to DB2 UDB Express GUI tools (Part 2) o Meet the Experts: Connie Nelin on DB2 Application Development Tools o Porting to DB2 UDB Express 8.1 from SQL Server 2000 o Using Hitachi 9900V ShadowImage and TrueCopy with IBM DB2 Universal Database Enterprise Server Edition Version 8.1 o Copying Your SAP/R3 System Across Platforms Using DB2 Universal Database V8 Redirected Restore o Book: DB2 UDB v8 Handbook for Windows, UNIX and Linux o Migrating From Microsoft SQL Server to IBM DB2 UDB Using Borland C#Builder Certification o Time to redeem your free DB2 UDB Professional Certification Voucher Training Classes o *Updated* (CF710) DB2 Stored Procedures Programming Workshop* 2 days * $995 USD Web Casts and e-Learning o Developing a VB.NET Federated Application for Microsoft Access o Building Web Services with C# and DB2 (updated) o Have you heard? The New DB2 UDB Administration Fastpath Course is Free! o Building Web Services with DB2 UDB, Java, and .NET o Developing a DB2 Application Using WebSphere MQ and Visual Studio .NET o Xquery: A Query Language for XML Webcast September 3 o Larry Downes Webcast on Digital Strategy and the Customer September 24 Support and Services o Skills White Paper concludes IBM meets the database skills challenge o Now available the NEW Problem Determination Mastery Exam for DB2 Universal Database (UDB) o Prepare for the New Problem Determination Mastery Exam with the Problem Determination Tutorials o Check out the NEW DB2 Information Management Books Web site! o Hot off the Press, the latest Certification guide for DB2 UDB V8.1 Application Development ------------------------------------------------------------ Offers ------------------------------------------------------------ IBM OEM Software Agreement - Entry OEM Are you a small to mid-size DB2 or Informix ISV interested in: --a simple and compatible migration path to an IBM contractual agreement? --a desirable contract with T&C's particularly attractive to a Business Partner who sells IBM products as part of their application? --an agreement that is positioned within the existing portfolio of IBM software group's existing offerings -- DB2, WebSphere, Tivoli and/or Lotus software -- so that it satisfies contract requirements for certain mid-size and lower end ISVs better than existing agreements? If this sounds interesting, then the IBM Entry OEM Agreement might be right for you. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D70 ------------------------------------------------------------ Events ------------------------------------------------------------ 2003 IMS Technical Conference - September 15-18, Las Vegas, NV Whether you're new to IMS or a seasoned veteran, take advantage of the opportunity to update your skills at the 2003 IMS Technical Conference. Experience 3 1/2 days of technical presentations, live demonstrations and hands-on labs. Explore how you can improve systems and data management capabilities with the latest IMS tools. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D25 IBM Data Management Technical Conference: Enroll by September 8, 2003 to get the Early Registration Price of $1695 a savings of $150! IBM Data Management Technical Conference: Usability Evaluation and Feedback Sessions (Highlighting - DB2, BI, Informix, U2 and Information Integration Sessions) -- This year, a new opportunity awaits you at the IBM Data Management Technical Conference (October 27-31 in Las Vegas). You'll have the ability to see what IBM is planning (before it is announced) and directly impact a variety of data management products! Representatives from several IBM development teams will be conducting usability evaluation and feedback sessions on a wide variety of topics. See what the teams are planning for upcoming releases, and have direct and early input into the features that are most important to you. Note that in most cases, you do not have to currently own the product to participate. Details are listed in each session's abstract. The number of participants that can be accommodated will be very limited in order to give you the time to work with the products and the team. Sign-ups will be on a first come, first served basis. Check out the session schedule on our conference web site and then send an e-mail to Thyra Rauch (trauchatus.ibm.com) to sign up. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D28 ------------------------------------------------------------ DB2 Information Mangement Software Product Line ------------------------------------------------------------ DB2 and zSeries Executive QA Version 8 builds on many of the themes from Version 7. It is the twelfth and largest release of DB2 for the MVS family of operating systems. It brings new synergy to the zSeries hardware and uses the z/OS 64-bit virtual addressing capabilities. Read the complete Executive Q&A document to find fast answers to questions you might have about IBM DB2 and zSeries. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D52 ------------------------------------------------------------ IBM Informix Product Line ------------------------------------------------------------ Just the facts! As IBM competitors continue to try to misinform our customers, IBM has updated the FACTS about how we intend to continually support, enhance and maintain these important servers and tools. The IBM Informix Product White Paper is now available on-line. In this fourth version, updates to product road maps, 'arrowhead' conversion, and IBM's positioning of our database products should clarify IBM's staunch support of the Informix products. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D24 FourGen Business Accounting Software Supported by Gillani, Inc. Gillani, Inc., the owner of all FourGen Software including FourGen CASE Tools (formerly bundled by Informix with 4GL as I-4GL Forms & Menus), FourGen Business Accounting, FourGen Enterprise & Endura Enterprise, offers a 25% discount to any customer globally with expired support, wishing to renew. Thousands of FourGen users globally run older FourGen versions including FourGen Business Accounting V3.83. Gillani has upgraded these products to V8.1, and made them available on Linux platform as well as latest AIX, HPUX and Solaris versions. http://www.gillani.com/FourGenBusinessAcct.htm ------------------------------------------------------------ e-business on demand ------------------------------------------------------------ Delivering the vision: autonomic computing Although many people have perceived the IBM e-business on demand initiative as a complex undertaking, the fact is, it is devoted to simplicity. In many powerful ways, the Internet has simplified our lives - but it has also complicated our IT systems by orders of magnitude. Now we are face-to-face with conflicting demands: cut IT costs, but at the same time improve efficiency and customer service. The only way to do that is to "make complexity simple." Autonomic computing is a cornerstone of the e-business on demand initiative and the new era of simplicity it is bringing. It is predicated on systems that are self-configuring, self-healing, self-optimizing, and self- protecting. In the words of Dr. Paul Horn, IBM Senior VP and Director of Research, "Building an autonomic computing network is not optional; in fact, the future of e-business and the Internet depends on it." This article reports on the state of the autonomic art in key IBM technologies. It also offers a sense of the priorities we face to make it happen. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D51 ------------------------------------------------------------ Technical Corner ------------------------------------------------------------ Overview of Java Development in DB2 UDB for Linux, UNIX, and Windows: Version 8.1 Update A lot has changed in DB2 UDB V8 for Java support. This article pulls it all together and answers common questions, too. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D1 An Introduction to DB2 UDB Express GUI tools (Part 1) This article introduces you to the GUI tools for DB2 UDB Express on DB2 UDB for Linux, UNIX, and Windows Version 8 and describes how to use them for performing basic database operations, restricting access to objects, and setting up connectivity. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D15 ASP.NET Web Forms With DB2 UDB Tables Using C#Builder and BDP for .NET This article shows you how to build an application using IBM DB2 UDB tables, C#Builder, and BDP for .NET, and then deploy it as an ASP.NET Web form (with a powerful asp:DataGrid control), so users can work with the DB2 UDB tables using a Web browser. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D17 Migrating Recursive SQL from Oracle to DB2 UDB After describing how recursive SQL works and what kinds of problems it solves, the author explains how to solve a problem which may occur when you migrate applications that use recursive SQL from Oracle to DB2 UDB. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D18 Pagination using DB2 UDB and JSPs This article explains how to display DB2 UDB search results in chunks of pages either through using the rownext() feature provided in the product, or by using a Java stateful bean or HttpSession. It also details the pros and cons of each method. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D19 An Introduction to DB2 UDB Scripting on Windows This article is the first in a series of articles on DB2 UDB and Windows scripting. This article shows database administrators how to script administration tasks with DB2 UDB on the Windows operating systems. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D2 Leverage Microsoft SQL Server 2000 Skills to Learn DB2 UDB Version 8 This article shows Microsoft SQL Server 2000 administrators how to leverage their SQL Server knowledge to quickly gain skills on DB2 UDB for Linux, UNIX, and Windows Version 8. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D20 Porting to DB2 Universal Database Version 8.1 from Sybase Adaptive Server Enterprise This article introduces DB2 UDB products and their capabilities, discusses porting databases and applications, and describes the most important aspects of porting applications from Sybase Adaptive Server Enterprise to DB2 UDB V8. It describes the differences between the two products in database options, data definition language (DDL), data modeling, SQL considerations, data conversion, and application conversion. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D21 An Introduction to DB2 UDB Express GUI tools (Part 2) New to DB2 UDB? Author Raul Chong shows you how easy it is to automate database tasks, tune performance, and troubleshoot using these easy-to-use tools. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D59 Meet the Experts: Connie Nelin on DB2 Application Development Tools Connie Nelin is responsible for the strategy behind database application development tools, including WebSphere Studio, DB2 Development Center, and Visual Studio .NET. Read what Connie has to say, and submit your questions here. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D60 Porting to DB2 UDB Express 8.1 from SQL Server 2000 This extensive guide introduces the DB2 UDB Express product and goes into detail on the similarities and differences between SQL Server and DB2 with regard to data types, administration issues, programming interfaces, terminology and more. Finally, it describes conversion tools and resources to help you do the job. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D61 Using Hitachi 9900V ShadowImage and TrueCopy with IBM DB2 Universal Database Enterprise Server Edition Version 8.1 Get your step-by-step instructions for various high availability configurations using the combined power of the Hitachi 9900V Series ShadowImage and TrueCopy functions with the suspended I/O features available in DB2 Universal Database (UDB). http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D63 Copying Your SAP/R3 System Across Platforms Using DB2 Universal Database V8 Redirected Restore With DB2 UDB Version 8 you can use redirected restore to copy an SAP/R3 system from one platform to another. Here are the step-by-step instructions and resources you need to know before you start. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D64 Book: DB2 UDB v8 Handbook for Windows, UNIX and Linux This book offers complete, start-to-finish coverage of DB2 Universal Database V8 administration and development for UNIX, Linux, and Windows. This definitive reference covers every aspect of deploying and managing DB2 Universal Database V8 including database design. Read a sample chapter here! http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D65 Migrating From Microsoft SQL Server to IBM DB2 UDB Using Borland C#Builder Using the Microsoft IBuySpy sample application, this article outlines what you'll need to do to change an application written in C# for Microsoft Visual Studio .NET and Microsoft SQL Server to work with Borland C#Builder and IBM DB2 Universal Database (UDB). http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D66 ------------------------------------------------------------ Certification ------------------------------------------------------------ Time to redeem your free DB2 UDB Professional Certification Voucher Did you take advantage of the latest IBM DB2 UDB voucher offer to become IBM DB2 UDB certified? If so now is the perfect time to redeem your voucher and schedule your free exam at your local Prometric testing center. The vouchers are non-transferable and expire on August 31, 2003. The exams eligible are 442: DB2 Content Manager V8; 516: DB2 V7.1 for OS/390 Database Administration, 701: DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration, 703: DB2 UDB V8.1 Family Application Development, 704: DB2 UDB V8.1 for Linux, UNIX and Windows Advanced Database Administration and 705: Business Intelligence Solutions V8.1. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D47 ------------------------------------------------------------ Training Classes ------------------------------------------------------------ *Updated* (CF710) DB2 Stored Procedures Programming Workshop* 2 days * $995 USD Learn how to recognize when an IBM DB2 stored procedure is the correct solution for an application, how to use the Stored Procedure Builder, how to CALL a stored procedure, how to create a stored procedure using Data Definition Language (DDL), and how to troubleshoot a stored procedure. The lab exercises in this offering, run on a Windows workstation, but are applicable to all IBM DB2 platforms. The exercises run on DB2 UDB Enterprise Server Edition (ESE) Version 8. This course has been updated to include the new DB2 V8 Development Center in lecture and labs. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D31 ------------------------------------------------------------ Web Casts and e-Learning ------------------------------------------------------------ Developing a VB.NET Federated Application for Microsoft Access This tutorial demonstrates the use of the ODBC wrapper technology available through DB2 Information Integrator and the IBM DB2 Development Add-In to create a client application that accesses tables residing in a Microsoft Access database. To showcase the ease of using these IBM technologies, we will walk you through the steps required to build a sample application. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D16 Building Web Services with C# and DB2 (updated) This tutorial demonstrates the techniques needed to build a Web service in C# that accesses an IBM DB2 Universal Database database using the DB2 managed data provider. The DB2 managed data provider offers capabilities similar to the SQL Server managed data provider as well as providing a high performance, secure way to access a DB2 database from any .NET programming language. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D3 Have you heard? The New DB2 UDB Administration Fastpath Course is Free! Our Fastpath downloadable computer-based self-study course for DB2 Universal Database(DB2 UDB)System Administration has recently been re-vamped for DB2 UDB V8! This course will enable you to gain V8 DB2 UDB skills quickly and help you get ready for V8 certification. Becoming V8 certified will validate your skills and give you the competitive edge you need in today's ever- changing job market. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D48 Building Web Services with DB2 UDB, Java, and .NET Using a sample application, this tutorial demonstrates how to combine a Visual Basic .NET Web service with a Web-based Java application to access data in a DB2 database. You'll learn how to create database objects and stored procedures using the DB2 Development Add-in for Visual Studio .NET, how to create a Web service in Visual Basic .NET, register a Web service with a UDDI server, and how to build a simple application in Java that accesses the Web service. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D58 Developing a DB2 Application Using WebSphere MQ and Visual Studio .NET DB2 UDB has great integration with WebSphere MQ messaging. Learn how to use the DB2 Development Add-ins for Visual Studio .NET to build an order application that takes advantage of this integration. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D62 Xquery: A Query Language for XML Webcast September 3 Join us on September 3 for the IBM Insight Exchange(tm) Technology Webcast featuring IBM's Dr. Don Chamberlin, as he discusses Xquery: A Query Language for XML. XQuery is being developed under the auspices of the World Wide Web Consortium (W3C). XQuery specifications have been published in a series of working drafts, and the language is making its way toward adoption as a W3C Recommendation. If successful, XQuery has the potential to be one of the most important new computer languages to be introduced in several years. Learn some of the principles underlying the language design and some of the key decisions that influenced its direction. Don Chamberlin is one of the primary designers of the SQL database language and he specializes in database languages, database systems, and document processing. Don't miss this opportunity! Register today! http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D68 Larry Downes Webcast on Digital Strategy and the Customer September 24 If you liked the book "Unleashing the Killer App: Digital Strategies for Market Dominance" then you'll want to join us to hear Larry Downes, renowned business strategist and author discuss Digital Strategy and the Customer: From Relationship Management to Partnership and Collaboration at the next IBM Insight Exchange(tm) webcast September 24. The digital revolution is giving new power and a new voice to customers, overcoming long-standing obstacles to organizing and tapping the expertise and desire they bring to interactions with you. Larry Downes will discuss some of the key technologies that are available today to jump-start the revolution in customer collaboration, and how large and small companies are already using it to cement relationships with a few or even a few million customers. You'll hear about the opportunities that are created by turning these ideas loose in your customers' and your own organizations. Larry Downes has been a leading voice in the development of business strategies that exploit disruptive technologies. He is the author of the Business Week and New York Times Business best-seller, "Unleashing the Killer App: Digital Strategies for Market Dominance" http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D69 ------------------------------------------------------------ Support and Services ------------------------------------------------------------ Skills White Paper concludes IBM meets the database skills challenge The availability of database skills is a key factor in deciding which DBMS to choose. Howard Fosdick, experienced DBA, and founder of several database user groups, has recently published a white paper that looks at the database skills challenge and how the main database vendors address them. Be confident about the skills availability for IBM DB2 UDB and be confident in choosing DB2 as your DBMS. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D42 Now available the NEW Problem Determination Mastery Exam for DB2 Universal Database (UDB) Based on customer feedback, this concise exam was developed by IBM's leading DB2 UDB technical support staff. The exam is designed to provide the skills necessary to master the problem determination process and lead to effective and efficient problem resolution. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D43 Prepare for the New Problem Determination Mastery Exam with the Problem Determination Tutorials This series of nine tutorials was designed to assist anyone supporting or developing in a DB2 database environment, to quickly identify and resolve problems or errors encountered. It will familiarize you with the DB2 problem determination facilities and tools available and when it is most appropriate to use them. By taking advantage of these tutorials, you will have the skills needed to ace the NEW Problem Determination Mastery Exam. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D44 Check out the NEW DB2 Information Management Books Web site! We have launched a brand new books Web site for DB2 information management publications. This site features the latest certification, reference and learning focused titles by industry experts. Whether you need a guide to prepare for DBA certification, or a handbook to learn DB2 UDB V8.1, you can find them all on the new Web site. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D45 Hot off the Press, the latest Certification guide for DB2 UDB V8.1 Application Development Just released, DB2 UDB V8.1 Application Development Certification Guide, 2/e by Steve Sanyal, David Martineau, Kevin Gashyna, Mike Kyprianou. This second edition provides the skills and techniques you need to build enterprise, Web, and eBusiness applications with DB2 UDB v8. This book is IBM's official guide to becoming an IBM Certified Application Developer for the DB2 Universal Database v8 Family. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL803D46 ============================================================ You received this e-mail because you are subscribed to Data Management as: newsatos2site.com Helpful Web sites: IBM DB2 Information Management Home Page: http://www.ibm.com/software/data/ DB2 UDB Product Family: http://www.ibm.com/software/data/db2/udb/ IBM Informix Product Family: http://www.ibm.com/informix/ DB2 Content Manager Portfolio: http://www.ibm.com/software/data/cm IBM U2 Product Family: http://www.ibm.com/software/data/u2 IBM DB2 Information Management Events Calendar: http://www.ibm.com/software/data/events/ IBM DB2 Information Management Education: http://www.ibm.com/software/data/education.html IBM U2 Education: http://www.ibm.com/software/data/u2/education IBM Global Services: http://www.ibm.com/services/learning IBM U2 Support http://www.ibm.com/data/software/u2/support IBM Passport Advantage program http://www.ibm.com/software/passportadvantage IBM U2 Business Partner Solutions: http://www.ibm.com/software/data/u2/partners International Informix Users Group http://www.iiug.org International DB2 Users Group http://www.idug.org 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 completing the form with your name and email address at https://www6.software.ibm.com/reg/dmunsubscribe/dmunsubscribe-r This request will remove your name from future mailings of this newsletter. Thank you. IBM Software, Route 100, Building 1, Somers, NY 10589