Date: Thu, 22 Jan 2004 17:33:03 +0000 (CUT) From: IBM DB2 Information Management Software Subject: DB2 Information Management Software Today newsletter DB2 Information Management Software Today newsletter Happy New Year! Welcome to the first edition of Information Management Software Today for 2004. We are excited to continue to bring you more news from the world of DB2 Information Management Software. We hope you enjoy this issue. As always please let us know what you think. Do you have colleagues that would find value in this newsletter? New readers can subscribe and customize the newsletter to accommodate their interests in DB2 software by visiting http://www.ibm.com/software/data/db2infonews/ How are we doing? 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. Have you updated your profile to receive the newsletter in a convenient HTML format? https://www6.software.ibm.com/reg/dm-db2modify/dm-db2modify-r In This Month's Issue: ====================== DB2 Information Management Software in the News o APT Solutions Awarded IBM Dealmaker of the Year 2003 o If Content Is King, IBM Wants the Crown o IBM Wins 2003 Product and Services of the Year Award for Content Compliance o IBM Acquires Green Pasture Software Events o IDUG 2004 Asia Pacific 18-19 March in Sydney, Australia o 2004 IBM Technical Conferences o IBM Sponsors AIIM/On Demand Conference and Exposition, March 8-10, Jacob Javitz Center, NYC DB2 Information Management Software Product Line o Register for the IBM Business Integration Solution Kit o DB2 Now Available for HP-UX v2 on Itanium 2-Based HP Integrity Servers o Charles Schwab's New Content Management System Enhances Web Business o CRN Interview: Janet Perna & Brett MacIntyre, IBM Software DB2 Content Management Product Line o HypoVereinsbank Gains Realtime customer Insight with IBM Content Management Solution Technical Corner o Accessing DB2 with Web Services o DB2 UDB Connectivity Cheat Sheet Series: Part 3, Setting up Connectivity for DB2 UDB for iSeries o DB2 Index Extensions by Example and in Detail o SAP/DB2 and High Availability on Sun Cluster 3.X o Install and Configure IBM DB2 Universal Database Express Edition in Client/Server Environment o Leveraging Oracle Skills to Learn DB2 UDB o DB2 Basics: Constraints o Tunneling Database Traffic with openSSH and Linux o Using a SELECTIVITY Clause to Influence the Optimizer o Migrating From SQL Links to dbExpress Using DB2 UDB o Content Manager Replication Version 8.2 on Windows o Creating a Document Viewer: Information Integrator for Content Applet Viewer Sample Certification o Hot Off the Press: New DB2 UDB V8 Certification Study Guide for Exams 701 and 706 o Check Out DB2 UDB Certification News, Offers and More o Check Out the New DB2 Information Management Professional Certification Roadmaps Training Classes o Enhance Your DB2 UDB skills with a Free Course that Utilizes the New Capabilities in DB2 UDB V8 Support and Services o Accelerate Time to Value with DB2 Information Management Software Services ------------------------------------------------------------ DB2 Information Management Software in the News ------------------------------------------------------------ APT Solutions Awarded IBM Dealmaker of the Year 2003 London-based Contact Management specialist, APT Solutions, has been nominated as a Dealmaker of the Year 2003 by IBM Software Business in recognition of the company's recent expansion into Australia. Using IBM's UniData nested-relational database, APT Solutions supplied its STRATUM Contact Membership Management system to the New South Wales Teachers Federation(NSWTF), which represents 65,000 members. The NSWTF chose STRATUM for its speed, flexibility, and cost-effectiveness. APT Solutions was one of just five companies selected for this Award. http://www.aptsol.com If Content Is King, IBM Wants the Crown IBM is well positioned to reign over the estimated $10 billion content management market next year, analysts say. With products such as its DB2 Content Manager system, Lotus Workplace Content Management and a number of similar offerings to be introduced next year, industry watchers say IBM is poised to deliver the most comprehensive portfolio of content management capabilities of all of the vendors in this space. http://searchdomino.techtarget.com/originalContent/0,289142,sid4_gci942712,00.html IBM Wins 2003 Product and Services of the Year Award for Content Compliance Transform Magazine has announced IBM as the 2003 Product of the Year Winner for Compliance Products and Services. In a market saturated with compliance hype and hyperbole, IBM offers a comprehensive suite of regulation-specific solutions combining software, hardware and, most importantly, consulting services that will make the difference between implementing technology and reaching compliance. http://www.transformmag.com/showArticle.jhtml?articleID=17000164&pgno=4 IBM Acquires Green Pasture Software On December 17, 2003, IBM announced it acquired Green Pasture Software. Green Pasture develops web-based products to electronically develop and manage the entire lifecycle of business documents. Green Pasture is tightly integrated with DB2 Content Manager, DB2 Records Manager, LotusInstant Messaging and Lotus Domino Document Manager. Also on December 17, IBM announced the new DB2 Document Manager product based on Green Pasture technology. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014S6 ------------------------------------------------------------ Events ------------------------------------------------------------ IDUG 2004 Asia Pacific 18-19 March in Sydney, Australia IDUG 2004-Asia Pacific will take place this March at the Wesley Conference Centre in Sydney. DB2 users should make a point to take advantage of this unique opportunity to benefit from two-days of the latest DB2 education and peer networking opportunities, featuring 20 technical sessions, in-depth seminars, an IBM experts panel and product exhibition. Visit the IDUG Web site for event details and registration. Save AUD160 when you register by 16 February. http://www.idug.org 2004 IBM Technical Conferences Visit the IBM IT Education Services web pages now, to get an initial glimpse into the themes and focus areas for the 2004 roster of Technical Conferences. You'll get a sneak peak at the hot topics that will be presented by our executives, experts and product developers. Mark the conferences dates on your calendar and keep watching these pages as we build the agendas, plan certification testing, develop hands on labs and other special sessions, create birds-of-a- feather discussion groups, and organize the Product Expo. Don't miss out. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B5 IBM Sponsors AIIM/On Demand Conference and Exposition, March 8-10, Jacob Javitz Center, NYC Join us at AIIM/OnDemand and learn about the latest IBM collaborative solutions to develop, manage, store and distribute all forms of information. Find out how IBM content management solutions can help you streamline business processes, comply with governmental regulations, and drive down costs. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014S11 ------------------------------------------------------------ DB2 Information Management Software Product Line ------------------------------------------------------------ Register for the IBM Business Integration Solution Kit Connecting the systems in your company is more important now than ever. You want to give your people the tools they need to create efficiencies across and beyond your company. IBM business integration solutions can help. Get the facts on how your company can save time and money with our Business Integration Solution Kit. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B24 DB2 Now Available for HP-UX v2 on Itanium 2-Based HP Integrity Servers IBM has announced the electronic general availability of 64-bit DB2 UDB products and components for the HP-UX v2 operating system running on HP Integrity servers, based on the Intel Itanium 2 processors. With this announcement, DB2 UDB continues to build on its momentum in the HP-UX marketplace. DB2 Version 8.1.4 products and components engineered to exploit the scalability, reliability, and performance of the HP Integrity server product line and HP-UX v2. Itanium-based solutions perform the real-life information management jobs that require "heavy lifting". HP Integrity servers, based on the Intel Itanium processors. They are standards-based, innovative building blocks you can use today, to realize price and costs savings while gaining greater stability, efficiency and agility within your IT infrastructure. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B42 Charles Schwab's New Content Management System Enhances Web Business One of the most strategic initiatives for Schwab is the architecting and implementation of a content management system (CMS). For Schwab, CMS is not merely a platform implementation to support the content creation and publishing lifecycle. Rather, according to Robyn Leonard, Schwab Senior Vice-President, "CMS is an initiative that will fundamentally change the way Schwab does business." http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014S1 CRN Interview: Janet Perna & Brett MacIntyre, IBM Software In-depth Q&A with Janet Perna and Brett MacIntyre on IBM strategy and leadership position in enterprise content management. http://crn.channelsupersearch.com/news/crn/46819.asp ------------------------------------------------------------ DB2 Content Management Product Line ------------------------------------------------------------ HypoVereinsbank Gains Realtime customer Insight with IBM Content Management Solution By transforming their business processes to give employees realtime, electronic access to a common repository of comprehensive information, HypoVereinsbank is now meeting very high standards for customer responsiveness,providing instant answers to customer or employee questions. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014S4 ------------------------------------------------------------ Technical Corner ------------------------------------------------------------ Accessing DB2 with Web Services This tutorial shows how to develop a .NET Web service for accessing a DB2 database with DB2 .NET managed data provider using the IBM Development Add-Ins provided by DB2 Universal Database (UDB) v8 FixPak 2, for Visual Studio .NET. It also shows how to consume Web services developed from both WORF and .NET technology in a Java Web application. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B1 DB2 UDB Connectivity Cheat Sheet Series: Part 3, Setting up Connectivity for DB2 UDB for iSeries As part of a series on DB2 UDB connectivity, this article focuses on DB2 for iSeries connectivity. It covers three scenarios: connecting from DB2 UDB for iSeries clients to DB2 UDB for Linux, UNIX and Windows servers, connecting from DB2 UDB for iSeries clients to DB2 UDB for z/OS subsystem servers, and connecting from DB2 UDB for iSeries clients to DB2 UDB for iSeries servers. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B2 DB2 Index Extensions by Example and in Detail DB2 index extensions enhance performance of applications accessing unstructured data in DB2 UDB. This article demonstrates in detail how to use DB2 index extensions, using the example of querying interval trees. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B25 SAP/DB2 and High Availability on Sun Cluster 3.X SAP Web Application Server supports high availability through a technique called switchover. This article describes the integration of DB2 Universal Database, SAP R/3 Enterprise 4.70, and Sun Cluster 3.1 on the Solaris 9 environment to provide highly available data service. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B26 Install and Configure IBM DB2 Universal Database Express Edition in Client/Server Environment This article demonstrates how easy it is to use DB2 GUI tools to install and configure DB2 UDB Express Edition in client/server environments. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B27 Leveraging Oracle Skills to Learn DB2 UDB If you're a database specialist interested in growing your DB2 Universal Database skills, there's a good chance that you've already developed database skills with another relational database product somewhere along the way. This article shows you how to use your current knowledge of Oracle 9i to quickly gain skills in DB2 UDB for Linux, UNIX, and Windows Version 8. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B28 DB2 Basics: Constraints Constraints are used by DB2 UDB to enforce business rules for data and to help preserve database integrity. This article describes the various types of constraints supported by DB2 UDB and provides examples of each constraint type. In addition, the author explains the fundamentals of constraints management (using either the command line or the DB2 Control Center). http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B29 Tunneling Database Traffic with openSSH and Linux Client server traffic on TCP/IP networks is an attractive target for hackers. Linux and openSSH provide a simple and effective means of encrypting this traffic. In this article, the author outlines security exposures, and then illustrates effective counter measures for protecting the network packets. Linux and ssh can protect Windows clients with the methods presented. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B3 Using a SELECTIVITY Clause to Influence the Optimizer This article explains how you can influence the DB2 SQL optimizer by providing the expected cardinality using a selectivity clause. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B4 Migrating From SQL Links to dbExpress Using DB2 UDB In this article, Bob Swart demonstrates two Borland data-access technologies for connecting to IBM DB2 tables. SQL Links and dbExpress can be used by both Delphi and C++ Builder developers. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B41 Content Manager Replication Version 8.2 on Windows Replication provides high availability and reliability for Content Manager. In this article, the author shows you how to create two resource managers on separate Windows 2000 server machines and demonstrates how to configure Content Manager replication. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014S10 Creating a Document Viewer: Information Integrator for Content Applet Viewer Sample This article shows how to use the Information Integrator for Content toolkit to add a document viewer to a custom Web client. Here's a method for building transparent access to critical unstructured and structured information across and beyond the enterprise. A sample program is included. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014S9 ------------------------------------------------------------ Certification ------------------------------------------------------------ Hot Off the Press: New DB2 UDB V8 Certification Study Guide for Exams 701 and 706 This new guide by Roger Sanders, DB2 Universal Database v8.1 Certification Exams 701 and 706 Study Guide, covers every aspect of DB2 UDB that is featured on these two database administration exams in great depth. In addition, every chapter features practice exam questions and answers, as well as explanations and breakdowns of every correct answer. There is no better way to prepare for the DB2 UDB V8.1 Database Administration Certification exams 701 and 706. For more information or to purchase, visit: http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B36 Check Out DB2 UDB Certification News, Offers and More Have you heard about all the new certification offers and promotions taking place this winter? From no charge certification preparation materials to discounts on certification exams, there is something for everyone. Take a look at the completely re-vamped professional certification website and explore what may benefit you. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B37 Check Out the New DB2 Information Management Professional Certification Roadmaps To help you begin and prepare for professional certification, we have created a series of certification roadmaps to help you define and map out your certification path. We offer a variety of job-related certifications for our DB2 information management software products. These roadmaps are designed to provide a comprehensive, concise view of all the exams and roles available as well as provide you with the most efficient path to achieve the various levels of certification. To view visit: http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B44 ------------------------------------------------------------ Training Classes ------------------------------------------------------------ Enhance Your DB2 UDB skills with a Free Course that Utilizes the New Capabilities in DB2 UDB V8 DB2 Universal Database Administration Fastpath for V8 (CT28D) has recently been re-vamped. The labs for this course have been updated and now utilize the new capabilities of DB2 UDB V8. Try out your skills with this new course. Register and download today at: http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B35 ------------------------------------------------------------ Support and Services ------------------------------------------------------------ Accelerate Time to Value with DB2 Information Management Software Services The DB2 Information Management Consulting team offers a complete portfolio of software services to help boost your success. From implementation to migration, our experts will be there for you. For more information please visit: http://www.ibm.com/isource/cgi-bin/goto?on=IMNL014B34 ============================================================ You received this e-mail because you are subscribed to Data Management as: newsatos2site.com Helpful Web sites: IBM DB2 Information Management Software 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 Training: 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