- db2数据库入门教程（官方中文版）
DB2大小：4MBPART 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 db2move 工具...........................................................................................................108 9.5 db2look 工具..............................................................................................................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 SQLCODE与SQLSTATE .........................................................................................208 A.3 DB2 管理通知日志.....................................................................................................208 A.4 db2diag.log................................................................................................................209 A.5 CLI追踪.....................................................................................................................209 A.6 DB2缺陷与补丁.........................................................................................................209 参考资源 ...............................................................................................................................210 网站..................................................................................................................................210 书籍..................................................................................................................................211PART 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 db2move 工具...........................................................................................................108 9.5 db2look 工具..............................................................................................................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 SQLCODE与SQLSTATE .........................................................................................208 A.3 DB2 管理通知日志.....................................................................................................208 A.4 db2diag.log................................................................................................................209 A.5 CLI追踪.....................................................................................................................209 A.6 DB2缺陷与补丁.........................................................................................................209 参考资源 ...............................................................................................................................210 网站..................................................................................................................................210 书籍..................................................................................................................................211
5 2433浏览会员免费 - DB2数据库odbc驱动
db2驱动大小：87MBDB2数据库的odbc驱动，安装后即可通过odbc配置连接db2数据库DB2数据库的odbc驱动，安装后即可通过odbc配置连接db2数据库 5 1283浏览会员免费 - 阮若夷（Redis深入浅出）
Redis的主要缺点是数据库容量受到物理内存的限制，不能用作海量数据的高性能读写，并且它没有原生的可扩展机制，不具有scale（可扩展）能力，要依赖客户端来实现分布式读写，因此Redis适合的场景主要局限在较小数据量的高性能操作和运算上 5 315浏览会员免费 - JDBC连接DB2驱动包（公司授权正版驱动） JDBC大小：3MB这个是购买的IBM正版DB2数据库中的驱动包，无限制连接，希望能对大家有帮助，其中包括： db2jcc.jar db2jcc_license_cu这个是购买的IBM正版DB2数据库中的驱动包，无限制连接，希望能对大家有帮助，其中包括： db2jcc.jar db2jcc_license_cu 5 351浏览会员免费
- DB(数据库查看器) DB数据库查看器大小：443KBDB数据库查看器 可查询paradox及dbf数据库文件内容。DB数据库查看器 可查询paradox及dbf数据库文件内容。 3 2469浏览会员免费
- DB2数据库入门（3个PDF文件） DB2数据库入门大小：12MB从资料用来帮助新接触DB2数据库的朋友快速入门，包括DB2数据仓库的配置、商业智能的应用等内容从资料用来帮助新接触DB2数据库的朋友快速入门，包括DB2数据仓库的配置、商业智能的应用等内容 5 329浏览会员免费
- DB数据库文件查看器 数据库大小：454KB绿色 小巧 的DB数据库文件查看器，可以查看和修改DB文件。绿色 小巧 的DB数据库文件查看器，可以查看和修改DB文件。 3 1918浏览会员免费
- Quest central for DB2 注册机 DB2大小：235KBQuest central for DB2 v4.8.1 的注册机,破解软件后请做个人学习使用Quest central for DB2 v4.8.1 的注册机,破解软件后请做个人学习使用 5 176浏览会员免费
- ToadforDB2_Freeware_6.1.0.125.zip
ToadforDB2大小：79MBToadforDB2_Freeware_6.1.0.125.zip，第三方管理DB2的图形界面工具ToadforDB2_Freeware_6.1.0.125.zip，第三方管理DB2的图形界面工具 5 558浏览会员免费 - IBM.Data.DB2.dll
IBM大小：800KBIBM DB2 DLL,.net 下连接访问DB2的DLL，由IBM提供IBM DB2 DLL,.net 下连接访问DB2的DLL，由IBM提供 4 358浏览会员免费 - DB2 9.7企业版 license DB2大小：998B用于DB2 9.7 企业的证书，通过db2licm注册后即可免除过期烦恼！用于DB2 9.7 企业的证书，通过db2licm注册后即可免除过期烦恼！ 4 267浏览会员免费
- 数据库系统实现 access大小：15MB数据库系统实现!!!数据库系统实现!!! 5 125浏览免费
- Quest.Central.for.DB2 4.8 Quest.Central.for.DB2大小：35MBDB2 客户端连接工具，很好用，不信下载下来试试哦DB2 客户端连接工具，很好用，不信下载下来试试哦 5 121浏览会员免费
- java连接DB2数据库编程简介 java连接DB2数据库编程简介大小：2MBjava连接DB2数据库编程简介，包括基本的连接方法和实例java连接DB2数据库编程简介，包括基本的连接方法和实例 4 169浏览会员免费
- Toad-for-DB2通用license直接放入安装目录即生效 toad大小：42BToad for DB2的激活文件，只需将key文件拷贝至安装目录下，重启DB2后，所有功能都会开放！版本不限Toad for DB2的激活文件，只需将key文件拷贝至安装目录下，重启DB2后，所有功能都会开放！版本不限 5 1083浏览会员免费
- Altium designer常用封装 Altium，常用封装，封装库，protel大小：572KB二极管:1N5404,1n5822,WYAK,1N,DIODE*.("*"为通配符); 三极管:npn(PNP也用这个封装); 电阻:AXIAL*; 键盘,鼠标ps2:ps2; 串口系列:DB9*,DB25*; 74系列用dip封装:dip*; led:led*; 晶振:JZ*; USB:usb*; 开关:SW*; 单列直插式:sip*; 非极性电容:RAD*; 极性电容:dr*; LM的稳压器件:7805,LM78*; 排线:IDE*; 滑动变电阻器(电位器):HZ; 发光二极管:FG*; 电源:DY* 整流:ZL*; 电感:DG; can接头:CAN*; 蜂鸣器:FM; 电池:DC*;二极管:1N5404,1n5822,WYAK,1N,DIODE*.("*"为通配符); 三极管:npn(PNP也用这个封装); 电阻:AXIAL*; 键盘,鼠标ps2:ps2; 串口系列:DB9*,DB25*; 74系列用dip封装:dip*; led:led*; 晶振:JZ*; USB:usb*; 开关:SW*; 单列直插式:sip*; 非极性电容:RAD*; 极性电容:dr*; LM的稳压器件:7805,LM78*; 排线:IDE*; 滑动变电阻器(电位器):HZ; 发光二极管:FG*; 电源:DY* 整流:ZL*; 电感:DG; can接头:CAN*; 蜂鸣器:FM; 电池:DC*; 4 642浏览会员免费
- DB2数据库调整数据库性能
DB2数据库调整数据库性能，DB2数据库调整数据库性能 5 113浏览会员免费 - db2中文API
这是一个db2 的API 有需要的朋友可以下载，不需要积分的 5 369浏览会员免费 - DB2 服务器快速入门
DB2 服务器快速入门，包括服务器的基本配置和问题，新手推荐 5 121浏览会员免费 - db2 v9.7 license企业版用 db2ese_c.lic license大小：710Bdb2 v9.7 license企业版用 db2ese_c.lic 有需要的就下载吧db2 v9.7 license企业版用 db2ese_c.lic 有需要的就下载吧 4 594浏览会员免费
- db2基础 db2大小：10MB自己从网上整理的一些db2的基础知识，对自己有很大的帮助，也希望对大家有所帮助自己从网上整理的一些db2的基础知识，对自己有很大的帮助，也希望对大家有所帮助 4 137浏览免费
- db2数据库入门官方教程（中文版） db2数据库大小：4MB资源简介 第 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 db2move 工具...........................................................................................................108 9.5 db2look 工具..............................................................................................................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 SQLCODE与SQLSTATE .........................................................................................208 A.3 DB2 管理通知日志.....................................................................................................208 A.4 db2diag.log................................................................................................................209 A.5 CLI追踪.....................................................................................................................209 A.6 DB2缺陷与补丁.........................................................................................................209 参考资源 ...............................................................................................................................210 网站..................................................................................................................................210 书籍..................................................................................................................................211资源简介 第 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 db2move 工具...........................................................................................................108 9.5 db2look 工具..............................................................................................................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 SQLCODE与SQLSTATE .........................................................................................208 A.3 DB2 管理通知日志.....................................................................................................208 A.4 db2diag.log................................................................................................................209 A.5 CLI追踪.....................................................................................................................209 A.6 DB2缺陷与补丁.........................................................................................................209 参考资源 ...............................................................................................................................210 网站..................................................................................................................................210 书籍..................................................................................................................................211 5 993浏览会员免费
- DB2数据恢复及高可用性指南与参考
DB2数据恢复及高可用性指南与参考，DB2数据恢复及高可用性指南与参考 5 147浏览会员免费 - 杨志丰（OceanBase--淘宝结构化大数据解决之道）
淘宝数据库特点： 非常重要：几乎所有淘宝业务都依赖 数量多：以千计的数据库服务器 数据量大：单表几亿~几百亿条记录 访问量大：每天几亿~几百亿次访问 4 228浏览会员免费 - DB数据库编辑器(破解版)_3.1.6.54 DB数据库大小：2MBDB数据库编辑器(破解版)_3.1.6.54DB数据库编辑器(破解版)_3.1.6.54 4 7474浏览会员免费
- Db2教程 Db2教程大小：850KBDb2教程,我看过了，挺好的一个教程。Db2教程,我看过了，挺好的一个教程。 4 131浏览会员免费
- .net连接DB2数据库编程简介 .net连接DB2数据库编程简介大小：2MB.net连接DB2数据库编程简介，包括基本的连接方法和实例.net连接DB2数据库编程简介，包括基本的连接方法和实例 5 187浏览会员免费
- Setup-Subversion-1.8.9.msi svn大小：6MBSetup-Subversion-1.8.9.msi windows下服务器启动Setup-Subversion-1.8.9.msi windows下服务器启动 5 215浏览会员免费
- 杨栋（HCE助MapReduce提升资源利用率）
A MapReduce Frame work towards lmprove Resource Utilization 4 135浏览会员免费 - IBM DB2 DRIVER DB2驱动(64位) DB2大小：60MBIBM DB2 DRIVER DB2驱动 适用于WI32系统 安装及使用说明见 http://download.csdn.net/detail/kingty_x/5429753IBM DB2 DRIVER DB2驱动 适用于WI32系统 安装及使用说明见 http://download.csdn.net/detail/kingty_x/5429753 4 923浏览会员免费
- DB2 Connect 服务器快速入门
DB2 Connect 服务器快速入门,主要是关于服务的安装、配置和连接 5 116浏览会员免费 - JAVA的DB2驱动包
DB2驱动包大小：1MBjava连接DB2数据库的驱动包java连接DB2数据库的驱动包 5 128浏览会员免费 - 吴朱华（海量数据从'小'做起 中小企业Big Data解决之道）
海量数据从'小'做起——中小企业Big Data解决之道 4 161浏览会员免费 - DB2快速入门
在windows中如何运用DB2？此入门教程给了一个详细的说明。适合DB2初级用户学习 4 120浏览免费 - 丛磊（NoSQL在SAE中的应用）
新浪云计算SinaCloud.com 新浪及合作第三方支持：微游戏、微盘、校园微博、Q微博、互联网的那点事… 云计算产品研发：计算类服务、存储类服务、云应用商店、云服务商店、CDN… 4 71浏览会员免费 - db2学习资料 db2入门教程大小：19MB含DB2基础教程、db2自学资料、db2重点解析课件，能有效的帮助刚接触db2的童鞋快速入门，对应db2有更全面的了解及有助于初学者更深入的理解含DB2基础教程、db2自学资料、db2重点解析课件，能有效的帮助刚接触db2的童鞋快速入门，对应db2有更全面的了解及有助于初学者更深入的理解 5 138浏览会员免费
- db2aese_c_v10.1.lic db2大小：1010BProduct name: "DB2 Enterprise Server Edition" License type: "CPU Option" Expiry date: "Permanent" Product identifier: "db2aese" Version information: "10.1"Product name: "DB2 Enterprise Server Edition" License type: "CPU Option" Expiry date: "Permanent" Product identifier: "db2aese" Version information: "10.1" 5 433浏览会员免费
- Toad for DB2 4.7 Trial正式版+注册机+连接配置方式 Toad大小：86MBToad for DB2 4.7 Trial正式版+注册机+连接配置方式 toad_for_db2_keygen + Quest_central_for_DB2_v4.8.1 1,Toad For DB2 安装破解安装,连接使用方法.txt 2,连接配置.docx toad_for_db2_keygen + Quest_central_for_DB2_v4.8.1.rar ToadforDB2_Trial_4.7.0.556.exe Toad_InstallGuide.pdf Toad for DB2 4_7 - Release Notes.htmToad for DB2 4.7 Trial正式版+注册机+连接配置方式 toad_for_db2_keygen + Quest_central_for_DB2_v4.8.1 1,Toad For DB2 安装破解安装,连接使用方法.txt 2,连接配置.docx toad_for_db2_keygen + Quest_central_for_DB2_v4.8.1.rar ToadforDB2_Trial_4.7.0.556.exe Toad_InstallGuide.pdf Toad for DB2 4_7 - Release Notes.htm 4 251浏览会员免费
- 刘思喆（'R' You Ready？）
大数据时代下优雅、卓越的统计分析及绘图环境 4 83浏览免费 - db2ese_c.lic DB2 V9.7 license linux x86_64 b2ese_c.lic大小：998B破解前 emal:/opt/ibm/db2/V9.7/license # db2licm -l Product name: "DB2 Enterprise Server Edition" Expiry date: "Expired" Product identifier: "db2ese" Version information: "9.7" Enforcement policy: "Soft Stop" Product name: "DB2 Connect Server" Expiry date: "Expired" Product identifier: "db2consv" Version information: "9.7" Concurrent connect user policy: "Disabled" Enforcement policy: "Soft Stop" db2ese_c.lic拷贝到/opt/ibm/db2/V9.7/license下 emal:/opt/ibm/db2/V9.7/adm # db2licm -a ../license/db2ese_c.lic LIC1402I License added successfully. LIC1426I This product is now licensed for use as outlined in your License Agreement. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/opt/ibm/db2/V9.7/license/en_US.iso88591" 再用db2licm -l查看 貌似只破解了一部分，但是可以连数据库了 db2icomm@emal:~/Desktop> db2licm -l Product name: "DB2 Enterprise Server Edition" License type: "CPU Option" Expiry date: "Permanent" Product identifier: "db2ese" Version information: "9.7" Enforcement policy: "Soft Stop" Features: DB2 Performance Optimization ESE: "Not licensed" DB2 Storage Optimization: "Not licensed" DB2 Advanced Access Control: "Not licensed" IBM Homogeneous Replication ESE: "Not licensed" Product name: "DB2 Connect Server" Expiry date: "Expired" Product identifier: "db2consv" Version information: "9.7" Concurrent connect user policy: "Disabled" Enforcement policy: "Soft Stop"破解前 emal:/opt/ibm/db2/V9.7/license # db2licm -l Product name: "DB2 Enterprise Server Edition" Expiry date: "Expired" Product identifier: "db2ese" Version information: "9.7" Enforcement policy: "Soft Stop" Product name: "DB2 Connect Server" Expiry date: "Expired" Product identifier: "db2consv" Version information: "9.7" Concurrent connect user policy: "Disabled" Enforcement policy: "Soft Stop" db2ese_c.lic拷贝到/opt/ibm/db2/V9.7/license下 emal:/opt/ibm/db2/V9.7/adm # db2licm -a ../license/db2ese_c.lic LIC1402I License added successfully. LIC1426I This product is now licensed for use as outlined in your License Agreement. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/opt/ibm/db2/V9.7/license/en_US.iso88591" 再用db2licm -l查看 貌似只破解了一部分，但是可以连数据库了 db2icomm@emal:~/Desktop> db2licm -l Product name: "DB2 Enterprise Server Edition" License type: "CPU Option" Expiry date: "Permanent" Product identifier: "db2ese" Version information: "9.7" Enforcement policy: "Soft Stop" Features: DB2 Performance Optimization ESE: "Not licensed" DB2 Storage Optimization: "Not licensed" DB2 Advanced Access Control: "Not licensed" IBM Homogeneous Replication ESE: "Not licensed" Product name: "DB2 Connect Server" Expiry date: "Expired" Product identifier: "db2consv" Version information: "9.7" Concurrent connect user policy: "Disabled" Enforcement policy: "Soft Stop" 5 451浏览会员免费
- DB2函数大全 DB2大小：9KBDB2常用函数介绍，比较实用。DB2常用函数介绍，比较实用。 4 142浏览会员免费
- db2jcc.jar、db2jcc_javax.jar db2jcc.jar、db2jcc_javax.jar大小：1MB这是连接DB2的TYPE4所需要的驱动包，二合一，db2jcc.jar是驱动包，db2jcc_javax.jar是提供的许可证，如果没有的话，会出现异常：No license is present. 初学DB2时废了不少功夫找这两个包，现在免分下载，希望大家少走弯路。这是连接DB2的TYPE4所需要的驱动包，二合一，db2jcc.jar是驱动包，db2jcc_javax.jar是提供的许可证，如果没有的话，会出现异常：No license is present. 初学DB2时废了不少功夫找这两个包，现在免分下载，希望大家少走弯路。 5 331浏览免费
- Aqua Data Studio 12..0.X.破解补丁.zip Aqua大小：18MBAqua Data Studio 12.0.12 附带软件下载连接： http://pan.baidu.com/s/1dDpCbapAqua Data Studio 12.0.12 附带软件下载连接： http://pan.baidu.com/s/1dDpCbap 5 128浏览会员免费
- Toad_for_DB2_使用指南
Toad for DB2 使用指南，介绍了Toad for DB2的使用和注意事项。 5 995浏览会员免费 - 随机信号分析与处理--罗鹏飞等著.pdf
随机信号分析与处理--罗鹏飞等著.pdf 4 2581浏览会员免费 - DB2客户端工具 DB2,SqlDbx,WINSQL,Tord大小：1MBDB2自带的开发工具虽然很全也很强大,但是用起来不是很方便。SqlDbx这款客户端查询以及数据库开发工具虽然短小,但很强大。虽然不及Toad for db2的强大功能,SqlDbx的常用功能一点都不输,且文件大小才1.2M(当然前提是按照了DB2客户端).此工具的犀利程度不输与ORACLE前端工具PL SQL。DB2自带的开发工具虽然很全也很强大,但是用起来不是很方便。SqlDbx这款客户端查询以及数据库开发工具虽然短小,但很强大。虽然不及Toad for db2的强大功能,SqlDbx的常用功能一点都不输,且文件大小才1.2M(当然前提是按照了DB2客户端).此工具的犀利程度不输与ORACLE前端工具PL SQL。 4 894浏览会员免费
- Toad for DB2 4.7 Trial正式版+注册机+总结连接配置方式.part1 Toad大小：14MB弄了一个星期终于把toad for db2 运行起来了 把资源上传上来与大家分享 奈何只能分割成小于15M的 大家忍忍吧 连接配置方式.excel文件中是我的toad链接配置方式 比Aqua Data Studio 和ibm_data_studio_standalon好用多了 不是一个档次 很全 放心用吧弄了一个星期终于把toad for db2 运行起来了 把资源上传上来与大家分享 奈何只能分割成小于15M的 大家忍忍吧 连接配置方式.excel文件中是我的toad链接配置方式 比Aqua Data Studio 和ibm_data_studio_standalon好用多了 不是一个档次 很全 放心用吧 3 159浏览会员免费
- db2 v9.5 企业版 License db2大小：2KBdb2 v9.5 企业版 License,CPU选项的，好东东。大家用快点下。 看下面信息是否是真的了。 $ db2licm -l Product name: "DB2 Enterprise Server Edition" License type: "CPU 选项" Expiry date: "永久" Product identifier: "db2ese" Version information: "9.5" Enforcement policy: "软停止" Features: DB2 Database Partitioning: "未许可" DB2 Performance Optimization ESE: "未许可" DB2 Storage Optimization: "未许可" DB2 Advanced Access Control: "未许可" DB2 Geodetic Data Management: "未许可" IBM Homogeneous Replication ESE: "未许可" Product name: "DB2 Connect Server" License type: "试用" Expiry date: "04/12/2010" Product identifier: "db2consv" Version information: "9.5"db2 v9.5 企业版 License,CPU选项的，好东东。大家用快点下。 看下面信息是否是真的了。 $ db2licm -l Product name: "DB2 Enterprise Server Edition" License type: "CPU 选项" Expiry date: "永久" Product identifier: "db2ese" Version information: "9.5" Enforcement policy: "软停止" Features: DB2 Database Partitioning: "未许可" DB2 Performance Optimization ESE: "未许可" DB2 Storage Optimization: "未许可" DB2 Advanced Access Control: "未许可" DB2 Geodetic Data Management: "未许可" IBM Homogeneous Replication ESE: "未许可" Product name: "DB2 Connect Server" License type: "试用" Expiry date: "04/12/2010" Product identifier: "db2consv" Version information: "9.5" 5 195浏览会员免费
- DB2客户端,客户端访问DB2服务器工具 DB2,db2客户端大小：25MB客户端电脑访问DB2数据库时安装,维护常用工具。不带开发中心的DB2客户端程序。客户端电脑访问DB2数据库时安装,维护常用工具。不带开发中心的DB2客户端程序。 4 244浏览会员免费
- DB2基础教程
DB2基础教程..... 5 138浏览会员免费 - DB2的JDBC驱动包 JDBC大小：3MB链接DB2数据库的时候采用的JDBC驱动包链接DB2数据库的时候采用的JDBC驱动包 5 1020浏览会员免费
- db2java.jar db2java.jar db2java.jar大小：1MBdb2java.jar db2java.jar db2java.jar db2java.jardb2java.jar db2java.jar db2java.jar db2java.jar 5 184浏览会员免费
- Toad for DB2 4.7 Trial正式版+注册机+连接配置方式.part6.rar Toad大小：14MB弄了一个星期终于把toad for db2 运行起来了 把资源上传上来与大家分享 奈何只能分割成小于15M的 大家忍忍吧 连接配置方式.excel文件中是我的toad链接配置方式 比Aqua Data Studio 和ibm_data_studio_standalon好用多了 不是一个档次 很全 放心用吧弄了一个星期终于把toad for db2 运行起来了 把资源上传上来与大家分享 奈何只能分割成小于15M的 大家忍忍吧 连接配置方式.excel文件中是我的toad链接配置方式 比Aqua Data Studio 和ibm_data_studio_standalon好用多了 不是一个档次 很全 放心用吧 4 85浏览会员免费
- Toad for DB2 4.7 Trial正式版+注册机+连接配置方式.part5.rar Toad大小：14MB弄了一个星期终于把toad for db2 运行起来了 把资源上传上来与大家分享 奈何只能分割成小于15M的 大家忍忍吧 连接配置方式.excel文件中是我的toad链接配置方式 比Aqua Data Studio 和ibm_data_studio_standalon好用多了 不是一个档次 很全 放心用吧弄了一个星期终于把toad for db2 运行起来了 把资源上传上来与大家分享 奈何只能分割成小于15M的 大家忍忍吧 连接配置方式.excel文件中是我的toad链接配置方式 比Aqua Data Studio 和ibm_data_studio_standalon好用多了 不是一个档次 很全 放心用吧 4 75浏览会员免费
- 丹麦发烧级音乐播放器BeoPlayer绿色版 丹麦发烧级音乐播放器BeoPlayer绿色版大小：13MB丹麦是一个有着迷人风景的北欧小国。与独有的迷人风景一样，丹麦有着全球顶级扬声器生产厂商BANG & OLUFSEN（简称B&O)，Beoplayer正是出自Bang & Olufsen之手。Bang & Olufsen是丹麦的一家全球顶级数字产品设备提供商，美奂美仑与独特高贵是他们的产品设计理念，因此其产品一直受到了很多地球人的追捧和崇拜，而Beoplayer被音乐发烧友称为“音质最好的播放器”——据说其声音效果超过大名鼎鼎的Foobar2000。 编辑本段软件特点 Bang&Olufsen公司出品,界面外形超酷。并且,播放效果较好,对音质有一定的提升作用。放mp3时可以把很多爆音和杂音都修饰掉,可以负责的说,Beoplayer可以不用借助硬件设备来提高mp3的听觉效果。 Beoplayer 是一套好有特色的“播放音乐”及“下载音乐”软件，当你首次安装程序完成后，“ Beoplayer”就会为你自动搜寻计算机内的数码音乐，然后再列出详细清单，方便你可以随时下载及播放音乐。 更可对应 CDDB2功能，自动更新数码音乐的歌手及曲目名称等资料，然后“ Beoplayer”就会自动同你用歌手、曲目及文件名称等作顺序排列整理，绝对是音乐管理软件好帮手。下载音乐方法非常简单，只要用鼠标将音乐拖至 BeoSound 2播放曲目，再 Download 就完成整个程序。果然够 High！ BeoPlayer 的配色是以黑色为底，搭配白色、灰色的文字，及少部分画龙点睛的红色组合而成。视窗也打破一般传统的观念，执行时只在系统列有一图示，当滑鼠游标移动到桌面右侧边缘时，会出现一个黑色的小三角型，在小三角型点一下滑鼠会滑出 BeoPlayer 的控制面板，面板里包括主要的控制功能，像是播放、音量、设定等，当游标移开面板时，面板又会自动收回，支援音乐 CD、MP3、WMA 等主要音乐格式，亦可以将音乐 CD 转录到硬碟上。 从4.80版开始支持vista sp1,xp sp2,4.81版开始支持xp sp3，如今的5.03版本已经能够完美兼容VISTA与Win7。 BeoPlayer唯一的美中不足是暂不支持歌词显示，期待Bang&Olufsen能稍作改进。丹麦是一个有着迷人风景的北欧小国。与独有的迷人风景一样，丹麦有着全球顶级扬声器生产厂商BANG & OLUFSEN（简称B&O)，Beoplayer正是出自Bang & Olufsen之手。Bang & Olufsen是丹麦的一家全球顶级数字产品设备提供商，美奂美仑与独特高贵是他们的产品设计理念，因此其产品一直受到了很多地球人的追捧和崇拜，而Beoplayer被音乐发烧友称为“音质最好的播放器”——据说其声音效果超过大名鼎鼎的Foobar2000。 编辑本段软件特点 Bang&Olufsen公司出品,界面外形超酷。并且,播放效果较好,对音质有一定的提升作用。放mp3时可以把很多爆音和杂音都修饰掉,可以负责的说,Beoplayer可以不用借助硬件设备来提高mp3的听觉效果。 Beoplayer 是一套好有特色的“播放音乐”及“下载音乐”软件，当你首次安装程序完成后，“ Beoplayer”就会为你自动搜寻计算机内的数码音乐，然后再列出详细清单，方便你可以随时下载及播放音乐。 更可对应 CDDB2功能，自动更新数码音乐的歌手及曲目名称等资料，然后“ Beoplayer”就会自动同你用歌手、曲目及文件名称等作顺序排列整理，绝对是音乐管理软件好帮手。下载音乐方法非常简单，只要用鼠标将音乐拖至 BeoSound 2播放曲目，再 Download 就完成整个程序。果然够 High！ BeoPlayer 的配色是以黑色为底，搭配白色、灰色的文字，及少部分画龙点睛的红色组合而成。视窗也打破一般传统的观念，执行时只在系统列有一图示，当滑鼠游标移动到桌面右侧边缘时，会出现一个黑色的小三角型，在小三角型点一下滑鼠会滑出 BeoPlayer 的控制面板，面板里包括主要的控制功能，像是播放、音量、设定等，当游标移开面板时，面板又会自动收回，支援音乐 CD、MP3、WMA 等主要音乐格式，亦可以将音乐 CD 转录到硬碟上。 从4.80版开始支持vista sp1,xp sp2,4.81版开始支持xp sp3，如今的5.03版本已经能够完美兼容VISTA与Win7。 BeoPlayer唯一的美中不足是暂不支持歌词显示，期待Bang&Olufsen能稍作改进。 4 473浏览会员免费
- Embarcadero.DBArtisan 8.5注册文件 注册文件大小：70KBEmbarcadero DBArtisan 是一款管理企业异质数据库，强化高可用性、效能与安全的管理工具!线上可使用度、高效能及安全性，是所有数据库管理员的共同期许，但要达到以上目标，不但需要随时提高警惕，各种临机应变的计画，还有一大堆繁重而琐碎的工作。幸而有了Embarcadero DBArtisan，解除了数据库管理员的桎梏。 藉着Embarcadero DBArtisan一目了然的图形化工具，使得费时而易出错的数据库管理工作成为过去式。DBArtisan是Oracle、 Sybase、Microsoft SQLServer、及IBM DB2 Universal Databases首选的数据库管理工具。其丰富的特色帮助专业的数据库管理员，将企业中数据库的利用性、效能、及安全性发挥到极致。DBArtisan 可让数据库管理员利用单一之图形介面管理多种数据库平台，大大提昇了专业数据库管理员的生产力。 DBArtisan将例行管理工作予以自动化及效率化，例如建立使用者帐号、更改物件，在发展环境、测试环境及正式环境中移转结构描述等。也因为 DBArtisan提供了几种主要数据库平台标准化的单一共通管理介面的解决方案，进而能够降低企业成本，提高总体生产力。<br><br>DBArtisan 主要特色:<br>1.空间管理<br>2.安全管理<br>3.效能管理<br>4.微调及效能整合<br>5.物件管理更为简单<br>6.排程作业<br>7.视觉化建立指令及编辑资料<br>8.移转资料结构描述<br>9.产生结构描述之网页文件<br>10.非侵入式安装<br>11.选择性安装除错及追踪工具模组Embarcadero DBArtisan 是一款管理企业异质数据库，强化高可用性、效能与安全的管理工具!线上可使用度、高效能及安全性，是所有数据库管理员的共同期许，但要达到以上目标，不但需要随时提高警惕，各种临机应变的计画，还有一大堆繁重而琐碎的工作。幸而有了Embarcadero DBArtisan，解除了数据库管理员的桎梏。 藉着Embarcadero DBArtisan一目了然的图形化工具，使得费时而易出错的数据库管理工作成为过去式。DBArtisan是Oracle、 Sybase、Microsoft SQLServer、及IBM DB2 Universal Databases首选的数据库管理工具。其丰富的特色帮助专业的数据库管理员，将企业中数据库的利用性、效能、及安全性发挥到极致。DBArtisan 可让数据库管理员利用单一之图形介面管理多种数据库平台，大大提昇了专业数据库管理员的生产力。 DBArtisan将例行管理工作予以自动化及效率化，例如建立使用者帐号、更改物件，在发展环境、测试环境及正式环境中移转结构描述等。也因为 DBArtisan提供了几种主要数据库平台标准化的单一共通管理介面的解决方案，进而能够降低企业成本，提高总体生产力。<br><br>DBArtisan 主要特色:<br>1.空间管理<br>2.安全管理<br>3.效能管理<br>4.微调及效能整合<br>5.物件管理更为简单<br>6.排程作业<br>7.视觉化建立指令及编辑资料<br>8.移转资料结构描述<br>9.产生结构描述之网页文件<br>10.非侵入式安装<br>11.选择性安装除错及追踪工具模组 5 138浏览会员免费
- db2jcc.jar DB2大小：1MBDB2数据库驱动db2jcc.jarDB2数据库驱动db2jcc.jar 5 56浏览会员免费
- 循序渐进DB2 (第2版)——DBA系统管理、运维与应用案例
DB2数据库是IBM公司关系型数据库核心产品，在国内以及全球有着广泛的应用。针对DB2初学者，循序渐进地把DB2涉及的众多概念和知识介绍给大家。客户端连通性、实例、数据库、表空间和缓冲池、数据移动、备份恢复、SQL基础知识、DB2基本监控方法、运行数据库必须考虑的设置、DBA日常维护以及数据库常用工具都是关注的重点。在介绍这些数据库对象和概念的同时，尽可能从DBA日常工作的角度探究DB2数据库常规维护工作。同时还就表、索引、序列、触发器等数据库对象从应用设计的角度进行了介绍。适合DB2的初学者、DB2开发人员、准备参加DB2认证考试的读者以及DB2数据库管理人员学习和阅读。 4 466浏览会员免费 - db2ppt db2大小：3MBdb2管理指导的入门教材db2管理指导的入门教材 0 63浏览会员免费
- DataStage IBM IBM大小：19MBIBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service. IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to: IBM Director of Licensing, IBM Corporation, North Castle Drive, Armonk, NY 10504-1785 U.S.A. The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you. This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice. Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk. IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you. Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products. This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental. COPYRIGHT LICENSE: This information contains sample application programs in source language, which illustrateIBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service. IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to: IBM Director of Licensing, IBM Corporation, North Castle Drive, Armonk, NY 10504-1785 U.S.A. The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you. This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice. Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk. IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you. Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products. This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental. COPYRIGHT LICENSE: This information contains sample application programs in source language, which illustrate 5 154浏览会员免费
CSDN会员
开通CSDN年卡参与万元壕礼抽奖
已订阅内容
我的课程
图文专栏
登录后即可查看
学习路径
七天热销榜 
下载资源
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
