DB2%20UDB%20for%20iSeries:%20V5R2%20enhancements%20to%20the%20iSeries'%20self-managing%20database - PowerPoint PPT Presentation

About This Presentation
Title:

DB2%20UDB%20for%20iSeries:%20V5R2%20enhancements%20to%20the%20iSeries'%20self-managing%20database

Description:

... Broadcast Help page for more information or to test your browser compatibility. ... Open Standard(s)/SQL Support/DB2 Compatibility. JDBC V3.0 (native and Linux) ... – PowerPoint PPT presentation

Number of Views:209
Avg rating:3.0/5.0
Slides: 29
Provided by: search400T
Category:

less

Transcript and Presenter's Notes

Title: DB2%20UDB%20for%20iSeries:%20V5R2%20enhancements%20to%20the%20iSeries'%20self-managing%20database


1
DB2 UDB for iSeries V5R2 enhancements to the
iSeries' self-managing database
  • Doug Mack
  • mackd_at_us.ibm.com

2
WEBCAST SCHEDULE
  • Todays 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 PowerPoint
    presentation on the webcast topic.
  • 35 -- 60 Moderator and speaker engage in a QA
    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.

3
TECHNICAL FAQs
  • Here are answers to the most common technical
    problems users encounter during a webcast
  •  
  • Q Why cant 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. Youll should refresh (hit F5) 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/

4
DB2 UDB for iSeries

V5R2 Update
8 2002 IBM Corporation
5
ibm.com/eserver/iseries
Agenda
  • Background
  • Landscape
  • DB2 UDB Strategy
  • V5R2 Enhancements
  • Availability
  • Openness (Industry Standards/DB2 Family)
  • Performance
  • Usability
  • Resources

6
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

7
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!
  • DB2 is a family of IBM products that run on over
    twenty platforms
  • DB2 UDB for iSeries is built into OS/400
  • The DB2 family has surpassed Oracle as the leader
    in database marketshare
  • DB2 UDB for iSeries leads the industry in support
    of the SQL ANSI Core '99 standard elements

Source Based on Dataquest, May 2002 Release
8
ibm.com/eserver/iseries
DB2 UDB for iSeries Strategic Initiatives
  • Openness - Industry Standard Support
  • Accomodate ISVs
  • Portability/Compatibility
  • Flexibility
  • Continued LEADERSHIP in database technologies
  • Consistency across DB2 family
  • Common SQL, comon utilities
  • Shared R D across IBM Labs
  • Continued Leveraging of iSeries Strengths
  • Availability
  • Scalability
  • Usability - Total Cost of Ownership
  • For example Query Optimizer DESIGNED for Low TCO
  • Application Flexibility

9
ibm.com/eserver/iseries
OS/400 Database History Lesson
  • 2001
  • SQLTriggers
  • Database Navigator
  • Generate SQL
  • 2G LOBs
  • 1TB tables
  • ODBC 3.5
  • DB2 Extemders

IBM Delivers Robust SQL Function
  • 1999/2000
  • Large Objects
  • SQLJ
  • Data Links
  • UDTs, UDFs
  • Op Nav Performance Monitor
  • DB2 OLAP
  • Visual Explain
  • Java (tm) Stored Procedures
  • 1997/98
  • Cluster parallelism
  • Data mining
  • Parallel Index Build
  • UCS-2
  • BI Solutions
  • Dynamic Bitmaps
  • Encoded Vector Indexes
  • Parallel Data Loader
  • 1995/96
  • SQL Optimization
  • Referential Integrity
  • DRDA DUW
  • Net.Data
  • Triggers
  • Long Names
  • Stored Procedures
  • SMP Parallelism
  • 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
  • 2002/3
  • Self Optimizing Query Engine
  • Migration Toolkits
  • Multiple Name Spaces
  • Switchable Disk Clustering
  • Index Advisor
  • New Statistics Manager
  • Adaptive e-Business Transaction Services
  • Enhanced DB2 Family Compatibility
  • Add'l SQL Standards Support

1997 Renamed to DB2 UDB
1995 RDBMS is named DB2/400
10
ibm.com/eserver/iseries
DB2 UDB Extenders XML Extender - 5722-DE1
Application
DAD (Data Access Definition)
DB2 XML Extender
DB2
XML Collection
XML Column
user table
book
XML DOC
XML DOC
  • XML column
  • Store and retrieve entire XML documents as DB2
    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

11
ibm.com/eserver/iseries
DB2 UDB Symmetric MultiProcessing Feature
  • Parallel Methods
  • 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

M E M O R Y
QUERY SQL
Single Level Storage
IOP
IOP
IOP
IOP
IOP
IOP
IOP
Cust 1
Cust 2
Cust 3
Cust 4
Cust 5
Cust 6
Cust 7
12
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
First Row
Last Row
Count
Arizona
1
1
80005
5000
Arkansas
2
5
99760
7300
......
Virginia
37
1222
30111
340
Wyoming
38
7
83000
2760
Vector
1
13
12
28
2
17
38
2
26
33
....
Row 1
Row 2
13
ibm.com/eserver/iseries
DB2 UDB for iSeries
V5R2 Enhancements - Overview
  • Performance
  • Transaction Services - WebSphere
  • Query Optimizer Statistics Engine - BI, SQL
  • Improved EVI Maintenance
  • Journal Caching
  • Database Availability
  • Switchable Disk Clustering with Independent ASP
    Support
  • Partial Rollback
  • Savepoints
  • Usability
  • Operations Navigator Enhancements
  • DB2 OLAP
  • Data Mining
  • SQL Enhancements for Traditional Programmers
  • Migrate legacy programmers to SQL
  • e-Infrastructure/EAS Application
    Availability/Portability
  • Enhanced Support for the SQL Industry Standard
  • Transaction Services
  • Enhanced DB2 UDB Family Compatibility
  • Server Consolidation
  • DB2 UDB in Linux
  • Database Migration Toolkits/Services
  • Multiple Database Name Support
  • Independent ASPs


This does not imply 100 Compatibility across
all DB2 UDB Family Members
14
ibm.com/eserver/iseries
Open Standard(s)/SQL Support/DB2 Compatibility
  • CLI Enhancements
  • SQL Statement Length expanded to 64K
  • PSM Improvements
  • Iterate
  • Nested Compound Statements
  • Remote Result Set Support (CLI and JDBC)
  • DRDA compatiblity - retrieve results sets from
    production system
  • Savepoints (DB2 compatibility)
  • New Database Catalog Views for ODBC/JDBC (DB2
    Compatibility)
  • JDBC V3.0 (native and Linux)
  • User Defined Table Functions
  • Improved DB2 XML Extender Performance
  • Identity Column (auto incrementing)
  • ROWID Column type
  • System wide Unique Row Identifier
  • UNION in a view
  • Global Temp Tables
  • SQL Syntax to create in QTEMP - more industry
    standard
  • New Transaction Services
  • XA and JTA (Java Transaction API)

15
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

16
ibm.com/eserver/iseries
Performance
  • Transaction Services
  • Open Standard
  • XA and JTS (Java Transaction Services API)
  • Improved e-Business Apps
  • WebSphere
  • Database Technology Enhancements
  • Enhanced performance and recovery options for DB2
    UDB access path protection
  • Object-oriented query optimizer that lays
    foundation for self-learning query optimizer
  • Streamlined data access for SQL interfaces
  • V5R2 Performance Gains
  • Limited to certain SQL operations

Application Server
iSeries Connection Management
Server Job 1
1
DB2 UDB for ISeries
Transaction Objects
Server Job m
5
1000s of clients
17
ibm.com/eserver/iseries
Availability Switched Disk Clustering
System Data
System Data
Switched Disk
DB2 Store_1
DB2 Store_3
DB2 Store_2
IFS UDFS
Archive Store_1
Archive Store_2
  • High Availability Flexibility
  • Switchable Disks for scheduled maintenance
  • NOT a replacement for H/A Solutions
  • Multiple Relational Databases on a single iSeries
  • Multiple Namespaces
  • Consolidate Servers while maintaining separate,
    regional databases

18
ibm.com/eserver/iseries
iSeries 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

19
ibm.com/eserver/iseries
DB2 UDB for iSeries 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
  • Object Based Kernel in OS/400

M E M O R Y
QUERY SQL
Single Level Storage
IOP
IOP
IOP
IOP
IOP
IOP
IOP
Cust 1
Cust 2
Cust 3
Cust 4
Cust 5
Cust 6
Cust 7
20
ibm.com/eserver/iseries
DB2 OLAP Database Utility for Reporting Systems -
V8
  • OLAP is OnLine Analytical Processing
  • DB2 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
  • DB2 OLAP is based on OPEN Standards
  • Accomodate just many End User Interfaces
  • Executive Information Systems
  • Spreadsheets
  • Portals
  • OLAP Mining
  • Delivered via PTF to V7
  • V8 Just Delivered
  • Hybrid Relational and Multi-Dimensional OLAP
  • Performance - Parallel cube loads/calcs
  • Heterogeneous Data Extracts

21
ibm.com/eserver/iseries
DB2 UDB in Linux
  • DB2 UDB for Unix/Windows/Linux
  • IBM Statement of Direction
  • WorkGroup Edition
  • Entry Level Pricing
  • Enterprise Edition Edition
  • More function bundled in
  • Beta Program Commencing 1Q 2003
  • Connecting to DB2 UDB for iSeries
  • DB2 Connect, JDBC, ODBC
  • Data Propagator

OS/400
OS/400
Linux
Linux
DB2 UDB
DB2 UDB for iSeries
DB2 Connect
DPropR
22
ibm.com/eserver/iseries
Database Migration Utilities
Services and Toolkits
  • Oracle Migration Toolkit
  • No Charge Migration Utility
  • Q4 2002 Availability
  • Downloadable
  • http//www-919.ibm.com/servers/eserver/iseries/dev
    eloper/db2/porting.html
  • Converts to DB2 UDB for iSeries
  • Data Type Conversion
  • Stored Procedure, Trigger Conversion
  • Custom Technology Center Services RECOMMENDED
  • Not a 100 Conversion utility
  • SQLServer to DB2 Migrations
  • www.ibm.com/servers/eserver/iseries/service/ctc

23
DB2 UDB for iSeries Product Offerings
Feature
Function
Delivery Mechanism
Benefit
When to use
DB2 UDB for iSeries
Relational Database, SQL Engine, Database
Interfaces, Operations Navigator
Included in OS
World Class Relational Database
Never Stop! Included with every system
DB2 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
DB2 Multi-System
Allows you to split records from a single
table(physical file) across multiple systems.
Database Partitioning feature ala DB2 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 to remote systems
When customer needs to create second database
(for backup, or data replication) with minimal
impact to production envrionment
QMF for Windows
Query/400-like capability in Windows environment.
Import Query/400 directly in QMF formats.
Compatibility with other DB2 family members.
Chargeable iSeries Feature
Common Query tool for multiple DB2 UDBs
Low Cost tool - consider including in every config
24
DB2 UDB for iSeries Product Offerings
Feature
Function
Delivery Mechanism
Benefit
When to use
Data Propagator Capture and Apply
Replicate Data between iSeries systems - requires
journaling (or remote journaling) for CHANGED
DATA ONLY replication
Chargeable iSeries Product
Replicate Data across DB2 Family Members
Data Replication req'd for variety of reasons
(data warehouse, web, consolidated databases)
DB2 Text/XML Extender
Programming interfaces for developing
applications using DB2-XML interchange or Text
Search Capabilities
Chargable iSeries Product
Programming Enablers
For Application Developers
DB2 OLAP
Database Utility to build high performance
reporting repositories
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
Query Manager and SQL Development Toolkit
5250 based offering providing (1) forms oriented
query building facility (2) interactive SQL
scripting, and (3) SQL pre-compiler for
applications written with embedded SQL
Chargeable iSeries Product
Commonality with OS/390 QMF products, interactive
SQL Scripting Interface for development
Requirement for QM compatibility application
development environments
Web Query Tool
Web based Query tool.
SWG Passport Advantage Product
Pure web based solution. Low Cost query.
If web based query capability is required.
25
ibm.com/eserver/iseries
DB2 UDB For iSeries Information
  • Deliverables
  • DB2 UDB for iSeries CD
  • http//www.elink.ibmlink.ibm.com/public/applicatio
    ns/publications/cgibin/pbi.cgi
  • DB2 UDB for iSeries New and Enhanced Utilities
  • DB2 UDB for iSeries Frequently Asked Questions
  • DB2 UDB for iSeries Business Intelligence
    Concepts (Updated)
  • "Got Those Query Blues?" Paper
  • iSeries Nation and DB2 UDB for iSeries Home Page
    Websites (Updated)
  • DB2 UDB Common SQL Comparison Document

26
ibm.com/eserver/iseries
Additional Resources
  • DB2 UDB for iSeries Home Page
  • http//www.ibm.com/servers/eserver/iseries/db2
  • DB2 UDB for iSeries Frequently Asked Questions
  • http//www.ibm.com/servers/eserver/iseries/db2/db2
    faq.htm
  • DB2 UDB for iSeries Overview White Paper
  • http//www.ibm.com/servers/eserver/iseries/db2/ove
    rview.htm
  • DB2 UDB Family Compatibility
  • http//www.iseries.ibm.com/developer/db2/downloads
    /cpsqlref.pdf
  • DB2 UDB Family Common Utilities
  • http//www.ibm.com/servers/eserver/iseries/db2/db2
    udbprod.htm
  • iSeries Navigator On-line Tutorials
  • http//www.as400.ibm.com/developer/education/ibo/v
    iew?biz.html
  • DB2 UDB for iSeries On-Line Education
  • http//www.iseries.ibm.com/developer/education/ibo
    /curr.html?apdv

27
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
IBM(logo)
AS/400e
iSeries
e (logo) business
OS/400
IBM
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, Windows NT, and the
Windows logo are trademarks of Microsoft
Corporation in the United States, other
countries, or both. ActionMedia, LANDesk, MMX,
Pentium and ProShare are 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.
28
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 Search400.com
    site.
Write a Comment
User Comments (0)
About PowerShow.com