DB2 Enterprise Server Edition (ESE) is a multi-user version of DB2, which allows you to create and manage a single partition database environment or partition database environment. Partitioning database systems can manage large amounts of data and provide advantages such as enhanced performance and high availability. The main goal of this test is performance test, Different DB2 and Oracle can support a single node storage, but this architecture can only process parallel processing, to implement HA function, but also to be unified storage.
Each participated computer must have the same operating system. For example, the partition database system cannot always include Windows NT and Windows 2000 operating systems. Pay attention to the following points when installing:
1 Make sure that the host computer and the participating computer are the same Windows domain.
2 Make sure that the time from the host computer and participating computers is consistent with the date setting. To make time and date settings are considered consistent, the GMT time difference between all computers must not exceed 1 hour.
3 Make sure all participated computers can use TCP / IP to communicate with each other
4 During installation, the system will ask you to provide DB2 management server user accounts
5 On the main computer of the partitions you have to install, you must have a domain user account belonging to the local administrators group.
6 Make sure to install DB2 to the same drive on each participant computer
7 During installation, you will be asked to provide a domain user account associated with DB2 instance
First we have to install the database partition server owned by the instance. After installation of the database partition server, we can install the participating server, the installation step is simpler, but you must remember the precautions, otherwise it will cause the installation to fail or not use.
The environment of this test is two Dell 1750 PC Server, each configured as CPU P4 2.8GHz, memory 1GB.
The operating system is Windows 2000 Server, the database is DB2 V8.2. Configure only one logical node on each machine, a total of two logical nodes. A database is established on the server owned by the instance, and DB2 will automatically configure it as a partition database, and the data will be distributed on both nodes.
The test data is as follows:
l The results obtained in the 100 million recorded data environments are as follows: (unit: milliseconds)
insert
Update
Delete
SELECT
parallel
3875
3719
2921
1359
Stand-alone
6750
5907
4344
6422
l 50000 million recorded data environments are as follows: (unit: milliseconds)
insert
Update
Delete
SELECT
parallel
46937
52531
30672
125
Stand-alone
91016
44141
60906
23250
From the results of the test, there is a certain error. Due to the network communication between the two nodes, the transmission and hardware differences between the networks are caused by the existence of errors, but can basically see that the parallel architecture is reflected. It is superior in performance, most of which can improve approximately
50%
Performance, the performance improvement of individual operations is nearly double. On another perspective, this parallel structure also increases the complexity of the system, it is possible to bring certain problems in the future maintenance process.
DB2
Some support is also provided in the partitioning configuration management, and the user can manage the partition database in the graphical interface, and the data can be reassigned (which can balance the load and generate data deformation), and the dynamic increased deletion node, etc. .
