HP 3000 Manuals HP 3000 Manuals
Modifying the Schemas
If you've gathered your information and decided to modify the data
dictionary schema files, you can do that now by following the
instructions provided in "To Modify," later in this section.
The only modifications you should make to the data dictionary schemas are
changes to the capacity of datasets and changes to the database
passwords.
The schema file for HDPDIC is called SHDPDIC and the schema file
for HDPENV is called SHDPENV. Both schema files are found in
PPCUTIL.HPOFFICE.
Data Dictionary Passwords
The passwords found in the schemas for HDPDIC and HDPENV are the ones
Access Server will use to access the data dictionary. You can, however,
change either password at any time by modifying the schema file,
rebuilding the database, and letting Access Server know about the change.
Dataset Capacities
If the default capacities do not match your requirements, you can reduce
or increase them once the product is up and running, by modifying the
schemas and streaming the job JDICTCHG in PPCUTIL.HPOFFICE. This job
unloads, rebuilds, and reloads the data dictionary.
If you plan to reduce the default capacities, be aware that Access Server
requires the following files for its own permanent use:
* Two entries in the REMOTE-SYSTEM dataset: one of these is an
unnamed entry used as a "dummy" for the host HP 3000 system, the
other for mainframe processing.
* Two entries in the DATA-SOURCE dataset: the database DIAGDB used
by Access Server diagnostics, and the database HDPENV (which can
be deleted after installation) for defining the JOB-STATUS table.
(The database entry for HDPENV configures it with a blank database
password, which allows read access to the JOB-STATUS dataset
only.)
* Four entries in the TABLE dataset: the IMAGE tables DIAGTABLE01,
DIAGTABLE02, and DIAGTABLE03 used by Access Server diagnostics,
and the IMAGE table JOB-STATUS (which can be deleted after
installation).
* Five entries in the ACCESS-GROUP dataset: the access groups
DEFAULT-GROUP and OPERATOR (both of which can be deleted after
installation), plus the access groups ADMIN, DIAGNOSTICS, and a
"dummy" entry used to link this dataset to the ITEM dataset for
item security purposes.
* Five entries in the USER dataset: the users DEFAULT-USER and
OPERATOR (both of which can be deleted after installation), and
the permanent users ADMIN, DIAGHDP, and DIAGUSER.
* At least as many entries in the TABLE_SECURITY dataset as there
are entries in the TABLE dataset.
For more information about the data dictionary entries, see "Permanent
Entries," and "Entries You Can Delete," later in this chapter.
To Modify the Schemas
The job JDICTCHG.PPCUTIL.HPOFFICE can contain commands to expand or
contract the HDPDIC and HDPENV databases, or to change their passwords.
1. Use a text editor to change the password and/or capacities in the
schema files SHDPDIC and SHDPENV in PPCUTIL.HPOFFICE.
2. If Access Server has been installed and enabled, disable it. The
primary DBA or the user OPERATOR can do this by using the UDC
command DISABLEAC, or by typing
RUN ADMIN.PPC.SYS;PARM=2;INFO="username/password"
If you do not supply the INFO string, you will be prompted for the
user name (ADMIN or OPERATOR) and password. If you supply only
the user name, you will be prompted for the password.
3. Remove any maintenance words on the databases.
4. Remove passwords from MGR.HPOFFICE, PPCDICT, and PPCUTIL.
5. Stream JDICTCHG.PPCUTIL.HPOFFICE. This job unloads the HDPDIC and
HDPENV databases, purges them, rebuilds them using the schema
files you've modified, and reloads them.
6. Restore any maintenance words to the databases.
7. Restore passwords to MGR.HPOFFICE, PPCDICT, and PPCUTIL.
To inform Access Server of any new passwords, run ADMIN.PPC.SYS with
PARM=3 for a change to HDPDIC's password, or PARM=4 for a change to
HDPENV's password. (The UDC commands CHGDICPASS and CHGENVPASS contain
the equivalent :RUN statements.)
For example, if you use the UDC command CHGDICPASS or type
RUN ADMIN.PPC.SYS;PARM=3
You'll be prompted for HDPDIC's new password. ` Type it exactly as you
created it in the schema file (uppercase and lowercase are significant).
The password is not echoed on the screen.
Access Server checks the password by trying a DBOPEN against the
database. If it is successful, Access Server "remembers" the new
password and tells you it has been successfully changed; otherwise, an
appropriate error message is displayed and the old password remains
unchanged.
NOTE The passwords for HDPDIC and HDPENV are stored, encrypted, in
the privileged files HDPDICPW and HDPENVPW in the group
PPCDICT.HPOFFICE.
After the data dictionary is built, you might want to put a lockword on
the schema files, rename them, or remove them, since they contain
encrypted passwords.