IBM DB2 Discovering the Possibilities

1. ® IBM DB2Discovering the Possibilities Michael Gunzelmann February 14, 2007 Partner Smart.™

2. Agenda • Housekeeping • An introduction to IBM DB2 • The opportunities and challenges • Licensing the various editions • The IBM value statement

3. Housekeeping • Make the content meet your needs • Ask questions as you think of them • If you would like more information e-mail me • Thank you for your participation

4. Introduction • Michael Gunzelmann • Ingram Micro IBM Sales Engineer • Dedicated IBM business partner resource • Responsible for IM and Tivoli Storage products • Focused on partner enablement activities

5. Exploring IBM DB2 • DB2 Universal Database • Aka DB2 • IBM flagship database application • Competes with • Oracle • Microsoft SQL • MySQL and other IBM databases • Runs on multiple platforms • Windows • Linux • UNIX

6. Exploring DB2 con’t • Latest version is Viper (v9.1) • First database to support XML in its native format (pureXML) • Provides security at the row and column level • Unparallel compression capabilities • Above are all chargeable features • Also supports handheld devices • Scales to hundreds of servers • Multiple editions to meet everyone’s needs

7. Editions for Every Situation • DB2 Express – C • Open source version (“C” = Community) • Free to build, deploy and distribute • DB2 Personal Edition • Windows, Linux or UNIX • Single user solution • Designed for remote deployments and mobile users • DB2 Express • Windows or Linux • 2 CPUs and 4 GB RAM • Simplified install and use version

8. DB2 Editions con’t • DB2 Workgroup Edition • Windows, Linux and Unix • Classic DB2 product, highly customizable • 4 CPUS and 16 GB RAM • DB2 Enterprise Developer Edition • Windows, Linux and UNIX • Enterprise edition but limited to development use • Supports all enterprise features • No hardware limitations

9. DB2 Editions con’t • DB2 Enterprise Edition • Windows, Unix and Linux • Includes these additional features • High Availability Disaster Recovery • Online Reorganization • Table Partitioning • Multidimensional Clustering • Workload Management • Only version to support Geodetic data modeling • Only version that can provide database and table partitioning

10. Opportunities & Challenges • Databases are like cars, everyone seems to have one • Are rarely the lead item in any solution • Once deployed, they stay in place • Displacing an existing database requires a very compelling reason for change • Databases are closely tied to development efforts • More opportunities for those with development and implementation skills

11. Compelling v9 Features • The XML play • Good for B2B companies and those who have an XML push from their industry standards • XML data remains intact and retains its native formatting • Additional value when viewed as an XML tool, as opposed to a database in and of itself • Perfect for those that use eforms

12. Compelling Features con’t • Security play • Secure right down to the record and field (i.e. row & column) • Security is an important business issue, not merely an IT concern • Storage play • Storage savings due to compression (40-50% typical!) • Tremendous advantage for those with data marts • Significant enough to allow you to repurpose hardware • Enhances backup and restore objectives

13. Other Advantages • DB2 is typically less expensive to purchase and has a lower total cost of ownership • Cross platform capabilities • Data migration tools for MS SQL and Oracle • Support for both JAVA and Microsoft .NET • Integration with other IBM Software solutions • Data Warehousing • Business Intelligence tools

14. Questions to Ask • Do you store XML based information but don’t want to lose its native formatting? • Does your application need to have granular table security? • Does your database provide you with the desired capacity and performance for your business needs? • Have your software maintenance costs grown out of control?

15. Questions to Ask con’t • Are you considering migrating your application to a lower cost platform, such as Linux? • Do you have adequate time to perform database backups? • Can you meet your DB recovery objectives? • Are the costs associated with your database volumes stressing your IT budgets? • Do you need to add features such as XML, compression, and additional security that your current solution just doesn’t provide?

16. Licensing DB2 • DB2 Express – C (“C” = Community) • Free download • Use and distribute at will • DB2 Personal Edition • Licensed by authorized user ($475) • One user per system • No user minimum

17. Licensing DB2 con’t • DB2 Express • Only for systems with up to 2 physical CPUs • Must include a license for each authorized user ($170) • Minimum of 5 user per installed server • Unlimited user per core license also available ($5,025) • Additional options • High Availability • Online Reorganization • Performance Optimization • Workload management • Database federation

18. Licensing DB2 con’t • DB2 Workgroup Edition • License by user OR by CPU core (value unit) • CPU license has unlimited user count ($13,990) • Per user licensing requires a minimum of 5 users per server instance ($361 / user) • Additional options • High Availability • Online Reorganization • Performance Optimization • Workload management • Database federation

19. Licensing DB2 con’t • DB2 Enterprise Edition • License by user OR by CPU core (value unit) • CPU license has unlimited user count ($37,500) • Per user licensing requires a minimum of 25 users per server instance ($965 / user) • Supports additional options • Database Partitioning • Geodetic Data Management • Performance Optimization

20. The DB2 Value Statement • Begin with Express and upgrade seamlessly to a more powerful version • Multiple platforms – Windows, Linux, UNIX • Purchase only the features that you need • Enterprise features at an SMB price

21. The Value Statement con’t • XML Performance - no need to shred XML data • Compression decreases database storage costs • Provides granular user security • Is an IBM solution • Stable • Known for support • Is a long term player in the industry

22. Help is only a Phone Call Away! • If you have any general IBM software questions Ingram Micro IBM Software Helpdesk 1-800-445-5066, x76426

23. Need Help with an Opportunity? • Dedicated IBM sales resources • Michael Gunzelmann • Tivoli Storage • DB2 Information Management • michael.gunzelmann@ingrammicro.com • Joe Loffredo • Tivoli Automation & Security • WebSphere • joe.a.loffredo@ingrammicro.com

24. Looking to Add a New IBM Focus? • Contact an Ingram Marketing Specialist • Raffaele DiPrado 716-633-3600, x67372 • raffaele.diprado@ingrammicro.com • Amy Flanagan 716-633-3600, x67126 • amy.flanagan@ingrammicro.com • Jennifer Willman 716-633-3600, x67109 • jennifer.willman@ingrammicro.com

25. Want to Develop a DB2 Focus? Ingram is hosting A FREE DB2 9 Training & Certification March 6-8, 2007 Marietta, GA

26. Training topics to be covered • DB2 Family Fundamentals • Basic Architecture • Instances and Databases • Database Objects • Basic Security • Client Configuration • Backup and Recovery • Concurrency • Data Movement and Utilities • Applying Fix Packs

27. Need more Information? Contact: • Michael Adan • 714-382-1310 • michael.adan@ingrammicro.com

28. ® Questions? Partner Smart.™