建站
咨詢
售后
建站咨詢
新聞中心
DB2數(shù)據(jù)庫的優(yōu)秀性勿須多言，本文將問您介紹DB2數(shù)據(jù)庫安裝的正確操作步驟，如果您對(duì)DB2數(shù)據(jù)庫安裝有興趣的話，不妨一看，對(duì)您將有所幫助。
一、DB2安裝過程
1 新建3個(gè)組，分別為管理組件das組，實(shí)例inst組，守護(hù)def組。隨后在三個(gè)組中分別加入對(duì)應(yīng)的用戶：das，inst，和def。注意的是inst 用戶>同時(shí)屬于das組。為各個(gè)用戶建立目錄和密碼。
2 運(yùn)行DB2SETUP后未出現(xiàn)向?qū)В霈F(xiàn)提示后退出的解決。
請(qǐng)不要執(zhí)行DB2SETUP,請(qǐng)執(zhí)行DB2_install，然后輸入DB2數(shù)據(jù)庫安裝的組件名字進(jìn)行安裝。
3 創(chuàng)建實(shí)例
在/opt/IBM/DB2/v8.1/instane/下分別執(zhí)行
./dascrt -u dasuser
./dasicrt -w 32 -u defuser instuser ＃如未指定位寬，則會(huì)報(bào)錯(cuò)說配置文件不能正常初始化。
在/cfg/下執(zhí)行DB2ln
4 設(shè)置
切換到instuser用戶下
$DB2set -g DB2COMM = TCPIP #在全局或使用-i指定某個(gè)實(shí)例的連接屬性
5 啟動(dòng)數(shù)據(jù)庫
$DB2start ＃在啟動(dòng)前請(qǐng)修改系統(tǒng)時(shí)間到2005年以前，否則會(huì)出現(xiàn)數(shù)據(jù)庫license過期的提示
建立樣表#p#
$DB2sampl
測(cè)試
$DB2 "select * from stuff"
二、DB2的初次使用
$DB2
Command Line Processor for DB2 SDK 8.2.3
You can issue database manager commands and SQL statements from the command
prompt. For example:
DB2 => connect to sample
DB2 => bind sample.bnd
For general help, type:.
For command help, type: command, where command can be
the first few keywords of a database manager command. For example:
CATALOG DATABASE for help on the CATALOG DATABASE command
CATALOG for help on all of the CATALOG commands.
To exit DB2 interactive mode, type QUIT at the command prompt. Outside #p#
interactive mode, all commands must be prefixed with 'DB2'.
To list the current command option settings, type LIST COMMAND OPTIONS.
For more detailed help, refer to the Online Reference Manual.
DB2 => DB2start
DB20000I The DB2START command completed successfully.
DB2 => create db mydb
DB20000I The CREATE DATABASE command completed successfully.
DB2 => connect to mydb user admin
Enter current password for admin:
Database Connection Information
Database server = DB2/NT 8.2.3
SQL authorization ID = ADMIN
Local database alias = MYDB
DB2 => create schema myschema
DB20000I The SQL command completed successfully. #p#
DB2 => create table myschema.mytable(id int, name varchar(30))
DB20000I The SQL command completed successfully.
DB2 => insert into myschema.mytable values(101,'Bruce Lu')
DB20000I The SQL command completed successfully.
DB2 => select * from myschema.mytable
ID NAME
101 Bruce Lu
1 record(s) selected.
DB2 => drop table myschema.mytable
DB20000I The SQL command completed successfully. #p#
DB2 => drop schema myschema restrict
DB20000I The SQL command completed successfully.
DB2 => connect reset
DB20000I The SQL command completed successfully.
DB2 => drop db mydb
DB20000I The DROP DATABASE command completed successfully.
DB2 => DB2stop
DB20000I The DB2STOP command completed successfully.
DB2 => quit
DB20000I The QUIT command completed successfully.
本文名稱：DB2數(shù)據(jù)庫的正確安裝步驟簡介
文章分享：http://www.dlmjj.cn/article/cdhphjj.html
