Installation/Configuration of DB2 for Windows NT 2.1.2 ---------------------------------------------------------- Since most people don't read documentation and to get things up and running quickly, we are providing this quickstart guide to get you started with DB2 as fast as possible. But, PLEASE, read the readme eventually and take a look at the online documentation, especially the Planning guide. This guide will get you started assuming you will want to run your ODBC application on the local machine. If you want to set up a client/server configuration please read the "Installation and Operation Guide" which will appear as an ICON in the DB2 Information folder. Anyway here goes: BEFORE YOU INSTALL DB2 ----------------------- 1) Make sure you have enough Disk Space 53 meg for the full install of DB2 (this script assumes a full install) 8 meg for the sample database 34 meg to hold the install images 34 meg for the zip files that you download --- The 68 meg needed to hold the zips and install images can be free up after install. 2) Logon with an 8 character userid Make sure you log on with a userid that meets DB2's naming restrictions, which are limited to 8 characters. The most common install or usage problem is trying to use the "Administrator" userid. Create a userid called DB2NTADM, make that a member of the Administrators group (unless installing on Windows 95) and logon on as that user. 3) Download the install image Download either the complete package DB2NTALL.ZIP or the 8 disk set (named DB2NT1.ZIP through DB2NT8.ZIP. If you download the 8 disk images separately, you should also download the batch file DB2IMAGE.BAT. 4) Create an install directory If you downloaded the full package, then create a directory called db2inst and enter: pkunzip -d db2ntall.zip \db2inst If you downloaded the 8 disks separately then run DB2IMAGE.bat It will create a directory on the current drive called \db2inst and unzip each of the zip files to create subdirectories within that directory. After the install you can free disk space by deleting the zips and removing the db2inst directory. INSTALL DB2 for Windows NT or Windows 95 ---------------------------------------- 5) Install the product 1) change to \db2inst\disk1 and run setup.exe 2) Select the IBM Database 2 check box and choose either the Server or Single User radio button. If you are installing on Windows 95, only the Single User product is available. Quick Editorial ***************************************************************************** The only difference between the single user and server products is that the single user product will not accept any inbound connections. You may have more than one local connection. ***************************************************************************** 3) On the next panel select "try and buy" you will have 60 days before the temporary product license ends. 4) On the next panel select "Full Install" 5) On the next panel select a drive to install on.. leave the directory name as "sqllib" . 6) Select "install" 6) Reboot the machine. We place things in the systems settings of the control panel. These variables will not be picked up by NT services until you reboot. USING DB2 --------- 7) Create the sample database. 1) There is an icon in the DB2 for Windows NT/95 folder called "DB2 command window". Click on this icon and perform all DB2 tasks from this window. 2) type in DB2SAMPL No news is good news, so if the program returns without error, it worked. 3) The DB2SAMPL database contains the following tables DEPARTMENT ORG EMPLOYEE PROJECT EMP_ACT STAFF EMP_PHOTO STAFFG EMP_RESUME 8) Start the DB2 service and security daemons: type NET START DB2 type NET START DB2NTSECSERVER 9) Catalog the database as an ODBC data source. Click on the CLI-ODBC Administrator button in the DB2 for Windows NT/95 folder. Select the sample database and catalog it as an ODBC data source by clicking on the "Add as ODBC" button. 10) You are now ready to run your odbc application. LOTUS APPROACH CONSIDERATIONS ----------------------------- If your sample odbc application is Lotus Approach you will need to create primary keys on some of the tables in the sample database. If you don't perform this step, Lotus approach will consider the tables read-only. A batch file is provided to do this: 1) change to \sqllib\samples\db2sampl 2) type in DB2SAMPK -- the batch file assumes that DB2SAMPL has not been run, so ignore the errors related to creating the database and creating the tables. But primary keys should be created successfully. Summary of Files on Download Site ----------------------------------------------------------------------- 41 DB2IMAGE.BAT - Unzips DB2NT1 through DB2NT8 3,444,694 DB2NT1.ZIP - DB2NT zipfile 1 of 8 4,241,142 DB2NT2.ZIP - DB2NT zipfile 2 of 8 4,340,001 DB2NT3.ZIP - DB2NT zipfile 3 of 8 4,257,006 DB2NT4.ZIP - DB2NT zipfile 4 of 8 4,017,971 DB2NT5.ZIP - DB2NT zipfile 5 of 8 3,977,926 DB2NT6.ZIP - DB2NT zipfile 6 of 8 5,277,521 DB2NT7.ZIP - DB2NT zipfile 7 of 8 4,230,609 DB2NT8.ZIP - DB2NT zipfile 8 of 8 47,402,978 DB2NTALL.ZIP - Contents of all 8 zipfiles in one file 4,934 readme.txt - this readme