aixdb2安装手册_AIX系统上DB2安装使用手册.doc

DB2培训手册

盈达电子商务软件系统(上海)有限公司 页码 PAGE 9

DB2培训手册

目录

TOC \o "1-4" \h \z \u HYPERLINK \l "_Toc123453648" DB2培训手册 PAGEREF _Toc123453648 \h 1

HYPERLINK \l "_Toc123453649" 1.DB2服务器安装 PAGEREF _Toc123453649 \h 3

HYPERLINK \l "_Toc123453650" 1.1.前提条件 PAGEREF _Toc123453650 \h 3

HYPERLINK \l "_Toc123453651" 1.2.DB2软件安装 PAGEREF _Toc123453651 \h 3

HYPERLINK \l "_Toc123453652" 1.3.创建数据库管理服务器 PAGEREF _Toc123453652 \h 7

HYPERLINK \l "_Toc123453653" 1.4.创建实例 PAGEREF _Toc123453653 \h 7

HYPERLINK \l "_Toc123453654" 1.5.修改/etc/services文件 PAGEREF _Toc123453654 \h 7

HYPERLINK \l "_Toc123453655" 1.6.设置环境变量 PAGEREF _Toc123453655 \h 7

HYPERLINK \l "_Toc123453656" 1.6.1.修改.bash_profile PAGEREF _Toc123453656 \h 7

HYPERLINK \l "_Toc123453657" 1.6.2.设置服务名称 PAGEREF _Toc123453657 \h 7

HYPERLINK \l "_Toc123453658" 1.6.3.设置注册变量 PAGEREF _Toc123453658 \h 7

HYPERLINK \l "_Toc123453659" 1.7.启动实例 PAGEREF _Toc123453659 \h 8

HYPERLINK \l "_Toc123453660" 2.创建数据库 PAGEREF _Toc123453660 \h 9

HYPERLINK \l "_Toc123453661" 2.1.创建数据库 PAGEREF _Toc123453661 \h 9

HYPERLINK \l "_Toc123453662" 2.2.创建缓冲池(8K) PAGEREF _Toc123453662 \h 9

HYPERLINK \l "_Toc123453663" 2.3.创建系统临时表空间(8K) PAGEREF _Toc123453663 \h 9

HYPERLINK \l "_Toc123453664" 2.4.创建数据表空间(8K) PAGEREF _Toc123453664 \h 9

HYPERLINK \l "_Toc123453665" 2.5.创建数据库用户 PAGEREF _Toc123453665 \h 10

HYPERLINK \l "_Toc123453666" 3.创建Schema PAGEREF _Toc123453666 \h 11

HYPERLINK \l "_Toc123453667" 3.1.创建表格 PAGEREF _Toc123453667 \h 11

HYPERLINK \l "_Toc123453668" 3.2.创建视图 PAGEREF _Toc123453668 \h 11

HYPERLINK \l "_Toc123453669" 4.初始化数据导入 PAGEREF _Toc123453669 \h 12

HYPERLINK \l "_Toc123453670" 4.1.公共数据导入 PAGEREF _Toc123453670 \h 12

HYPERLINK \l "_Toc123453671" 4.2.用户数据导入 PAGEREF _Toc123453671 \h 12

HYPERLINK \l "_Toc123453672" 5.DB2数据库日常操作 PAGEREF _Toc123453672 \h 14

HYPERLINK \l "_Toc123453673" 5.1.启动和关闭数据库实例 PAGEREF _Toc123453673 \h 14

HYPERLINK \l "_Toc123453674" 5