Graphical linux+db2_v9.7 Detailed installation steps

Source: Internet
Author: User
Tags db2 db2 connect db2 connect to create database hp server

One: Platform

1:HP Server

Cpu:inter (R) Xeon (r) E5606 2.13G

Disk: Local Disk plus storage

2: Operating system

Redhet 5.4 64-bit

Kernel: 2.6.18-194.1.ax53

3: Database

db2_v9.7 x86_64

Two: Install the operating system

Put the Redhat 5.4 64-bit CD-ROM into the optical drive, if there is storage, first unplug the storage line, reload the system. Follow the prompts to install the operating system

After installation, log in as root, configure IP address and gateway

You can configure IP addresses and gateways graphically

Open Terminal: Input setup, select Network Configuration, Edit devices,eth0, configure static IP and netmask, save exit

Third: Install the DB2 database

1: Put the DB2 CD into the optical drive and execute the MOUNT/DEV/CDROM/MNT

2:CD/MNT Note: If the package in the CD is a tar.gz package, you need to create the directory first

Mkdir/db2

TAR-ZXVF ******.tar.gz-c/DB2

CD/DB2/EXPC)

3:./db2setup (Graphical installation)

4:

5: Click to install the product, one click Install, accept the terms, and then click Next

6: Select Typical installation

7: Install DB2 on this computer

8: Choose the installation directory

9: Set up DB2 Management Server account

10: Create DB2 instance

11: Set up the DB2 instance user account

12: Set up a protected account

13: Complete

14: The above DB2 is installed on the virtual machine, the version is V9.7

Four: Create a database and table the first method

1: Cancellation system, to Db2inst1 landing system

2: Open terminal execution Db2start

3: Set the DB2 boot self-starter

Su–root

Cd/opt/ibm/db2/v9.7/instance

./db2iauto-on Db2inst1

Exit

4: Open the graphical interface, perform db2cc

5: Click OK

6: Expand all ststems--machine name sequentially-–instances-–db2inst1--databases

Creating a Database

7: Enter the database name

8: Select the database file storage location, by default

9: Next step is done

10: The above is a graphical interface to create a database

11: Import script, CREATE table

Open Command Editor

Select Add, use Db2inst1 login

(Note: The database name changed, because I deleted before, and created a, can not duplicate)

Then copy the commands in the script to the box and execute the line, and remember that if you created the database, the first line in the script doesn't have to be copied because the first line of the script is to create the database.

(2) The second method

Switch to Db2inst1

Create database TestDB using CodeSet GBK territory CN

DB2 Connect to TestDB

Take Table.sql footsteps to the/OPT

Cd/opt

Cat Table.sql

Copy all content with the mouse

And then copy it under the terminal.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.