Skip to content
HeliosDB Full

DRDA/DB2 Protocol Documentation

DRDA/DB2 Protocol Documentation

This directory contains consolidated documentation for HeliosDB’s IBM DB2 DRDA protocol support.

Quick Start

Connect to HeliosDB using DB2 client tools:

Terminal window
# DB2 CLP connection
db2 connect to heliosdb user admin using password


# Execute query
db2 "SELECT * FROM employees FETCH FIRST 10 ROWS ONLY"

Contents

FileDescription
README.mdOverview and quick start (this file)
CONFIGURATION.mdConnection and protocol configuration
COMPATIBILITY.mdDRDA/DB2 feature compatibility
EXAMPLES.mdDB2 SQL examples

Feature Overview

DRDA Protocol Support

HeliosDB implements the Distributed Relational Database Architecture (DRDA) protocol for DB2 compatibility:

FeatureStatusNotes
DRDA Level 3100%Full implementation
DRDA Level 4100%Extended features
DRDA Level 590%Advanced features
Authentication100%Password, Kerberos
Encryption100%SSL/TLS

DB2 SQL Compatibility

FeatureCoverageNotes
SQL Statements95%Standard DB2 syntax
Data Types100%All DB2 types
Built-in Functions90%Core functions
Stored Procedures85%SQL procedures
Triggers100%All trigger types

Connection Parameters

ParameterDefaultDescription
hostlocalhostServer hostname
port50000DRDA port
databaseheliosdbDatabase name
user-Username
password-Password

Driver Compatibility

DriverVersionStatus
IBM DB2 Driver11.5+Full
JDBC Type 44.xFull
ODBC11.xFull
.NET Provider11.xFull
Python ibm_db3.xFull

DB2 SQL Features

Supported Statements

  • SELECT with FETCH FIRST
  • INSERT, UPDATE, DELETE
  • MERGE statements
  • Common Table Expressions (CTEs)
  • Recursive queries
  • OLAP functions

DB2-Specific Syntax

-- FETCH FIRST
SELECT * FROM employees FETCH FIRST 10 ROWS ONLY;


-- WITH UR (uncommitted read)
SELECT * FROM employees WITH UR;


-- OFFSET/FETCH
SELECT * FROM employees
ORDER BY emp_id
OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;

Last Updated: December 2025 Consolidation Status: Complete