Installation Instructions for DB2 Universal Database (version 7.2.5 or later) on Windows 2000 SP 3/XP: 1) If a previous version of DB2 UDB is installed, it will need to be removed first. 2) Extract db72eewi.zip into a directory of your choice. 3) Extract d72f7eew.zip into the directory used in 2) above. 4) Execute setup.exe (extracted as per step 2) above). 5) From the "Installation" dialog, select "Install". 6) From the "Select Products" dialog, select "DB2 Enterprise Edition" and "DB2 Application Development" and click on the "Next>" button. 7) Next, you will see the "Select Installation Type" dialog. Select the "Custom" radio button, and click "Next>". 8) Select the following components from the "Select Components" dialog: - Communications Protocols - Stored Procedure Builder - Application Development Interfaces - Documentation - Based DB2 UDB Support - Administration and Configuration Tools Record the "Destination Folder" used if you use one other than the default. You will need this information to locate the JDBC driver under "Destination Folder"\java12\db2java.zip. 9) Select "Yes" on the "Create DB2 Instance" dialog and click "Next>" to continue. 10) The "Configure DB2 Services" dialog will list 3 services (DB2 instance, Administration Server, and Control Server). 11) Select "DB2 Instance" and click the "Startup..." button to bring up the "Configure Startup Options" dialog. Select "Manual" as the Startup type and click "Continue". 12) Select "Control Server" and click the "Startup..." button to bring up the "Configure Startup Options" dialog. Select "Manual" as the Startup type and click "Continue". 13) Click the "Next>" button from the "Configure DB2 Services" dialog after you have changed the "DB2 Instance" and "Control Server" services to manual startup. 14) On the "Enter Username and Password for Control Center Server" dialog, type in a "Username" of "USERID" and a "Password" of "PASSWORD" (this assumes you have created the local admin ID USERID or you need to be logged in as Administrator to have DB2 create the user for you). Make sure the option "Use the same values for the remaining DB2 Username and Password settings" check box is selected (checked). Click the "Next>" button to continue. 15) At the "Start Copying Files" dialog click the "Next>" button. You can take a break while the code installs |-). 16) Click the "Finish" button when the installation has completed. 17) Click the "Exit button to cancel out of the "IBM Product Registration" dialog and click the "Yes" button to confirm that you want to exit without registering. 18) Also, you should close the "Startup" window. Verification Procedures: 1) Log on to Windows as user USERID (with password PASSWORD). 2) Startup the "DB2 Command Window" (Start->Programs->IBM DB2->Command Window). 3) At the DB2 command prompt (window titled "DB2 CLP"), enter the following command: DB2START. 4) You should get the message "SQL1026N The database manager is already active". This is because the DB2 services start automatically when Windows starts. 5) Create a sample database "TEST". Enter: DB2 CREATE DB TEST 6) Connect to the database. Enter: DB2 CONNECT TO TEST You should get the message Database Connection Information Database server = DB2/NT 7.2.1 SQL authorization ID = USERID Local database alias = LIBRARY 7) Now type in the command: DB2 CONNECT RESET You should get back the message "DB20000I The SQL command completed successfully". 8) Type in the command: DB2LEVEL 9) You should get back the message: DB21085I Instance "DB2" uses DB2 code release "SQL07021"... The value SQL07021 indicates that you are running DB2 UDB 7.2.5 (DB2 7.2 would show SQL07020, and DB2 UDB 7.1 would show SQL0701x where x is a number). 10) Type in "EXIT" to close the DB2 Command Window. Other Installation Related Notes: 1) If you are using WSAD with your DB2 installation, you will need to right click on the projects that need to access the database, and add the JDBC driver to your build path by adding an "External Jar" and browsing to "Destination Folder"\java12\db2java.zip (see step 8 above).