Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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
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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

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 (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Screencast - Getting to Know the Pipeline
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Suggested Courses

571 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