社区
DB2
帖子详情
谁有DB2的SQL中文帮助啊
InsideJava
2003-08-19 12:09:10
rt
请大侠们帮忙
...全文
32
4
打赏
收藏
谁有DB2的SQL中文帮助啊
rt 请大侠们帮忙
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
4 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
db2boy
2003-08-20
打赏
举报
回复
英文怎么会没有,http://www-900.ibm.com/developerWorks/cn/dmdd/support/downloads/downloads.shtml, 每个厂商对sql的实现都不太一样,sql server的sql不是都能在 db2上运行。
leowu
2003-08-20
打赏
举报
回复
你是不是要db2的sql reference,我有英文的。你要可以把你的邮箱告诉我,发mail给我:leo_wu@tom.com。
其实在ibm官方网上都是有下载的,就是比较难找。
pcclever
2003-08-19
打赏
举报
回复
楼上老大,到现在为止,我连英文的都没找到过。被逼无奈又装了一套中文版slq2000。
jiezhi
2003-08-19
打赏
举报
回复
沒有見過中文的。看英文的吧
IBM
DB2
v9.0
SQL
帮助
文档(英)
IBM
DB2
v9.0
SQL
帮助
文档(英),找了好久终找到了!
Toad for
DB2
解决方案(
中文
)
Toad for
DB2
是一种专业化、图形化的
DB2
开发和管理工具,用来
帮助
DBA和开发人员有效地完成他们的工作。它集成了模式浏览、
SQL
编程、开发和调试、DBA管理、
SQL
语句优化等多种功能。功能强大、低负载、简单易用,访问速度快,是一个结构紧凑的专业化
DB2
开发和管理环境。使用Toad for
DB2
,我们可以通过一个图形化的用户界面快速访问数据库,完成复杂的
SQL
代码编辑和测试工作。
SQL
入门教程
【课程全部章节可以免费学习啦!】 本课程为
SQL
入门教程,面向
SQL
...本课程基于最新
SQL
标准 ,全面讲解六种主流数据库的
SQL
语句实现与差异,包括:Oracle、My
SQL
、
SQL
Server、Postgre
SQL
、
Db2
以及
SQL
ite 。
db2
数据库入门教程(官方
中文
版)
PART I – 概览.........................................................................................................................11 第 1章 –
DB2
Express-C是什么?..........................................................................................13 1.1免费开发、部署和分发… 无限制!...............................................................................13 1.2用户
帮助
和技术支持.....................................................................................................14 1.3
DB2
服务器..................................................................................................................14 1.4
DB2
客户端和驱动........................................................................................................14 1.5 应用程序开发的自由性.................................................................................................15 1.6
DB2
版本号与
DB2
版本分类........................................................................................16 1.7升级到其它的
DB2
版本................................................................................................16 1.8
DB2
Express-C的维护.................................................................................................16 1.9相关免费软件................................................................................................................17 1.9.1 IBM数据工作室(Data Studio)...........................................................................17 1.9.2
DB2
Net Search Extender .....................................................................................17 1.9.3 Starter Toolkit for
DB2
on Rails.............................................................................17 1.9.4 Web 2.0 Starter Toolkit for
DB2
............................................................................17 1.9.5 WebSphere Application Server – Community Edition............................................18 第 2章 –
DB2
相关特性和产品................................................................................................19 2.1
DB2
Express-C订购中包含的功能...............................................................................22 2.1.1 Fix packs补丁包...................................................................................................22 2.1.2高可用性灾难恢复(HADR) ................................................................................22 2.1.3数据复制(Data Replication)...............................................................................22 2.2
DB2
Express-C所不具备的功能...................................................................................23 2.2.1数据库分区............................................................................................................23 2.2.2连接集中器(Connection Concentrator ).............................................................23 2.2.3 Geodetic Extender ................................................................................................23 2.2.4工作负载管理(Workload Management, WLM) .......................................................24 2.3
DB2
相关收费产品........................................................................................................24 2.3.1
DB2
连接(
DB2
Connect)...................................................................................24 2.3.2 WebSphere Federation Server..............................................................................24 2.3.3 WebSphere Replication Server .............................................................................25 第 3章 – 安装
DB2
..................................................................................................................27 3.1安装前提条件................................................................................................................27 3.2操作系统中的安装权限.................................................................................................27 3.3安装向导.......................................................................................................................27 3.4自动安装.......................................................................................................................31 实验 #1 安装
DB2
Express-C,创建 SAMPLE数据库........................................................32 第 4章 –
DB2
的应用环境.......................................................................................................35 实验 #2 - 创建一个新的数据库............................................................................................43 4.1
DB2
配置......................................................................................................................44 4.1.1 环境变量................................................................................................................44 4.1.2 数据库管理器配置文件(dbm cfg) ...........................................................................44 4.1.3 数据库配置文件(db cfg)....................................................................................46 4.1.4
DB2
概要文件注册表.............................................................................................47 4.2
DB2
管理服务器...........................................................................................................48 实验 #3 – 实例、数据库和配置管理....................................................................................49 第 5章 –
DB2
工具..................................................................................................................51 5.1控制中心(Control Center).........................................................................................52 5.2命令编辑器(Command Editor) .................................................................................55 5.3
SQL
帮助
向导(
SQL
Assist Wizard ).........................................................................57 5.4 显示
SQL
按钮..............................................................................................................58 实验 #4 使用脚本填充EXPRESS数据库...........................................................................59 5.5 脚本..............................................................................................................................60 5.5.1
SQL
脚本...............................................................................................................60 5.5.2操作系统(shell)脚本..........................................................................................61 实验 #5 为EXPRESS数据库创建一个安装脚本.................................................................62 5.6任务中心(Task Center )...........................................................................................65 5.6.1工具目录(Tools Catalog)数据库........................................................................65 5.7 日志(Journal)...........................................................................................................66 5.8运行状况监视器(Health Monitor ).............................................................................67 5.8.1运行状况中心(Health Center )...........................................................................68 PART II –
DB2
Express-C 数据库管......................................................................................71 第 6章 –
DB2
体系结构...........................................................................................................73 6.1
DB2
进程模型...............................................................................................................73 6.2
DB2
内存模型...............................................................................................................74 6.3
DB2
存储模型...............................................................................................................75 6.3.1数据页和扩展数据块..............................................................................................75 6.3.2缓冲池...................................................................................................................76 6.3.3表空间...................................................................................................................77 第 7章 –
DB2
客户端的连接....................................................................................................81 7.1
DB2
目录......................................................................................................................81 7.2 配置助手(Configuration Assistant )..........................................................................82 7.2.1服务器端的安装要求..............................................................................................82 7.2.2 Setup required at the client 客户端的安装要求......................................................84 7.2.3建立客户端与服务器端概要文件............................................................................87 实验 #6 使用配置助手........................................................................................................90 第 8章 – 数据库对象...............................................................................................................93 8.1 模式..............................................................................................................................93 8.2表.................................................................................................................................93 8.2.1数据类型................................................................................................................93 8.2.2标识列...................................................................................................................96 8.2.3序列对象................................................................................................................96 8.2.4系统目录表............................................................................................................97 8.2.5已声明临时表.........................................................................................................97 实验 #7 创建一个数据表.....................................................................................................99 8.3视图............................................................................................................................101 8.4索引............................................................................................................................101 8.4.1 Design Advisor ....................................................................................................101 8.5参照完整性.................................................................................................................102 第 9章 – 数据迁移工具..........................................................................................................105 9.1 导出(EXPORT)工具...............................................................................................106 9.2 导入(IMPORT)工具................................................................................................106 9.3 使用 LOAD来导入......................................................................................................107 9.4
db2
move 工具...........................................................................................................108 9.5
db2
look 工具..............................................................................................................109 实验 #8 导出EXPRESS数据库的DDL............................................................................111 第 10章 – 数据库安全...........................................................................................................115 10.1 认证..........................................................................................................................116 10.2 授权..........................................................................................................................116 10.3 DBADM权限............................................................................................................118 10.4 PUBLIC 组...............................................................................................................119 10.5 GRANT和REVOKE语句 ........................................................................................119 10.6 查看授权和特权........................................................................................................119 10.7 关于组特权...............................................................................................................121 实验 #9 授予和撤销用户的权限........................................................................................122 第 11章 – 备份和恢复...........................................................................................................125 11.1 数据库的日志记录....................................................................................................125 11.2 日志的类型...............................................................................................................126 11.3 日志记录的类型.......................................................................................................126 11.3.1 循环日志记录 ....................................................................................................126 11.3.2 档案日志记录和日志保留...................................................................................127 11.4 从控制中心进行数据库日志记录...............................................................................127 11.5 日志记录的参数........................................................................................................129 11.6 数据库备份...............................................................................................................129 实验 #10 – 安排一个备份计划..........................................................................................131 11.7 数据库恢复...............................................................................................................133 11.7.1 恢复类型............................................................................................................133 11.7.2 数据库恢复........................................................................................................133 11.8 其他关于备份和恢复的操作......................................................................................134 第 12章 – 维护任务...............................................................................................................135 12.1 重组(REORG)、运行统计(RUNSTATS)、重绑定(REBIND).......................135 12.1.1重组(REORG)命令........................................................................................135 12.1.2运行统计(RUNSTATS)命令 ..........................................................................136 12.1.3 绑定/重新绑定.................................................................................................136 12.1.4 在控制中心执行维护工作...................................................................................137 12.2 维护方式...................................................................................................................139 实验#11 – 配置自动维护.................................................................................................141 第 13章 – 并行与锁定...........................................................................................................143 13.1 事务(Transactions)..............................................................................................143 13.2 并行(Concurrency) ..............................................................................................143 13.3无并行控制导致的问题 .............................................................................................144 13.3.1丢失更新(Lost update)..................................................................................145 13.3.2未落实的读(Uncommitted read)....................................................................145 13.3.3不可重复读(Non-repeatable read).................................................................146 13.3.4幻象(Phantom read)......................................................................................146 13.4隔离级别(Isolation Levels)...................................................................................147 13.4.1未落实的读........................................................................................................147 13.4.2游标稳定性........................................................................................................147 13.4.3读稳定性............................................................................................................148 13.4.4可重复读............................................................................................................148 13.4.5隔离级别对比.....................................................................................................148 13.4.6设定隔离级别.....................................................................................................149 13.5锁定升级...................................................................................................................150 13.6锁定监视...................................................................................................................151 13.7锁定等待...................................................................................................................151 13.8死锁的引发与侦测.....................................................................................................152 13.9并行与锁定的最佳实践:..........................................................................................153 PART III –
DB2
Express-C应用程序开发............................................................................155 第 14章 –
SQL
PL 存储过程..................................................................................................157 14.1 IBM数据工作室(Data Studio)..............................................................................158 14.1.2在Data Studio中创建一个存储过程..................................................................159 14.2
SQL
PL 存储过程基础..............................................................................................161 14.2.1存储过程的结构.................................................................................................161 14.2.2 可选的存储过程属性..........................................................................................162 14.2.3参数...................................................................................................................162 14.2.4
SQL
PL存储过程中的注释................................................................................163 14.2.5 复合语句............................................................................................................163 14.2.6 变量声明............................................................................................................163 14.2.7 赋值语句............................................................................................................164 14.3 游标..........................................................................................................................164 14.4 流控制......................................................................................................................164 14.5 调用存储过程 ...........................................................................................................165 14.6 错误和情况处理器....................................................................................................166 14.7 动态
SQL
..................................................................................................................168 第 15章 – 直接插入
SQL
过程语言、触发器、用户定义函数(UDF)..................................169 15.1直接插入
SQL
PL .....................................................................................................169 15.2 触发器(Trigger)....................................................................................................170 15.2.1 触发器的类型 ....................................................................................................170 实验 #12 从控制中心创建一个触发器...............................................................................174 15.3 用户定义函数 (UDF).................................................................................................177 15.3.1 标量函数(Scalar function).............................................................................177 15.3.2 表函数(Table function)..................................................................................178 实验 #13 使用IBM Data Studio创建用户定义函数(UDF)............................................179 第 16章 –
DB2
pureXML......................................................................................................181 16.1 在数据库中使用XML................................................................................................181 16.2 XML数据库..............................................................................................................182 16.2.1 启用 XML的数据库............................................................................................182 16.2.2 原生 XML数据库...............................................................................................182 16.3
DB2
中的XML..........................................................................................................183 16.3.1 pureXML 技术优势............................................................................................184 16.3.2 XPath基础........................................................................................................185 16.3.3 XQuery的定义..................................................................................................188 16.3.4 插入 XML文档...................................................................................................189 16.3.5 查询 XML数据...................................................................................................191 16.3.6 使用
SQL
/XML执行联合操作............................................................................196 16.3.7 使用 XQuery执行联合操作................................................................................196 16.3.8 更新与删除操作.................................................................................................197 16.3.9 XML 索引.........................................................................................................198 实验 #14 -
SQL
/XML 和 XQuery.......................................................................................200 第 17章 – 使用 Java、PHP和 Ruby进行数据库应用开发...................................................201 17.1 Java应用程序开发...................................................................................................201 17.1.1 JDBC类型 2驱动程序.......................................................................................201 17.1.2 JDBC类型 4驱动程序.......................................................................................202 17.2 PHP应用程序开发...................................................................................................203 17.2.1
DB2
为PHP提供的连接选项.............................................................................203 17.2.2 Zend Core for IBM.............................................................................................204 17.3 Ruby on Rails应用程序开发.....................................................................................206 17.3.1 Startup Toolkit for
DB2
on Rails ........................................................................206 附录 A — 排除故障...............................................................................................................207 A.1 查找错误代码的更多信息...........................................................................................207 A.2
SQL
CODE与
SQL
STATE .........................................................................................208 A.3
DB2
管理通知日志.....................................................................................................208 A.4
db2
diag.log................................................................................................................209 A.5 CLI追踪.....................................................................................................................209 A.6
DB2
缺陷与补丁.........................................................................................................209 参考资源 ...............................................................................................................................210 网站..................................................................................................................................210 书籍..................................................................................................................................211
DB2
-730
中文
教材--适合数据库开发人员以及对数据库有兴趣的人
• 第 1 部分:
DB2
规划 本教程介绍
DB2
9 产品和工具的基本知识,以及描述不同类型的数据应用程序、数据仓库和 OLAP 的概念。 • 第 2 部分:安全性 本教程介绍与
DB2
9 相关的身份验证、授权和特权概念。您应该具备数据库概念和操作系统安全性的基本知识。 • 第 3 部分:访问
DB2
数据 本教程讲解组成
DB2
数据库的对象,以及影响创建数据库的方式的不同因素。在简要介绍
DB2
对象之后,我们将研究用来创建、访问和操作
DB2
对象的不同工具。 • 第 4 部分:处理
DB2
数据 本教程讲解结构化查询语言(Structured Query Language,
SQL
),
帮助
您理解
DB2
9 如何使用
SQL
操纵关系数据库中的数据。 • 第 5 部分:处理
DB2
对象 学习能
帮助
您适当管理
DB2
数据库服务器的技巧。 • 第 6 部分:数据并发性 本教程讲解数据一致性的概念以及
DB2
在单用户和多用户环境中用来维护一致性的各种机制。 • 第 7 部分:XQuery 简介 本教程将解释几个基本的 XQuery 概念,并讲解如何编写处理
DB2
XML 数据的简单 XQuery。
DB2
5,889
社区成员
11,654
社区内容
发帖
与我相关
我的任务
DB2
IBM DB2 是美国IBM公司开发的一套关系型数据库管理系统,它主要的运行环境为UNIX(包括IBM自家的AIX)、Linux、IBM i(旧称OS/400)、z/OS,以及Windows服务器版本
复制链接
扫一扫
分享
社区描述
IBM DB2 是美国IBM公司开发的一套关系型数据库管理系统,它主要的运行环境为UNIX(包括IBM自家的AIX)、Linux、IBM i(旧称OS/400)、z/OS,以及Windows服务器版本
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章