安装DB2v9.1Express-C

由于IBM每次推出新版本的软件之后官网就不再提供旧版本软件的下载了,db2v9.1就只能通过其他渠道下载了

百度网盘地址:http://pan.baidu.com/share/link?shareid=725954&uk=3171914453

下载下来有350M左右


解压它

找到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 -- 安装操作已成功完成。




  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值