DB2 DRDA V5 Vol. 1：分布式关系数据库架构详解与连接协议

DRDA

需积分: 10 156 浏览量更新于2024-07-17 收藏 2.28MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

DB2通信协议DRDA文档（第1卷）是Open Group制定的分布式关系数据库架构（DRDA）版本5的标准之一，专注于描述分布式环境中的数据库管理器间连接性。该文档的核心内容围绕如何让应用程序能够访问分布式的SQL数据，强调了在分布式系统中应用与关系数据库管理系统(RDBMS)之间的连接、参与者角色、流程控制以及处理分布式数据库管理所需的格式和协议。 DRDA V5 Vol. 1详尽地阐述了在分布式环境中，数据库连接的建立过程，包括但不限于： 1. **连接模型**：它定义了在分布式环境中如何创建和维护应用程序与数据库之间的连接，这涉及到网络层次结构和通信机制，确保数据的一致性和安全性。 2. **参与者职责**：文档明确划分了客户端应用、数据库代理、数据库服务器等各角色的职责，例如，应用负责提交请求，代理负责转发和协调，而服务器执行实际的数据操作。 3. **数据传输协议**：DRDA规范了数据在不同组件间传输时的协议，如SQL命令的序列化、解序列化，以及错误处理和日志记录的方式。 4. **事务管理**：在分布式环境下，如何确保跨多个数据库的事务的一致性和隔离级别是关键，DRDA文档对此提供了指导。 5. **安全与认证**：文档讨论了如何通过加密、身份验证和授权机制来保护分布式数据库的通信，保证数据隐私和完整性。 6. **标准接口**：虽然DRDA不提供API，但它为分布式数据库管理系统处理过程设定了统一的接口规范，以便于不同厂商的产品兼容和互操作。 7. **版权与许可**：本文档基于IBM等公司的受版权材料制作，任何复制、存储或传播都需事先获得The Open Group的许可。 DB2通信协议DRDA V5 Vol. 1是理解分布式数据库设计、实现和管理的关键参考文献，对于开发、部署和优化分布式应用系统中的SQL数据访问具有重要意义。它不仅提供了理论基础，还对实际操作中的问题给出了详细的解决方案。

资源详情

资源推荐

Contents

A-27 CNTQRYCommand Instance Variables .................................................. 679

A-28 Reply Objects for the CNTQRYCommand ............................................. 679

A-29 DRPPKG Command Instance Variables .................................................. 680

A-30 Reply Objects for the DRPPKG Command ............................................. 680

A-31 DSCINVRM Reply Message Instance Variables ..................................... 681

A-32 DSCRDBTBL Command Instance Variables ........................................... 682

A-33 Command Objects for the DSCRDBTBL Command.............................. 682

A-34 Reply Objects for the DSCRDBTBL Command ...................................... 682

A-35 DSCSQLSTT Command Instance Variables ............................................ 683

A-36 Reply Objects for the DSCSQLSTT Command....................................... 683

A-37 DTAMCHRM Reply Message Instance Variables .................................. 684

A-38 ENDATMCHN Command Instance Variables ....................................... 685

A-39 ENDBND Command Instance Variables ................................................. 686

A-40 Reply Objects for the ENDBND Command............................................ 686

A-41 ENDQRYRM Reply Message Instance Variables ................................... 687

A-42 ENDUOWRM Reply Message Instance Variables ................................. 688

A-43 EXCSATCommand Instance Variables ................................................... 689

A-44 EXCSATRD Reply Object Instance Variables .......................................... 690

A-45 EXCSQLIMM Command Instance Variables .......................................... 691

A-46 Command Objects for the EXCSQLIMM Command............................. 691

A-47 Reply Objects for the EXCSQLIMM Command ..................................... 691

A-48 EXCSQLSET Command Instance Variables ............................................ 692

A-49 Command Objects for the EXCSQLSET Command............................... 692

A-50 Reply Objects for the EXCSQLSET Command....................................... 692

A-51 EXCSQLSTT Command Instance Variables ............................................ 693

A-52 Command Objects for the EXCSQLSTT Command............................... 693

A-53 Reply Objects for the EXCSQLSTT Command....................................... 694

A-54 GETNXTCHK Command Instance Variables ......................................... 695

A-55 Reply Objects for the GETNXTCHK Command .................................... 695

A-56 INTRDBRQS Command Instance Variables ........................................... 696

A-57 INTTKNRM Reply Message Instance Variables ..................................... 697

A-58 MGRDEPRM Reply Message Instance Variables ................................... 698

A-59 MGRLVLRM Reply Message Instance Variables .................................... 699

A-60 OBJNSPRM Reply Message Instance Variables ...................................... 700

A-61 OPNQFLRM Reply Message Instance Variables .................................... 701

A-62 OPNQRYCommand Instance Variables ................................................. 702

A-63 Command Objects for the OPNQRYCommand .................................... 702

A-64 Reply Objects for the OPNQRYCommand ............................................ 703

A-65 OPNQRYRM Reply Message Instance Variables ................................... 704

A-66 PKGBNARM Reply Message Instance Variables ................................... 705

A-67 PKGBPARM Reply Message Instance Variables ..................................... 706

A-68 PRCCNVRM Reply Message Instance Variables .................................... 707

A-69 PRMNSPRM Reply Message Instance Variables .................................... 708

A-70 PRPSQLSTT Command Instance Variables............................................. 709

A-71 Command Objects for the PRPSQLSTT Command............................... 709

A-72 Reply Objects for the PRPSQLSTT Command ....................................... 709

A-73 QRYNOPRM Reply Message Instance Variables ................................... 710

A-74 QRYPOPRM Reply Message Instance Variables .................................... 711

A-75 RDBACCRM Reply Message Instance Variables ................................... 712

A-76 RDBAFLRM Reply Message Instance Variables .................................... 713

A-77 RDBATHRM Reply Message Instance Variables .................................... 714

A-78 RDBCMM Command Instance Variables ................................................ 715

xvi Open Group Standard (2011)

Contents

A-79 Reply Objects for the RDBCMM Command ........................................... 715

A-80 RDBNACRM Reply Message Instance Variables ................................... 716

A-81 RDBNFNRM Reply Message Instance Variables ................................... 717

A-82 RDBRLLBCK Command Instance Variables ........................................... 718

A-83 Reply Objects for the RDBRLLBCK Command...................................... 718

A-84 RDBUPDRM Reply Message Instance Variables .................................... 719

A-85 REBIND Command Instance Variables ................................................... 720

A-86 Command Objects for the REBIND Command...................................... 720

A-87 Reply Objects for the REBIND Command .............................................. 720

A-88 RSCLMTRM Reply Message Instance Variables .................................... 721

A-89 RSLSETRM Reply Message Instance Variables ...................................... 722

A-90 SECCHK Command Instance Variables .................................................. 723

A-91 Command Objects for the SECCHK Command..................................... 723

A-92 Reply Objects for the SECCHK Command ............................................. 723

A-93 SECCHKRM Reply Message Instance Variables .................................... 724

A-94 SNDPKT Command Instance Variables .................................................. 725

A-95 Command Objects for the SNDPKT Command..................................... 725

A-96 Reply Objects for the SNDPKT Command ............................................. 725

A-97 SQLERRRM Reply Message Instance Variables ..................................... 726

A-98 SYNCCTL Command Instance Variables ................................................ 727

A-99 Command Objects for SYNCCTL............................................................. 727

A-100 SYNCCRD Reply Object Instance Variables ........................................... 728

A-101 SYNCLOG Reply Object Instance Variables ........................................... 729

A-102 SYNCRSY Command Instance Variables ................................................ 730

A-103 Command Objects for SYNCRSY ............................................................. 730

A-104 SYNCRRD Reply Object Instance Variables ............................................ 731

A-105 Reply Objects for SYNCRRD..................................................................... 731

A-106 SYNTAXRM Reply Message Instance Variables .................................... 732

A-107 TRGNSPRM Reply Message Instance Variables .................................... 733

A-108 VALNSPRM Reply Message Instance Variables ..................................... 734

DRDA, Version 5, Volume 1: Distributed Relational Database Architecture (DRDA) xvii

Preface

The Open Group

The Open Group is a vendor-neutral and technology-neutral consortium, whose vision of

Boundaryless Information Flow™ will enable access to integrated information within and

between enterprises based on open standards and global interoperability.The Open Group

works with customers, suppliers, consortia, and other standards bodies. Its role is to capture,

understand, and address current and emerging requirements, establish policies, and sharebest

practices; to facilitate interoperability,develop consensus, and evolve and integrate

speciﬁcations and Open Source technologies; to offer a comprehensive set of services to enhance

the operational efﬁciency of consortia; and to operate the industry’s premier certiﬁcation service,

including TOGAF™ and UNIX

certiﬁcation.

Further information on The Open Group is available at

www.opengroup.org.

The Open Group has over 20 years’ experience in developing and operating certiﬁcation

programs and has extensive experience developing and facilitating industry adoption of test

suites used to validate conformance to an open standardorspeciﬁcation.

Moreinformation is available at www.opengroup.org/certiﬁcation.

The Open Group publishes a wide range of technical documentation, the main part of which is

focused on development of Technical and Product Standards and Guides, but which also

includes white papers, technical studies, branding and testing documentation, and business

titles. Full details and a catalog areavailable at www.opengroup.org/bookstore.

As with all live documents, Technical Standards and Speciﬁcations requirerevision to align with

new developments and associated international standards. Todistinguish between revised

speciﬁcations which arefully backwards-compatible and those which arenot:

• Anew Version indicates thereisnochange to the deﬁnitive information contained in the

previous publication of that title, but additions/extensions areincluded. As such, it replaces

the previous publication.

• Anew Issue indicates thereissubstantive change to the deﬁnitive information contained in

the previous publication of that title, and theremay also be additions/extensions. As such,

both previous and new documents aremaintained as current publications.

Readers should note that Corrigenda may apply to any publication. Corrigenda information is

published at www.opengroup.org/corrigenda.

This Document

DRDA, an Open Group standard, comprises three volumes:

• Distributed Relational Database Architecture(DRDA) (the DRDA Reference)

• Formatted Data Object Content Architecture(FD:OCA) (the FD:OCA Reference)

• Distributed Data Management (DDM) Architecture (the DDM Reference)

This volume, Distributed Relational Database Architecture,describes the connectivity between

relational database managers that enables applications programs to access distributed relational

data.

DRDA, Version 5, Volume 1: Distributed Relational Database Architecture (DRDA) xix

Preface

This volume describes the necessary connection between an application and a relational

database management system in a distributed environment. It describes the responsibilities of

these participants, and speciﬁes when the ﬂows should occur.Itdescribes the formats and

protocols required for distributed database management system processing. It does not describe

an Application Programming Interface (API) for distributed database management system

processing.

This reference is divided into three parts. The ﬁrst part describes the database access protocols.

The second part describes the environmental support that DRDA requires, which includes

network support. The thirdpart contains the speciﬁc network protocols and characteristics of

the environments these protocols run in, along with how these network protocols relate to

DRDA.

Note: To understand DRDA, the reader should be familiar with the following referenced documents:

• Distributed Data Management (DDM)

• Formatted Data Object Content Architecture(FD:OCA)

• Structured Query Language (SQL) and Character Data Representation Architecture

(CDRA)

• Distributed Transaction Processing (DTP)

• At least one of the deﬁned network protocols: Systems Network Architecture(SNA) or

TCP/IP

Intended Audience

This volume is intended for relational database management systems (DBMS) development

organizations. Programmers who wish to code their own connections between database

management systems can use this description of DRDA as a basis for their code.

Typographic Conventions

The following typographical conventions areused throughout this document:

• Bold font is used for system elements that must be used literally,such as interface names

and deﬁned constants.

• Italic strings areused for emphasis or to identify the ﬁrst instance of a wordrequiring

deﬁnition. Italics in text also denote function names and variable values such as interface

arguments.

• Normal font is used for the names of constants and literals.

• The notation <ﬁle.h> indicates a header ﬁle.

• The notation [EABCD] is used to identify an error value EABCD.

• Syntax, code examples, and user input in interactive examples areshown in fixed

width font.

• Variables within syntax statements areshown in italic fixed width font.

Problem Reporting

For any problems with DRDA-based softwareorvendor-supplied documentation, contact the

softwarevendor ’s customer service department. Comments relating to this Technical Standard,

however,should be sent to the addresses provided on the copyright page.

xx Open Group Standard (2011)

剩余805页未读，继续阅读

Alent7

粉丝: 0
资源: 4

DB2 DRDA V5 Vol. 1：分布式关系数据库架构详解与连接协议

北斗串口2.1通信协议(北斗卫星导航系统用户终端通用数据接口).docx

DRDA通信协议 英文版

DRDA Version 5 Volume 3-Distributed Data Management (DDM) Architecture.PDF

如何在IBM文件下找到数据库配置文件

如何修改这个访问路径http://localhost/nacos改成其他的呢？譬如http://localhost/other/nacos

DRDA Version 4 Volume 1 （英文）

2.1接口协议.pdf

DB2数据库协议解析-DRDAV5.3

DB2数据库网络协议分析报告

DRDA Version 4 Volume 3（英文）

DB2通信协议DRDA文档(2/3卷)DRDA V5 Vol. 2

DB2_DRDA官方说明文档介绍资料

北斗2.1通信协议

北斗2.1协议编号【BD420007-2015】-北斗用户终端RDSS单元性能要求及测试方法-20151102

DB2、ORACLE

DB2_DRDA通信协议

geopandas-0.13.1-py3-none-any.whl

lxml-5.0.1-cp310-cp310-win_amd64.whl

单片机资料c源码通过矩阵按键与数码管单片机资料c源码通过矩阵按键与数码管

本地音乐播放器优化版源码20240831

最新资源

DRDA通信协议英文版