|
一。DB2 Planning
1.DB2 Products
The different editions of DB2
DB2 Everyplace
A mobile computing infrastructure;
A tiny engine, about 180KB
Triggers are not part of the DB2 Everyplace engine.
DB2 Personal Edition (DB2 PE)
A single-user RDBMS;
Remote clients cannot connect to databases that are running this edition DB2;
However, workstations with the Control Center can connect to these databases to perform remote administration;
DB2 Workgroup Server Edition (DB2 WSE)
Web–enabled client / server RDBMS;
Intended primarily for small business and departmental computing;
No integrated mainframe connectivity via the DB2 Connect component;
Does not support 64-bit computing or DB2 Data Links File Manager;
Can be installed on SMP machines with up to four processors;
Don’t allow for external Web-based usage, should consider DB2 Workgroup Unlimited Server Edition (DB2 WSUE);
In DB2 Version7, this product was called DB2 Workgroup Edition.
DB2 Workgroup Server Unlimited Edition
Essentially DB2 WSE with different licensing terms;
Eliminates the need to count users accessing the database;
Can not create 64-bit instances;
Does not come with the connection concentrator;
Does not include the integrated DB2 Connect component found in DB2 ESE
In DB2 Version7, this product was called DB2 Workgroup Unlimited Edition.
DB2 Enterprise Server Edition (DB2 ESE)
Does not run on Windows XP for production purposes, but can be licensed for user acceptance testing, test and application development on that OS;
Microsoft limits the number of concurrent connections that can be handled by the single-user version of their Windows server products, like DB2 WSE or DB2 WSUE in a four-way SMP box;
DB2 ESE is meant for large and mid-sized departmental servers;
Includes the DB2 Connect component, which enables you to connect to iSeries and zSeries-based DB2 databases, as well as non-database hot resources like CICS, VSAM and IMS;
Each server running DB2 ESE is licensed for 5 registered users when connecting to host-based data sources, need more, purchase a separate DB2 Connect server license and user entitlements;
DB2 ESE is licensed per processor and can be installed on any number of processors on a single SMP box;
Has the ability to partition data within a single server, across multiple database servers (all of which have to be running on the same operating system), DPF;
DPF allows multiple SMP machines to be clustered together under a single database image for very large-scale transaction volumes;
In DB2 Version 7, this product was called DB2 Enterprise Edition.
DB2 Universal Developer’s and DB2 Personal Developer’s Edition
DB2 clients:
DB2 Runtime Client;
DB2 Administration Client;
DB2 Application Development
DB2 Extenders:
The DB2 Extenders can take your database applications beyond traditional numeric and character data to images, XML, videos, voice, spatial objects, complex documents and more.
XML Extender:
You can store entire XML documents in DB2 or store them as external files managed by the database. This method is known is XML Columns;
You can also decompose an XML document into relational tables and then recompose that information to XML on the way out of the dataset. This method is known as XML Collections.
DB2 Net Search Extender:
You need a high-speed in-memory search, this is the extender for you;
For internet applications;
Eg. A license for up to five concurrent users comes with DB2 WSE with this product, if you want to support more than five users, DB2 WSUE or DB2 ESE.
DB2 Spatial Extender:
It allows you to store, manage and analyze spatial data, that is, information about the location of geographic features;
Eg. A license for up to five concurrent users comes with DB2 WSE with this product, if you want to support more than five users, DB2 WSUE or DB2 ESE.
Text, Audio, Image, and Video (TAIV) Extenders:
It allows you to extend the relational database to use nontraditional forms of data like text, songs, pictures and movies.
DB2 Data Links File Manager
It allows you to manage files that reside outside the database as though they were logically.
DB2 Connect
This product is an add-on product to DB2 that can be purchased separately, although some complimentary user licenses are provided in DB2 ESE.
DB2 add-on tools
The free tools come as part of a DB2 installation and can be launched from the Control Center, the Configuration Assistant or on their own.
DB2 Recovery Expert;
DB2 Performance Expert;
DB2 High Performance Unload;
Quickly and efficiently unloads and extracts data from DB2 for movement across enterprise systems.
DB2 Web Query Tool;
DB2 Table Eidtor
|
