Transcript Digital Imaging Guidelines

®
IBM DB2
Discovering the Possibilities
Michael Gunzelmann
February 14, 2007
Partner
Smart.™
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_1
Agenda
1. Housekeeping
2. An introduction to IBM DB2
3. The opportunities and challenges
4. Licensing the various editions
5. The IBM value statement
2
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_2
®
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
3
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_3
®
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
4
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_4
®
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
5
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_5
®
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
6
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_6
®
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
7
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_7
®
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
8
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_8
®
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
9
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_9
®
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
10
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_10
®
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
11
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_11
®
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
12
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_12
®
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
13
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_13
®
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?
14
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_14
®
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?
15
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_15
®
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
16
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_16
®
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
17
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_17
®
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
18
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_18
®
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
19
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_19
®
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
20
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_20
®
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
21
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_21
®
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
22
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_22
®
Need Help with an Opportunity?
Dedicated IBM sales resources
– Michael Gunzelmann
Tivoli Storage
DB2 Information Management
[email protected]
– Joe Loffredo
Tivoli Automation & Security
WebSphere
[email protected]
23
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_23
®
Looking to Add a New IBM Focus?
Contact an Ingram Marketing Specialist
– Raffaele DiPrado
716-633-3600, x67372
 [email protected]
– Amy Flanagan
716-633-3600, x67126
 [email protected]
– Jennifer Willman
716-633-3600, x67109
 [email protected]
24
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_24
®
Want to Develop a DB2 Focus?
Ingram is hosting
A FREE DB2 9 Training &
Certification
March 6-8, 2007
Marietta, GA
25
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_25
®
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
26
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_26
®
Need more Information?
Contact:
Michael Adan
714-382-1310
[email protected]
27
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_27
®
®
Questions?
Partner
Smart.™
Confidential and proprietary information of Ingram Micro Inc. — Do not distribute or duplicate without Ingram Micro's express written permission.
000000_28