Fujitsu UDS/SQL V2.5 用户手册
Database design
Database distribution
U929-J-Z125-9-76
47
D
ok
us
c
h
abl
on
en
1
9x
24 V
e
rs
ion
7
.3
us
f
ü
r F
ram
eM
ak
er
V
7
.x
v
o
m
1
4.
02
.2
00
7
©
c
o
gni
tas
Gm
b
H
20
01-
20
07
18
. Ok
tobe
r 20
07
S
ta
nd
1
1:
29
.4
9
P
fa
d:
G
:\
v
og
t\
fs
c
\ud
s
\M
anu
al
e
\e
n\
ud
s
e
nt
_e\
u
ds
ent
.k
0
3
Multiple DBHs - multiple databases
Multi-DB operation is also possible with databases belonging to other configurations. Other
configurations may be located on another host in a homogeneous BS2000 network (see
configurations may be located on another host in a homogeneous BS2000 network (see
) or on the same host (see
).
The UDS/SQL supplementary product UDS-D is required for operation with multiple
database handlers (see the “
database handlers (see the “
” manual). With UDS-D, a COBOL or
CALL DML application program, but not an SQL program, can access databases from two
or more different configurations within a single transaction, without requiring any infor-
mation on the location of the databases accessed. This means that multi-DB operation can
be extended to include UDS-D operation without any changes to existing application
programs.
or more different configurations within a single transaction, without requiring any infor-
mation on the location of the databases accessed. This means that multi-DB operation can
be extended to include UDS-D operation without any changes to existing application
programs.
Inter-configuration consistency of all databases is maintained at all times during
processing. UDS-D also provides inter-configuration deadlock detection and resolution.
processing. UDS-D also provides inter-configuration deadlock detection and resolution.
The following diagrams show the additional options provided by UDS-D, which are to be
understood as an addition to
understood as an addition to
Figure 7: Accessing databases on remote computers
AP1
APn
...
DB1
DBn
...
Computer 1
DBH
UDS-D
Configuration 1
AP1
APn
...
DB1
DBn
...
Computer 2
Configuration 2
Network
UDS-D
DBH