Database administrator tasks – HP Integrity NonStop H-Series User Manual
Page 46
For a mixture of remote and local systems in one work environment, you can combine the suggested
assignments as fits your situation. For example, if you have separate development and production
systems, some local and some remote, each under one host system, your assignments might look
like
Figure 3-3 NonStop Software Management Role Assignment Example
In this example:
•
The assigned roles for the development systems and production systems are distributed
identically although they can be different people for each set of systems.
•
One planner is assigned to each host system, \SYSA.
•
One operator is assigned to all local targets, including the logical targets on \TARGB, \TARGC,
and the logical target on \SYSA.
•
One database administrator is assigned to all the local systems: \TARGB, \TARGC, and
\SYSA.
•
One operator and one database administrator are assigned to the remote target system,
\TARGD.
•
The operators and database administrators could be separate people, or one person could
hold both responsibilities, as your personnel availability allows.
Database Administrator Tasks
The database administrator uses NonStop Software Essentials, ZPHIHMI, and ZPHITMI to maintain
the software databases and perform other management tasks. Maintaining the software databases
requires an understanding of NonStop software management concepts and SQL database
administration concepts and procedures. The database administrator often initially installs NonStop
Software Essentials on systems and updates its configuration. Database administrator tasks include:
•
Adding, moving, renaming, or deleting archive volumes
•
Backing up and restoring archive subvolumes on tape
•
Viewing, modifying, and listing system profiles
•
Managing volumes for NonStop Software Essentials use on a target system
•
Managing the check-out of database items
46
Planning and Preparing the NonStop Software Management Environment