• start from the execute file :

DB2_ESE_10_Win_x86-64\setup.exe

  • Navigator to "Install a Product", then Click "Install New" button

DB安装-LMLPHP

DB安装-LMLPHP

DB安装-LMLPHP

DB安装-LMLPHP

  • the installation directory:C:\Program Files (x86)\IBM\SQLLIB\

  • DB安装-LMLPHP
  • DB安装-LMLPHP
  • account:db2admin/Passw0rd

  • DB安装-LMLPHP
  • DB安装-LMLPHP

DB安装-LMLPHP

DB安装-LMLPHP

DB安装-LMLPHP

  • Then finish the installation processing:

  • DB安装-LMLPHP
    • create a database

    DB creation

    On DB2 server, create a db with db2 administrator. The default user on Linux on db2inst1, default user on Windows is db2admin. Please keep in mind don't use OS administrator to create db, especially on Windows, don't make this mistake, otherwise you may got failed to create tables for no permission with db2admin.

    command:

    db2 "CREATE DB Nitro using codeset UTF-8 territory us PAGESIZE 32768"

    Create
    a large buffer pool:

    db2
    CONNECT TO NITRO

    db2
    CREATE BUFFERPOOL LARGE_BUFFER_POOL IMMEDIATE SIZE 250 PAGESIZE 32 K

    db2
    CONNECT RESET

    db2
    CONNECT TO NITRO

    db2
    CREATE USER TEMPORARY TABLESPACE LARGE_USERTEMP PAGESIZE 32 K
    MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE
    16 TRANSFERRATE 0.14 BUFFERPOOL LARGE_BUFFER_POOL

    db2
    CONNECT RESET

DB2
Enterprise Server Edition - DB2COPY1

Installation
Version

10.1

Installation
Location

C:\Program
Files (x86)\IBM\SQLLIB

Account

db2admin/Passw0rd

Instance
name

Instance
user information:

DB2

User
name: db2admin

Pass
Word: Passw0rd

DB2
Administration server

Instance
user information

User
name: db2admin

Pass
Word: Passw0rd

05-11 09:43