Fujitsu UDS/SQL V2.5 Network Router User Manual


 
Database design Database distribution
U929-J-Z125-9-76 47
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
18. Oktober 2007 Stand 11:29.49 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.k03
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
figure 7) or on the same host (see figure 8).
The UDS/SQL supplementary product UDS-D is required for operation with multiple
database handlers (see the “Database Operation” 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.
Inter-configuration consistency of all databases is maintained at all times during
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 figure 6.
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