Installing DB2 databases under Windows and linking databases using Aqua Data Studio

Tag:...    Success    rect   .net   admin    edit   etc    next    csdn   

This article is just as your own experience, does not have a general! 1, in fact, the installation of DB2 database is relatively simple, is generally directly next to the next step, but some places need attention. I installed the DB2 database version as shown in: 2, after getting the database version, unzip, such as the directory structure: and then click Setup.exe. The installation screen appears, check the installation product:  3, will appear as shown in the interface:  wait a little bit, will appear as shown in the interface:  4, then click Next, appear as shown in the installation screen, select I accept both IBM terms .... Then choose Next 5, then appear as shown in the interface, you can choose a typical installation or other installation, it is recommended that the novice Typical installation: Click Next 6, and then appear as shown in the interface: We recommend changing the directory where the response file name resides. Click Next: 7, select the installation folder, of course, can not be the C-drive, modified to G-Disk, click Next: 8, and then enter the location to set the replica name, the replica name indicates that the installation directory corresponds to a unique database. So by default, you can change your name, to check the default DB2 copy, unless you want to install multiple databases to Windows 9, after entering the following interface, you can click the "Configuration Button", you can not modify, and then configure, and then click Next: 10, Next is to configure the database link information, as shown, the password is to wait for the terminal to login password, so, be sure to remember. The user name should also be remembered. 11, finally appear as shown in the interface, click Finish, you can complete the installation. 12, after the installation is completed, the next step into the cmd in the Windows7, using the administrator access, enter Db2cmd in the command window, as shown:  13, will pop up a new window, if the pop-up window, the database installation is successful. 13. Next, use the DB2 link tool to log in to the DB2 database. (Go to the front pop-up terminal, look at the DB2 list DB directory, as a result of execution, I have a test database, if not, execute DB2 create DB test, which means to create a test database) 14, Execute Db2start in the terminal to start the database service. Then open the Aqua Data Studio 16 software, select Server-to-register server, select DB2 luw8.x/in the popup window ... 15, in the name write your favorite name, type selection for testing, login name db2admin, password for just you fill in the password, the host for your IP address, the port number is generally the default of 50000, if you do not know, go to the Services file to view (file inc:\windows\system32\drivers\etc\services, refer to link), the database will fill in the corresponding sample, you create your own database (if not, you need to create it yourself). Others are not filled in, then click Test Connection. The test successfully pops up as follows "16, last click Save. Appears on the left side of the local database server: At this point, the installation is complete.

Installing DB2 databases under Windows and linking databases using Aqua Data Studio