DB2 7.2/8 EE vs EEE

Posted on 2003-02-24
Medium Priority
Last Modified: 2012-05-05
1) We have DB2 7.2 EE installed in windows NT & 2000 OS.

2) We actually need EEE which is under procurement since we want to implement logical/physical/mixed partitioning to improve performance.

3) Can we start work using EE and then replace with EE and partitioning in the end. I think the performance tuning we do for EEE is just partitioning part over EE's tuning.

4) Will there be any problem in migrating/porting databases from EE to EEE of the same version or different version of DB2.
Question by:k_murli_krishna
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 13

Accepted Solution

ghp7000 earned 300 total points
ID: 8033869
As I've told you before, if you buy EEE then you can install EE OR EEE using the same install CD's, you simply select from a menu to determine if you will install EE or EEE.
There are differences in performance tuning between EE and EEE, some of which are quite major and some of which are quite minor. The partitioning scheme you use is more a part of physical database deisgn than performance tuning, although there is some relationship. For example, if you will have a cluster of 2 machines for a 20 node database, obviously there will be a performance impact compared to the same 10 cluster 20 node database. So, you may want to configure cluster A different than cluster B, but the intra and inter partition parallelism features of DB2 can be configured to work the same across all nodes.
However, you cannot take an EE backup and restore it to a EEE environment, or vice versa. What you would have to do is to create the EEE database and load/import the EE data into it.
Migrating databases with fixpacks higher than than the existing database manager is not possible. For example, you have a database backup that was taken with V7.2 and try to restore to an instance created in v7.1, this won't work.
The database manager level has to be the same or higher, if it is higher, you will have to rebind the db utilities for that database using the bind files for the most recent release/fixpack.
LVL 17

Author Comment

ID: 8040687
ghp7000, thank you very much. Please have a look at my question db2admin command. I have posted a comment for which your reply is pending.

Featured Post

Learn by Doing. Anytime. Anywhere.

Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.

Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question