Databases Reference
In-Depth Information
Installation using db2_install script
On a Linux system, log in as a user with root authority.
If DB2 Express-C has been downloaded from the previously mentioned URl, it
needs to be decompressed and untarred prior to installation:
1. Decompress the product file:
gzip -d db2exc_91_LNX_x86.tar.gz
2. Untar the product file:
tar -xvf db2exc_91_LNX_x86.tar
3. Change directory into the product directory where db2_install can be found
and enter the following command:
./db2_install
Sample database creation
There are several options for creating the sample database.
You can create the sample database with just the tables in V8 sample SQL
database objects, XML database objects, or both.
The graphical option prompts you for the creation of the database once
installation is complete and provides graphical options for creating a sample
database.
The command line option involves the
db2sampl
command. Key options are:
-sql
: Create SQL database objects and data
-xml
: Create XML database objects and data
-v8
: Create the SAMPLE database from DB2 UDB V8
Considerations for DB2 Express-C
The following constraints are present in DB2 Express-C:
Maximum processors: 2
Maximum addressable memory: 4 GB
Database Partitioning Feature: N/A
Connection Concentrator: N/A
DB2 Geodetic Extender: N/A
Query Patroller: N/A
Net Search Extender: N/A
Search WWH ::
Custom Search