Universiti Teknologi MARA



Procedure

1. Obtain DB2 Express-C images: Download the appropriate DB2 Express-C image from the DB2 Express-C Web site (db2/express). Unzip the files into any directory you wish.

2. Locate the files: Navigate to the directory (or drive) containing the unzipped DB2 product installation files.

3. Run the DB2 Setup Launchpad: Launch the DB2 Setup Launchpad by doubleclicking on the setup.exe file. From the Launchpad, click the Install Product option on the left pane of the window.

4. Run the DB2 setup wizard: The DB2 setup wizard checks that all system requirements are met and sees if there are any existing DB2 installations. Click on Install New to start the wizard, then click Next. .

5. Review the license agreement: Read and accept the license agreement (select the “I Accept...” radio button) and click the Next button to continue.

6. Choose the installation type: For this exercise, select the Typical option (this is the default). The Compact option performs a basic installation, while the Custom option allows you to customize the specific features you want to install. Click the Next button to continue.

7. Select the installation, response file creation, or both: Leave the default so that DB2 is installed, and also a response file is created. Click the Next button to continue.

8. Select the installation folder: This screen allows you to customize the drive and directory where the DB2 code is installed on your system. Ensure sufficient space exists for the installation. Use the default drive and directory settings for this example (shown below):

Drive: C:

Directory: C:\Program Files\IBM\SQLLIB

Click the Next button to continue.

9. Set the user information: Once DB2 Express-C is installed, certain DB2 processes are run as system services. These services require an operating system account in order to run. In the Windows environment, using the default db2admin user account is recommended. If the user account does not yet exist, DB2 creates it in the operating system for you. You can also specify to use an existing account, but that account must have local administrator authority. We recommend using the defaults suggested. Ensure you specify a password for the account.Click the Next button to continue.

10. Configure the DB2 instance: A DB2 instance can be thought of as a container for databases. An instance must exist before a database can be created inside it. During a Windows installation, an instance called DB2 is automatically created.

By default, the DB2 instance is configured to listen for TCP/IP connections on port 50000. Both the default protocol and the port can be changed by clicking the Configure button. We recommend using the default settings in this example. Click the Next button to continue.

11. Start the installation:. Review the installation summary options previously selected. Click the Finish button to begin copying the files to the installation location. DB2 will also perform some initial configuration processes.

12. First Steps. After the installation is complete, another launch utility, called First Steps, is displayed. First Steps can also be started later with the command db2fs.

13. The SAMPLE database is a database that you can use for test purposes. It can be created from First Steps by clicking the Create SAMPLE database button. Click on this button, and the window shown below appears. Choose the second option (XML and SQL objects and data). The SAMPLE database can also be created using the command db2sampl -xml -sql.

[pic]

14. After a few minutes, you can verify the database was created. Open the DB2 Control Center tool choosing: Start -> Programs -> IBM DB2 -> DB2COPY1 (Default) -> General Administration Tools -> Control Center .You can also start the Control Center with the command db2cc. The first time you start the Control Center, a pop-up window will ask you to choose which Control Center view you want to use. Leave the default (Advanced), and click OK. On the left panel, drill down the All Databases folder. If you cannot see the SAMPLE database in that folder, make sure you refresh your view by choosing View -> Refresh

15. Restart the computer. This is step is optional. Although this step is not mentioned in the official DB2 installation documentation, we recommend rebooting the system (if possible, at least on Windows) to ensure all processes start successfully and to clean up any memory resources that might not have been cleaned up correctly.

16. Validate your DB2 installation by running the commands: db2level, db2licm, and db2val. From the Windows Start Menu, open the DB2 Command Window as follows: Start -> Programs -> IBM DB2 -> DB2COPY1 (Default) -> Command Line Tools -> Command Window. From the Command Window. If db2val finishes successfully, your installation is in good shape!. If there are errors, review the log file specified in the error message for more details. The output of the three commands should be similar in the following picture.

[pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download