????????????????????DB2???????????????DB2???????inux?μ??????衣
??????????? DB2?汾?????? ??????????????ū??????????汾??????????????μ?Express-C?汾??????汾???????????????汾??
?????????????v9.7?汾???????п????????????????? Data Studio Client??
????Linux?汾??
????Linux?汾?μ?DB2??????????????汾???????????CentOS6.2??
????????????
????1???????db2_v101_linuxia32_expc.tar.gz
????2???????????????????????????? ./expc ?????
????[root@localhost opt]# tar -zxvf db2_v101_linuxia32_expc.tar.gz
????????????? http://www.cnblogs.com/zxlovenet/p/3972766.html
????3???????????
????[root@localhost opt]# cd expc/
????4????а??
????[root@localhost expc]# ./db2_install
????5?????????????
?????饗???????
db2iadm1(db2inst1)
db2fadm1( db2fenc1??
[root@localhost expc]# groupadd -g 2000 db2iadm1
[root@localhost expc]# groupadd -g 2001 db2fadm1
[root@localhost expc]# useradd -m -g db2iadm1 -d /home/db2inst1 db2inst1
[root@localhost expc]# useradd -m -g db2fadm1 -d /home/db2fenc1 db2fenc1
[root@localhost expc]# passwd db2inst1
[root@localhost expc]# passwd db2fenc1
????6????? license??????????? PS:?????ExpressC?汾??????
????[root@localhost adm]# pwd
????/opt/ibm/db2/V10.1/adm
????[root@localhost adm]# chmod -R 775 *
????[db2inst1@localhost adm]$ ./db2licm -a /tmp/seagull/db2v10/license/db2ese_c.lic
????7????????????????????
[root@localhost instance]# pwd
/opt/ibm/db2/V10.1/instance
[root@localhost instance]# chmod -R 775 *
[root@localhost instance]# ./db2icrt -p 50000 -u db2fenc1 db2inst1
[root@localhost instance]# su - db2inst1
[db2inst1@localhost ~]$ db2sampl
Creating database "SAMPLE"...
Connecting to database "SAMPLE"...
Creating tables and data in schema "DB2INST1"...
Creating tables with XML columns and XML data in schema "DB2INST1"...
'db2sampl' processing complete.
[db2inst1@localhost ~]$ db2start
SQL1026N The database manager is already active.
[db2inst1@localhost ~]$ db2 connect to sample
Database Connection Information
Database server = DB2/LINUX 10.1.2
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
[db2inst1@localhost ~]$ db2 "select * from staff"