HP 3000 Manuals

Running the Administrator Utility [ Information Access Server: Database Administration ] MPE/iX 5.0 Documentation


Information Access Server: Database Administration

Running the Administrator Utility 

Running the Administrator Utility 

Normally, you use this command to run the Administrator Utility:

         :RUN ADMIN.PPC.SYS

If you use the UDC (user-defined commands) file provided with Access
Server (ACUDC.PPCUTIL.HPOFFICE), typing

         :ADMIN

is equivalent to typing this command.

Running the utility with this command brings you to the Entry screen.
(This screen is pictured under "Entering the Administrator Utility,"
later in this chapter.)

The RUN command can also be issued with various PARM values to run the
utility in different ways.  A UDC is provided for each of these :RUN
strings to make the commands easy to issue.  A table at the end of this
section summarizes the purpose, PARM value, and UDC equivalent for each
string.

Controlling PC User Access While Running the Utility.   

If you are the primary DBA, occasionally you might want to keep your PC
users out of Access Server when you perform a task, then let them back in
when you're finished.  You'll need to do this when you:

   *   Create the Access Server environment initially.

   *   Configure sensitive data, because all users who pass MPE security
       can access a table for which security has not yet been defined.

   *   Alter dataset capacities or the database passwords for the HDPDIC
       and HDPENV databases, because unloading and loading the databases
       is required to accomplish these alterations.

For these occasions, a "software switch" is provided, using the PARM
feature of the :RUN string.


NOTE The user OPERATOR is a predefined user who can only run the Administrator Utility to make Access Server available or unavailable to users. (Primary DBAs can make Access Server available or unavailable; secondary DBAs do not have that capability.) If you are the primary DBA, it is recommended that you use the user OPERATOR to make Access Server available or unavailable if that step is part of an automatic or semi-automatic procedure (such as the WARM START of the HP 3000). By using the user OPERATOR instead of user ADMIN, you will be protecting your password from personnel who should typically not know it (such as the HP 3000 operators in your data center).
To make Access Server available to users, :RUN ADMIN.PPC.SYS;PARM=1;INFO="ADMIN" or :RUN ADMIN.PPC.SYS;PARM=1;INFO="OPERATOR" or type the UDC :ENABLEAC To make Access Server unavailable to users, :RUN ADMIN.PPC.SYS;PARM=2;INFO="ADMIN" or :RUN ADMIN.PPC.SYS;PARM=2;INFO="OPERATOR" or type the UDC :DISABLEAC Whenever Access Server is turned ON or OFF in this way, a check is performed to ensure that every definition of a saved table in the data dictionary has a corresponding MPE file containing the data for the saved table. (For details on this feature, see Chapter 8, "Configuring Security," and to "Saved Tables" in Chapter 12.) When Access Server is first installed, no user can access it. In other words, the "software switch" that determines whether users can use Access Server is in the OFF position. Regardless of whether Access Server is ON or OFF, you can run the Administrator Utility in all its functionality at any time. If there are any currently active users when you issue the DISABLEAC command, Access Server asks you to verify the request, then immediately terminates the task it was performing for each user, ends the user's remote access, and alerts Access PC, which issues an appropriate message to the user.
NOTE To prevent unauthorized users from running the Administrator Utility, we suggest putting a lockword on the program file ADMIN.PPC.SYS. You can do that by logging on as MANAGER.SYS,PPC and typing: :RENAME ADMIN, ADMIN/lockword When you run the utility, the MPE file system will ask you for the lockword before granting your request to run.
Functional List of UDCs That Run ADMIN. ----------------------------------------------------------------------------------------------- | | | | | UDC | Purpose | PARM | | | | | ----------------------------------------------------------------------------------------------- | | | | | ADMIN | Runs the Administrator Utility. | None. | | | | | ----------------------------------------------------------------------------------------------- | | | | | PARMHELP | Help text for Administrator Utility | PARM=-1 | | | parameters. | | | | | | ----------------------------------------------------------------------------------------------- | | | | | ENABLEAC | Makes Access Server available to PC users. | PARM=1 | | | | | ----------------------------------------------------------------------------------------------- | | | | | DISABLEAC | Makes Access Server unavailable to PC | PARM=2 | | | users. | | | | | | ----------------------------------------------------------------------------------------------- | | | | | CHGDICPASS | Notifies Access Server of new HDPDIC | PARM=3 | | | password. | | | | | | ----------------------------------------------------------------------------------------------- | | | | | CHGENVPASS | Notifies Access Server of new HDPENV | PARM=4 | | | password. | | | | | | ----------------------------------------------------------------------------------------------- | | | | | HOSTVERIFY | Verifies that all Access Server software on | PARM=5 | | | the HP 3000 is the correct version. | | | | | | ----------------------------------------------------------------------------------------------- | | | | | TUTORIAL | Resets configuration for DBA tutorial. | PARM=6 | | | | | ----------------------------------------------------------------------------------------------- | | | | | SITECHARSET | Specifies the site language. | PARM=8 | | | | | ----------------------------------------------------------------------------------------------- | | | | | TRANS | Runs the Translator utility. | None | | | | | ----------------------------------------------------------------------------------------------- | | | | | JSPURGE | Examines or deletes status entries in the | None | | | data dictionary. | | | | | | ----------------------------------------------------------------------------------------------- | | | | | GONOGO | Tests whether or not HDSP successfully | None | | | opens and runs in the Host Batch Facility. | | | | | | -----------------------------------------------------------------------------------------------
NOTE For a discussion about entering MPE commands in a file for execution when Information Access is started up, see "Using an IAFILE" in Chapter 12.

NOTE When running the Administrator Utility with only valid PARM values, an INFO string is used in the :RUN command to specify the user name and optional password that allows access to the utility. (If an invalid PARM value is suppliewd, the PARM HELP is displayed.) The syntax is: ;INFO="username/password" If you run the Administrator Utility with a non-negative PARM value and do not include the INFO string, or specify only a user name and not the user password, you will be prompted to enter the necessary information. You should take advantage of this if you do not want to keep user names and/or passwords in your UDC file.


MPE/iX 5.0 Documentation