Notes from when I installed the DB2 server code on my T21 laptop on 12-13-2005. Use the green/white CD titled DB2 Universal Database Enterprise Edition for Websphere, Commerce Version 8.1, Fixpak 5 Licensed for WebSphere Commerce v 5.6 not the older yellow on white CD titled IBM WebSphere Commerce DB2 Universal Database for Windows NT and Windows 2000 DB2 installed itself in C:\Program Files\IBM\SQLLIB but databases are at C:\DB2 (a fact I learned when I uninstalled DB2. It didn't clear out this directory, so when I tried to reinstall the SAMPLE database, it was already there, but not defined in the database directory) The userid I used to install DB2, was db2admin (password=global) The instance is DB2. The default port was used, which in \winnt\system32\drivers\etc\services, is defined as db2c_DB2 50000/tcp --------------------------------------------------------------------------------- It's best to just choose the typical installation instead of the custom install, 'cause the custom install defaults to installing everything and you have to know what to take off. Everything you want is in the typical install anyway, Rick. Here's the summary just before it installed all of this. Product to install: DB2 Enterprise Server Edition Installation type: Typical Selected features: Getting started First Steps Client support Spatial Extender Client Application Development tools Spatial Extender Samples Interfaces JDBC Support Java Development Kit Java Runtime Environment LDAP Exploitation MDAC 2.7 ODBC Support OLE DB Support Sample Applications Sample Database SQLJ Support SQLJ Application Development Tools SQLJ Samples Administration tools DB2 Web Tools XML Extender XML Extender Samples Communication protocols Server support Communication protocols Business Intelligence Data Warehouse tools Information Catalog Manager tools Base Application Development Tools Apply Base Client Support System Bind Files Capture Control Center Client Tools Command Center Configuration Assistant Connect Support Satellite Synchronization Database Tools Development Center Event Analyzer APPC NetBIOS NetBIOS Listener Named Pipes Named Pipes Listener TCP/IP TCP/IP Listener Space required: 429 MB New instances: Instance name: DB2 Start instance on reboot: Yes TCP/IP configuration: Service name: db2c_DB2 Port number: 50000 NetBIOS configuration: Workstation name: N00BD0C1 Adapter number: 7 Instance user information: User name: db2admin DB2 Administration server: Instance user information: User name: db2admin Contact specification: New contacts: Name: Rick Jasper Instance: DB2 Email address: rick.jasper@thomson.com Email address is for a pager: No ================================================================================= Printed off the README I found in C:\Program Files\IBM\SQLLIB\samples\java Installed the samples database by running db2sampl (actually, I did this from the Installation GUI, but I think it does the same command) --------------------------------------------------------------------------------- There are 11 tables in the samples database. db2 => list tables Table/View Schema Type Creation time ------------------------------- --------------- ----- -------------------------- CL_SCHED JASPER T 2005-12-13-15.16.31.893003 DEPARTMENT JASPER T 2005-12-13-15.16.26.165002 EMP_ACT JASPER T 2005-12-13-15.16.26.646001 EMP_PHOTO JASPER T 2005-12-13-15.16.27.296003 EMP_RESUME JASPER T 2005-12-13-15.16.30.501000 EMPLOYEE JASPER T 2005-12-13-15.16.26.315002 IN_TRAY JASPER T 2005-12-13-15.16.32.013001 ORG JASPER T 2005-12-13-15.16.25.314004 PROJECT JASPER T 2005-12-13-15.16.27.036001 SALES JASPER T 2005-12-13-15.16.31.693001 STAFF JASPER T 2005-12-13-15.16.25.934001 The most important one is probably the employee table. describe table employee Column Type Type name schema name Length Scale Nulls ------------------------------ --------- ------------------ ------ ----- ----- EMPNO SYSIBM CHARACTER 6 0 No FIRSTNME SYSIBM VARCHAR 12 0 No MIDINIT SYSIBM CHARACTER 1 0 No LASTNAME SYSIBM VARCHAR 15 0 No WORKDEPT SYSIBM CHARACTER 3 0 Yes PHONENO SYSIBM CHARACTER 4 0 Yes HIREDATE SYSIBM DATE 4 0 Yes JOB SYSIBM CHARACTER 8 0 Yes EDLEVEL SYSIBM SMALLINT 2 0 No SEX SYSIBM CHARACTER 1 0 Yes BIRTHDATE SYSIBM DATE 4 0 Yes SALARY SYSIBM DECIMAL 9 2 Yes BONUS SYSIBM DECIMAL 9 2 Yes COMM SYSIBM DECIMAL 9 2 Yes There are 32 records in the employee table, which is what I used for my Java Servlets class homework. Here's a sample, EMPNO FIRSTNME MIDINIT LASTNAME WORKDEPT PHONENO HIREDATE JOB EDLEVEL SEX BIRTHDATE SALARY BONUS COMM ------ ------------ ------- --------- -------- ------- ---------- ------- ------- --- ---------- -------- ------- ------- 000010 CHRISTINE I HAAS A00 3978 01/01/1965 PRES 18 F 08/24/1933 52750.00 1000.00 4220.00 000020 MICHAEL L THOMPSON B01 3476 10/10/1973 MANAGER 18 M 02/02/1948 41250.00 800.00 3300.00 000030 SALLY A KWAN C01 4738 04/05/1975 MANAGER 20 F 05/11/1941 38250.00 800.00 3060.00 000050 JOHN B GEYER E01 6789 08/17/1949 MANAGER 16 M 09/15/1925 40175.00 800.00 3214.00 000060 IRVING F STERN D11 6423 09/14/1973 MANAGER 16 M 07/07/1945 32250.00 500.00 2580.00 000070 EVA D PULASKI D21 7831 09/30/1980 MANAGER 16 F 05/26/1953 36170.00 700.00 2893.00 000090 EILEEN W HENDERSON E11 5498 08/15/1970 MANAGER 16 F 05/15/1941 29750.00 600.00 2380.00 ... 000340 JASON R GOUNOT E21 5698 05/05/1947 FIELDREP 16 M 05/17/1926 23840.00 500.00 1907.00 describe table cl_sched Column Type Type name schema name Length Scale Nulls ------------------------------ --------- ------------------ -------- ----- ----- CLASS_CODE SYSIBM CHARACTER 7 0 Yes DAY SYSIBM SMALLINT 2 0 Yes STARTING SYSIBM TIME 3 0 Yes ENDING SYSIBM TIME 3 0 Yes describe table department Column Type Type name schema name Length Scale Nulls ------------------------------ --------- ------------------ ------ ----- ----- DEPTNO SYSIBM CHARACTER 3 0 No DEPTNAME SYSIBM VARCHAR 29 0 No MGRNO SYSIBM CHARACTER 6 0 Yes ADMRDEPT SYSIBM CHARACTER 3 0 No LOCATION SYSIBM CHARACTER 16 0 Yes describe table emp_act Column Type Type name schema name Length Scale Nulls ------------------------------ --------- ------------------ ------ ----- ----- EMPNO SYSIBM CHARACTER 6 0 No PROJNO SYSIBM CHARACTER 6 0 No ACTNO SYSIBM SMALLINT 2 0 No EMPTIME SYSIBM DECIMAL 5 2 Yes EMSTDATE SYSIBM DATE 4 0 Yes EMENDATE SYSIBM DATE 4 0 Yes describe table emp_photo Column Type Type name schema name Length Scale Nulls ------------------------------ --------- ------------------ ------ ----- ----- EMPNO SYSIBM CHARACTER 6 0 No PHOTO_FORMAT SYSIBM VARCHAR 10 0 No PICTURE SYSIBM BLOB 102400 0 Yes describe table emp_resume Column Type Type name schema name Length Scale Nulls ------------------------------ --------- ------------------ ------ ----- ----- EMPNO SYSIBM CHARACTER 6 0 No RESUME_FORMAT SYSIBM VARCHAR 10 0 No RESUME SYSIBM CLOB 5120 0 Yes