DB2 Personal Developer Edition V8 s1

DB2 UDB Express V8.2 Setup Guide

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

1.)  From the CD extract the DB2ExEWindiows.zip into C:\Software

2.)  Run the setup.exe from C:\Software\DB2ExEWindiows

The Setup page will appear.

3.)  Click Install Product at the first screen.

4.)  Click Next to select DB2 UDB Express.

5.)  Wait while DB2 prepares the setup. At the first screen of the DB2 setup select Next.

6.)  Accept the terms of the license.

7.)  Click Next

8.)  Leave typical install selected and click Next.

9.)  Change the default directory to C:\Program Files\SQLLIB

10.)  Click Next.

11.)  Enter wasadmin for the username and password. Be sure to leave the domain property empty.

12.)  Click the Next button. Click Yes if asked to create the user.

13.)  Click Next to accept the defaults under the configure DB2 instances.

14.)  Click Install to the install summary page.

Wait a bit while the software installs.

15.)  Click Finish when the software installation is complete.

16.)  When you are prompted to check for updates click No.

17.)  Close the First Steps utility if it opens.

18.)  Restart the machine.

19.)  Once the machine restarts, login as the user ‘wasadmin’ with the password of ‘wasadmin’.

20.)  Start the DB2 First Steps program by selecting Start -> Programs -> IBM DB2 -> Set-up tools -> First Steps.

First Steps windows appears.

21.)  From the left menu, select Create Sample Database.

22.)  Check the DB2 UDB Sample

23.)  Click OK. Wait a bit while it creates the database.

24.)  Click OK on the confirmation of creating the database.

25.)  Close DB2 First Steps window.

26.)  Open a command line processor by selecting Start -> Programs -> IBM DB2 ­ Command Line Tools -> Command Line Processor.

27.)  At the DB2 prompt enter the following instructions:

db2 => connect to sample user wasadmin using wasadmin

db2 => select * from employee

28.)  Make sure you see the screen below displaying all the information in the employee table.

29.)  Type quit.

30.)  Then type exit to close the Command Line Processor.

DB2 UDB Express V8.2 Setup Guide Page 8 of 8