DB2使用指南
DB2+v9.7安装指南
DB2 V9.7 安装说明1、DB2_ESE_97_Win_x86.exe拷贝到服务器上，双机运行：2、解压安装程序，选择解压的目录：3、在解压完毕的目录中，运行setup.exe：4、点击运行进入DB2安装启动板：5、选择安装产品选项，进入安装产品界面，选择安装新产品：等待。
等待…6、点击下一步：7、选择同意许可协议，点下一步继续：8、选择经典安装类型：9、创建响应文件，目录选择c盘外的其他盘目录：10、选择DB2安装目录，目录选择c盘以外的其他盘符目录，点击下一步继续：11、设置用户名和密码，统一username/password设置为db2admin/db2admin。
12、点击下一步继续：13、除掉“准备DB2工具目录”选项的勾，点下一步继续：14、除掉“设置DB2服务器已发送通知”选项的勾，点下一步继续：15、默认选择，点下一步继续：16、点完成继续：等待….17、点下一步继续：18、点完成退出：安装完毕。
数据库启动、停止、实例创建、数据恢复1、通过【开始】-【运行】打开DB2CMD2、创建实例之前，首先停止服务器，输入db2stop force 回车：3、再次启动服务，输入db2start 回车：4、创建数据库实例roeee（本实例是r1的系统所用实例），输入：db2 create dbroeee回车5、创建cpms实例（建管项目系统用实例），输入db2 create dbcpms回车：6、创建starflow实例，输入db2 create dbstarflow回车：7、数据库实例创建完毕后，重新停止服务，输入db2stop force 回车：8、再次启动服务，准备开始数据恢复，输入db2start 回车：9、找到存放数据库文件的目录：CPMS.0.DB2.NODE0000.CATN0000.20110716161740.001ROEEE.0.DB2.NODE0000.CATN0000.20110714221252.001STARFLOW.0.DB2.NODE0000.CATN0000.20110714221325.001以E盘中dbbak中的备份数据文件为例，演示如何找到相应目录：首先输入E: 回车，切换到E盘根目录下：通过输入dir回车查看E盘下的文件目录：找到dbbak目录，然后输入cd dbbak回车进入dbbak目录：通过输入dir回车查看dbbak目录下的文件：实际部署过程中需要找到自己存放以下3个文件的目录路径。
DB2手册
1前言 (8)2DB2专有名词解释 (8)2.1I NSTANCE(实例) (8)2.2DB2A DMINISTRA TION S ERVER(管理服务器) (8)2.3C ONTAINER(容器) (8)2.4DRDA (8)2.5DARI (8)2.6SPM (8)2.7FCM (8)2.8ADSM (8)2.9DCE (8)3DB2编程 (9)3.1建存储过程时C REATE 后一定不要用TAB键 (9)3.2使用临时表 (9)3.3从数据表中取指定前几条记录 (9)3.4游标的使用 (9)3.5类似DECODE的转码操作 (10)3.6类似CHARINDEX查找字符在字串中的位置 (10)3.7类似DATEDIF计算两个日期的相差天数 (11)3.8写UDF的例子 (11)3.9创建含IDENTITY值(即自动生成的ID)的表 (11)3.10预防字段空值的处理 (11)3.11取得处理的记录数 (11)3.12从存储过程返回结果集(游标)的用法 (11)3.13类型转换函数 (12)3.14存储过程的互相调用 (12)3.15C存储过程参数注意 (13)3.16存储过程FENCE及UNFENCE (13)3.17SP错误处理用法 (13)3.18V ALUES的使用 (13)3.19给SELECT 语句指定隔离级别 (14)3.20A TOMIC及NOT A TOMIC区别 (14)3.21C及SQL存储过程名称都要注意长度 (14)3.22怎样获得自己的数据库连接句柄 (14)3.23类似于ORACLE的N AME PIPE (14)3.24类似于ORACLE的TRUNCATE清表但不记日志的做法 (14)3.25用CLI编程批量的INSERT (14)4DB2一些不好的限制 (18)4.1临时表不能建索引 (18)4.2CURSOR不能定义为WITH UR(可以但...).. (18)4.3CURSOR ORDER BY以后不能FOR UPDATE (18)4.4程序中间不能自由改变隔离级别 (18)4.5UPDATE 不能用一个表中的记录为条件修改另一个表中的记录。
萤石 猫眼门铃 智能门铃-CP3系列 CS-DB2C-ZH 使用说明书
用户指南使用产品前请仔细阅读用户指南目录装箱清单日常维护售后服务支持版权声明040607091.门铃充电2223242503FAQ 2.安装Micro SD卡（可选）13141516安装设备添加至“萤石云视频”无线接收器上电下载“萤石云视频”规范使用视频产品的倡议配置流程概览外观介绍0820202110门铃开机11配网问题12关联问题1.选择安装位置132.门铃镜头保养1.实时预览1717182.设置门铃1.门铃04052.无线接收器3.安装门铃背板4.安装门铃主体193.设置无线接收器门铃 x1无线接收器 x1门铃背板x1用户指南 x1螺丝配件 x1门铃、门铃背板和无线接收器有白色、灰色两种颜色，具体请以购买的实物为准。
本文将以白色版本为例展开介绍。
正面反面顶部侧面拆机孔需配合拆机孔针使用开机：关机状态下长按2秒，指示灯蓝色常亮3秒后熄灭，且语音提示设备已开机，表明门铃开机成功。
关机：开机状态下长按5秒，语音提示设备即将关机，且指示灯红色闪烁3次后熄灭，表明门铃关机成功。
*电源键红色慢闪：充电中红色亮3秒：电量低于20%且门铃被唤醒蓝色常亮：充满电且适配器未移除蓝色亮3秒：电量高于20%且门铃被唤醒门铃含义解释*指示灯（门铃）外观介绍｜门铃安装在门口，具有监控、录像、侦测和门铃呼叫等功能。
外观介绍｜无线接收器无线接收器安装在室内，具有无线信号中继放大、响铃、录像存储等功能。
侧面含义解释*指示灯（无线接收器）红色常亮：设备启动中/重置中红色快闪：与门铃断开连接或者SD卡故障红色慢闪：网络断开蓝色常亮：联网成功蓝色快闪：等待配网*RESET键长按5秒：无线接收器运行时，长按5秒，指示灯红色常亮，表示无线接收器开始重启并恢复出厂设置短按一次：无线接收器响铃时，短按按键，可恢复静音。
配置流程概览下载“萤石云视频”扫描二维码下载“萤石云视频”客户端如果您使用的是手机/Pad扫描下面的二维码，下载并安装客户端。
db2 backup指令
在IBM Db2 数据库中，备份数据库是维护数据库完整性和灾难恢复计划的关键操作之一。
以下是在Db2 中使用备份指令的基本形式：1. Online Backup：--在线备份整个数据库BACKUP DATABASE <database_name> TO <backup_path>;--例子BACKUP DATABASE SAMPLE TO '/path/to/backup';2. Offline Backup：--离线备份整个数据库OFFLINE DATABASE <database_name> TO <backup_path>;--例子OFFLINE DATABASE SAMPLE TO '/path/to/backup';3. 备份数据库别名：--备份数据库别名BACKUP DATABASE ALIAS <alias_name> TO <backup_path>;--例子BACKUP DATABASE ALIAS SAMPLE_ALIAS TO '/path/to/backup';4. 备份单个表空间：--备份单个表空间BACKUP TABLESPACE <tablespace_name> TO <backup_path>;--例子BACKUP TABLESPACE USERSPACE1 TO '/path/to/backup';5. 备份日志文件：--备份日志文件BACKUP LOG TO <backup_path>;--例子BACKUP LOG TO '/path/to/log/backup';6. 备份增量数据：--备份增量数据BACKUP INCREMENTAL TO <backup_path>;--例子BACKUP INCREMENTAL TO '/path/to/incremental/backup';7. 带有选项的备份：--使用选项备份BACKUP DATABASE <database_name> TO <backup_path> WITH <options>;--例子BACKUP DATABASE SAMPLE TO '/path/to/backup' WITH 2 BUFFERS BUFFER 1024 PARALLELISM 2;上述是基本的备份命令，实际使用时可能需要根据具体情况进行调整。
db2系统命令和配置参数大全
db2updv9 － 将数据库更新为版本 9 当前级别
db2xdbmig － 迁移 XSR 对象
db2xprt － 格式化陷阱文件
disable_MQFunctions － 禁用 WebSphere MQ 函数
db2daslevel － 显示 DAS 级别
db2dclgn － 声明生成器
db2diag － db2diag.log 分析工具
db2drdat － DRDA 跟踪
db2drvmp － DB2 数据库驱动器映射
DB2 系统命令与配置参数大全
DB2 系统命令与配置参数大全
DB2 系统命令
dasauto － 自动启动 DB2 管理服务器
dascrt － 创建 DB2 管理服务器
dasdrop － 除去 DB2 管理服务器
dasmigr － 迁移 DB2 管理服务器
db2imigr － 迁移实例
db2inidb － 初始化镜像数据库
db2inspf － 格式化检查结果
db2isetup － 启动实例创建界面
db2iupdt － 更新实例
db2jdbcbind － DB2 JDBC 程序包绑定程序
db2exfmt － 说明表格式
db2exmig － 迁移说明表命令
db2expln － SQL 和 XQuery 说明
db2extsec － 设置 DB2 对象的许可权
db2flsn － 查找日志序号
comm_bandwidth － 通信带宽
conn_elapse － 连接耗用时间
cpuspeed － CPU 速度
安全指南--DB2安全配置
目录1. 范围 (2)2. 术语和定义 (2)3. 安全检查列表 (2)3.1 检查系统及DB2数据库版本 (2)3.2 检查DB2数据库补丁 (2)3.3 检查DB2数据库配置信息 (3)3.4 检查权限 (3)3.5 检查数据库调试和开发环境是否分开 (5)3.6 认证 (5)3.7 审计 (5)3.8检查备份策略 (7)3.9检查是否建立良好的日志管理策略 (7)1.范围本部分规定了网络系统中所使用的DB2数据库应用所应该遵守的安全检查指南。
2.术语和定义无。
3.安全检查列表3.1 检查系统及DB2数据库版本1)oslevel命令检查系统版本2)在DB2 5.2及以上版本中，db2level命令的输出提供了有关DB2实例的版本及修补级别的详细信息。
3.2 检查DB2数据库补丁通过db2level获取的修补代码及修订包发行号进行比较。
如果两者结果不同，那么意味着没有安装相应的修订包查找最近的DB2 FixPaks:3.3 检查DB2数据库配置信息1.检查安全的密码策略加强密码设置，设置最小的密码长度为8个字符以上，含字符、数字和特殊字符(1).检查用户口令修改时间(2).定期修改用户密码2.是否实施严格的口令3.检查帐号策略1)检查是否存在不必要的默认用户或测试用户2)检查是否存在不必要的用户及用户所拥有的对象3)检查是否有DBA或其他帐号的密码写于应用程序或者脚本中4. 检查数据库配置文件权限1)系统中的实例不是越多越好，如果在系统中创建的实例过多，不仅会造成额外的资源消耗（内存、硬盘空间等），也会增大管理开销。
检查每个实例在创建后的配置文件、每个数据库创建后的配置文件是否采取了安全保护措施2)检查恢复历史文件是否采取了安全保护措施3)检查数据库软件安装目录是否合理管理3.4 检查权限DB2访问控制的层次结构检查对DB2的用户赋于不同级别的权力和各种特权。
1.检查SYSADM、SYSCTRL 和 SYSMAINT权限的分配情况2.检查DBADM 和 LOAD 权限的分配情况3.检查是否每个实例有单独的权限控制，不同的实例是否设定不同的管理人员4.检查用户对象特权的使用情况，如：CONTROL、INSERT、DELETE、CREATEIN、DROPIN、REFERENCES 和 SELECT 等5.检查数据库级特权的使用情况，如：3)CREATETAB：允许用户在数据库内创建表。
db2expln使用说明
Db2expln使用说明1.语法图>>-db2expln--+------------------------+------------------------->| '-| connection-options |-'|>--+--------------------+--+---------------------+-------------->| '-| output-options |-' '-| package-options |-'|>--+---------------------+--+---------------------+------------->| '-| dynamic-options |-' '-| explain-options |-'|>--+--------+--------------------------------------------------><| '- -help-'|connection-options:||-- -database--database-name--+---------------------------+-----|| '- -user--user-id--password-'|output-options:||--+-----------------------+--+------------+--------------------|| '- -output--output-file-' '- -terminal-'|package-options:||-- -schema--schema-name-- -package--package-name--------------->|>--+-------------------------------+---------------------------->| '- -version--version-identifier-'|>--+----------------------------+--+-----------+---------------->| '- -escape--escape-character-' '- -noupper-'|>--+---------------------------+--------------------------------|| '- -section--section-number-'|dynamic-options:||--+----------------------------+------------------------------->| '- -statement--sql-statement-'|>--+--------------------------------+--------------------------->| '- -stmtfile--sql-statement-file-'|>--+-------------------------------------+--+---------+---------|| '- -terminator--termination-character-' '- -noenv-'|explain-options:||--+---------+--+---------+-------------------------------------|| '- -graph-' '- -opids-'1.1常用命令行１．分析程序包db2expln -d 数据库名-i -g -c 模式名-p程序包-s 0 -tdb2expln -d 数据库名-i -g -c 模式名-p程序包-s 0 -o文件名第一条命令行讲执行方案显示在屏幕上，第二条语句将方案输出到文件中２．分析sql 语句db2expln -d 数据库名-i -g -q sql语句-tdb2expln -d 数据库名-i -g -q sql语句-o 文件名３．输出简单说明在该输出中，每个程序包的说明信息显示在下列两个部分：∙程序包信息，如绑定日期和相关的绑定选项∙后跟要说明的SQL 语句的节信息，例如，节号。
DB2 REXX 语言扩展（RLX）用户指南和参考手册版本 9.1.6 November 2016说
RLX for DB2REXX Language XtensionsUser GuideandReferenceVersion 9.1.6November 2016Publication RLX-102-11 Relational Architects Intl______________________________________________________________________________This Guide: (RAI Publication RLX-102-11)This document applies to RLX Version 9 Release 1 Mod Level 6 (November 2016), and allsubsequent releases, unless otherwise indicated in new editions or technical newsletters.Specifications contained herein are subject to change and will be reported in subsequentrevisions or editions.Purchase Orders for publications should be addressed to:Documentation CoordinatorRelational Architects Intl.Riverview Historic Plaza33 Newark StreetHoboken NJ 07030 USATel: 201 420-0400Fax: 201 420-4080Email ****************Web Reader comments regarding the product, its documentation, and suggested improvements arewelcome. A reader comment form for this purpose is provided at the back of this publication.Copyright (c) 1990, 2016 by Relational Architects, Inc. (RAI) as an unpublished work --all rights reserved. The software product(s) described herein and the documentationthereof are trade secrets and property of Relational Architects, International Inc. All use,disclosure, duplication, electronic storage, reproduction or transmission without specificwritten authorization from RAI is strictly prohibited. These products may also beprotected under the trade-secret and copyright laws of countries other than the UnitedStates and international agreements.DB2, QMF and ISPF are software products of IBM Corporation. RLX, RDX, REXX LanguageXtensions, REXX DB2 Xtensions, AcceleREXX, RLX/SQL, RLX/TSO, RLX/CLIST,RLX/ISPF, RLX/VSAM, RLX/SDK, RLX/Net, RLX for z/OS, RLX/Compile, RLX/CAF,RLX/RRSAF, RLX/IFI and RLX/Translate are trademarks of Relational ArchitectsInternational, Inc.Ed 16A29 ______________________________________________________________________________ ii RLX Product Family ReferenceTable of ContentsPreface (iii)Related Publications (iii)Notational Conventions (iv)Section A: What's New in RLX for DB2 ..................................................... A-1 Summary of Changes to RLX Version 9.1 ....................................................................... A-1Chapter 1: Introducing RLX/SQL and RLX/TSO .................................. 1-11.1 What is RLX ? ................................................................................................................... 1-11.2 What is RLX/SQL ? .......................................................................................................... 1-21.3 RLX support for SQL and DB2 ...................................................................................... 1-31.4 Structure of the RLX/SQL Reference ............................................................................... 1-41.4.1 The RLX/SQL Reference - Part I: Using RLX .......................................... 1-51.4.2 The RLX/SQL Reference - Part II: Using SQL with RLX ....................... 1-51.4.3 The RLX/SQL Reference - Part III:Reference for SQL statements and RLX extensions ....................................... 1-5Part I - Using RLXChapter 2: Setting Up the Environment to use RLX .................................. 2-12.1 RLX Libraries.................................................................................................................... 2-22.2 Basic RLX libraries allocation for all environments............................................................. 2-22.3 Additional library allocations to exploit the TSO/ISPF environment ................................. 2-42.4 Preallocating the RLX Libraries (exec RLXRLA) ........................................................... 2-42.5 How to dynamically allocate and free the RLX libraries (exec RLXDYN) ....................... 2-52.6 Selection of RLX run-time parameters ............................................................................... 2-52.6.1 Change RLX default parameters (job RLXJTSD) ................................................... 2-52.6.2 Set run-time parameters when using RLXS command ............................................ 2-62.6.3 Run-time parameters specified in REXX exec (RLXPROF. stem) ......................... 2-62.6.4 Run-time parameters specified in ISPF PROFILE variables (exec RLXRPU) ....... 2-72.6.5 Select DB2 subsystem name from DSNHDECP load module ................................ 2-8Table of Contents 12.6.6 Directly connect to a DB2 subsystem ..................................................................... 2-82.7 Verify that RLX is accessible ............................................................................................. 2-92.8 RLX User Facility ........................................................................................................... 2-102.9 Stored Procedures Tester .................................................................................................. 2-11Chapter 3: EXEC Invocation ....................................................................... 3-13.1 ADDRESS RLX - the RLX Host Command Environment ............................................... 3-23.2 Direct EXEC invocation versus using the RLXS frontend ................................................. 3-33.3 Running RLX execs Natively .......................................................................................... 3-53.3.1 Terminating the RLX Environment ................................................................... 3-63.4 Running RLX EXECs in MVS Batch .............................................................................. 3-63.5 Invoking RLX/TSO execs through the RLXS frontend .................................................. 3-73.5.1 Invoking the RLXS Command on the TSO Command line ............................ 3-93.5.2 Invoking the RLXS Command from within another EXEC .............................. 3-93.5.3 Invoking the RLXS Command as an ISPF SELECTION Menu Option ........ 3-103.5.4 Invoking the RLXS Command through the ISPEXEC SELECT service ....... 3-103.5.5 Main Invocation Panel ....................................................................................... 3-113.6 RLXS Keyword Parameters ............................................................................................ 3-123.7 Running RLX / TSO applications in the TSO / ISPF background ................................ 3-13Chapter 4: Controlling RLX Operation ..................................................... 4-14.1 The RLX Profile - overview ............................................................................................... 4-24.2 The RLX User Profile and RLX User Profile Facility ..................................................... 4-44.3 Specifying DB2 Related Parameters .................................................................................. 4-54.4 Datatype conversion and output formatting .......................................................................... 4-64.5 Error Handling ..................................................................................................................... 4-74.6 Scope Options ...................................................................................................................... 4-84.7 Precision of floating point datatypes .................................................................................... 4-84.8 Tracing Options .................................................................................................................... 4-94.9 Return Code Options ............................................................................................................ 4-94.10 High Level Qualifier Specification ....................................................................................... 4-94.11 Determining Host Variable Datatypes ................................................................................ 4-104.12 RLX/ISPF Control variables ............................................................................................. 4-164.13 Maximum Attentions .......................................................................................................... 4-184.14 Maximum Tokens ............................................................................................................... 4-184.15 Specify Color Attributes of the RLX panels ....................................................................... 4-18 2 RLX for DB2 User ReferenceChapter 5: Controlling RLX operation withthe RLXPROF Compound Variables ..................................... 5-15.1 Overview ............................................................................................................................ 5-1Chapter 6: Controlling RLX during Execution:The RLX CONTROL Service ................................................. 6-16.1 Overview .............................................................................................................................. 6-26.2 The RLX CONTROL REFRESH service ........................................................................ 6-46.3 Error Handling ..................................................................................................................... 6-56.3.1 The RLX CONTROL ERRORS service ....................................................... 6-56.3.2 RLX ISPF error handling: The RLX CONTROL ISPERROR service ............ 6-86.3.3 RLX Error Reporting - The RLX CONTROL EPANEL service.................. 6-96.4 Datatype conversion and output formatting ........................................................................ 6-106.4.1 Output Formatting of Numeric Datatypes ....................................................... 6-116.4.2 Input editing and output formatting of DATE datatypes............................... 6-126.4.3 Input editing and output formatting of TIME datatype ................................. 6-136.5 VDEFINE - explicitly define host variable datatypes ...................................................... 6-146.6 Scope Control ..................................................................................................................... 6-146.6.1 Scope of cursor name recognition ................................................................... 6-146.6.2 Scope of recognition for Host variable VDEFINEs ........................................ 6-156.6.3 Scope of RLX statement recognition .............................................................. 6-156.7 RLX SQL extensions ........................................................................................................ 6-166.7.1 Limiting the size of query results loaded intoISPF tables and REXXSTEMs ....................................................................... 6-166.7.2 Disposition of SQL Query Results previously loaded into ISPF tables .......... 6-166.7.3 Specifying an Underscore replacement character (URC) .............................. 6-17Part II -- Using SQL with RLXChapter 7: The RLX SQL Interface - an Overview .............................. 7-17.1 RLX SQL Syntax ............................................................................................................... 7-17.2 SQL statements supported ................................................................................................... 7-37.3 DB2 CAF services supported ............................................................................................. 7-57.4 DB2 commands and IFI trace data services ....................................................................... 7-67.5 Develop and test REXX SQL procedures without Program Preparation ........................... 7-6Table of Contents 37.6 DB2 Security and Authorization considerations ................................................................. 7-77.7 DB2 SQL structures - SQLCA, SQLDA and IFCA ...................................................... 7-77.8 DB2 Unit of Recovery considerations ................................................................................ 7-87.9 Managing DB2 Connections and Application Plan Threads .............................................. 7-97.9.1 Managing the DB2 connection ........................................................................ 7-97.9.2 Specifying the DB2 application plan ............................................................... 7-107.9.3 Plan and connection termination ...................................................................... 7-10Chapter 8: SQL Host Variables................................................................... 8-18.1 RLX host variables .............................................................................................................. 8-28.2 Host variables shared among REXX, SQL and ISPF ....................................................... 8-48.3 Host variable datatypes ........................................................................................................ 8-58.4 DB2 datatypes and REXX character string datatypes ......................................................... 8-68.5 NULLs, null values, and indicator variables ...................................................................... 8-78.6 NULL values on Input .......................................................................................................... 8-9Chapter 9: Constructing SQL Statements in REXX ................................ 9-19.1 RLX SQL statement coding techniques .............................................................................. 9-29.2 How RLX Statements are Executed ..................................................................................... 9-29.3 Fixed Format Statements ...................................................................................................... 9-39.4 Variable Format Statements ................................................................................................. 9-49.5 Coding Long SQL Statements ............................................................................................ 9-69.6 RLXQUOTE macro for verification.................................................................................... 9-79.7 Fixed versus Variable blocked exec Libraries ...................................................................... 9-79.8 Referencing parameters in RLX statements ......................................................................... 9-99.9 Referencing ISPF dialog variables in RLX statements ....................................................... 9-10Chapter 10: SQL Diagnostics and Error Handling ................................. 10-110.1 SQL Execution errors ..................................................................................................... 10-3Common, Fixed Format Area ................................................................................ 10-4Scrollable Area ...................................................................................................... 10-4Internal and External SQL Statements ................................................................... 10-5 Failures while Determining Input Variable Datatypes ...................................................... 10-610.2 Error Response Options ................................................................................................... 10-7Cancel .................................................................................................................... 10-7Filtering Errors ....................................................................................................... 10-8 4 RLX for DB2 User Reference10.3 Syntax errors detected by the RLX semantic parser .................................................... 10-1010.4 Logic errors detected by RLX ....................................................................................... 10-1010.5 Host Variable data errors ............................................................................................... 10-1110.6 Problem Determination Procedures for RLX applications .......................................... 10-1210.6.1 SQLCODE values unique to RLX .............................................................. 10-1310.6.2 RLX return codes ......................................................................................... 10-1410.7 Common RLX Problems ............................................................................................. 10-1510.7.1 A03 abends .................................................................................................. 10-1510.7.2 Limits to Address RLX support .................................................................. 10-1510.7.3 More than one CURSOR declared with the same name ............................. 10-16c10.7.4 Complex Expressions Within Predicates ...................................................... 10-1610.7.5 Nested EXECs and TSO CLISTs ............................................................. 10-1710.7.6 Multiple fetches referencing the same CURSOR .......................................... 10-1810.7.7 Handing Implicit Rollback ............................................................................ 10-18Part III -- RLX SQL ReferenceChapter 11: Static SQL Data ManipulationLanguage Statement Reference .......................................... 11-111.1 Static Data Manipulation Language (DML) Statements ................................................ 11-211.2 ALLOCATE CURSOR ................................................................................................ 11-211.3 ASSOCIATE LOCATORS ........................................................................................... 11-311.4 CALL (DB2 V4.1) ....................................................................................................... 11-411.5 CLOSE ........................................................................................................................... 11-511.6 COMMIT ....................................................................................................................... 11-611.7 CONNECT (Types 1 and 2) ......................................................................................... 11-711.8 DECLARE CURSOR ................................................................................................... 11-811.8.1 CURSOR based processing ........................................................................... 11-811.9 DELETE ...................................................................................................................... 11-1011.10 EXPLAIN .................................................................................................................... 11-1111.11 FETCH ........................................................................................................................ 11-1111.12 INSERT ....................................................................................................................... 11-1211.13 OPEN ........................................................................................................................... 11-1311.14 RELEASE ................................................................................................................... 11-1411.15 ROLLBACK ............................................................................................................... 11-15Table of Contents 511.17 SET CONNECTION ................................................................................................ 11-1711.18 SET CURRENT DEGREE ...................................................................................... 11-1811.19 SET CURRENT LOCALE LC_TYPE .................................................................... 11-1911.20 SET CURRENT OPTIMIZATION HINT ............................................................... 11-2011.21 SET CURRENT PACKAGESET ............................................................................ 11-2111.22 SET CURRENT PATH ........................................................................................... 11-2211.23 SET CURRENT RULES (DB2 V4.1) .................................................................. 11-2311.24 SET CURRENT SQLID .......................................................................................... 11-2411.25 SET host-variable...................................................................................................... 11-2511.26 UPDATE .................................................................................................................... 11-27Chapter 12: Dynamic SQL DML Statement Reference .......................... 12-112.1Dynamic SQL DML Statement Summary ..................................................................... 12-112.2 The DESCRIBE Statement ............................................................................................. 12-212.2.1 DESCRIBE for Statements that receive data from DB2 ................................. 12-412.2.2 DESCRIBE for Statements that supply data to DB2 ...................................... 12-512.3 EXECUTE Statement ...................................................................................................... 12-612.4 EXECUTE IMMEDIATE ............................................................................................... 12-712.5 PREPARE Statement ....................................................................................................... 12-712.5.1 PREPARE of INSERT statement ................................................................ 12-812.5.2 PREPARE of SELECT statement ................................................................ 12-9Chapter 13: RxSQL Statement Reference ................................................ 13-113.1 Support for IBM's RxSQL product .............................................................................. 13-213.2 RXSQL CALL Statement .............................................................................................. 13-213.3 RXSQL CLOSE Statement ............................................................................................ 13-213.4 RXSQL COMMIT Statement ........................................................................................ 13-313.5 RXSQL CONNECT Statement ..................................................................................... 13-313.6 RXSQL CREATE PACKAGE and CREATE PROGRAM ....................................... 13-313.7 RXSQL DECLARE Statement ...................................................................................... 13-313.8 RXSQL DESCRIBE Statement ..................................................................................... 13-413.9 RXSQL DROPSTMT Command .................................................................................. 13-413.10 RXSQL EXEC or EXECUTE IMMEDIATE Statement ........................................... 13-413.11 RXSQL EXECUTE Statement...................................................................................... 13-513.12RXSQL FETCH Statement ........................................................................................... 13-5 6 RLX for DB2 User Reference13.14 RXSQL OP Command ................................................................................................. 13-513.15 RXSQL OPEN Statement ............................................................................................ 13-613.16 RXSQL PREP Statement ............................................................................................. 13-613.17 RXSQL PURGE Command ......................................................................................... 13-613.18 RXSQL PUT Statement ............................................................................................... 13-613.19 RXSQL ROLLBACK Statement ................................................................................. 13-713.20 RXSQL SQLDATE Command .................................................................................... 13-713.21 RXSQL SQLISL Command ........................................................................................ 13-713.22 RXSQL SQLTIME Command..................................................................................... 13-813.23 RXSQL STATE Command ......................................................................................... 13-813.24 RXSQL STMT Command ........................................................................................... 13-813.25 RXSQL TRACE Command ......................................................................................... 13-913.26 RXSQL XCALL Statement ......................................................................................... 13-913.27 RXSQL XPREP Statement .......................................................................................... 13-913.28 RXSELECT exec to display SQL query result ............................................................. 13-913.29 RXSQLEX exec to execute single SQL statements ...................................................... 13-9Chapter 14: RLX Extension Facilities ...................................................... 14-114.1 The DECLARE REXXSTEM service ......................................................................... 14-114.1.1 Names of REXX stemmed variables Created by DECLARE REXXSTEM14-314.2 The PURGE service ...................................................................................................... 14-414.3 VDEFINE - explicitly define host variable datatypes ................................................... 14-7Chapter 15: Using RLX as a DB2 Application Server ............................ 15-115.1 What is a DB2 Application Server? ............................................................................ 15-115.2 Sample RLX Implementation of an Application Server ............................................. 15-115.3 Program preparation ............................................................................................... 15-315.3.1 Prepare RLX Package Collection .................................................................. 15-315.3.2 BIND Application Plans ............................................................................... 15-415.4 Dynamic vs. Static SQL ............................................................................................... 15-4Chapter 16 RLX Stored Procedure Support ............................................ 16-116.1 The RLX Stored Procedure Samples ............................................................................. 16-216.2 A Simple Stored Procedure Example ............................................................................ 16-3Table of Contents 716.3 A Stored Procedure which returns a Result Set ............................................................. 16-516.4 Defining RLX Stored Procedures to DB2 ..................................................................... 16-816.4.1 The Parameter List passed to RLX Stored Procedures .................................. 16-9Chapter 26: RLX Recovery from DB2 Thread Termination .............. 26-126.1 Persistent Thread Functionality ....................................................................................... 26-1Appendix A: REXX Variables Updated by RLX/SQL ........................... A-1A.1 SQLCA Variables ............................................................................................................ A-2A.2 SQLDA Variables ........................................................................................................... A-3A.2.1 Output SQLDA variables ................................................................................ A-4A.2.2 SQLDA fields for Input Host Variables ........................................................... A-6A.3 IFI Variables .................................................................................................................... A-6A.4 RLX Diagnostic and Informational Variables ................................................................. A-8A.5 RLX/ISPF informational variables .................................................................................. A-9A.6 RLX/CAF informational variables .................................................................................. A-9A.7 RLX Return Codes ........................................................................................................ A-10A.8 RLX Special SQLCODE values .................................................................................. A-11A.9 RLX user abend codes ................................................................................................... A-118 RLX for DB2 User Reference。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
DB2使用指南基线应用产品部
密级[公开]
2011-3-29
历史记录
目录
1 序言 (4)
1.1 编写目的 (4)
1.2 读者范围 (4)
1.3 软件下载地址 (4)
2 DB2的安装 (5)
3 创建数据库 (10)
4 DBVIS的使用 (13)
5 DB2的卸载 (16)
1序言
1.1编写目的
本文档介绍了DB2的安装、完全卸载、数据库的创建、DBVISUAL数据库管理工具的使用方法。
1.2读者范围
未接触过以及不熟悉DB2数据库的开发人员，以及需要使用到DB2数据库的相关测试人员。
1.3软件下载地址
2DB2的安装
1、找到DB2软件后，找到其所在的目录DB2\v9.7_nt32_server\SERVER\image，双击setup.exe文件，如图所示：
图2-1
2、双击后打开了如下图所示的界面，选择“安装产品”，找到DB2企业服务器版版本9.7，点击其下面的“安装新产品”。
图2-2 3、一路点击“下一步”，选择“典型安装”。
图2-3
4、选择默认的响应文件名即可。
图2-4
5、点击下一步并选择安装目录后，到了如下界面，填入用户名、密码，密码请大家选择自己比较熟悉的能记住的，可以设置为用户名和密码均为db2admin。
图2-5
6、点击下一步后，到了配置DB2实例页面。
图2-6
7、点击进入“配置”页面，默认的端口号为“50000”，可以不修改，也可以修改为其他，下图为将其修改为“60000”。
图2-7
8、点击确定后，下一步，看到如下图所示。
图2-8
9、将“设置DB2服务器以发送通知”这个选项点开，如果默认的选此操作后，DB2将会发送好多垃圾邮件。
图2-9
10、一路点击下一步，最后完成安装。
3创建数据库
1、安装完后，在开始菜单中找到DB2安装目录，从“一般管理工具”中找到“控制中心”，如图所示。
图3-1
2、打开控制中心后，右击“所有数据库”|“创建数据库”|“标准”。
图3-2
3、接下来如图所示，以在D盘创建一个名为DB2的数据库为例，缺省缓冲池和表空间页大小选择为16K（对于bosent使用的数据库，可以使用8k），点击下一步。
图3-3
4、代码集默认选择UTF-8，并点击下一步，完成创建库。
图3-4
图3-5
图3-6
图3-7
4DBVIS的使用
DBVIS是个绿色版数据库客户端操作工具，通过它可以进行数据库中数据的查看、增加、删除、修改、导入、到处等功能。
双击dbvis.exe，在主页面上右击connection，选择create database connection，如图。
图4-1
图4-2
点击Use Wizard按钮，进入如下页面，给自己将要连接的数据库起个名字，最好与数据库同名，以便于查询的时候分的清楚。
图4-3
图4-4
图4-5
点击test connection，测试连接成功，点击确定即可。
图4-6
5DB2的卸载
DB2在3个月的时候就会过期，所以每隔3个月就需要完全卸载后再重新安装一次，卸载的方法为在命令行窗口输入命令db2unins –f。
在弹出的窗口中点击“是”，即可等待完全卸载。
图5-1
图5-2。