Digital Imaging Guidelines - Ingram Micro

sunfloweremryologistData Management

Oct 31, 2013 (3 years and 7 months ago)

88 views

000000_
1

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

IBM DB2


Discovering the Possibilities

Michael
Gunzelmann

February 14, 2007

®

Partner

Smart.


®

000000_
2

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

2

Agenda

1.
Housekeeping

2.
An introduction to IBM DB2

3.
The opportunities and challenges

4.
Licensing the various editions

5.
The IBM value statement


®

000000_
3

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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

®

000000_
4

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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



®

000000_
5

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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

®

000000_
6

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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

®

000000_
7

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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

®

000000_
8

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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


®

000000_
9

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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


®

000000_
10

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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

®

000000_
11

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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


®

000000_
12

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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


®

000000_
13

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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

®

000000_
14

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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?


®

000000_
15

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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?

®

000000_
16

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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

®

000000_
17

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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


®

000000_
18

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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


®

000000_
19

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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


®

000000_
20

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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


®

000000_
21

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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


®

000000_
22

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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

®

000000_
23

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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



®

000000_
24

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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



®

000000_
25

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

25

Want to Develop a DB2 Focus?

Ingram is hosting


A FREE DB2 9 Training &
Certification

March 6
-
8, 2007

Marietta, GA


®

000000_
26

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

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

®

000000_
27

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

27

Need more Information?

Contact:


Michael Adan


714
-
382
-
1310


michael.adan@ingrammicro.com



000000_
28

Confidential and proprietary information of Ingram Micro Inc.


Do not distribute or duplicate without Ingram Micro's express wr
itten permission.

Partner

Smart.


®

Questions?