Build a development and testing environment

Overview background

Because the production environment database of the XXX management system is built using AIX + DB2 8.2, the Web application is hosted on IIS, and its physical architecture is as follows:

Figure 1 current production environment architecture

Description: Aix, Advanced Interactive Executive (Aix)Is IBMProprietary UnixThe name of the operating system, mainly used for minicomputers.

Problems

Currently, the materials provided by the customer include the source code of the production environment and the DB2 database backup files under the AIX system. In the current situation, the customer (xxx Information Center) cannot provide a database server for the development environment, nor can (in fact, we cannot) directly connect to the database of the production environment for development, you cannot directly use the database backup files under Aix to restore (to Windows), and our development environment (.. NET application development environment) is the use of the Windows environment, so how to build a development environment database becomes a key issue to build a development environment.

Solution

In view of the different production and development environments, we need to quickly build a development environment for Bug modification and simulate the user's production environment to a certain extent, three solutions are proposed: the first is to use Windows Server + DB2 for development and testing; the second is to use an IBM server. After virtualization, the AIX system and DB2 are installed; third, Unix systems using other environments, such as sco unix systems and Unix + DB2 development environments. For more information about each solution, see the following section.

Detailed solution introduction: Windows Server + DB2

L hardware requirements: one common PC, with a core II 2.0 or above, 4 GB memory or above, 4 GB or larger, and 320 GB hard disk space, and GB or more, install the Windows Server 2003 and later server operating systems.

L Advantages and Disadvantages: the advantages and disadvantages of this solution are obvious. The advantage is that the development and testing environment can be set up quickly and conveniently, and the database development technology is more familiar in the Windows environment; second, the cost is the most economical. Disadvantages: the development and testing environments are the most different. If the production database structure and development and testing database structure do not change during bug modification, this solution is optimal, but the potential risk is that, once the production and development database structure changes, synchronizing the database structure under the two platforms becomes another problem.

L price: 3000 ~ 5000

IBM server + virtualization + DB2

L hardware requirements: one IBM x3400/x3500 m2 series server. configuration parameters: CPU Intel Xeon e5504, 2 GB in frequency, 4 GB in memory, standard hard drive 146 GB, supported operating system: UNIX and Windows Server systems.

L Advantages and Disadvantages: this solution can simulate the production environment to the maximum extent. After installing the UNIX System on the server, you can use the virtualization tool to create an AIX Virtual Machine and install DB2 on the virtual machine; the price is also the highest. The disadvantage of this solution is that technical support is required to configure the test environment.

L price: 15000 ~ 20000

SCO Unix + DB2

L hardware requirements: A common PC with a core II 2.0 or above, 4 GB memory or above, 4 GB or larger, and a hard disk space of 320 GB or above, preferably over GB, and the sco unix operating system is installed.

L Advantages and Disadvantages: this solution can simulate the production environment to a certain extent, however, building such a development environment requires some time to familiarize yourself with the SCO Unix + DB2 installation and configuration and database restoration, which requires technical support and is relatively low cost. The disadvantage is that it requires technical support under sco unix.

L price: 3000 ~ 5000

Application suggestions

In terms of applications, we recommend that you first use solution 1 to quickly build a development and testing environment. In the future, you can use existing software and hardware resources to build the testing environment described in solution 3 with time and conditions. This process is shown in:

 

Figure 2 physical architecture of development environment

In fact, if there is no major change in the database structure, you can directly use DB2 in Windows to simulate the production environment. After all, AIX only installs the DB2 database. In the near future, the data structure will change. You only need to export the relevant SQL statements in the development environment and deploy them in the production environment.