Application shared libraries

Client

JDBC type 2, SQLJ

embedded SQL

JDBC type 4

DRDA

DRDA application requester

CLI, APIs

ADO ODBC/OLE DB

communication layer

Network

Netbios

shared memory

SNA

TCP/IP

named pipes

internode communication

Server Shared Libraries (Node 1   n)

Database Server

Base Support Utilities

communication layer

DRDA application server

Fast Communication

Load

Backup & Restore

db2agent

Logger

Deadlock Detector

Manager

Relational Data Services

Catalog

Access

 Services

 Plan

SQL Compiler

 Manager

Runstats

Data

Protection

Utilities

Services

Common Services

Run time Interpreter

Import

System

relational operations

Export

aggregation

Data Management Services

Locks

Monitor

group by

Index Manager

Load

Configuration

hash join

Sort

Transaction

Long and Large 

Management

Services

UDF

Object 

Backup

etc..

Manager

Restore

Logging

Data

Table Manager

Rollforward

Services

Buffer Pool Manager

prefetchers

page cleaners

Operating System Services

code page conversion

memory management

TCP/IP

file i/o

message queues

trace 

latching

semaphores

wait post

Operating System

Storage

Linux

UNIX

Windows

Figure 1 2   DB2 architecture overview

From a client server view, the client code and the server code are separated into 

different address spaces. The application code runs in the client process, while 

the server code runs in separate processes. The client process can run on the 

same machine as the database server or a different one, accessing the database 

server through a programming interface. The memory units are allocated for the 

database managers, database, and application. 

 Chapter 1. Introduction 

7