HP 3000 Manuals HP 3000 Manuals
Defining Databases on the HP 3000
If information you want to define as a table exists in a database on the
host or a remote HP 3000, specify that database as a data source.
To add, change, delete, or examine the data dictionary definition of
databases:
* Go directly to the screen you want by typing its screen name in
the Go to screen field of any menu and pressing Enter, or
* Choose a function label at the IMAGE Database Menu (IMD).
The IMAGE Database Menu looks like this.
______________________________________________________________________________________________
| |
| |
| CONFIG IMAGE Database Menu Screen: IMD |
| Choose a function, or type in a screen name and press ENTER. |
| |
| |
| Add Database - Add the definition of an IMAGE database. |
| |
| Change Database - Change the definition of an IMAGE database. |
| |
| Delete Database - Delete the definition of an IMAGE database. |
| |
| Show One Database - Show the group, account, system, database password, |
| open mode, and associated tables for one IMAGE database. |
| |
| List All Database - List the database name, group, account, and system for |
| all IMAGE databases. |
| |
| Done - Return to the Remote System Menu. |
| |
| |
| Go to screen |
| |
| Add Change Delete Show One List All Done |
| Database Database Database Database Database |
| |
______________________________________________________________________________________________
Adding a Database Definition
Add the definition of a database to the data dictionary at the Add IMAGE
Database (AIMD) screen, shown below. You must use this screen to define
a database before you can define any tables that derive their data from
it.
Table 4-1 describes the fields on the Add Image Database screen.
______________________________________________________________________________________________
| |
| |
| CONFIG Add Image Database Screen: AIMD |
| Type in the information and press ENTER. |
| |
| |
| |
| |
| Database.Group.Account . . |
| |
| |
| Remote System |
| |
| |
| Database Password |
| |
| |
| Open Mode |
| |
| |
| |
| |
| |
| Help Done |
| |
| |
______________________________________________________________________________________________
Table 4-1. Add IMAGE Database Screen Fields
--------------------------------------------------------------------------------------------
| | |
| Field | Description |
| | |
--------------------------------------------------------------------------------------------
| | |
| Database | Name of the database whose definition you want to add to the data |
| | dictionary. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Group | MPE group where the database resides. (The logon group on the host |
| | system is displayed as the default.) |
| | |
--------------------------------------------------------------------------------------------
| | |
| Account | MPE account where the database resides. (The logon account on the |
| | host system is displayed as the default.) |
| | |
--------------------------------------------------------------------------------------------
| | |
| Remote System | Name of the remote HP 3000 system on which the database is located. |
| | If you are defining a database on the host HP 3000, leave this field |
| | blank to indicate the host. |
| | |
| | If you want to define a database located on a remote HP 3000 system, |
| | you must define the remote system at the Add Remote HP 3000 System |
| | (A3) screen before you define its databases. (See "Adding a Remote |
| | HP 3000 System Definition" under "Defining HP 3000 Systems" in |
| | Chapter 3.) |
| | |
--------------------------------------------------------------------------------------------
| | |
| Database | IMAGE password used to open the database. |
| Password | |
| | Since IMAGE passwords are case-sensitive, you must enter them exactly |
| | as they were created. |
| | |
| | If this field is left blank, all datasets not secured by passwords |
| | will be checked to make sure that at least one is a detail or manual |
| | master dataset (the only kinds Access Server can configure). |
| | |
| | A database can have more than one password associated with it, each |
| | one representing a different view of the data. This field lets you |
| | define each such view separately. |
| | |
| | An alternate way to create different views of the data is to |
| | configure the database once with the password that gives the widest |
| | view of the data. Then use the screens available from the Add Table |
| | Menu (AT) to create narrower views of the data. (See "Adding..." |
| | under both "Defining IMAGE Tables" and "Defining View Tables" in |
| | Chapter 5.) |
| | |
--------------------------------------------------------------------------------------------
Table 4-1. Add IMAGE Database Screen Fields (cont.)
--------------------------------------------------------------------------------------------
| | |
| Field | Description |
| | |
--------------------------------------------------------------------------------------------
| | |
| Open Mode | Mode used to open the database (default is 5). Since Access Server |
| | allows for read access only, the open mode must be 5, 6, 7, or 8. |
| | These are the same as the IMAGE Access Modes described in the |
| | TurboIMAGE Data Base Management System Reference Manual. |
| | |
| | While Access Server is running, other applications with an open mode |
| | of 1 to 8 may already have the same database open (or may try to open |
| | it). (Modes 1 to 4 allow an application to change entries in the |
| | database). |
| | |
| | For shared read access compatible with other applications using an |
| | open mode of 1 or 5, use an open mode of 5. |
| | |
| | For shared read access compatible with other applications using an |
| | open mode of 2, 4, 6, or 8, use an open mode of 6. |
| | |
| | For esclusive read access, use an open mode of 7. No one else will |
| | be able to access the database during the time Access Server reads |
| | the data into the configured table, not even another PC user running |
| | Access PC or the Host Batch Facility. |
| | |
| | For shared read access that protects the database from modification |
| | while Access Server has the database open, use an open mode of 8. |
| | This is compatible with other applications using an open mode of 6 or |
| | 8. |
| | |
--------------------------------------------------------------------------------------------
To Add a Database Definition:.
1. Go to the Add IMAGE Database screen by typing AIMD in the Go to
screen field of any menu, or by choosing Add Database f1 at the
IMAGE Database Menu.
2. Type in the database name, the group and account, the remote
system name (if any), the database password (unless blank), and
the open mode (if not default).
3. To add the definition, press Enter.
The Administrator Utility attempts to open the database. (If the
database resides on a remote HP 3000 system, the Administrator
Utility verifies the remote connection by performing a remote
logon unless the remote session already exists. Then the database
is added.)
If the attempt succeeds, the database definition is added to the
data dictionary.
If the attempt fails, a message appears indicating the cause of
the failure. If the cause seems to be something you typed, the
field containing the error is highlighted. Correct the
information and press Enter to try again to add the database.
4. When the screen clears, the logon group and account is redisplayed
and you can add another database.
5. To leave this screen, choose Done f8. This returns you to the
IMAGE Database Menu. From there, you can go to another screen or
exit the utility.
Once all your database definitions have been successfully added to the
data dictionary, use the Add IMAGE Table (AIMT) and Add View Table (AVT)
screens to configure IMAGE tables and view tables from these databases.
Security Issues.
Databases can be protected by security measures that limit database
access across accounts. If this is the case, you can allow PC users to
access data as follows:
* Have users log onto the group and account where the database of
interest resides, or
* Allow any MPE user read access to the database files by using the
:ALTGROUP and :ALTACCT commands, or
* Release the database files with the RELEASE command in
DBUTIL.PUB.SYS.
(You'll find a complete discussion of these options in Chapter 2.)
Changing a Database Definition
Change a database definition already in the data dictionary at the Change
IMAGE Database (CIMD) screen. This screen displays the current
definition of the database you specify, in the same format as the Add
IMAGE Database screen.
You can change the Group, Account, Remote System, Password, and Open Mode
fields, but not the Database field. (For information about these fields,
see "Adding an IMAGE Database Definition," above.)
DBA Capabilities.
If you are a secondary DBA, you can change only a database definition
that you currently control.
Password Change Ground Rules.
The ground rules for changing the database password differ depending on
whether or not tables have been derived from the database.
If tables have not yet been derived from the database, you can change the
password to any valid password associated with this database. It does
not matter whether the new password gives the same view of the data as
did the old password.
If any tables have been derived from the database, change the password
only if the new password provides either:
* The same view of the data as the old password
* A broader view of the data that encompasses the old view
Example of the same view.
Suppose you are rebuilding a database and are changing the only valid
password OLD to the new password NEW. NEW will provide precisely the same
view of the data as OLD did. You use the Change IMAGE Database (CIMD)
screen to change the defined password to NEW. By altering the password
this way (instead of deleting and re-adding the database definition), you
avoid the automatic deletion of and need to re-add the IMAGE tables and
view tables derived from the old definition of the database.
Example of a broader view.
Suppose the original password PARTIAL provided a view of only one
dataset. Then, changing the password to the valid password TOTAL (that
provides a view of all datasets) does not disturb the operation of IMAGE
and view tables derived from the old database definition. Do not move to
a more restricted view (from TOTAL to PARTIAL, for example) unless all
the information from which tables have been derived is still accessible
using the more restricted password.
To Change a Database Definition:.
1. Go to the Change IMAGE Database screen by typing CIMD in the Go to
screen field of any menu or choosing Change Database f2 at the
IMAGE Database Menu.
2. Type in as much information as will uniquely identify the database
and press Enter. For example, if you have only one database named
DB1 defined in the data dictionary, typing DB1 in the Database
field is sufficient. However, if you are a secondary DBA, you
might have to enter more fields to identify the database because a
database with the same name may be controlled by another DBA.
If an entry exists for this database, the current definition of
the database is displayed.
3. Type in any changes to the Group, Account, Remote System,
Password, or Open Mode fields.
If you decide to leave the database definition unchanged, choose
Cancel Changes f8. The screen will clear and you can specify
another database to change or return to the IMAGE Database Menu.
_________________________________________________________________
NOTE You must enter the password exactly as it was created.
(IMAGE passwords are case-sensitive.)
If you leave the password field blank, all datasets not
secured by passwords will be checked to make sure that at
least one is a detail or manual master dataset (the only
kinds Access Server can configure).
Neglecting to enter a password can cause a wrong view of the
data to be configured.
_________________________________________________________________
4. To put the changes into effect, press Enter.
An attempt is made to open the database. (If the database resides
on a remote system, a remote logon is performed if the existing
remote session was created outside of the Administrator Utility.
A remote logon is not performed if the existing remote session was
created within the Administrator Utility.)
If the attempt succeeds, the database definition in the data
dictionary is updated. However, no checking is done to see if any
tables configured from the database are still correct. To check
the tables, use the Synchronization feature (see Chapter 9,
Synchronizing Tables).
If the attempt fails, an error message appears and the field
containing the error is highlighted. Type in the correct
information and press Enter, or choose Cancel Changes f8 to leave
the database definition unchanged.
5. When the screen clears, you can change another database
definition.
6. To leave this screen, choose Done f8. This returns you to the
IMAGE Database Menu. From there, you can go to another screen or
exit the utility.
Deleting an IMAGE Database Definition
Delete an unwanted database definition at the Delete IMAGE Database
(DIMD) screen.
Impact on PC Users.
Deleting a database definition has no effect on a user currently
accessing a configured table whose data derives from that database. The
user is working from a copy of the data created before the database
definition was deleted.
The next time this user or another user tries to access the same
configured table, however, an error message will appear.
DBA Capabilities.
If you are a secondary DBA, you can delete only a database definition
that you currently control and if you control all the tables associated
with it.
To Delete a Database Definition:.
NOTE Deleting a database definition also deletes the definitions of all
configured tables that are derived, in whole or in part, from that
database.
1. Go to the Delete IMAGE Database screen by typing DIMD in the Go to
screen field of any menu, or by choosing Delete Database f3 at
the IMAGE Database Menu.
2. Type in as much information as will uniquely identify the database
and press Enter. For example, if you have only one database named
DB1 defined in the data dictionary, typing DB1 in the Database
field is sufficient. However, if you are a secondary DBA, you
might have to enter more fields to identify the database because a
database with the same name may be controlled by another DBA.
3. Press Enter.
The Administrator Utility looks through the data dictionary for
the database name and any tables configured to it.
If there are no tables configured from the database, it is deleted
from the dictionary.
If one or more table definitions is derived from the database, the
following message will appear at the top of the screen:
There are tables associated with this database. The tables will
be deleted when the database is deleted. Do you really want to
delete?
Choose Yes f1 or No f8, whichever is appropriate.
4. When the screen clears, you can delete another database.
5. To leave this screen, choose Done f8. This returns you to the
IMAGE Database Menu. From there, you can go to another screen or
exit the utility.
Examining Database Information
Examine information about databases at the Show IMAGE Database (SIMD)
screen and at the List IMAGE Databases (LIMD) screen.
These screens provide two different ways to examine the definitions of
databases currently defined in the data dictionary:
* Display the definition of a specific database (Show), or
* Display a list of all defined databases (List)
Whether you Show or List depends on why you are referencing the
information. Here's what you'll see at each screen.
______________________________________________________________________________________________
| |
| |
| CONFIG Show IMAGE Database Screen: SIMD |
| Type in the information and press ENTER. |
| |
| Database.Group.Account . . |
| |
| Remote System |
| |
| Database Password |
| |
| Open Mode |
| |
| Tables on page of |
| |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| _____________ _____________ _____________ _____________ |
| |
| Print Previous Next Go To Help Done |
| Page Page Page |
| |
______________________________________________________________________________________________
_____________________________________________________________________________________________________________
| |
| |
| CONFIG List IMAGE Databases Screen: LIMD |
| Choose Done to return to the IMAGE Database Menu. |
| Page of |
| |
| DB Group Account Rem Sys DB Group Account Rem Sys |
| |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| ____ . ______ . ______ ______ ____ . ______ . ______ ______ |
| |
| Print Previous Next Go To Help Done |
| Page Page Page |
| |
_____________________________________________________________________________________________________________
DBA Capabilities.
If you are the primary DBA, you can examine the definitions of all
databases and display a list of all defined databases. If you are a
secondary DBA, you can examine only the definitions of databases that you
control. When you display a list of defined databases, only the ones you
control are shown.
To Show a Particular Database Definition:.
1. Go to the Show IMAGE Database screen by typing SIMD in the Go to
screen field of any menu or choosing Show One Database f4 at the
IMAGE Database Menu.
2. Type in as much information as will uniquely identify the database
and press Enter. For example, if you have only one database named
DB1 defined in the data dictionary, typing DB1 in the Database
field is sufficient. However, if you are a secondary DBA, you
might have to enter more fields to identify the database because a
database with the same name may already be defined by another DBA.
The group, account, system, database password, and open mode for
the specified database appear on the screen, as defined in the
data dictionary. Also displayed is a list of all configured
tables derived, in whole or in part, from this database. (If you
are a secondary DBA, only tables that you control are listed.)
3. If you want a printout of the database definition, choose Print
f1.
This sends a copy to the file ADMLIST, which prints to the default
or other specified printer.
4. To see the definition of another database, type in the new
database name over the old one and press Enter.
5. To leave this screen, choose Done f8. This returns you to the
IMAGE Database Menu. From there, you can go to another screen or
exit the utility.
To List All Currently Defined Databases:.
1. Go to the List IMAGE Databases screen by typing LIMD in the Go to
screen field of any menu or choosing List All Database f5 at the
IMAGE Database Menu.
If you are the primary DBA, an alphabetically sorted list of the
names of all databases in the data dictionary is displayed
automatically. If you are a secondary DBA, an alphabetically
sorted list of the names of databases you control is displayed.
Following each database name (DB) is the group, account, and
remote system name (blank if host) associated with that database.
If no databases are defined, a message appears to that effect.
2. If you want a printout of the complete listing, choose Print f1.
This sends a copy of the complete list to the file ADMLIST, which
prints to the default or other specified printer.
3. To leave this screen, choose Done f8. This returns you to the
IMAGE Database Menu. From there, you can go to another screen or
exit the utility.
To see the password, open mode, or tables associated with a particular
database listed, go to the Show IMAGE Database (SIMD) screen. (See "To
Show...", above.)