In the case of central administration, all DB configurations are addressed from a single console, i.e. every DBH involved can be started, administered and terminated from the same console.
It is also possible to administer multiple DB configurations centrally
with UDSADM via OMNIS
by using the software product OMNIS as of OMNIS Version 4.0.
A detailed description of OMNIS can be found in the OMNIS manuals “Functions and Commands” and “Administration and Programming”.via an administration program that uses the DCAM interface
(see section “Administration of UDS/SQL via DCAM”).
Central administration using OMNIS
OMNIS communicates messages between the database administrator and the DBHs to be managed, regardless of which hosts are running these DBHs.
Figure 27: Central administration using OMNIS
Starting and administering DBHs with OMNIS
For operational security reasons, it is advisable to start UDS/SQL as an ENTER job and to perform administration tasks via UDSADM or the DCAM interface.
All DBHs must be started with the DBH load parameter PP ADM=REMOTE (see PP ADM in chapter "DBH load parameters"). This causes every DBH to open a DCAM application for administration with the application name confname.
The database administrator connects OMNIS with these DCAM applications or starts UDSADM in multiple tasks and can then address all DBHs via OMNIS from one console.
If the connection to OMNIS is down, the database administrator can also manage the DB configuration locally.
Central administration can be resumed as soon as OMNIS is available again, assuming that the configuration is not being managed locally.