0. update your apt database:
sudo apt-get update
1. update your Source-List /etc/apt/source.list, uncommnent the following lines:
deb http://archive.canonical.com/ubuntu lucid partner
deb-src http://archive.canonical.com/ubuntu lucid partner
2. install db2express-c:
sudo apt-get install db2exc
3. if you met error like below,then make sure you have memory larger than 512MB. I met the error when I gave my VM 256MB memory (the official requirements said it is 256MB/512MB...). Another solution could be found
here (saying you need to run db2start one more time).
Message: SQL1042C An unexpected system error occurred. SQLSTATE=58004
4. verify installation:
# login as db2 instance owner
sudo su - db2inst1
# create sample database
db2sampl
# connect to sample database
db2 connect to sample
# list tables and query by db2 command line interface (CLI)
db2 list tables
db2 "select * from emp"
5. create sample database user
# exit the login of db2inst1
exit
# create a new Ubuntu user since db2 use system authentication
sudo useradd -d /home/db2user db2user
# set password for db2user
sudo passwd db2user
# login as db2inst1 again to grant privilege to new user "db2user"
sudo su - db2inst1
db2 connect to sample
db2 grant DBADM on database to user db2user
6. change db2inst1 password:
# i'm not sure what the default password is
# but you'd better change it to make your system safe
sudo passwd db2inst1
more information:
the user name "db2inst1" may be different if you have installed db2 in your system before. (the last number '1' will increase by your installations)
if you met any other problems check the diagnostic log first:
/home/db2inst3/sqllib/db2dump/db2diag.log
IBM Official DB2 for Ubuntu Wiki
分享到:
相关推荐
Installing STLinux on Ubuntu
OpenERP Installing Ubuntu9.04
Oracle Solaris 11.2 Installing and Configuring OpenStack in Oracle Solaris 11.2-124
有下面几个文档 What's New for DB2 Version 9.7 PDF July, 2012 Quick Start Guide - DB2 Personal Edition1 PDF Quick Start Guide - DB2 Servers1 PDF Quick Start Guide - DB2 Connect1...Installing DB2 Servers
面是我在Ubuntu6.06 LTS 下源码编译安装samba主要安装过程,本人第一次用Ubuntu,刚装上去时候,没有gcc编译环境。郁闷了半天。找出这一过程发了不少的时间。可能还有些不妥,不过我经过这样的安装达到了向windows共享...
Installing Ubuntu—Getting started 11 Finishing Installation 16 2 The Ubuntu Desktop 19 Understanding the Ubuntu desktop 19 Unity 19 The Launcher 21 The Dash 21 Workspaces 24 Managing windows 24 Unity...
Automate Ubuntu installs, no matter how many servers you’re installing Quickly set up low-cost Web servers and e-mail Protect your server with Ubuntu’s built-in and optional security tools ...
Installing Ubuntu 14.04 & ROS & TurtleBot 06-29-2016 个人小结,关于Ubuntu和ROS的安装。
Ubuntu Server Succinctly illuminates the path from installing Ubuntu Server on a machine to configuring user accounts, groups, directories, networks, databases, and more. In only a few dozen pages, ...
One way of doing it is using mod_php5 Apache module to serve PHP 5.3 applications, while running PHP 5.2 applications using fastcgi module. Under Ubuntu 12.04 this can be achieved by installing ...
Administer, install, and configure the 5–year Hardy–Heron Ubuntu Server Long Term Support Edition of the most popular Linux distribution in the world. Use the new installation and GUI tools. ...
Ubuntu-10.04环境下安装 ns2 2.34
Compilation - Compiling and Running C Programs, Installing Codeblocks IDE on Raspberry Pi / Linux, Variables and Data Types in C, Operators, Input and output - printf and scanf, Strings, Arrays, ...
Chapter 3 Installing Ubuntu Chapter 4 Post-Installation Configuration Chapter 5 First Steps with Ubuntu Chapter 6 The X Window System Chapter 7 Managing Software Chapter 8 On the Internet: ...
安装mumax3最全教程
The Ubuntu Server Guide contains information on how to install and configure various server applications on your Ubuntu system to fit your ...installing Ubuntu, refer to the Ubuntu Installation Guide.
Installing BizTalk Server 2010 and BAM in a Multi-Computer Environment
Part 2 covers installing Ubuntu on your computer. An illustrated guide is provided, and all installation choices are explained in depth. Additionally, you’ll find a problem-solving chapter to help in...
Part 2 covers installing Ubuntu on your computer. An illustrated guide is provided, and all installation choices are explained in depth. Additionally, you’ll find a problem-solving chapter to help in...