Installing IBM DB2 Personal Edition, Version 7

IBM DB2 UDB v7.1 Personal Edition
Installation Guide

Note:The drive with the installation files will be referred to as drive X. Please substitute this drive letter with the appropriate CD or network drive letter. If the required files were downloaded from a website and placed into a temporary installation directory, substitute this drive letter for the temporary installation directory.

Note:You cannot use ghosting or disk imaging to install this software. You must install the software on each machine separately.

Step 1.Install DB2.

  1. If you have not already done so, log on to Windows as Administrator.
  2. Insert the CD labelled DB2 V7.1.
  3. From the X:\dbinstall directory, run setup.exe.
  4. From the Installation window, select the Install option.

  1. Select the following products to install, as shown below.

DB2 Personal Edition
DB2 Application Development Client
DB2 Administrative Client

Press the Next button.

  1. In the Select Installation Type window, select the Typical option. Press the Next button.

  1. In the Choose Destination Location window, specify the drive on which you want to install DB2, and press the Next button.
  2. In the Control Center Server settings enter:

wasadmin for the Username
wasadmin for the Password and Confirm password, as shown below,

and press the Next button.

  1. A prompt saying The username wasadmin does not exist. Would you like Setup to create it for you? will be displayed. Select the Yes button.
  1. The Start Copying Files window will be displayed. Click the Next button.

  1. At the end of the install, select the Finish button.

  1. The First Steps window will be displayed. Select Exit and log off.
  2. Restart the computer, logging on as wasadmin.
  3. If the First Steps window does not automatically appear, then, from the Windows Start menu, select Programs->IBM DB2->First Steps.

In the First Steps window, select Create Sample Databases option.

  1. Select DB2 UDBSample and press the OK button.

Note: If the Sample database already exists, then, in the Command Line Processor, enter:

Catalog db sample
Drop database sample

Press the OK button.

  1. Return to the First Steps window. Select the Exit button.

Step 2.Verify DB2 installation.

  1. From the Windows Start menu, select Programs -> IBM DB2 -> Command Line Processor. The following text will be displayed in the window.

prompt. For example:

db2 => connect to sample

db2 => bind sample.bnd

For general help, type: ?.

For command help, type: ? command, where command can be

the first few keywords of a database manager command. For example:

? CATALOG DATABASE for help on the CATALOG DATABASE command

? CATALOG for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside

interactive mode, all commands must be prefixed with 'db2'.

To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 =>

  1. Enter the following command at the db2 => command line prompt, and press the enter key.

connect to sample

  1. The following text will then be displayed:

Database Connection Information

Database server = DB2/NT 7.1.0

SQL authorization ID = WASADMIN

Local database alias = SAMPLE

db2 =>

  1. Enter the following command at the command line prompt, and press the enter key.

select * from employee where job = 'CLERK'

The output will be:

EMPNO FIRSTNME MIDINIT LASTNAME WORKDEPT PHONENO HIREDATE JOB

EDLEVEL SEX BIRTHDATE SALARY BONUS COMM

------

------

000120 SEAN O'CONNELL A00 2167 12/05/1963 CLERK

14 M 10/18/1942 29250.00 600.00 2340.00

000230 JAMES J JEFFERSON D21 2094 11/21/1966 CLERK

14 M 05/30/1935 22180.00 400.00 1774.00

000240 SALVATORE M MARINO D21 3780 12/05/1979 CLERK

17 M 03/31/1954 28760.00 600.00 2301.00

000250 DANIEL S SMITH D21 0961 10/30/1969 CLERK

15 M 11/12/1939 19180.00 400.00 1534.00

000260 SYBIL P JOHNSON D21 8953 09/11/1975 CLERK

16 F 10/05/1936 17250.00 300.00 1380.00

000270 MARIA L PEREZ D21 9001 09/30/1980 CLERK

15 F 05/26/1953 27380.00 500.00 2190.00

6 record(s) selected.

  1. Close the window.

Copyright Web Age Solutions Inc., 2001.DB2 v7 Personal Edition Install Guide - 1