由于IBM每次推出新版本的软件之后官网就不再提供旧版本软件的下载了,db2v9.1就只能通过其他渠道下载了
百度网盘地址:http://pan.baidu.com/share/link?shareid=725954&uk=3171914453
解压它
找到setup.exe双击
在弹出的 DB2安装启动板 中点击 安装产品
点击安装新产品
在弹出的 DB2安装向导中点击下一步
同意条款
选 典型安装
设置响应文件位置
设置安装位置
设置用户信息
选择 本地用户或与用户账户
在用户信息组里填
域:无—使用本地用户账户
用户名:db2admin
密码:db2admin
确认密码:db2admin
这里配置默认实例,默认就就行
检查配置
开始安装
到这里一般等待时间比较长
弹出 创建SAMPLE数据库和表
安装完成,之后会跳出 第一步(这是IBM大部分软件的的做法)
下面简单测试一下数据库能不能用
开始-->所有程序-->IBM DB2-->DB2COPY1(缺省值)-->命令行工具-->命令窗口
输入以下命令
db2 connect to sample
db2 select * from employee
结果
C:\Program Files\IBM\SQLLIB\BIN>db2 connect to sample
数据库连接信息
数据库服务器 = DB2/NT 9.1.2
SQL 授权标识 = ADMINIST...
本地数据库别名 = SAMPLE
C:\Program Files\IBM\SQLLIB\BIN>db2 select * from employee
EMPNO FIRSTNME MIDINIT LASTNAME WORKDEPT PHONENO HIREDATE JOB
EDLEVEL SEX BIRTHDATE SALARY BONUS COMM
------ ------------ ------- --------------- -------- ------- ---------- --------
------- --- ---------- ----------- ----------- -----------
000010 CHRISTINE I HAAS A00 3978 1995-01-01 PRES
18 F 1963-08-24 152750.00 1000.00 4220.00
000020 MICHAEL L THOMPSON B01 3476 2003-10-10 MANAGER
18 M 1978-02-02 94250.00 800.00 3300.00
000030 SALLY A KWAN C01 4738 2005-04-05 MANAGER
20 F 1971-05-11 98250.00 800.00 3060.00
000050 JOHN B GEYER E01 6789 1979-08-17 MANAGER
16 M 1955-09-15 80175.00 800.00 3214.00
000060 IRVING F STERN D11 6423 2003-09-14 MANAGER
16 M 1975-07-07 72250.00 500.00 2580.00
000070 EVA D PULASKI D21 7831 2005-09-30 MANAGER
16 F 2003-05-26 96170.00 700.00 2893.00
000090 EILEEN W HENDERSON E11 5498 2000-08-15 MANAGER
16 F 1971-05-15 89750.00 600.00 2380.00
000100 THEODORE Q SPENSER E21 0972 2000-06-19 MANAGER
14 M 1980-12-18 86150.00 500.00 2092.00
000110 VINCENZO G LUCCHESSI A00 3490 1988-05-16 SALESREP
19 M 1959-11-05 66500.00 900.00 3720.00
000120 SEAN O'CONNELL A00 2167 1993-12-05 CLERK
14 M 1972-10-18 49250.00 600.00 2340.00
000130 DELORES M QUINTANA C01 4578 2001-07-28 ANALYST
16 F 1955-09-15 73800.00 500.00 1904.00
000140 HEATHER A NICHOLLS C01 1793 2006-12-15 ANALYST
18 F 1976-01-19 68420.00 600.00 2274.00
000150 BRUCE ADAMSON D11 4510 2002-02-12 DESIGNER
16 M 1977-05-17 55280.00 500.00 2022.00
000160 ELIZABETH R PIANKA D11 3782 2006-10-11 DESIGNER
17 F 1980-04-12 62250.00 400.00 1780.00
000170 MASATOSHI J YOSHIMURA D11 2890 1999-09-15 DESIGNER
16 M 1981-01-05 44680.00 500.00 1974.00
000180 MARILYN S SCOUTTEN D11 1682 2003-07-07 DESIGNER
17 F 1979-02-21 51340.00 500.00 1707.00
000190 JAMES H WALKER D11 2986 2004-07-26 DESIGNER
16 M 1982-06-25 50450.00 400.00 1636.00
000200 DAVID BROWN D11 4501 2002-03-03 DESIGNER
16 M 1971-05-29 57740.00 600.00 2217.00
000210 WILLIAM T JONES D11 0942 1998-04-11 DESIGNER
17 M 2003-02-23 68270.00 400.00 1462.00
000220 JENNIFER K LUTZ D11 0672 1998-08-29 DESIGNER
18 F 1978-03-19 49840.00 600.00 2387.00
000230 JAMES J JEFFERSON D21 2094 1996-11-21 CLERK
14 M 1980-05-30 42180.00 400.00 1774.00
000240 SALVATORE M MARINO D21 3780 2004-12-05 CLERK
17 M 2002-03-31 48760.00 600.00 2301.00
000250 DANIEL S SMITH D21 0961 1999-10-30 CLERK
15 M 1969-11-12 49180.00 400.00 1534.00
000260 SYBIL P JOHNSON D21 8953 2005-09-11 CLERK
16 F 1976-10-05 47250.00 300.00 1380.00
000270 MARIA L PEREZ D21 9001 2006-09-30 CLERK
15 F 2003-05-26 37380.00 500.00 2190.00
000280 ETHEL R SCHNEIDER E11 8997 1997-03-24 OPERATOR
17 F 1976-03-28 36250.00 500.00 2100.00
000290 JOHN R PARKER E11 4502 2006-05-30 OPERATOR
12 M 1985-07-09 35340.00 300.00 1227.00
000300 PHILIP X SMITH E11 2095 2002-06-19 OPERATOR
14 M 1976-10-27 37750.00 400.00 1420.00
000310 MAUDE F SETRIGHT E11 3332 1994-09-12 OPERATOR
12 F 1961-04-21 35900.00 300.00 1272.00
000320 RAMLAL V MEHTA E21 9990 1995-07-07 FIELDREP
16 M 1962-08-11 39950.00 400.00 1596.00
000330 WING LEE E21 2103 2006-02-23 FIELDREP
14 M 1971-07-18 45370.00 500.00 2030.00
000340 JASON R GOUNOT E21 5698 1977-05-05 FIELDREP
16 M 1956-05-17 43840.00 500.00 1907.00
200010 DIAN J HEMMINGER A00 3978 1995-01-01 SALESREP
18 F 1973-08-14 46500.00 1000.00 4220.00
200120 GREG ORLANDO A00 2167 2002-05-05 CLERK
14 M 1972-10-18 39250.00 600.00 2340.00
200140 KIM N NATZ C01 1793 2006-12-15 ANALYST
18 F 1976-01-19 68420.00 600.00 2274.00
200170 KIYOSHI YAMAMOTO D11 2890 2005-09-15 DESIGNER
16 M 1981-01-05 64680.00 500.00 1974.00
200220 REBA K JOHN D11 0672 2005-08-29 DESIGNER
18 F 1978-03-19 69840.00 600.00 2387.00
200240 ROBERT M MONTEVERDE D21 3780 2004-12-05 CLERK
17 M 1984-03-31 37760.00 600.00 2301.00
200280 EILEEN R SCHWARTZ E11 8997 1997-03-24 OPERATOR
17 F 1966-03-28 46250.00 500.00 2100.00
200310 MICHELLE F SPRINGER E11 3332 1994-09-12 OPERATOR
12 F 1961-04-21 35900.00 300.00 1272.00
200330 HELENA WONG E21 2103 2006-02-23 FIELDREP
14 F 1971-07-18 35370.00 500.00 2030.00
200340 ROY R ALONZO E21 5698 1997-07-05 FIELDREP
16 M 1956-05-17 31840.00 500.00 1907.00
42 条记录已选择。
C:\Program Files\IBM\SQLLIB\BIN>
前文中设置的响应文件记录了所有的安装过程,如果安装过程出错可以在这找原因
C:\Documents and Settings\Administrator\My Documents\DB2LOG\DB2-EXP-Sun Jun 14 07_25_57 2015.log
笔者的部分内容
开始部分
=== 记录开始: 2015-6-14 7:26:05 ===
操作 7:26:05: INSTALL.
操作开始 7:26:05: INSTALL。
操作 7:26:05: AppSearch. 正在搜索已安装的应用程序
操作开始 7:26:05: AppSearch。
AppSearch: 属性: INSTALLDIR.64D68DB0_DBE9_457E_ABE5_38AA65A3E74E,签名: InstallPathInReg
AppSearch: 属性: VERINREG.64D68DB0_DBE9_457E_ABE5_38AA65A3E74E,签名: VerInReg
AppSearch: 属性: IE4FOUND,签名: sigShdocvwISUS
AppSearch: 属性: XPFOUND,签名: sigKernel32
AppSearch: 属性: MDAC28IE4SIG,签名: NewSignature11.E7D6BCFA_9BFA_49D4_A1EE_767B7FD61E38
AppSearch: 属性: MDAC28INSTVER,签名: NewSignature1.E7D6BCFA_9BFA_49D4_A1EE_767B7FD61E38
AppSearch: 属性: PROP_RSP_DB2_OLEDB_GUID,签名: PROP_RSP_DB2_OLEDB_GUID
AppSearch: 属性: PROP_RSP_DB2_OLEDB_ADVANCED_PAGE_GUID,签名: PROP_RSP_DB2_OLEDB_ADVANCED_PAGE_GUID
AppSearch: 属性: PROP_RSP_DB2_OLEDB_CONNECTION_PAGE_GUID,签名: PROP_RSP_DB2_OLEDB_CONNECTION_PAGE_GUID
AppSearch: 属性: PROP_RSP_DB2_OLEDB_ENUMERATOR_GUID,签名: PROP_RSP_DB2_OLEDB_ENUMERATOR_GUID
AppSearch: 属性: PROP_RSP_DB2_OLEDB_ERROR_LOOKUP_GUID,签名: PROP_RSP_DB2_OLEDB_ERROR_LOOKUP_GUID
操作结束 7:26:05: AppSearch。返回值 1。
操作 7:26:05: LaunchConditions. 正在评估启动条件
操作开始 7:26:05: LaunchConditions。
操作结束 7:26:05: LaunchConditions。返回值 1。
结束部分
Property(C): p_gotoSummary = Y
Property(C): p_serverNetBios = 1
Property(C): p_serverNPipe = 1
Property(C): p_noSvProtSelected = NO
Property(C): p_configNB = 1
Property(C): p_appcSelected = 0
Property(C): p_localUserAccount = 无 - 使用本地用户帐户
Property(C): p_lastDialog = DasUserInfo
Property(C): TYP_INCLUDES_WH = N
Property(C): p_displayDomainWarning = NO
Property(C): p_CurrentDialog = DB2Instance
Property(C): PROP_RSP_LANG = EN
Property(C): p_instanceStorage = DB2;
Property(C): PROP_RSP_LANG1 = CN
Property(C): p_instReturnID = db2inst
Property(C): p_DB2InstAuthCfgBackFlag = DB2Instance
Property(C): p_DasUserInfoShown = Y
Property(C): RSP_FILE_PATH = C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\PROD_EXP00.RSP
Property(C): p_NextDialog = Summery_rspInstall
Property(C): p_domainUnavailable = 1
Property(C): p_msgStorage = DB2 .NET Data Provider 需要 .NET Framework V1.1 或 V2.0。在系统上安装了必需的 .NET Framework 之后才能配置它。为了使用 DB2 .NET Data Provider,安装 .NET Framework V1.1 或 V2.0,然后从“启动”快捷方式或者从命令行配置 DB2 .NET Data Provider。
Property(C): p_dwCDB_localInst = DB2
Property(C): WriteRspFileStatus = 1
Property(C): p_dasDomainUser = YES
Property(C): p_noSpaceFlag = InstallPathSelection
Property(C): p_lastPathDialog = InstallPathSelection
Property(C): p_summaryBackFlag = DB2Instance
Property(C): p_securityBackFlag = pathSelection
Property(C): p_DB2InstanceESEBackFlag = InstallPathSelection
Property(C): p_DB2InstanceBackFlag = DasUserInfo
Property(C): p_instanceSetupBackFlag = InstallPathSelection
Property(C): DB2_COPY_NAME2 = DB2COPY1
Property(C): p_healthMonitorFlag = 10
Property(C): p_toolsCatalogBackFlag = DB2Instance
Property(C): PROP_RSP_DB2.AUTOSTART = YES
Property(C): INSTALL_RESULT = Setup Complete Successfully
=== 记录停止: 2015-6-14 7:38:00 ===
MSI (c) (3C:40) [07:38:00:707]: 产品: IBM DB2 Express Edition - DB2COPY1 -- 安装操作已成功完成。