beautypg.com

Database administrator tasks – HP Integrity NonStop H-Series User Manual

Page 46

background image

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 (page 46)

.

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

This manual is related to the following products: