1 / 51

Understanding Why Customers Will Move to DB2 for z/OS V8

Understanding Why Customers Will Move to DB2 for z/OS V8. Mark DePledge Database Sales Specialist depledge@us.ibm.com. Agenda. DB2 for z/OS V8 History Features (30k feet) Why customers are moving to V8 Migration Planning Workshop DB2 Why customers are moving to V8

hosea
Télécharger la présentation

Understanding Why Customers Will Move to DB2 for z/OS V8

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Understanding Why Customers Will Move to DB2 for z/OS V8 Mark DePledge Database Sales Specialist depledge@us.ibm.com

  2. Agenda • DB2 for z/OS V8 • History • Features (30k feet) • Why customers are moving to V8 • Migration Planning Workshop • DB2 Why customers are moving to V8 • Exploiting DB2 V8 with Tools

  3. V1.1 V1.2 V1.3 V2.1 V2.2 V2.3 V3 V4 V5 V6V7 V8 1983 1992 1993 1995 1997 1999 2001 2004 Brief DB2 History Memory Availability Performance SQL VLDB New Workloads Unicode Long Names Universal Database Triggers UDF UDT LOBs Data Spaces Online Reorg TCPIP Sysplex Parallelism SQLEnhancements Stats History Utility Wildcards Parallel IO Hiperspaces Referential Integrity Data Sharing T2 Indexes Stored Procedures CPU Parallel Sequential Prefetch Packages Breakthroughs Explain Sequential Detection GUI Tools Store Proc Language Rexx

  4. DB2 for z/OS Version 8 is • Reengineering & Renaissance • Breaking the Limits • SQL Function & DB2 family • Performance Enhancements • Continuous Availability • VLDB • Indexing Improvements • Utilities • WebSphere, Java, & Distributed • SAP, PeopleSoft, & Siebel • Unicode Catalog (mostly) • Unicode, ASCII, and EBCDIC tables • Large Memory Addressing • Long Name Support • Multilevel Security with Row Level Granularity (MLS) • Server Location Aliases • Client Location Aliases • Unicode Catalog (mostly) • Unicode, ASCII, and EBCDIC tables • Large Memory Addressing • Long Name Support • Multilevel Security with Row Level Granularity (MLS) • Server Location Aliases • Client Location Aliases Reengineered for e-business On Demand

  5. DB2 for z/OS Version 8 is • 64 bit addressing • 16 EB of storage • 1TB per Bufferpool • No Hiperpools or Dataspaces • Indexes increased to 2000 bytes • 128TB Tables (32K page) • 4096 Partitions • 2 MB SQL Statements • 225 way joins • 93 Active & 10000 Archive Logs • 64 bit addressing • 16 EB of storage • 1TB per Bufferpool • No Hiperpools or Dataspaces • Indexes increased to 2000 bytes • 128TB Tables (32K page) • 4096 Partitions • 2 MB SQL Statements • 225 way joins • 93 Active & 10000 Archive Logs • Reengineering & Renaissance • Breaking the Limits • SQL Function & DB2 family • Performance Enhancements • Continuous Availability • VLDB • Indexing Improvements • Utilities • WebSphere, Java, & Distributed • SAP, PeopleSoft, & Siebel Reengineered for e-business On Demand

  6. Common Table Expressions • Multi-row Fetch • Multi-row Insert • Wide Cursor Positioned Update / Delete • GET DIAGNOSTICS • Insert within Select • Sequences • Dynamic Scrollable Cursors • Current Package Path • Scalar Fullselect Expressions • Materialized Query Tables • XML Publishing • Volatile Table Attribute • SQL Procedure Language improvements • Multiple Distincts in a Select • New Special Registers to distributed threads • GETVARIABLE function • For MLS & other info • Encryption Built In Functions • CARDINALITY clause • READ ONLY using KEEP UPDATE LOCKS • IS NOT DISTRINCT FROM… • Common Table Expressions • Multi-row Fetch • Multi-row Insert • Wide Cursor Positioned Update / Delete • GET DIAGNOSTICS • Insert within Select • Sequences • Dynamic Scrollable Cursors • Current Package Path • Scalar Fullselect Expressions • Materialized Query Tables • XML Publishing • Volatile Table Attribute • SQL Procedure Language improvements • Multiple Distincts in a Select • New Special Registers to distributed threads • GETVARIABLE function • For MLS & other info • Encryption Built In Functions • CARDINALITY clause • READ ONLY using KEEP UPDATE LOCKS • IS NOT DISTRINCT FROM… DB2 for z/OS Version 8 is • Reengineering & Renaissance • Breaking the Limits • SQL Function & DB2 family • Performance Enhancements • Continuous Availability • VLDB • Indexing Improvements • Utilities • WebSphere, Java, & Distributed • SAP, PeopleSoft, & Siebel Reengineered for e-business On Demand

  7. Indexing improvements • NUDS on NICS • Cost Based Parallel Sorting • Star Join with Sparse Indexes • Enhanced Trigger operation • SQL Cardinality clause • REPORT(ONCE) • Dynamic Statement Cache Explain • Temp Tables ON COMMIT DROP • Data Sharing Improvements • Batched GBP writes • Reduced False Contention • Intelligent Visual Explain • Multi-row Fetch used for distributed connections • Materialized Query Tables • WLM task control for Stored Procedures • BP Page Fixing • Indexing improvements • NUDS on NICS • Cost Based Parallel Sorting • Star Join with Sparse Indexes • Enhanced Trigger operation • SQL Cardinality clause • REPORT(ONCE) • Dynamic Statement Cache Explain • Temp Tables ON COMMIT DROP • Data Sharing Improvements • Batched GBP writes • Reduced False Contention • Intelligent Visual Explain • Multi-row Fetch used for distributed connections • Materialized Query Table • WLM task control for Stored Procedures • BP Page Fixing DB2 for z/OS Version 8 is • Reengineering & Renaissance • Breaking the Limits • SQL Function & DB2 family • Performance Enhancements • Continuous Availability • VLDB • Indexing Improvements • Utilities • WebSphere, Java, & Distributed • SAP, PeopleSoft, & Siebel Reengineered for e-business On Demand

  8. Schema Evolution • Several changes which required a DROP are now online ALTERs • Adding Partitions • Rotating Partitions • Alter CLUSTERing • Tables & Indexes • Add index column • Dependent Indexes & Views handled • Sequence / Identity attributes • Partitioning Improvements • Utility Enhancements • Improved LPL Recovery • Online ZParms • Sliding Scale SQTY • Schema Evolution • Several changes which required a DROP are now online ALTERs • Adding Partitions • Rotating Partitions • Alter CLUSTERing • Tables & Indexes • Add index column • Dependent Indexes & Views handled • Sequence / Identity attributes • Partitioning Improvements • Utility Enhancements • Improved LPL Recovery • Online ZParms • Sliding Scale SQTY DB2 for z/OS Version 8 is • Reengineering & Renaissance • Breaking the Limits • SQL Function & DB2 family • Performance Enhancements • Continuous Availability • VLDB • Indexing Improvements • Utilities • WebSphere, Java, & Distributed • SAP, PeopleSoft, & Siebel Reengineered for e-business On Demand

  9. DB2 for z/OS Version 8 is • Reengineering & Renaissance • Breaking the Limits • SQL Function & DB2 family • Performance Enhancements • Continuous Availability • VLDB • Indexing Improvements • Utilities • WebSphere, Java, & Distributed • SAP, PeopleSoft, & Siebel • 4096 Partitions • Data Partitioned Secondary Indexes (DPSI's) • Unbundling Partitioned / Clustering Indexes • Online Schema Evolution • Add Partitions • Rotate Partitions • Data Type Change • Performance/Optimization • 4096 Partitions • Data Partitioned Secondary Indexes (DPSI's) • Unbundling Partitioned / Clustering Indexes • Online Schema Evolution • Add Partitions • Rotate Partitions • Data Type Change • Performance/Optimization Reengineered for e-business On Demand

  10. h • Unlike Type Indexable Predicates • Reverse scan of an Index • NOT PADDED columns for • Varying length index columns • Indexes only access • 2000 byte indexes • No partitioning index needed for partitioned tables • Table Controlled Partitioning • Partitioning and Clustering indexes do not have to be the same • Data Partitioned Secondary Indexes • Enhanced recovery, locking concurrency, data sharing, eliminated BUILD2 phase. • Unlike Type Indexable Predicates • Reverse scan of an Index • NOT PADDED columns for • Varying length index columns • Indexes only access • 2000 byte indexes • No partitioning index needed for partitioned tables • Table Controlled Partitioning • Partitioning and Clustering indexes do not have to be the same • Data Partitioned Secondary Indexes • Enhanced recovery, locking concurrency, data sharing, eliminated BUILD2 phase. DB2 for z/OS Version 8 is • Reengineering & Renaissance • Breaking the Limits • SQL Function & DB2 family • Performance Enhancements • Continuous Availability • VLDB • Indexing Improvements • Utilities • WebSphere, Java, & Distributed • SAP, PeopleSoft, & Siebel Reengineered for e-business On Demand

  11. System Level Backup • System Level Recovery with PIT option • REPAIR VERSION • Automatic Restart • REBALANCE • SORTKEYS / SORTDATA defaults • DFSort used by V8 Utilities • Catalog SHRLEVEL REFERENCE Online REORG • Online REORG w/DISCARD • Load / Unload delimited output • SCOPE PENDING • Runstats NUDS on NICS • Runstats Purge Dynamic Statement Cache • Accounting Data Aggregation • System Level Backup • System Level Recovery with PIT option • REPAIR VERSION • Automatic Restart • REBALANCE • SORTKEYS / SORTDATA defaults • DFSort used by V8 Utilities • Catalog SHRLEVEL REFERENCE Online REORG • Online REORG w/DISCARD • Load / Unload delimited output • SCOPE PENDING • Runstats NUDS on NICS • Runstats Purge Dynamic Statement Cache • Accounting Data Aggregation DB2 for z/OS Version 8 is • Reengineering & Renaissance • Breaking the Limits • SQL Function & DB2 family • Performance Enhancements • Continuous Availability • VLDB • Indexing Improvements • Utilities • WebSphere, Java, & Distributed • SAP, PeopleSoft, & Siebel Reengineered for e-business On Demand

  12. DB2 for z/OS Version 8 is • Reengineering & Renaissance • Breaking the Limits • SQL Function & DB2 family • Performance Enhancements • Continuous Availability • VLDB • Indexing Improvements • Utilities • WebSphere, Java, & Distributed • SAP, PeopleSoft, & Siebel • Encrypt data on the wire • Extended DESCRIBE • SQL CANCEL • READ ONLY using KEEP UPDATE LOCKS • IS NOT DISTRINCT FROM… • Type2 & Type4 Java Drivers • TCPIP Improvements • Encrypt data on the wire • Extended DESCRIBE • SQL CANCEL • READ ONLY using KEEP UPDATE LOCKS • IS NOT DISTRINCT FROM… • Type2 & Type4 Java Drivers • TCPIP Improvements Reengineered for e-business On Demand

  13. DB2 for z/OS Version 8 is • Long object names • Unicode table and SQL support • Scalar Fullselect • Sequences • Common Table Expressions and Recursive SQL • Multiple DISTINCT clauses • Group By expression • Literals and Predicates longer than 255 bytes • SQL statements greater than 32K bytes • Materialized Query Tables • Transparent ROWID for LOBs • Long object names • Unicode table and SQL support • Scalar Fullselect • Sequences • Common Table Expressions and Recursive SQL • Multiple DISTINCT clauses • Group By expression • Literals and Predicates longer than 255 bytes • SQL statements greater than 32K bytes • Materialized Query Tables • Transparent ROWID for LOBs • Reengineering & Renaissance • Breaking the Limits • SQL Function & DB2 family • Performance Enhancements • Continuous Availability • VLDB • Indexing Improvements • Utilities • WebSphere, Java, & Distributed • SAP, PeopleSoft, & Siebel Reengineered for e-business On Demand

  14. Prerequisites Summary • zSeries Architecture (z800, z890, z900, z990) • 64 bit exploitive • z/OS 1.3 or above • Data Sharing improvements require z/OS 1.4 (with CFLevel 12) • System Level Backup / Recovery & Multilevel Security require z/OS 1.5 • Migrate from DB2 for z/OS and OS/390 V7 • Unicode Conversion Services enabled • DSNHDECP customized for EBCIDIC, ASCII, and Unicode • No Type1 Indexes • Other prerequisites by feature • Other assessments required • CCSIDs in V7 • Language assessments

  15. DB2 UDB for z/OS QMF Net Search QMF QMF No-Charge Base Engine Classic Extender V7 Distributed Features Enterprise (stabilized) -QMF TSO/CICS Base Includes: - QMF for WebSphere QMF TSO/CICS z/OS Application - QMF for WebSphere Base ( msys, Rexx) -For workstation: Connectivity (T4) - QMF High Performance IRLM 2.2 - QMF for WebSphere Option (HPO) ODBC/JDBC/SQLJ - QMF for Windows Net.Data V7 -For workstation: JDBC (legacy+T2) - QMF Visionary Studio (stabilized) DB2 Extenders - QMF for WebSphere Text Extender - QMF for Windows DB2 (stabilized) - QMF Visionary Studio Management Audio, Video, Image Clients Extender Package (stabilized) XML Extender DB2 Management Clients Package Includes: * Note: Orders placed on or after November 12, 2004 will receive DB2 Connect PE 8.2 DB2 Connect PE 8.1 * Control Center Development Center No-Charge / Replication Center Optional Command Center z/OS Enablement for Priced / Control Center Optional DB2 Administration Server for z/OS (DAS) DB2 Visual Explain (CD/Rom) V8 Packaging & Changes (continued)

  16. Migrating to V8 • More formalized than prior migration • Migration occurs in three phases • Only from DB2 for z/OS & OS/390 V7 • Acquire and run DSNTIJP8 through the V7 maintenance stream and run against your V7 system early to discover items needing correction / change. • This is the same as DSNTIJPM delivered with V8. • Reestablish the V7 IVP • Assess ISV Package and Tooling Requirements • Training • Technical Conferences • IDUG • Onsite DB2 for z/OS V8 Migration Planning Wworkshop • Health Checks / Solution Assurance Reviewss

  17. Migrating to V8 • Develop compatibility and coexistence goals • Establish performance baselines • Develop the project plan • Plan for memory, CPU, and DASD increases, but also learn about several features that will reduce / eliminate increases in all three categories

  18. In CM you get: • 64 bit • Hiperpools / Dataspaces converted to primary bufferpools • Bufferpool page fixing option • New access paths • New V8 Utilities (EXCEPT System Backup & Recovery) • No new SQL function Migrating to V8 Migration Modes Enable New Function Mode (ENFM) Compatibility Mode (CM) New Function Mode (NFM) • Fallback maintenance is required to enter CM (and other prereqs) • Can last as long as necessary • No new function available • Run tests to ensure that no regression is taking place • V7 and V8 Data Sharing coexistence supported • Fallback to V7 is allowed • Minimize time in CM with SAP V8 Binaries/V7 Catalog V7 changes to V8 Catalog New V8 Feature

  19. Migrating to V8 Migration Modes Enable New Function Mode (ENFM) Compatibility Mode (CM) New Function Mode (NFM) • Administrator runs a job that triggers the ability to use new features of V8 • No Fallback allowed to V7 • No Returning to CM • Can return to ENFM • No change to the catalog data or structure • Convert DB2 so that it is ready to support new functions • Series of ALTERS and ONLINE REORGS of the Catalog and Directory • Process can be halted and restarted • This is a group wide event - no V7 allowed even if ENFM not running • However, no fallback to DB2 V7 is alowed once this job is started • Fallback maintenance is required to enter CM (and other prereqs) • Can last as long as necessary • No new function available • Run tests to ensure that no regression is taking place • V7 and V8 Data Sharing coexistence supported • Fallback to V7 is allowed • Minimize time in CM with SAP V8 Binaries/V7 Catalog V7 changes to V8 Catalog New V8 Feature

  20. possibly Cocktail Material V8 Interesting Coffee Topics • Parts of V8 design has been in work since 1999 • V8 Utilities use of DFSort • DB2 UDB for z/OS Utilities Suite has a license to use DFSort when invoked by the utilities • Must have access to DFSort R14 plus APAR PQ68263 applied • ISPF APAR OA07685 for Unicode browsing • V8 IVP cannot be run until in New Function Mode

  21. V8 Interesting Myths • In V8, you will have to convert your application’s stored data to Unicode. • Convert only if you have the need to store international data. • Unicode will always double your storage requirement. • Original UCS-2 stored everything in 2 bytes, but UTF-8 is very similar to ASCII. • Unicode does not affect me. • SQL & programs are prepared in Unicode. • Once I start migrating to V8, I can’t go back. • Understand how and when fallback can be performed during a V8 migration and what options are available. Practice! • Migration is completely different in V8. • In some ways, yes. In other ways, it is what we have been doing all along.

  22. V8 Interesting Myths • V8 requires more CPU, Memory, and Disk • Maybe, but there are a number of items that will improve / reduce resource requirements with minimal or no changes • Multi-row Fetch for distributed connections • Bufferpool page fixing • Others will require some work, but no application changes • Drop indexes no longer needed (reverse scan & partitioning) • Alter / Rebuild indexes on variable length columns (NOT PADDED) • REORG Tablespaces to match VSAM CI size to the DB2 page size CPU CPU Disk & IO Disk & CPU IO VSAM 4k VSAM 4k V7 16k Page size V8 16k Page size VSAM 16k Savings! VSAM 4k VSAM 4k

  23. DB2 for z/OS Migration Planning Workshop • To help customers navigate through the DB2 for z/OS V8 information / resources available • To communicate prerequisites early in the decision making process • To offer the opportunity to exchange ideas • To bring a project focus to migration

  24. Migration Planning Workshop - Checklists • Functional Inventory • Components • Prerequisites • Migration Considerations • Release Incompatibilities

  25. Migration Planning WorkshopFunctional Inventory • 2 pages representing the DB2 V8 features • General categorizations • Tool used for survey conducted in December for 2004 attendees • Helps build business justification or just summarize the wealth of feature in V8

  26. Migration Planning WorkshopComponents • Simple listing of FMIDs, PSP Bucket Information, and Descriptions • Manuals provided • How to order manuals

  27. Migration Planning WorkshopPrerequisites • Listing of prerequisites, the associated requirement, and detailed notes • Most of the checklist time is spent on these last three documents

  28. Items to watch • May not be required, but may impact your environment Migration Planning WorkshopMigration Considerations

  29. Migration Planning WorkshopRelease Incompatibilities • Items requiring evaluation when migrating • Pay special attention to internal and external tooling • Also include informational items

  30. V8 Project Planning - Assumptions • Consider this a framework or skeleton - suggestions • Use for ideas in your own environment • Tasks will be moveable to a degree • Overlay “freezes” based on your production schedules • Environments with many subsystems or data sharing in each environment (many Development, many Productions, etc) will likely needs more consideration analysis. • The plan contains dependencies, but no resource leveling

  31. Sandbox Environment Compatibility Mode Enable New Function Mode New Function Mode Installation of Code V8 Project Planning

  32. Customer Comments Very good level set of V8 features. Will help with our V8 migrations. Very productive day & workshop. Thanks for the reference materials. Time was very well spent. St. Louis, MO The Functional Inventory, Subsystem Defaults, and Migration Considerations are especially useful. I also like the open forum approach so that different companies can explain their environment – a way to exchange ideas. St. Louis, MO The project plan will come in handy with the administrative tasks. I took the 3 day transition class a few months back. This was a nice refresher course prior to installation. Pittsburgh, PA The migration project plan was very good. It was not part of the transition class. Pittsburgh, PA

  33. As of 12/17/2004

  34. FEATURE Large Memory Support, 64-bit Addressing, VSCR 9.57% Staying Current 6.38% SAP, PeopleSoft, and Siebel General (ISV Driven) 5.32% SQL Function & DB2 Family General 5.32% Schema Evolution General 4.26% Partitioning Improvements 4.26% DPSI's (Enhanced Recovery, Locking, Data Sharing, & Eliminated BUILD2) 4.26% Table Control Partitioning 4.26% NOT PADDED Indexes (Varying Length & Index Only) 3.19% Performance Improvements General 3.19% Fitting into other project timelines 3.19% Long Name Support 3.19% Multi-row Fetch 3.19% Multi-row Insert 3.19% 2 MB SQL Statements 2.13% Online ZParms 2.13% SE: Sequence & Identity Attributes 2.13% Sequences 2.13% Online Reorg Discard 2.13% Reverse scan of an index 2.13% Why are customers migrating from the Field • Information received on approximately 30 customers • Direct customer responses • Peer information sharing

  35. DB2 for z/OS Version 8 is • SQL Function & DB2 family 17% • Continuous Availability 16% • Indexing Improvements 12% • Reengineering & Renaissance 11% • Breaking the Limits 11% • SAP, PeopleSoft & Siebel 10% • VLDB 9% • No Category 6% • Performance Enhancements 5% • Utilities 3% • WebSphere & Java & Distributed 1% Reengineered for e-business On Demand

  36. Performance Management • DB2 Performance Expert (z/OS and Multiplatform) • DB2 Performance Monitor • DB2 Buffer Pool Analyzer • DB2 Query Monitor • DB2 SQL Performance Analyzer • DB2 Omegamon for DB2 DB2 DATA BASE TOOLS • Database Administration • DB2 Administration Tool • DB2 Object Comparison Tool • IBM Data Encryption for IMS and DB2 Databases DB2 Tools • Application Management • DB2 Bind Manager • DB2 Path Checker • DB2 Data Archive Expert • DB2 Information Integrator Classic Federation for z/OS • DB2 Table Editor (z/OS and Multiplatform) • DB2 Test Database Generator • DB2 Web Query Tool (z/OS and Multiplatform) • Recovery Management • DB2 Archive Log Accelerator • DB2 Change Accumulation Tool • DB2 Log Analysis Tool • DB2 Object Restore • DB2 Recovery Expert (Multiplatform) • IBM Application Recovery for IMS and DB2 Data Bases • Utilities and Utility Management • DB2 Utilities Suite • DB2 Automation Tool • DB2 High Performance Unload (z/OS and Multiplatform) • Data Replication • DB2 Data Propagator • Information Integrator – Q Based Replication

  37. Target Source Source Control Control Control Capture Utilities Admin Apply New Replications Solutions for DB2 - Q Replication Federation Engine Log based Stored Procedure WebSphere MQ XML Capture Federation Engine Log based WebSphere MQ • Availability, Event, Offload, Distributed

  38. V8 Utilities Exploitation

  39. ! DB2 Tools To Leverage and Exploit DB2

More Related