DB2数据库的正确安装步骤简介

DB2数据库的优秀性勿须多言，本文将问您介绍DB2数据库安装的正确操作步骤，如果您对DB2数据库安装有兴趣的话，不妨一看，对您将有所帮助。

一、DB2安装过程

 1 新建3个组，分别为管理组件das组，实例inst组，守护def组。随后在三个组中分别加入对应的用户：das，inst，和def。注意的是inst 用户>同时属于das组。为各个用户建立目录和密码。

 2 运行DB2SETUP后未出现向导，出现提示后退出的解决。

 请不要执行DB2SETUP,请执行DB2_install，然后输入DB2数据库安装的组件名字进行安装。

 3 创建实例

 在/opt/IBM/DB2/v8.1/instane/下分别执行

 ./dascrt -u dasuser

 ./dasicrt -w 32 -u defuser instuser ＃如未指定位宽，则会报错说配置文件不能正常初始化。

 在/cfg/下执行DB2ln

4 设置

 切换到instuser用户下

 $DB2set -g DB2COMM = TCPIP #在全局或使用-i指定某个实例的连接属性

 5 启动数据库

$DB2start ＃在启动前请修改系统时间到2005年以前，否则会出现数据库license过期的提示

 建立样表#p#

 $DB2sampl

 测试

 $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数据库的正确安装步骤简介
文章URL：http://www.shufengxianlan.com/qtweb/news34/450684.html

网站建设、网络推广公司-创新互联，是专注品牌与效果的网站制作，网络营销seo公司；服务项目有等

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联