1、 IBM软件部OCB. 2006 2006 IBM 公司 Confidentiality/date line: 13pt Arial Regular, whiteMaximum length: 1 line Information separated by vertical strokes,with two spaces on either side Disclaimer information may also be appear in this area. Place flush left, aligned at bottom, 8-10pt Arial Regular, white IB
2、M logo must not be moved, added to, or altered in any way. Indications in green = Live content Indications in white = Edit in masterIndications in blue = Locked elementsIndications in black = Optional elements Presentation title:28pt Arial Regular, blackRecommended maximum length: 2 lines Group name
3、:17pt Arial Regular, whiteMaximum length: 1 line Copyright: 10pt ArialRegular, whiteTemplate release: Oct 02For the latest, go to http:/ client presentations, clients logo may go in this areaDB2开发基础介绍IBM 软件部 | DB2 信息管理软件 2006 IBM公司 IBM logo must not be moved, added to, or altered inany way. Backgrou
4、nd shouldnot be modified. Title/subtitle/confidentiality line: 10pt Arial Regular, whiteMaximum length: 1 lineInformation separated by vertical strokes,with two spaces on either side Slide heading:28pt Arial Regular, blue R120 | G137 | B251 Maximum length: 2 lines Slide body:18pt Arial Regular, blac
5、kSquare bullet color:teal R045 | G182 | B179Recommended maximum text length: 5 principal points Group name:14pt Arial Regular, whiteMaximum length: 1 line Copyright: 10pt ArialRegular, whiteOptional slide number: 10pt Arial Bold, whiteTemplate release: Oct 02For the latest, go to http:/ in green = L
6、ive content Indications in white = Edit in masterIndications in blue = Locked elementsIndications in black = Optional elements议程 访问工具 客户端和 DB2数据库的连接方式 DB2中的数据类型 DB2中独有的一些 SQL语句语法 如何写存储过程？ 在 DB2 9版本中如何用开发工作台写存储过程？ 如何写触发器？IBM 软件部 | DB2 信息管理软件 2006 IBM公司 IBM logo must not be moved, added to, or altered
7、 inany way. Background shouldnot be modified. Title/subtitle/confidentiality line: 10pt Arial Regular, whiteMaximum length: 1 lineInformation separated by vertical strokes,with two spaces on either side Slide heading:28pt Arial Regular, blue R120 | G137 | B251 Maximum length: 2 lines Slide body:18pt
8、 Arial Regular, blackSquare bullet color:teal R045 | G182 | B179Recommended maximum text length: 5 principal points Group name:14pt Arial Regular, whiteMaximum length: 1 line Copyright: 10pt ArialRegular, whiteOptional slide number: 10pt Arial Bold, whiteTemplate release: Oct 02For the latest, go to
9、 http:/ in green = Live content Indications in white = Edit in masterIndications in blue = Locked elementsIndications in black = Optional elements访问工具 db2命令行处理器 (db2clp) 控制中心 命令编辑器 复制中心 配置助手 信息中心 第三方的访问工具IBM 软件部 | DB2 信息管理软件 2006 IBM公司 IBM logo must not be moved, added to, or altered inany way. Back
10、ground shouldnot be modified. Title/subtitle/confidentiality line: 10pt Arial Regular, whiteMaximum length: 1 lineInformation separated by vertical strokes,with two spaces on either side Slide heading:28pt Arial Regular, blue R120 | G137 | B251 Maximum length: 2 lines Slide body:18pt Arial Regular,
11、blackSquare bullet color:teal R045 | G182 | B179Recommended maximum text length: 5 principal points Group name:14pt Arial Regular, whiteMaximum length: 1 line Copyright: 10pt ArialRegular, whiteOptional slide number: 10pt Arial Bold, whiteTemplate release: Oct 02For the latest, go to http:/ in green
12、 = Live content Indications in white = Edit in masterIndications in blue = Locked elementsIndications in black = Optional elementsdb2命令行处理器 (db2clp)有 2种运行方式：(1)类似于操作系统命令，如下图：(2)在 db2提示符下执行 SQL命令IBM 软件部 | DB2 信息管理软件 2006 IBM公司 IBM logo must not be moved, added to, or altered inany way. Background sho
13、uldnot be modified. Title/subtitle/confidentiality line: 10pt Arial Regular, whiteMaximum length: 1 lineInformation separated by vertical strokes,with two spaces on either side Slide heading:28pt Arial Regular, blue R120 | G137 | B251 Maximum length: 2 lines Slide body:18pt Arial Regular, blackSquar
14、e bullet color:teal R045 | G182 | B179Recommended maximum text length: 5 principal points Group name:14pt Arial Regular, whiteMaximum length: 1 line Copyright: 10pt ArialRegular, whiteOptional slide number: 10pt Arial Bold, whiteTemplate release: Oct 02For the latest, go to http:/ in green = Live co
15、ntent Indications in white = Edit in masterIndications in blue = Locked elementsIndications in black = Optional elementsdb2命令行处理器 (db2clp) - 在 db2提示符下执行 SQL命令(1)首先在操作系统提示符下执行 db2命令，会出现 db2提示符 db2 =(2)输入你想执行的任何 SQL语句IBM 软件部 | DB2 信息管理软件 2006 IBM公司 IBM logo must not be moved, added to, or altered inan
16、y way. Background shouldnot be modified. Title/subtitle/confidentiality line: 10pt Arial Regular, whiteMaximum length: 1 lineInformation separated by vertical strokes,with two spaces on either side Slide heading:28pt Arial Regular, blue R120 | G137 | B251 Maximum length: 2 lines Slide body:18pt Aria
17、l Regular, blackSquare bullet color:teal R045 | G182 | B179Recommended maximum text length: 5 principal points Group name:14pt Arial Regular, whiteMaximum length: 1 line Copyright: 10pt ArialRegular, whiteOptional slide number: 10pt Arial Bold, whiteTemplate release: Oct 02For the latest, go to http
18、:/ in green = Live content Indications in white = Edit in masterIndications in blue = Locked elementsIndications in black = Optional elements控制中心 初学者常用的工具，可以通过 show sql按钮告诉你 db2语句的语法 功能强大的管理工具 修改数据库参数 创建数据库及存放其中的对象 管理分区的策略 创建联邦的数据库对象 备份恢复IBM 软件部 | DB2 信息管理软件 2006 IBM公司 IBM logo must not be moved, ad
19、ded to, or altered inany way. Background shouldnot be modified. Title/subtitle/confidentiality line: 10pt Arial Regular, whiteMaximum length: 1 lineInformation separated by vertical strokes,with two spaces on either side Slide heading:28pt Arial Regular, blue R120 | G137 | B251 Maximum length: 2 lin
20、es Slide body:18pt Arial Regular, blackSquare bullet color:teal R045 | G182 | B179Recommended maximum text length: 5 principal points Group name:14pt Arial Regular, whiteMaximum length: 1 line Copyright: 10pt ArialRegular, whiteOptional slide number: 10pt Arial Bold, whiteTemplate release: Oct 02For
21、 the latest, go to http:/ in green = Live content Indications in white = Edit in masterIndications in blue = Locked elementsIndications in black = Optional elements控制中心界面IBM 软件部 | DB2 信息管理软件 2006 IBM公司 IBM logo must not be moved, added to, or altered inany way. Background shouldnot be modified. Titl
22、e/subtitle/confidentiality line: 10pt Arial Regular, whiteMaximum length: 1 lineInformation separated by vertical strokes,with two spaces on either side Slide heading:28pt Arial Regular, blue R120 | G137 | B251 Maximum length: 2 lines Slide body:18pt Arial Regular, blackSquare bullet color:teal R045
23、 | G182 | B179Recommended maximum text length: 5 principal points Group name:14pt Arial Regular, whiteMaximum length: 1 line Copyright: 10pt ArialRegular, whiteOptional slide number: 10pt Arial Bold, whiteTemplate release: Oct 02For the latest, go to http:/ in green = Live content Indications in whi
24、te = Edit in masterIndications in blue = Locked elementsIndications in black = Optional elements命令编辑器执行 sql命令，察看执行计划IBM 软件部 | DB2 信息管理软件 2006 IBM公司 IBM logo must not be moved, added to, or altered inany way. Background shouldnot be modified. Title/subtitle/confidentiality line: 10pt Arial Regular, w
25、hiteMaximum length: 1 lineInformation separated by vertical strokes,with two spaces on either side Slide heading:28pt Arial Regular, blue R120 | G137 | B251 Maximum length: 2 lines Slide body:18pt Arial Regular, blackSquare bullet color:teal R045 | G182 | B179Recommended maximum text length: 5 princ
26、ipal points Group name:14pt Arial Regular, whiteMaximum length: 1 line Copyright: 10pt ArialRegular, whiteOptional slide number: 10pt Arial Bold, whiteTemplate release: Oct 02For the latest, go to http:/ in green = Live content Indications in white = Edit in masterIndications in blue = Locked elemen
27、tsIndications in black = Optional elements复制中心 配置 SQL复制，异构数据源之间的复制 Q复制，通过 Websphere MQ队列进行复制 复制进程的启动和停止 复制情况的监控配置和管理复制的图形化界面IBM 软件部 | DB2 信息管理软件 2006 IBM公司 IBM logo must not be moved, added to, or altered inany way. Background shouldnot be modified. Title/subtitle/confidentiality line: 10pt Arial Re
28、gular, whiteMaximum length: 1 lineInformation separated by vertical strokes,with two spaces on either side Slide heading:28pt Arial Regular, blue R120 | G137 | B251 Maximum length: 2 lines Slide body:18pt Arial Regular, blackSquare bullet color:teal R045 | G182 | B179Recommended maximum text length:
29、 5 principal points Group name:14pt Arial Regular, whiteMaximum length: 1 line Copyright: 10pt ArialRegular, whiteOptional slide number: 10pt Arial Bold, whiteTemplate release: Oct 02For the latest, go to http:/ in green = Live content Indications in white = Edit in masterIndications in blue = Locked elementsIndications in black = Optional elements复制中心界面
