Poon's Blog

INSTALL DB2 UDB ENTERPRISE (ESE) STEP BY STEP

KEYWORD:DB2 ,SERVER,SETUP,HOWTO

1.RUN THE SETUP.EXE
2.CHOOSE INSTALL PRODUCT
3.CHOOSE DB2 UDB ESE ,then click NEXT;
4.the install program will check you operating system if any db2 product was installed.
if there is not , then go to the next step;
5.first you will be asked to specify your local data warehouse control database.if it doesn't exists,
the install program will create it by asking you some infomation:
instance:DB2
database:DWCTRLDB
mode:IWH
-------------
USER INFOMATION
DATABASE USERNAME:db2admin
password:******(whatever as you like)
confirm:(retype above)
6.choose the meta data you wana prepare
four choices,choose one as you need,for example:
i choose no.3 :db2 tools directory and data warehouse control database.
7.security issuses.
enable os securities
db2 admin group : db2admns
db2 user group : db2users, then next.

these steps above tells some configs on db2 installation,

but not cover everything / infomation you need.

BTW:After you complete the installation, you may wana test to see if it works.

So just open the command window,
type db2cmd , press ENTER;
type db2, press ENTER;
now you can perform any SQL statement or db2 command you know to test IF DB2 WORKS FINE.
GOOD LUCK.