www. ibm. com/eserver/iseries DB 2 Universal Data Base for i. Series ISTUG Barry Thorn IBM UK Ltd. September 2002 8 2002 IBM Corporation
Agenda www. ibm. com/eserver/iseries q. Positioning DB 2 UDB for i. Series ØDB 2 UDB Family ØOpenness and Industry Standards q. Self Managing Database ØAvailability ØUsability ØScalability q. Linux q. Summary 8 2002 IBM Corporation
The Landscape – Data Management Trends § Support of Industry Standards CRITICAL n www. ibm. com/eserver/iseries Pervasive and the growth of XML as the supporting standard n § Explosive increase in ebusiness Transactions Self-Managing Databases n n Linux Data Analysis (BI/CRM) Becoming CRITICAL n Skills are in demand "Customers must focus on highly available DBMS architectures to support utility-grade e-business infrastructures. Customer selection of the correct DBMS infrastructure for CRM and ERP operations -- and beyond -- is essential. " Meta Group Meta Trend - OLTP DBMS Choice Criteria, 11/01 8 2002 IBM Corporation
IBM DB 2 Family www. ibm. com/eserver/iseries Hosts DB 2 UDB for z/OS, OS/390 DB 2 for VSE & VM DB 2 UDB for i. Series q Universal Access q Universal Application q Universal Extensibility q Universal Scalability q Universal Reliability q Universal Management Everyplace Enterprise Palm. OS Win CE EPOC-32 OS/2, Win NT, Win 2000 AIX, HP-UX, Solaris Linux, NUMA-Q Satellite Win 95, 98 Win NT Personal Clients OS/2 Win 95, 98 Win NT Win 2000 Linux Workgroup OS/2 Win NT Win 2000 Linux AIX Solaris HP-UX Personal Edition 8 2002 IBM Corporation Enterprise Extended AIX Solaris Win NT Win 2000 HP-UX NUMA-Q
DB 2 Universal Data Base (UDB) Family www. ibm. com/eserver/iseries q. Managing family compatibility ØData Management Steering Committee ØData Management Technical Council ØSQL Language Council q. Common design, algorithms, and code sharing where possible q. Two Types of Differences ØShort term differences based on different release dates and different customer priorities ØLong term differences based on Operating System differences (Isolated to database configuration and utilities) q. IBM DB 2 UDB Reference - SQL Reference for Cross-Platform Development Ø (http: //www-919. ibm. com/developer/db 2/downloads/cpsqlref. pdf) 8 2002 IBM Corporation
DB 2 UDB Momentum # of Data Management Patents Technology Leadership n www. ibm. com/eserver/iseries IBM Invented Relational Database '96 -'00 and SQL n 1, 141 More database patents in 2000 than all competitors combined Oracle 175 USPTO CLASS 707: DATA PROCESSING: DATABASE AND FILE MANAGEMENT, DATA STRUCTURES, OR DOCUMENT PROCESSING "Of all the vendors that have embraced the concept of the universal database it is arguably DB 2 UDB that is the most comprehensive. In particular, IBM appears to be the most firmly committed to offering an all-embracing product set. " - Databases - an evaluation and comparison, Bloor Research, Jan. 2002 8 2002 IBM Corporation
Conformance to 1999 Core Standard www. ibm. com/eserver/iseries q. No database vendor today has all the features of core q. DB 2 Universal Database for i. Series has already shipped 4/5 of the items DB 2 UDB for i. Series V 5 R 2 DB 2 UDB for i. Series V 5 R 1 DB 2 UDB for UWO V 7. 2 DB 2 UDB for OS/390 Microsoft SQL Server 2000 Oracle 8 i DB 2 UDB for i. Series V 5 R 2 8 2002 IBM Corporation
DB 2 UDB for i. Series – Strategic Initiatives www. ibm. com/eserver/iseries q. Openness - Industry Standard Support ØAccommodate ISVs ØPortability/Compatibility ØFlexibility q. Continued LEADERSHIP in database technologies ØConsistency ØShared across DB 2 family R & D across IBM Labs q. Continued Leveraging of i. Series Strengths ØAvailability ØUsability - Total Cost of Ownership ØScalability ØApplication Flexibility 8 2002 IBM Corporation
An Open Database www. ibm. com/eserver/iseries q ANS, ISO, FIPS, and JIS SQL Standard q Open Group - Distributed Relational Database Architecture q Open Group - XA Resource Manager APIs q ANS and ISO SQL Call Level Interface q ANS and ISO SQL and External Procedures q ODBC DB 2 Everyplace / DB 2 q JDBC Satellite Edition Net. Data Notes/Domino q OLE and ADO q US Government C 2 Security q UCS-2 (UNICODE or ISO 10646) SQL Client Integration Data. Propagator q Euro Character support Internet Access Notes Access Replication Access to Non-DRDA Databases Oracle Microsoft Data Joiner Access to DRDA and Non-DRDA Databases Oracle Microsoft DB 2 Non-relational 8 2002 IBM Corporation
A Self-Managing Database - e. Liza www. ibm. com/eserver/iseries q. Self-Configuring ØAuto Data Spreading and Load Balancing ØOS Compatibility with each new release ØNo Installation or Configuration of DB required before use q. Self-Healing ØSystem ØAuto Managed Access Paths, System Managed Journaling Restart of Database on System Failure q. Self-Protecting ØLeverages ØObject OS - Virus protection, Authentication and Resource Management Auditing q. Self-Optimizing ØFully integrated Cost-based Optimizer ØAutomatic capture and maintenance of database statistics ØAutomatic adjustment of query plan based on resource configuration 8 2002 IBM Corporation
An Available Database q. System Availability ØHigh Reliability ØCluster ØHigh Proven - Independent ASPs Availability Options q. Database Availability ØNo taking the database off-line for maintenance Statistics maintained real time l Load Balancing real time l Index re-balancing real time l ØFast Recovery Auto Restart of Database on System Failure l System Managed Access Paths/Journals l 8 2002 IBM Corporation www. ibm. com/eserver/iseries
Usability – The i. Series Advantage To DBA or NOT to DBA 8 2002 IBM Corporation www. ibm. com/eserver/iseries
DB 2 UDB for i. Series Scalability q. Single table - 1 terabytes q. Single distributed table - 32 terabytes q. Single index 1 terabyte q. Single www. ibm. com/eserver/iseries distributed index 32 terabytes q. Symmetric q. Massively q. Parallel Multi. Processing (SMP) - 32 -way Parallel Processing (MPP) - 32 x 32 -way table scan of 2. 5 terabyte table (10 billion rows) in 77 minutes) q. Restore of 2. 6 terabytes of data in one hour on a 24 -way SMP model 840 8 2002 IBM Corporation
www. ibm. com/eserver/iseries DB 2 UDB in Linux q. DB 2 UDB for i. Series Øvia ODBC q. DB 2 UDB for Unix/Windows/Linux ØLinux Partition ØTechnology ØGA Preview – Now OS/400 Linux DB 2 UDB EE for i. Series 4 Q 2002 or 1 Q 2003 DProp. R 8 2002 IBM Corporation DB 2 Connect Linux
Additional Resources q. DB 2 www. ibm. com/eserver/iseries UDB for i. Series Home Page Øhttp: //www. ibm. com/servers/eserver/iseries/db 2 q. DB 2 UDB for i. Series Frequently Asked Questions Øhttp: //www. ibm. com/servers/eserver/iseries/db 2 faq. htm ØInternally q. DB 2 at System Sales and PARTNERINFO UDB for i. Series Overview White Paper Øhttp: //www. ibm. com/servers/eserver/iseries/db 2/overview. htm ØInternally q. DB 2 at System Sale and PARTNERINFO UDB Family Compatibility Øhttp: //www. ibm. com/servers/eserver/iseries/developer/db 2 common. html q. DB 2 UDB Family Common Utilities Øhttp: //www. ibm. com/servers/eserver/iseries/db 2 udbprod. htm qi. Series Navigator On-line Tutorials Øhttp: //www. as 400. ibm. com/developer/education/ibo/view? biz. html 8 2002 IBM Corporation
Summary www. ibm. com/eserver/iseries q. DB 2 Universal Database (UDB) is a Family q. DB 2 UDB for i. Series ØOpen ØExcellent Standards Conformance q. Scalable from very small to very large q. Industry leading Index Technology q. Industry leading Usability ØDevelopment ØAdministration ØOperation 8 2002 IBM Corporation
www. ibm. com/eserver/iseries Trademarks and Disclaimers 8 IBM Corporation 1994 -2002. All rights reserved. References in this document to IBM products or services do not imply that IBM intends to make them available in every country. The following terms are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both: 400 ADSTAR Advanced Function Printing AFP AIX Any. Net Application Development APPN AS/400 e AT Brio. Query BRMS Client Series Cluster. Proven CODE/400 Data. Guide DB 2 Extenders DB 2 UDB for AS/400 DB 2 Universal e-business logo e(logo) Server Enterprise Storage Server Host Integration Series Host on Demand Host Publisher HTTP Server for AS/400 IBM Logo IBM Network Station Information Warehouse Integrated Language Environment Intelligent Printer Data Stream IPDS i. Series Just. Mail MQSeries Integrator Net. Commerce Net. Data Netfinity Net. View NUMA-Q Office. Vision OS/2 Operating System/400 OS/400 Payment Manager Payment Server PCOM Power. PC AS Print Service Facility p. Series PSF S/390 San. Francisco Screen Publisher Smooth. Start Stylized System. View Visual. Age for Java Visual. Age for RPG Web. Sphere Advanced Edition Web. Sphere Commerce Suite Web. Sphere Development Tools for AS/400 Web. Sphere Standard Edition Workpad x. Series cc: Mail, Domino. Doc, Freelance, Learning. Space, Lotus Domino, Lotus Notes, i. Notes, Quick. Place, Sametime, and Word Pro are trademarks of Lotus Development Corporation in the United States, other countries, or both. Tivoli and Net. View are trademarks of Tivoli Systems Inc. in the United States, other countries, or both. C-bus is a trademark of Corollary, Inc. in the United States, other countries, or both. Java and all Java-based trademarks and logos are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. Microsoft, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. PC Direct is a trademark of Ziff Communications Company in the United States, other countries, or both and is used by IBM Corporation under license. Action. Media, LANDesk, MMX, Pentium and Pro. Share trademarks of Intel Corporation in the United States, other countries, or both. IBM's Visual. Age products and services are not associated with or sponsored by Visual Edge Software, Ltd. Linux is a registered trademark of Linus Torvalds. UNIX is a registered trademark of The Open Group in the United States and other countries. SET and the SET Logo are trademarks owned by SET Secure Electronic Transaction LLC. Other company, product and service names may be trademarks or service marks of others. Information is provided "AS IS" without warranty of any kind. All customer examples described are presented as illustrations of how those customers have used IBM products and the results they may have achieved. Actual environmental costs and performance characteristics may vary by customer. Information in this presentation concerning non-IBM products was obtained from a supplier of these products, published announcement material, or other publicly available sources and does not constitute an endorsement of such products by IBM. Sources for non-IBM list prices and performance numbers are taken from publicly available information, including vendor announcements and vendor worldwide homepages. IBM has not tested these products and cannot confirm the accuracy of performance, capability, or any other claims related to non-IBM products. Questions on the capability of non-IBM products should be addressed to the supplier of those products. All statements regarding IBM future direction and intent are subject to change or withdrawal without notice, and represent goals and objectives only. Contact your local IBM office or IBM authorized reseller for the full text of the specific Statement of Direction. Some information in this presentation addresses anticipated future capabilities. Such information is not intended as a definitive statement of a commitment to specific levels of performance, function or delivery schedules with respect to any future products. Such commitments are only made in IBM product announcements. The information is presented here to communicate IBM's current investment and development activities as a good faith effort to help with our customers' future planning. Performance is based on measurements and projections using standard IBM benchmarks in a controlled environment. The actual throughput or performance that any user will experience will vary depending upon considerations such as the amount of multiprogramming in the user's job stream, the I/O configuration, the storage configuration, and the workload processed. Therefore, no assurance can be given that an individual user will achieve throughput or performance improvements equivalent to the ratios stated here. Photographs shown are of engineering prototypes. Changes may be incorporated in production models. 8 2002 IBM Corporation
Скачать презентацию www ibm com eserver iseries DB 2 Universal Data Base
3c0f3db64cb46d8eab674bc93d8a5306.ppt