DB 2 UDB for i Series V 5

Зарегистрируйтесь, чтобы просмотреть полный документ!

DB 2 UDB for i. Series: V 5 R 2 enhancements to the i. Series' self-managing database Doug Mack mackd@us. ibm. com 8 2002 IBM Corporation

WEBCAST SCHEDULE Today’s event will run one-hour long. Here are the expected times for each segment of the webcast: • : 00 -- : 05: Moderator introduces the speaker and discusses the details of the webcast. • : 05 -- : 35: Speaker delivers a Power. Point presentation on the webcast topic. • : 35 -- : 60: Moderator and speaker engage in a Q&A on the topic. You can submit questions to the speaker at any time during the event. Just click on the “Ask a Question” button in the lower left corner of your screen. 8 2002 IBM Corporation

TECHNICAL FAQs Here answers to the most common technical problems users encounter during a webcast: Q: Why can’t I hear the audio part of the webcast? A: Try increasing the volume on your computer. Q: I just entered the webcast and do not see the slide that the speaker is referring to. What should I do? A: The slides are constantly be pushed to your screen. You’ll should refresh (hit F 5) to view the latest slide. If your question is still not answered, please visit the Broadcast Help page for more information or to test your browser compatibility. Go to: http: //help. yahoo. com/help/bcst/ 8 2002 IBM Corporation

DB 2 UDB for i. Series V 5 R 2 Update 8 2002 IBM Corporation ®

ibm. com/eserver/iseries Agenda Background §Landscape §DB 2 UDB Strategy V 5 R 2 Enhancements §Availability §Openness (Industry Standards/DB 2 Family) §Performance §Usability Resources 8 2002 IBM Corporation

ibm. com/eserver/iseries The Landscape: Data Management Trends §Pervasive and the growth of XML as the supporting standard §Support of Industry Standards CRITICAL §Self Managing Databases §Explosive increase in e. Business Transactions §Linux §Data Analysis (BI/CRM) Becoming CRITICAL §Skills are in demand 8 2002 IBM Corporation

ibm. com/eserver/iseries IBM's Leadership in Database §IBM Invented Relational Database §IBM continually leads the industry in Database patents ƒ 7 Times more than competitors COMBINED! §DB 2 is a family of IBM products that run on over twenty platforms ƒ DB 2 UDB for i. Series is built into OS/400 §The DB 2 family has surpassed Oracle as the leader in database marketshare §DB 2 UDB for i. Series leads the industry in support of the SQL ANSI Core '99 standard elements 8 2002 IBM Corporation *Source: Based on Dataquest, May 2002 Release

ibm. com/eserver/iseries DB 2 UDB for i. Series Strategic Initiatives §Openness - Industry Standard Support ƒ Accomodate ISVs ƒ Portability/Compatibility ƒ Flexibility §Continued LEADERSHIP in database technologies ƒ Consistency across DB 2 family –Common SQL, comon utilities ƒ Shared R & D across IBM Labs §Continued Leveraging of i. Series Strengths ƒ Availability ƒ Scalability ƒ Usability - Total Cost of Ownership –For example: Query Optimizer DESIGNED for Low TCO ƒ Application Flexibility 8 2002 IBM Corporation

ibm. com/eserver/iseries OS/400 Database History Lesson n ctio Fun SQL t bus 1999/2000 s Ro ver üLarge Objects Deli üSQLJ IBM ü 1997/98 1970 üCodd Invents RDBMS 1973 üSystem R Project ü 1980 üS/38 Delivered with RDBMS Based on System R ü 1988 üIBM Defines COMMON SQL Language 1988 üAS/400 Delivered with SQL/400 1995/96 üSQL Optimization üReferential Integrity üDRDA DUW üNet. Data üTriggers üLong Names üStored Procedures üSMP Parallelism +++ üCluster parallelism üData mining üParallel Index Build üUCS-2 üBI Solutions üDynamic Bitmaps üEncoded Vector Indexes üParallel Data Loader +++ 1995: RDBMS is named DB 2/400 2001 üSQLTriggers üDatabase Navigator üGenerate SQL ü 2 G LOBs ü 1 TB tables üData Links üODBC 3. 5 üUDTs, UDFs üDB 2 Extemders üOp Nav Performance Monitor üDB 2 OLAP üVisual Explain üJava (tm) Stored Procedures +++ 2002/3 üSelf Optimizing Query Engine üMigration Toolkits üMultiple Name Spaces üSwitchable Disk Clustering üIndex Advisor 1997: Renamed to üNew Statistics Manager DB 2 UDB üAdaptive e-Business Transaction Services üEnhanced DB 2 Family Compatibility üAdd'l SQL Standards Support 8 2002 IBM Corporation

ibm. com/eserver/iseries DB 2 UDB Extenders: XML Extender - 5722 -DE 1 Application DAD (Data Access Definition) DB 2 XML Extender DB 2 XML Collection XML Column user table book XML DOC XML column § Store and retrieve entire XML documents as DB 2 column data § XML data represented by XML column XML collection § Decompose XML document into a collection of relational tables § Compose XML documents from a collection of relational tables 8 2002 IBM Corporation

ibm. com/eserver/iseries DB 2 UDB Symmetric Multi. Processing Feature §Parallel Methods M E M O R Y QUERY SQL – Parallel table scan – Parallel index scan – Parallel hash join – Parallel hash group by – Parallel index build – Parallel data load –Parallel index ANDing/ORing of dynamic bit maps –Parallel index maintenance – Parallel Encoded Vector Index –Parallel I/O –Parallel recovery –Parallel Reorganize Single Level Storage IOP IOP Cust #1 Cust #2 Cust #3 Cust #4 Cust #5 Cust #6 Cust #7 8 2002 IBM Corporation

ibm. com/eserver/iseries Encoded Vector Indexing (EVIs) Indexing technology that can significantly improve performance, especially for star schema ƒ 10% to 30% faster index builds ƒ 1/3 to 1/16 the size ƒ 1/2 the time for index scans ƒ 1/3 the time for bit map generation Symbol Table Key Value Code Arizona Arkansas. . . Virginia Wyoming 1 2 37 38 First Row 1 5 Last Row 80005 99760 1222 7 Count 5000 7300 30111 83000 340 2760 Vector 1 13 12 Row 1 Row 2 28 2 17 38 2 26 33 . . 8 2002 IBM Corporation

ibm. com/eserver/iseries DB 2 UDB for i. Series V 5 R 2 Enhancements - Overview Performance e-Infrastructure/EAS: Application Availability/Portability Ÿ Enhanced Support for the SQL Industry Standard Ÿ Transaction Services Ÿ Enhanced DB 2 UDB Family Compatibility* Server Consolidation Database Availability Ÿ Switchable Disk Clustering with Independent ASP Support Ÿ Partial Rollback Ÿ DB 2 UDB in Linux Ÿ Database Migration Toolkits/Services Ÿ Multiple Database Name Support ƒ Ÿ Transaction Services - Web. Sphere Ÿ Query Optimizer Statistics Engine - BI, SQL Ÿ Improved EVI Maintenance Ÿ Journal Caching ƒ Independent ASPs Savepoints Usability Ÿ Operations Navigator Enhancements Ÿ DB 2 OLAP ƒ Data Mining Ÿ SQL Enhancements for Traditional Programmers Migrate legacy programmers to SQL * This does not imply 100% Compatibility across all DB 2 UDB Family Members ƒ 8 2002 IBM Corporation

ibm. com/eserver/iseries Open Standard(s)/SQL Support/DB 2 Compatibility §JDBC V 3. 0 (native and Linux) §CLI Enhancements §User Defined Table Functions §SQL Statement Length expanded to 64 K Ÿ Improved DB 2 XML Extender Performance §Identity Column (auto incrementing) §ROWID Column type Ÿ System wide Unique Row Identifier §UNION in a view §Global Temp Tables §PSM Improvements Ÿ Iterate Ÿ Nested Compound Statements §Remote Result Set Support (CLI and JDBC) Ÿ DRDA compatiblity - retrieve results sets from production system §Savepoints (DB 2 compatibility) Ÿ SQL Syntax to create in QTEMP - more industry §New Database Catalog Views for ODBC/JDBC standard §New Transaction Services (DB 2 Compatibility) Ÿ XA and JTA (Java Transaction API) 8 2002 IBM Corporation

ibm. com/eserver/iseries Enhancements for traditional DB programmers § Field Reference File constructs for SQL § SET SCHEMA - Change Library List via SQL § Remove requirement for C Compiler or SQL Development Kit § SQL Stored procedures or Triggers § SQL Source Debugger 8 2002 IBM Corporation

ibm. com/eserver/iseries Performance Transaction Services §Open Standard Ÿ XA and JTS (Java Transaction Services API) §Improved e-Business Apps 1 Server Job 1 Appli catio n Serv er i. Series Connecti on Manage ment Ÿ Web. Sphere Database Technology Enhancements §Enhanced performance and recovery options for DB 2 UDB access path protection 5 1000 s of clients §Object-oriented query optimizer that lays foundation for self-learning query optimizer §Streamlined data access for SQL interfaces §V 5 R 2 Performance Gains Ÿ Limited to certain SQL operations 8 2002 IBM Corporation Transaction Objects Server Job m DB 2 UDB for ISeries

ibm. com/eserver/iseries Availability: Switched Disk Clustering System Data Switched Disk DB 2 Store_1 DB 2 Store_2 Archive Store_1 IFS UDFS Archive Store_2 DB 2 Store_3 High Availability Flexibility §Switchable Disks for scheduled maintenance §NOT a replacement for H/A Solutions Multiple Relational Databases on a single i. Series §Multiple Namespaces §Consolidate Servers while maintaining separate, regional databases 8 2002 IBM Corporation

ibm. com/eserver/iseries i. Series Navigator Enhancements To DBA or not to DBA SQL Tuning Enhancements Ÿ Enhanced Visual Explain Index Advisor ƒ Better direct advice behind graphical explain functions ƒ Print SQL Information (PRTSQLINF) ƒ Ÿ Statistics Engine Stats Collection Management Facility ƒ Collect Stats in Background ƒ Database Modeling Enhancements Ÿ Enhanced Database Navigator Ÿ More complex data models can be displayed and support for Triggers have been added Database Configuration Enhancements Ÿ Remote Database Directory ƒ Configure DRDA Servers Ÿ Independent ASP Support Ÿ Improved Commitment Control Definitions 8 2002 IBM Corporation

ibm. com/eserver/iseries DB 2 UDB for i. Series: Autonomic Computing §Self Configuring ƒ No Installation required ƒ No Tablespace, data partitioning, management of buffers –No Data Hot Spots §Self Healing ƒ ƒ Systems Managed Access Path Protection Self Managed Database Logging Auto Index Rebalancing Database Locking Issues (Oracle FUD) §Self Tuning ƒ Auto Tuner, Sophisticated Cost Based Query Optimizer ƒ Automatic Index Advisor §Self Protecting M E M O R Y QUERY SQL Single Level Storage IOP 8 2002 IBM Corporation IOP IOP IOP Cust #1 ƒ Object Based Kernel in OS/400 IOP Cust #2 Cust #3 Cust #4 Cust #5 Cust #6 Cust #7

ibm. com/eserver/iseries DB 2 OLAP Database Utility for Reporting Systems - V 8 OLAP is On. Line Analytical Processing §DB 2 OLAP is a utility to create, build, load and maintain high performance reporting databases providing Ÿ Provides "speed of thought" Query Response Times Ÿ No complex query language or database knowledge required §DB 2 OLAP is based on OPEN Standards Ÿ Accomodate just many End User Interfaces Executive Information Systems ƒ Spreadsheets ƒ Portals ƒ §OLAP Mining Ÿ Delivered via PTF to V 7 §V 8 Just Delivered Ÿ Hybrid Relational and Multi-Dimensional OLAP Ÿ Performance - Parallel cube loads/calcs Ÿ Heterogeneous Data Extracts 8 2002 IBM Corporation

ibm. com/eserver/iseries DB 2 UDB in Linux DB 2 UDB for Unix/Windows/Linux §IBM Statement of Direction §Work. Group Edition Ÿ Entry Level Pricing OS/400 Linux §Enterprise Edition Ÿ More function bundled in DB 2 UDB for i. Series §Beta Program Commencing 1 Q 2003 §Connecting to DB 2 UDB for i. Series Ÿ DB 2 Connect, JDBC, ODBC Ÿ Data Propagator DProp. R 8 2002 IBM Corporation DB 2 Connect Linux

ibm. com/eserver/iseries Database Migration Utilities Services and Toolkits Oracle Migration Toolkit §No Charge Migration Utility Ÿ Q 4 2002 Availability Ÿ Downloadable ƒ http: //www-919. ibm. com/servers/eserver/iseries/developer/db 2/porting. html Converts to DB 2 UDB for i. Series §Data Type Conversion §Stored Procedure, Trigger Conversion Custom Technology Center Services RECOMMENDED §Not a 100% Conversion utility §SQLServer to DB 2 Migrations §www. ibm. com/servers/eserver/iseries/service/ctc 8 2002 IBM Corporation

DB 2 UDB for i. Series Product Offerings Feature Function Delivery Mechanism Benefit When to use DB 2 UDB for i. Series Relational Database, SQL Engine, Database Interfaces, Operations Navigator Included in OS World Class Relational Database Never Stop! Included with every system DB 2 Symmetric Multiprocessing Allows database tasks to be run in parallel across an N-way system - Chargable Feature of OS/400 SQL/Query Performance On any N-way configuration DB 2 Multi-System Allows you to split records from a single table(physical file) across multiple systems. Database Partitioning feature ala DB 2 UDB EEE Chargeable Feature of OS/400 Scalability of Database, Enterprise view of data across multiple regions Large Data warehouses or Customers wanting single view of data across multple regions running common applications Remote Journaling Store Database Log Files on remote system Included in OS Replicate data When customer needs to to remote create second database systems (for backup, or data replication) with minimal impact to production envrionment QMF for Windows Query/400 -like capability in Windows Chargeable environment. Import Query/400 i. Series directly in QMF formats. Compatibility Feature with other DB 2 family members. Common Query tool for multiple DB 2 UDBs Low Cost tool - consider including in every config

DB 2 UDB for i. Series Product Offerings Feature Function Data Propagator Capture and Apply Replicate Data between i. Series systems - requires journaling (or remote journaling) for CHANGED DATA ONLY replication DB 2 Text/XML Extender Programming interfaces for developing applications using DB 2 -XML interchange or Text Search Capabilities Database Utility to build high performance reporting repositories DB 2 OLAP Delivery Mechanism Chargeable i. Series Product Benefit When to use Replicate Data across DB 2 Family Members Data Replication req'd for variety of reasons (data warehouse, web, consolidated databases) Chargable i. Series Product Programming Enablers For Application Developers SWG Passport Advantage Product Better response times in complex data analysis Business Intelligence Executive Information Systems Financial Analysis/Budgeting CRM Analytics - WITH EVERY H/A SALE Requirement for QM compatibility; application development environments Query Manager and SQL Development Toolkit 5250 based offering providing (1) Chargeable forms oriented query building i. Series facility (2) interactive SQL Product scripting, and (3) SQL pre-compiler for applications written with embedded SQL Commonality with OS/390 QMF products, interactive SQL Scripting Interface for development Web Query Tool Web based Query tool. Pure web based If web based query solution. Low capability is required. Cost query. SWG Passport Advantage Product

ibm. com/eserver/iseries DB 2 UDB For i. Series Information Deliverables: Ÿ DB 2 UDB for i. Series CD –http: //www. elink. ibm. com/public/applications/publications/cgibin/pbi. cgi Ÿ DB 2 UDB for i. Series New and Enhanced Utilities Ÿ DB 2 UDB for i. Series Frequently Asked Questions Ÿ DB 2 UDB for i. Series Business Intelligence Concepts (Updated) Ÿ "Got Those Query Blues? " Paper Ÿ i. Series Nation and DB 2 UDB for i. Series Home Page Websites (Updated) Ÿ DB 2 UDB Common SQL Comparison Document 8 2002 IBM Corporation

ibm. com/eserver/iseries Additional Resources §DB 2 UDB for i. Series Home Page Ÿ http: //www. ibm. com/servers/eserver/iseries/db 2 §DB 2 UDB for i. Series Frequently Asked Questions Ÿ http: //www. ibm. com/servers/eserver/iseries/db 2 faq. htm §DB 2 UDB for i. Series Overview White Paper Ÿ http: //www. ibm. com/servers/eserver/iseries/db 2/overview. htm §DB 2 UDB Family Compatibility Ÿ http: //www. iseries. ibm. com/developer/db 2/downloads/cpsqlref. pdf §DB 2 UDB Family Common Utilities Ÿ http: //www. ibm. com/servers/eserver/iseries/db 2 udbprod. htm §i. Series Navigator On-line Tutorials Ÿ http: //www. as 400. ibm. com/developer/education/ibo/view? biz. html §DB 2 UDB for i. Series On-Line Education Ÿ http: //www. iseries. ibm. com/developer/education/ibo/curr. html? apdv 8 2002 IBM Corporation

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: AS/400 e e (logo) business IBM(logo) i. Series OS/400 Lotus, Freelance Graphics, and Word Pro are registered trademarks of Lotus Development Corporation and/or IBM Corporation. Domino is a trademark of Lotus Development Corporation and/or IBM Corporation. C-bus is a trademark of Corollary, Inc. in the United States, other countries, or both. Java and all Java-based trademarks are 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. Action. Media, LANDesk, MMX, Pentium and Pro. Share trademarks of Intel Corporation in the United States, other countries, or both. 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

Questions To ask a question, simply click on the "Ask a Question" button in the bottom left corner of the presentation screen. Doug will get to those questions shortly after the event. Your questions will be answered and posted on the Search 400. com site. 8 2002 IBM Corporation

Скачать презентацию DB 2 UDB for i Series V 5

6f5d2661fdf0f1d33116d618a328c0ef.ppt

Количество слайдов: 28