HP 3000 Manuals HP 3000 Manuals
When to Modify the Schemas
The schema file for HDPDIC is called SHDPDIC and is found in
PPCUTIL.HPOFFICE. The schema file for HDPENV is called SHDPENV and is
also found in PPCUTIL.HPOFFICE.
The only modifications you should make to the data dictionary schemas are
changes to the capacity of datasets and changes to the database
passwords.
Changing Dataset Capacities
You can modify the default capacities when the product is up and running,
as your users' data needs change, by modifying the schemas and streaming
a job (JDICTCHG.PPCUTIL.HPOFFICE) that unloads, rebuilds, and reloads the
data dictionary.
If you plan to reduce the default capacities, be aware that when the data
dictionary is initialized, Access Server requires for its own permanent
use:
* One entry in the REMOTE-SYSTEM dataset, used as a "dummy entry"
for the host HP 3000 system.
* Two entries in the DATA-SOURCE dataset: the database DIAGDB used
by Access Server diagnostics, and the database HDPENV (which can
be deleted) 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).
* Five entries in the ACCESS-GROUP dataset: the access groups
OPERATOR, DEFAULT-GROUP (which can be deleted), 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 OPERATOR (which can
be deleted), DEFAULT-USER (which can be deleted), ADMIN, DIAGHDP,
and DIAGUSER.
* At least as many entries in the TABLE-SECURITY dataset as there
are in the TABLE dataset.
In addition, the PC tutorial requires entries for one database, six IMAGE
tables, two view tables, two access groups, two users, and table security
for each of the eight configured tables. These entries can be
automatically configured using the UDC command PCTUTORIAL.
In the Configuration Rules below, when we speak of making one capacity
twice another, for master datasets we are speaking only roughly, since
the doubled capacity is then adjusted upward to reach the next prime
number.
Changing 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 proceeding as follows:
1. If Access Server has been installed and enabled, disable it. Use
either the UDC command DISABLEAC or
:RUN ADMIN.PPC.SYS;PARM=2;INFO="ADMIN/password"
2. Use a text editor to change the password in the schema file.
3. If the database whose password you're changing has not yet been
built and initialized, perform that operation before going to the
next step.
Otherwise, remove any maintenance words on the database, unload
it, purge it, rebuild it using the modified schema, and reload it.
(JDICTCHG.PPCUTIL.HPOFFICE can be used for this purpose. It
unloads, purges, rebuilds, and reloads both databases.)
4. To inform Access Server of the new password, 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 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
PPCSAVE.HPOFFICE.