DB安装
-
start from the execute file :
DB2_ESE_10_Win_x86-64\setup.exe
-
Navigator to "Install a Product", then Click "Install New" button
-
the installation directory:C:\Program Files (x86)\IBM\SQLLIB\
-
account:db2admin/Passw0rd
-
Then finish the installation processing:
-
-
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 |