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 NITROdb2
CREATE BUFFERPOOL LARGE_BUFFER_POOL IMMEDIATE SIZE 250 PAGESIZE 32 Kdb2
CONNECT RESETdb2
CONNECT TO NITROdb2
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_POOLdb2
CONNECT RESET
DB2 | |
Installation | 10.1 |
Installation | C:\Program |
Account | db2admin/Passw0rd |
Instance Instance | DB2 User Pass |
DB2 Instance | User Pass |