DB2 Advanced Enterprise Server Edition Why You Should Consider It - - PowerPoint PPT Presentation

DB2 Advanced Enterprise Server Edition

Why You Should Consider It

Agenda:

 Introduction to The Fillmore Group  Background on AESE and IBM data strategy  AESE bundle components  IBM software purchasing primer  Upgrade paths to AESE  Simple upgrade examples  Upgrade pricing and timing factors  Complicated upgrade examples  Upgrade cost and timing calculator

3 Takeaways:

 Frank loves AESE  How MY organization can upgrade  Patience Pays!

The Fillmore Group, Inc.

• Frank Fillmore, DB2 Gold Consultant, IBM Champion
• DB2 Technical Support and Consulting
• IBM Authorized Training Partner
• IBM Information Management Software Reseller

Services:

 DB2 – implementation and tuning  Data Governance tools  Information Integration  Data Warehousing

DB2 Advanced Enterprise Server Edition

Background and Components

IBM Information Management

DB2 AESE

 Announced at IOD, October, 2010  AESE is a superset of DB2

Enterprise Server Edition (ESE)

 Includes popular, separately-priced

features to provide best value

 Better features, better value

What’s Included in AESE?

Everything that was in DB2 Enterprise Server Edition, and more… Compression: Storage Optimization Feature Tuning: Workload Management & Optim Performance Manager T

• ols: Optim Database Administrator & Development Studio

Federation: Support for Oracle & DB2 federation High Availability: Q-Replication for DB2 LUW source/targets Security: Label based access control

DB2 AESE Functionality vs. Oracle 11gR2

Compression Data Protection Data Partitioning Performance Managemen Developer Tooling Data Replication

Included

Storage Optimization Feature (SOF) Deep compression for lower data storage costs

Compression gives you the ability to transparently compress data on disk in

• rder to decrease disk space and storage infrastructure requirements. Since

disk storage systems are often the most expensive components of a database solution, even a small reduction in the storage subsystem can result in substantial cost savings for the entire database solution. For additional information on compression go to: http://www-01.ibm.com/software/data/db2/linux-unix-windows/storage- compression.html

Performance Optimization Feature (POF)

DB2 Performance Optimization Feature gives customers the insight and ability to optimize workload execution. This feature can save money and lower risks by helping customers do more work with existing hardware, ensure Service Level Agreements (SLAs) are met or exceeded and increase DBA productivity. The Performance Optimization Feature includes two capabilities: DB2 Workload Manager and Optim Performance Manager. For more information go to: http://www-01.ibm.com/software/data/db2/linux-unix- windows/performance-optimization.html

Optim T

• ols

Database Administrator & Development Studio

Optim Database Administrator helps organizations manage databases and database changes without disruption. It improves productivity and reduces application outages for complex structural changes to streamline change-in-place and database migration scenarios. Optim Development Studio provides an integrated database development environment for Oracle, DB2, and Informix. ODS improves development productivity up to 50% for developing and testing SQL and XQuery queries, stored procedures, Web services, and Java data access layers. For more information: http://www-01.ibm.com/software/data/optim/database-administrator/

Federation

InfoSphere Federation Server (IFS) creates a consolidated view of your data to support key business processes and decisions. Federation allows you to access and integrate diverse data and content sources as if they were a single resource - regardless of where the information resides. The Federation capability being included with AESE is limited to combining data from Oracle or Informix with DB2 for LUW. If you are already using IFS to combine other disparate sources such as SQL Server, Sybase and DB2 into a single virtual view, or need this capability, you must purchase the IFS software separately. For more information: http://www-01.ibm.com/software/data/infosphere/federation-server/

Q Replication – Limited Use

What is allowed What isn’t allowed

DB A (LUW) DB B (LUW) DB C (LUW) DB D (LUW) DB A (LUW) DB B (LUW) DB E (LUW) DB C (LUW) DB D (LUW) DB F (LUW) DB C (LUW) DB H ( Sybase) DB C (LUW) DB I ( DB2 z/OS)

Security: Label-Based Access Control

For the ultimate data access control, the Advanced Access Control feature uses Label Based Access Control (LBAC) to let you decide exactly who has write access and who has read access to individual rows and individual columns in any given table. Once the LBAC rules have been defined, data access control is managed by DB2 and is completely transparent to the user. For example, a user accessing a table will only see the rows they are authorized to see and DB2 will act as if any unauthorized rows don't exist. For more information: http://www.ibm.com/developerworks/data/tutorials/dm0605wong/

Webinar Poll:

 Do you currently own DB2 ESE?

DB2 Advanced Enterprise Server Edition

Purchasing IBM Software

Quick PVU Explanation

• A PVU is a unit of measure used to differentiate licensing of software on

distributed processor technologies.

• A PVU is defined by Processor Vendor, Brand, Type and Model Number.
• IBM defines a processor, for purposes of PVU-based licensing, to be each

processor core on a chip (socket).

• Each software product has a unique price per PVU.

For more information and a current PVU Table: http://www- 01.ibm.com/software/lotus/passportadvantage/pvu_licensing_for_customers.html

Intel Processor PVU Example

Sub-capacity licensing



The Licensee can deploy the Program using either Full Capacity licensing or Virtualization Capacity (Sub-Capacity) licensing according to the Passport Advantage Sub-Capacity Licensing terms.



If using Full Capacity licensing, the Licensee must obtain PVU entitlements sufficient to cover all activated processor cores in the physical hardware environment made available to or managed by the Program, except for those servers from which the Program has been permanently removed.



If using Virtualization Capacity licensing, the Licensee must obtain entitlements sufficient to cover all activated processor cores made available to or managed by the Program, as defined according to the Virtualization Capacity License Counting Rules.

IBM Passport Advantage

Passport Advantage is comprehensive IBM offering that covers software license acquisition including Fixed Term Licenses and Software Subscription and Support product upgrades and technical support under a single, common set of agreements, processes and tools. For more information: http://www-01.ibm.com/software/howtobuy/passportadvantage/

Webinar Poll:

 Do you know how many PVU’s of DB2

your organization owns?

DB2 Advanced Enterprise Server Edition

Upgrade Paths

Current Packaging (separately priced features are in yellow)

Functionality DB2 Express-C DB2 Express DB2 Workgroup DB2 Enterprise SQL Replication     Homogeneous Federation     Web Services Federation     pureXML Storage     Compression: Backup     High Availability Disaster Recovery    Tivoli System Automation    Online Reorg     Governor     Materialized Query Tables     Multi Dimensional Clustering     Query Parallelism     Connection Concentrator     Table Partitioning     Plan Lockdow n     Scan Sharing     DB2 pureScale    DB2 pureScale Geodetic Extender    DB2 Geodetic Feature Homogeneous Replication    DB2 Homogeneous Replication Feature Compression: Row Level    Compression: Indexes    Compression: Replication    Compression: XML    Label Based Access Control    DB2 Advanced Access Control Feature Sybase Compatability    Sybase SQL Skiin feature Database Partitioning: Relational    Database Partitioning: XML    Query Patroller    Workload Management    Data Studio Workload Analyzer    Optim Performance Manager  DataStudio add-on DataStudio add-on Multi database Federation  Multi database Qreplication  Optim Data Administrator  Optim DB Adminstrator Optim DB Adminstrator Optim DB Adminstrator Optim Development Studio  Optim Dev Studio Optim Dev Studio Optim Dev Studio Included - requires secondary server DB2 Performance Optimization Feature InfoSphere Federation Server InfoSphere Replication Server Storage Optimization Feature Only in InfoSphere

How Do You Get AESE? Existing DB2 ESE customers have 2 choices:

• 1. Purchase new licenses of AESE by PVU.
• or -
• 2. Purchase upgrade licenses by PVU that factor in the

products you already own.

New Purchase DB2 Pricing and Part Numbers For *new* license purchases, based on the Processor Value Unit (PVU) model DB2 ESE = D55IULL, $417 DB2 AESE = D0GB4LL, $464 $464 - $417 = $47 per PVU price difference

Trade up Parts – also sold by PVU If you already own DB2 Enterprise Server Edition, Storage Optimization and/or Performance Optimization the cost is less to factor in your existing license investment.

Description ESE to AESE ESE + SOF to AESE ESE + POF to AESE ESE+SOF+POF to AESE Part Number D0GBRLL D0GBSLL D0GBTLL D0GKKLL Price $218 $176 $176 $153

DB2 Advanced Enterprise Server Edition

Easy Examples

Example 1: ESE to AESE Kim’s Kites

Kim’s Kites owns 200 PVU’s of DB2 Enterprise Server Edition and wants to move to DB2 Advanced ESE. Part Numbers DB2 ESE: Trans: D55IULL S&S: E020CLL DB2 Advanced Trade Up from ESE: D0GBRLL …$218 per PVU Kim’s Kites purchases 200 PVU’s of DB2 AESE trade up part from DB2 ESE (D0GBRLL), and will then have full entitlement for DB2 AESE and all its features.

Example 2: ESE to AESE Donna’s Donuts

Donna’s Donuts owns 400 PVU’s of DB2 Enterprise Server Edition. They want to move to DB2 Advanced Enterprise and buy 200 PVU’s more, for a total 600 PVU’s of AESE.

Part Numbers: DB2 ESE: D55IULL or E020CLL if at S&S

DB2 Advanced: D0GB4LL ($464 per PVU) DB2 AESE Trade Up from ESE: D0GBRLL

…$218 per PVU

Donna’s Donuts purchases 400 PVU of DB2 AESE trade up from DB2 ESE (D0GBRLL), and 200 PVUs of new DB2 AESE licenses (D0GB4LL), and will then have entitlements for 600 PVU’s of AESE.

Example 3: ESE and SOF to AESE Tammy’s Terrible Towels

Tammy’s Terrible Towels owns 400 PVU’s of DB2 Enterprise Server Edition and 400 PVU’s of Compression/Storage Optimization Feature (SOF) and wants to move to DB2 Advanced ESE. P/N’s: DB2 ESE: Trans: D55IULL S&S: E020CLL DB2 AESE Trade Up from ESE&SOF: D0GBSLL …$176 per PVU Tammy will purchase 400 PVU of DB2 AESE trade up part from DB2 ESE & SOF (D0GBSLL). She will stop paying 400 PVU of SOF and will have full entitlement for DB2 AESE.

Example 4: ESE and POF to AESE Renu’s Range Rovers

Renu’s Range Rovers owns 800 PVU’s of DB2 Enterprise Server Edition and 800 PVU’s of the DB2 Performance Optimization Feature (POF) and wants to move to DB2 Advanced ESE. P/N’s: DB2 ESE: Trans: D55IULL S&S: E020CLL DB2 AESE Trade Up from ESE&POF: D0GTSLL …$176 per PVU Renu’s Range Rovers will purchase 800 PVU’s of DB2 AESE trade up part from DB2 ESE & POF (D0GTSLL). They will stop paying for the 800 PVU’s of POF and will have full entitlement included with AESE.

Example 5: ESE+SOF+POF to AESE Blaire’s Bears

Blaire’s Bears has both SOF and POF and owns 600 PVU’s of DB2 Enterprise Server Edition, 600 PVU’s of Compression/ Storage Optimization Feature (SOF) and 600 PVU’s of Performance Optimization Feature (POF). P/N’s: DB2 ESE: Trans: D55IULL S&S: E020CLL AESE Trade Up from ESE&SOF&POF: D0GKKLL …$153 per PVU Blaire’s Bears will purchase 600 PVU of DB2 AESE trade up part from DB2 ESE&SOF&POF (D0GKKLL). They will stop paying for the 600 PVU’s of SOF and POF and will have full entitlement under their DB2 AESE license.

DB2 Advanced Enterprise Server Edition

Timing – Patience Pays

How does Subscription and Support Work?

 IBM assesses an annual fee due on the anniversary

• f the original purchase

 S&S runs about 20% of the purchase price  Failure to maintain your S&S means you cannot

upgrade or use the PMR system.

S&S Example 1: ESE to AESE Kim’s Kites

Kim’s Kites owns 200 PVU’s of DB2 Enterprise Server Edition and wants to move to DB2 Advanced ESE. Kim’s Kites bought their 200 PVU’s of DB2 ESE in December of

• 2010. They paid $83 per PVU for S&S on their license anniversary

date in December of 2011, a total of $16,600. If they upgrade TODAY to AESE, the cost is $218 per PVU, or $43,600. What happens to the S&S they’ve paid for?

S&S Example 1: ESE to AESE Kim’s Kites

S&S at $83/per PVU; 200 PVU’s = $16,600.00 S&S is paid in advance. The prepaid amount per month is $1,383.33. The AESE upgrade is $218/per PVU; 200 PVU’s = $43,600.00 If Kim’s Kites buys the upgrade licenses in April they will forfeit 8 months of prepaid S&S ($1,383.33 X 8 = $11,066.67). Their new S&S anniversary date will be in April of 2013.

Example 5: ESE+SOF+POF to AESE Blaire’s Bears

Blaire’s Bears has both SOF and POF and owns 600 PVU’s of DB2 Enterprise Server Edition, 600 PVU’s of Compression/ Storage Optimization Feature (SOF) and 600 PVU’s of Performance Optimization Feature (POF). P/N’s: DB2 ESE: Trans: D55IULL S&S: E020CLL AESE Trade Up from ESE&SOF&POF: D0GKKLL …$153 per PVU Blaire’s Bears will purchase 600 PVU of DB2 AESE trade up part from DB2 ESE&SOF&POF (D0GKKLL). They will stop paying for the 600 PVU’s of SOF and POF and will have full entitlement under their DB2 AESE license.

Example 5: ESE+SOF+POF to AESE Blaire’s Bears

What if… Blaire’s Bears purchased: 200 PVU’s of ESE in June, 2007 400 PVU’s of ESE in March, 2010 600 PVU’s of Storage Optimization Feature in July, 2010 600 PVU’s of Performance Optimization Feature in May, 2011

Webinar Poll:

 Does your organization own more

than just DB2 ESE?

Create an AESE acquisition plan:

 Complete the AESE questionnaire  Review S&S renewal dates  Select an optimal purchase date  Discuss internal business requirements  Define one or two options that would make

this purchase really attractive to your

• rganization

Contact The Fillmore Group for help with:

 Completing the AESE questionnaire  Getting expirations dates on your S&S  Select an optimal purchase date  Implementation assistance  Training

3 Takeaways:

 Frank loves AESE  How MY organization can upgrade  Patience Pays!

Thank you

Frank Fillmore, President, The Fillmore Group (410) 465-6335