Install DB2 express-C on Ubuntu

FinallyDB2


Express-C is installed in
On Ubuntu

,
First go to IBM DB2
Download db2exc_972_lnx_x86.tar.gz on the expressofficial network, two
Ibm_data_studio_standalone_linux.tar.gzdb2exc_nlpack_972_lnx_x86.tar.gz
Is optional.

1. Configure Linux Kernel Parameters
/Etc/sysctl. conf file to add Kernel Parameters
Kernel. msgmni= 1024
Kernel. SEM = 250 256000 32 1024



Kernel. shmmax
















=



 

















268435456







Use sysctl kernel. shmmaxCommand


View the shared memory. Kernel. shmmax = 33554432 (32 MB ),Set


256 MB
Echo 268435456>/proc/sys/kernel/shmmax








If it is not set, it will report

Sql1220nthe
Database
Manager
Shared
Memory
Set
Cannot
Be
Allocated
.




Activate the change: sysctl-P



2.




Sudo apt-Get install libaio1 install the missing package.

3. Start installation below:

1. Tar-xvzf db2exc_970_lnx_x86.tar.gz

1. 
   

4. CD to the decompressed folder./db2setup all the way to next. 5. After the installation is complete, remember to run the db2profile in the installation directory and add environment variables .. /Home/Richar/sqllib/db2profile 6. Get it done. Test:
Create Database test create table ts1 (name varchar (40), NID integer) insert into ts1
Values






('Ss', 12)
7. Start
Db2start
Connect to test
Select * From ts1 address: http://blogold.chinaunix.net/u3/118694/showart_2334784.html