HP 3000 Manuals HP 3000 Manuals
Configuring the Data Dictionary
Configuring the Data Dictionary
The bulk of the tasks you can perform with the Administrator Utility are
those that allow you to configure the data dictionary. These tasks
include defining the data that can be accessed, the PC users who can use
Access Server, and which users can access which part of the data.
Impact on PC Users.
You can run the Administrator Utility at any time, whether Access Server
is currently being used or not.
After you initially configure the data dictionary you may want, for
example, to configure more tables or change which data particular users
can see. You can do so without disturbing your currently active users.
At times, if you are the primary DBA, you may want to "switch off" Access
Server, primarily when you are configuring a table containing sensitive
information. As soon as a table is configured, it is a public table
available to anyone, until at least one access group is assigned to it.
So you'd need to suspend Access Server, add the table, assign an access
group to it, then allow users into Access Server once more. (See the
discussion "Controlling PC User Access While Running the Utility," under
"Running the Administrator Utility," earlier in this chapter.)
Configuration Main Menu
The Configuration Main Menu sits atop the entire tree structure of menus
and screens with which you define entries in the Information Access data
dictionary.
At the Configuration Main Menu, function labels offer six kinds of
configuring tasks. Each of these tasks is presented as a separate
chapter following this chapter. The Configuration Main Menu is presented
here as an introduction to the variety of tasks. (For complete details
about each task, see Chapters 3 through 8.)
The tasks available from the Configuration Main Menu are menu paths that
let you define and maintain the following:
* HP 3000 Systems. Remote location of data source (if any).
* Data Source. Database or file from which to draw information.
* Access Group. Extent to which a group of users can define
information to be accessed (capabilities).
* User. Identification, access group (capabilities), and use of
system resources assigned to each valid user.
* Table. Form in which you want information to appear for users.
* Security. Limited access to specific information.
There are two ways to get to the screens where you actually add, change,
delete, or examine the data dictionary definitions for each kind of
configuration task:
* 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 Configuration Main Menu (CM).
The Configuration Main Menu looks like this.
____________________________________________________________________________________________
| |
| |
| CONFIG Configuration Main Menu Screen: CM |
| Choose a function, or type in a screen name and press ENTER. |
| |
| Remote Systems - Add, change, or display the definitions of remote |
| HP 3000 Systems. |
| |
| Data Sources - Add, change, or diplay the definitions of IMAGE databases, |
| or files. |
| |
| Access Groups - Add, change, or display access group definitions. |
| |
| Users - Add, change, or display user definitions. |
| |
| Tables - Add, change, or display table definitions. |
| |
| Security - Add, change, or display table security or item security. |
| |
| ADMIN Main - Return to the Administration Main Menu. |
| |
| |
| Go to screen |
| |
| Remote Data Access Users Tables Security Help ADMIN |
| Systems Sources Groups Main |
| |
____________________________________________________________________________________________
NOTE For a step-by-step illustration of the way entities are defined in
the data dictionary, please see Lesson 1:D, "How the Data
Dictionary is Configured" in the Information Access Server:
Learning the Administrator Utility manual.
Environment Configuration
At the Environment Configuration Menu (EC), the menu path you choose will
let you control password and lockword visibility, change the maximum
number of active users, change the maximum table size, and configure an
editor for adding and changing view tables.
To choose what part of the environment to configure:
* 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 Environment Configuration Menu
(EC).
The Environment Configuration Menu looks like this:
______________________________________________________________________________________________
| |
| |
| CONFIG Environment Configuration Menu Screen: EC |
| Choose a function, or type in a screen name and press ENTER. |
| |
| |
| Password Options - Set options to indicate whether passwords and lockwords |
| should be shown or suppressed in screens and in reports. |
| |
| Maximum Active - Display or change the maximum number of active users. |
| |
| Table Size - Change the maximum number of records allowed for a table. |
| |
| View Table Editor - Configure the editor used to define view tables. |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| Go to screen |
| |
| Password Maximum Table View Tab ADMIN |
| Options Activity Size Editor Main |
| |
______________________________________________________________________________________________
Controlling Password Visibility
Controlling Password Visibility.
Several screens in the Administrator Utility involve adding, changing, or
displaying passwords and lockwords of various kinds. Because of this,
there may be times when you want to prevent the display and printing of
passwords and lockwords.
The Password Options screen lets you set options that indicate whether
passwords for users, accounts, and data sources, and lockwords for files
should be shown or suppressed.
To reach the Password Options screen, type PW in the Go to screen field
of any menu, or choose Password Options f1 at the Environment
Configuration Menu.
To display or print passwords and lockwords, type any non- blank
character in either of the Show Passwords fields on the Password Options
screen and press Enter. To suppress the display or printing of passwords
and lockwords, leave the appropriate Show Passwords` field blank.
Here is what happens when you choose to display passwords:
* The Show Passwords (Screen/Print) field. On screens reached from
the Configuration Main Menu, passwords in data entry fields are
always shown because they can be added or changed.
You can, however, choose to show or suppress underlined passwords
on Show and List screens, since they appear in display-only
fields. This field also governs the printing of those same
password fields when you choose Print f1.
* The Show Passwords (Report) field. On reports generated from the
Report Main screen and from the Synchronization screens, this
field governs the printing or suppression of all password fields.
Suppressed passwords and lockwords are shown or printed as a string of
asterisks.
Default Settings.
When Access Server is first installed, the password options are set so
that all passwords on screens reached from the Configuration Main Menu
are displayed, and all passwords appearing in reports generated from the
Report Main screen are suppressed.
Changing Maximum Active Users
The Change Maximum Active Users screen lets you limit the number of
people using Access Server at one time.
To Change the Maximum Number of Active Users:.
1. Go to the Change Maximum Active Users screen by typing CA in the
Go to screen field of any menu, or choosing Maximum Active f2 at
the Environment Configuration Menu.
The screen shows you the current maximum number in the Max Active
Users field. (The default number is set in the data dictionary.)
2. Type in the new limit over the old, or blank out the field to
allow an unlimited number of users. ("Unlimited" actually means
the smaller of the capacities of the USER-ID- INDEX and
USER-MONITOR datasets in the data dictionary's HDPENV database.)
If you decide to leave the number unchanged, choose Cancel Change
f8. The Environment Configuration Menu returns.
_________________________________________________________________
NOTE If the current number of active users exceeds the new
maximum number, no new users will be able to use Access
Server or the Host Batch Facility until the current number
of users drops below the specified limit.
_________________________________________________________________
3. To put the change into effect, press Enter.
The entry in the data dictionary is updated and the Environment
Configuration Menu returns. From there, you can go to another
screen or exit the utility.
Changing Maximum Table Size
The Change Maximum Table Size screen lets you configure the maximum
number of records that can be retrieved during a query by Information
Access. The maximum number of records you can configure is limited to 2
million. Here are some guidelines for using this screen.
* Do not set your maximum table size too high. Access Server
allocates saved tables in 32 extents with one extent allocated
initially. For example, if you specified a maximum table size of
one million, then Access Server would open the file with a file
limit of one million, 32 extents, 1 extent initially allocated.
If the record size is one sector (256 bytes), then Access Server
would initially need a chunk of contiguous disc space that was
(one million / 32) = 31250 sectors. However, this would only be
temporary since Access Server closes all saved tables with the
"crunch" or "release space beyond the EOF" option of FCLOSE. In
the long run, no space is wasted. However, a large chunk of space
would be needed just to get started.
* It is better to leave the maximum table size smaller (100,000 is
the default). If you know ahead of time that a very large table
is to be loaded, you could then increase the maximum table size,
load the table, and then lower the maximum table size.
NOTE Maximum table size applies to the number of records that are
loaded. There is no limit to the size of the dataset or files that
Access Server can read from, as long as the select criteria
specified trims the number of records retrieved down below the
maximum table size.
To Change the Maximum Table Size:.
1. Go to the Change Maximum Table Size screen by typing MTS in the Go
to screen field of any menu, or by choosing Table Size f3 at the
Environment Configuration Menu.
The screen shows you the current maximum in the Max Table Size
field, as defined in the data dictionary.
2. Type in the new value in the Max Table Size field.
If you decide to leave the number unchanged, choose Cancel Change
f8. The Environment Configuration Menu returns.
3. To put the change into effect, press Enter.
The value is entered in the data dictionary and the Environment
Configuration Menu returns. From there, you can go to another
screen or exit the utility.
Configuring a View Table Editor
If you have a text editor on your HP 3000, you can use it for adding and
changing view table definitions. Access Server currently supports three
editors: EDITOR, TDP/3000, and HPEdit. However, you can configure other
HP 3000 editors such as QEDIT and QUAD for working with view table
definitions.
Configure an editor at the Configure View Table Editor screen, shown
below. Table 2-2 describes the fields in the Configure View Table Editor
screen.
_____________________________________________________________________________________________
| |
| |
| CONFIG Configuration View Table Editor Screen: CVTE |
| Type in the information and press ENTER. |
| |
| |
| |
| |
| |
| |
| |
| Editor.Group.Account . . Lockword |
| |
| Info Parm |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| Help Cancel |
| Changes |
| |
_____________________________________________________________________________________________
Table 2-2. Configure View Table Editor Screen Fields
--------------------------------------------------------------------------------------------
| | |
| Field | Definition |
| | |
--------------------------------------------------------------------------------------------
| | |
| User | Name assigned to the DBA user. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Editor | Program to run for the editor. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Group.Account | Group and account where the program file resides. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Lockword | The program file's lockword, if required. |
| | |
--------------------------------------------------------------------------------------------
| | |
| Info | Info string needed to run editor (optional). (Some |
| | editors might require an info string containing a prompt |
| | such as "Text filename." In this case, configure only |
| | "text." The Administrator Utility fills in the filename.) |
| | |
--------------------------------------------------------------------------------------------
| | |
| Parm | Parm value needed to run editor (optional). |
| | |
--------------------------------------------------------------------------------------------
To Configure a View Table Editor:.
1. Go to the Configure View Table Editor screen by typing CVTE in the
Go to screen field of any menu, or choosing View Tab Editor f4 at
the Environment Configuration Menu.
The screen shows you the current view table editor (if any) in the
Editor.Group.Account fields.
2. To add or change the view table editor, type the editor's program
file name and the group and account where the program file resides
in the Editor.Group.Account fields.
(If you are configuring EDITOR, TDP/3000, and HPEdit, you need
only fill in the Editor, Group, and Account fields.)
3. Type the program file's lockword, if required, in the Lockword
field.
4. Type the info string and parm value, if required, in the Info and
Parm fields. (It is not necessary to enclose the info string in
double quotes.)
5. To put the change into effect, press Enter.
The view table editor definition is entered in the data dictionary
and the Environment Configuration Menu returns. From there, you
can go to another screen or exit the utility.