DB2 personal version (Linux) installation
Cowboy (zizhao_chen@yahoo.com)
The Fe of Swust
2003-10-23
Keywords:
DB2 Linux installation
Summary:
This paper briefly introduces the installation process of DB2 PE on the Linux system.
table of Contents:
Introduction to DB2 PE
Or installation file
Prepare to install the environment
finish installation
test
in conclusion
Resource
Introduction to DB2 PE
DB2 Personal Edition (DB2 PE) is a single-user RDBMS running on a COMMODITY HARDWARE desktop. DB2 PE can be used in Windows 98, Windows Me, Windows NT (SP6 or higher), Windows 2000 (recommended SP2), Windows XP, and Linux. DB2 PE will support them when Microsoft publishes Window 2003 servers. DB2 PE has all the features of DB2 Workgroup Server Edition, but there is an exception: the remote client cannot connect to the database running the DB2 version. (However, workstations with control centers can be connected to these databases to perform remote management.) Because "this DB2 until DB2", the applications developed for DB2 PE will be able to be available in DB2 Any other version runs. You can develop DB2 applications using DB2 PE and then use them to production environments.
The DB2 PE is useless regardless of whether the PC is connected to the network; for users who need powerful data store, or need to provide data stock storage tools and can be connected to far
User of the process DB2 server, it is useful in these two situations. DB2 PE is also included with a DB2 Warehouse Center, so users can experiment with commercial intelligent modeling features such as extraction, conversion, and loading.
What is the reading data warehouse? ). DB2 PE has scalability that supports all DB2 Extender: XML (now bundled to DB2 installation), Spatial and Net Search. (For more information, please refer to DB2 Extender.)
Occasionally, users may want to use DB2 built-in replication feature and DB2 Control Server (DB2 Control Server) to establish synchronous environments, and employees can keep in touch with enterprises through this environment. Of course, this
Users and certain workstations that are only suitable for using laptops, such as those running retail terminals (Point-of-s
ALE, POS) Workstation for the application.
Preparation installation
Here, we installed DB2 PE (Personal Edition) and installation files can be obtained from IBM sites. The download address is:. Download the download is T
AR format file.
In my example, my installation file is already put on a FTP in the LAN. My installation environment is
A newly installed RedHat 7.2, which is used by the server installation method.
Copy the installation file to your local:
[root @ no18 root] # wget ftp://192.168.0.1/software/db/db2_v81_pe
_LNX_32_nlv.tar
Unzip:
[root @ no18 root] # TAR XVF DB2_V81_PE_LNX_32_NLV.TAR Unnormal files are placed in the PE folder in the current directory.
start installation:
[root @ no18 root] # pe / db2_install
Overlars, installation can be completed. At this time, the main job we installed will be completed.
finish installation
What we need to do now is to work on the initialization of the database. Includes installation authorization files and creates an instance and run it
.
First, we installed a license file.
If the authorized document is not installed, it is an evaluation version, and it will expire 90 days. Authorized documents, there is already a installation package. I
Install it with the following command:
[root @ no18 root] # /opt/ibm/db2/v8.1/adm/db2licm -a /root/pe/db2/license/db2pe.lic
Then we need to create a user.
[root @ no18 root] # UserAdd DB2Ins1
[root @ no18 root] # Passwd db2ins1
Start creating instances:
[root @ no18 root] # / opt / ibm / db2 / v8.1 / instance / db2icrt -u db2ins1 db2ins1
In this way, we created an instance db2ins1.
Start this example:
[root @ no18 root] # su db2ins1
[DB2INS1 @ no18 db2ins1] $ db2start
SQL1063N DB2Start Processing Was Successful.
test
As a test, we run a simple SQL: Create the SQL of the database.
[root @ no18 root] # su db2ins1
[root @ no18 root] # CD
[DB2INS1 @ no18 db2ins1] $ db2 crete database mydb
DB20000i The Create Database Command Completed SuccessFully.
That's OK, our database creation is successful.
in conclusion
DB2 has won many users with its ease of use and power and strong support. In this article, we take a school.
Learn the first step in DB2. I hope to help those who are interested in DB2.
Resource
1, "UP and RUNING WITH DB2 for Linux"
2,
Http://www-900.ibm.com/cn/software/db2/index.shtml
