Log on as root (or gain root access through a terminal if a root logon is not available)
Mount the DVD (if installing from Discovery DVD set), or download the appropriate Linux compressed image (tar.gz file) from the DB2 Express-C download site
Copy the compressed image file to the
Extract the files from the compressed image, either using the Ark GUI tool or using the console command tar zxvf db2exc_91_LNX_x86.tar.gz
/tmp folder, change to the
exp/disk1i directory and run the
In the DB2 setup Launchpad, choose Install a Product
Choose Install New
Verify the license and change the radio button to Accept, then choose "Next" to continue the installation
Choose a Typical installation and click "Next"
Verify the install path, or change it to some point on your system with at least 470 MB free, click "Next"
Set up the DAS (DB2 Administration Server) owner account. You can use an existing user, or set up a new one (the default user is 'dasusr1'). Click "Next"
Create a DB2 instance. Click "Next"
Set up the DB2 instance owner account. Again, you can use an existing user, or set up a new one (the default instance owner is 'db2inst1'). Click "Next"
Set up the DB2 fenced user account. Same as before, use an existing user or set up a new one. Click "Next"
Click "Finish" to initiate the install
If there are any problems with the installation, it will show up
in the installation log (the log is also kept in the
/tmp directory as
Log in as the DB2 instance owner (db2inst1 by default)
Open a terminal and run 'db2sampl' to create the SAMPLE database
Test terminal based commands:
db2 connect to sample
db2 'select * from dept'
Test DB2 Control Center:
Open the control center with 'db2cc' command
Select the "Advanced" view
Verify the SAMPLE database is present under the "All databases" tab
Look at the contents of one of the SAMPLE database tables and views (e.g. vphone)
Create TOOLS database:
db2 'create tools catalog TOOLS create new database TOOLSDB'
Launch DB2 Task Center:
Create a task that issues a simple query like "connect to sample; select tabname from syscat.tables; connect reset;", schedule to run now
Click on "show results", no errors should exist
Launch DB2 Journal: You should be able to see the results of the task you ran in the task center from the Journal.
Test DB2 Configuration Assistant
Start Configuration Assistant from the Control Center, or with db2ca
You should see the SAMPLE database listed, if not, click View, then Refresh.
Right click on the SAMPLE database, choose Change Database, then in step 4 of the wizard, register the database as a CLI/ODBC source, and catalog as system data source. Click Finish to commit the changes
Right click on the SAMPLE database again, and click on Test Connection. Select all types (Standard (ODBC), CLI, JDBC), then type in a userid and password, and click on Test Connection. Ensure all tests are successful.
Test DB2 trace facility: db2trc on -- check for positive response, then run db2trc off
Test DB2 problem determination facility: db2pd -db sample > sample.txt (examine output for errors)
Test DB2 license: db2licm -l should return:
Product name: "DB2 Express Edition" License type: "Unwarranted" Expiry date: "Permanent" Product identifier: "db2exp" Version information: "9.1" Max number of CPUs: "2"
db2 force applications all db2dart sample
(should report that DB2DART processing has completed successfully)
Test db2look facility: db2look -d sample -e > sample.ddl (should complete successfully)
Test remote connections:
Create connection through command prompt on DB2 remote client system:
db2 catalog tcpip node test remote computername server 50001 db2 catalog db sample at node test
From remote machine:
db2 connect to sample db2 "select * from dept"
Reboot server and retest via remote connection (to verify DB2 instance autostart and that any firewall changes stick)