HP 3000 Manuals HP 3000 Manuals
Printing Reports
There are two ways to print reports on configuration and status
information:
* From the Report on Configuration and Report on System Status
screens, for global types of reports
* Using the Print function label, for printing out information you
see on the screen(s) with which you're working
In either case, the printing or suppression of passwords is governed by
what you have chosen on the Password Options (PW) screen. (See
"Environment Configuration" under "Configuring the Data Dictionary" in
Chapter 2.)
All reports are output to the file ADMLIST, for which the default print
device is LP. To select a different device, you'll need to set up a file
equation before entering the Administrator Utility. For example, if you
have a laser printer configured with a device class PP, then the file
equation
:FILE ADMLIST;DEV=PP;ENV=LP2.HPENV.SYS
redirects your reports (and any printing done from List or Show screens)
to the laser printer, printing two pages per physical page. (Note: The
environment you specify must allow 132-character lines; otherwise, lines
will be truncated.)
Printing from Report Screens
You can produce reports about configuration and/or status by using the
Report screens in the Administrator Utility.
To use the Report screens:
* 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 in the Report Main Menu (RM).
The Report Main Menu looks like this.
______________________________________________________________________________________________
| |
| |
| REPORT Report Main Screen: RM |
| Choose a function, or type in a screen name and press ENTER. |
| |
| |
| Config - Report on configuration information. |
| |
| System Status - Report on system status information. |
| |
| ADMIN Main - Return to the Administrator Utility Main Menu. |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| Go to screen |
| |
| Config System Help ADMIN |
| Status Main |
| |
______________________________________________________________________________________________
Report on Configuration Screen
Produce a report about configuration at the Report on Configuration (ROC)
screen, which is shown below. Each printed report shows the name of the
primary DBA or secondary DBA who produced the report.
Table 10-1 describes each configuration report option.
DBA Capabiliities.
If you are the primary DBA, you can print all report options.
If you are a secondary DBA, you can print all report options except the
option for listing remote HP 3000 systems and their databases and files.
The reports you obtain will list only the data sources, tables, users,
and access groups that you control.
______________________________________________________________________________________________
| |
| |
| REPORT Report on Configuration Screen: ROC |
| Type in the information and press ENTER. |
| |
| Sel Report |
| |
| List all access groups and their users. |
| |
| List all users. |
| |
| List all tables. |
| |
| List all tables and related security information. |
| |
| List all remote HP 3000 systems and their databases and files. |
| |
| List all IMAGE databases and their associated tables. |
| |
| List all files and their associated tables. |
| |
| |
| |
| Select Help ADMIN |
| All Main |
| |
______________________________________________________________________________________________
Table 10-1. Report on Configuration Screen Fields
---------------------------------------------------------------------------------------------
| | |
| Option | Description |
| | |
---------------------------------------------------------------------------------------------
| | |
| List all access groups and their | This report lists each access group, its |
| users. | capability level, and the users associated with |
| | the access group. Secondary DBAs see only a list |
| | of the access groups they control. |
| | |
---------------------------------------------------------------------------------------------
| | |
| List all users. | This report lists each user, the access group the |
| | user belongs to, the number of tables each user |
| | has saved, the number of disc sectors those tables |
| | occupy, the maximum number of saved tables and |
| | sectors allowed each user, the user's priority |
| | queue, and whether or not the user has secondary |
| | DBA capability. Secondary DBAs see only a list of |
| | the users they control. |
| | |
---------------------------------------------------------------------------------------------
| | |
| List all tables. | This report lists information about all configured |
| | tables. For view tables, the Item, Using, Where, |
| | and Sort Clauses are listed. For IMAGE tables, |
| | the system, database, group, account, and dataset |
| | from which the table is derived are listed, along |
| | with the table description, item names, item |
| | types, item lengths, and (if a compound data |
| | item), the number of sub-items. For file tables, |
| | the system, file name, group, and account are |
| | listed, along with the table descriptions, item |
| | names, item types, starting byte, and item |
| | lengths. The controlling DBA is listed for all |
| | tables. Secondary DBAs see only a list of the |
| | tables they control. |
| | |
---------------------------------------------------------------------------------------------
| | |
| List all tables and related | This report duplicates the information in the |
| security information. | previous report, but adds a list of the access |
| | groups (if any) assigned to each table and item. |
| | Secondary DBAs see only a list of the tables they |
| | control. |
| | |
---------------------------------------------------------------------------------------------
Table 10-1. Report on Configuration Screen Fields (cont.)
---------------------------------------------------------------------------------------------
| | |
| Option | Description |
| | |
---------------------------------------------------------------------------------------------
| | |
| List all remote HP 3000 systems and | For each remote HP 3000 system defined in the data |
| their databases and files. | dictionary, this report lists the system name, the |
| | user and account names used to log on to the |
| | system, and the names and attributes of data |
| | sources defined for the system. A message is |
| | printed in the report if no data sources have been |
| | defined for a particular remote system. |
| | |
---------------------------------------------------------------------------------------------
| | |
| List all IMAGE databases and their | This report lists each database name, the group, |
| associated tables. | account, and system where the database resides, |
| | the open mode for the database, the controlling |
| | DBA, and the names of any tables associated with |
| | the database. For host databases, the system name |
| | is left blank. Secondary DBAs see only a list of |
| | the databases and associated tables they control. |
| | |
---------------------------------------------------------------------------------------------
| | |
| List all files and their | This report lists each file, the group, account, |
| associated tables. | and system where the file resides, the file type, |
| | the controlling DBA, and the names of any tables |
| | derived from the file. Secondary DBAs see only a |
| | list of the files and associated tables they |
| | control. |
| | |
---------------------------------------------------------------------------------------------
To Produce a Configuration Report:.
1. To produce reports on all the configurations listed on the screen,
choose Select All f1.
2. To produce a specific report, type an X next to the report option
you want and press Enter.
This sends a copy of the specified report to the file ADMLIST,
which prints to the default or other specified printer.
If you've chosen to suppress the printing of passwords, asterisks
will print in password fields.
3. When the screen clears, you can select another report.
4. To leave this screen, choose Done f8. This returns you to the
Report Main menu. From there, you can go to another screen or
exit the utility.
Report on System Status Screen
Produce a report on system status information at the Report on System
Status screen, which is shown below.
Table 10-2 describes each system status report option.
DBA Capabilities.
If you are a secondary DBA, you can print both report options. All
currently active users will be listed in the active users report.
However, only the saved tables that you control will be listed in the
saved table report.
______________________________________________________________________________________________
| |
| |
| REPORT Report on System Status Screen: ROS |
| Type in the information and press ENTER. |
| |
| Sel Report |
| |
| List all active users. |
| |
| List all saved tables. |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| Select Help ADMIN |
| All Main |
| |
______________________________________________________________________________________________
Table 10-2. Report on System Status Screen Options
---------------------------------------------------------------------------------------------
| | |
| Option | Description |
| | |
---------------------------------------------------------------------------------------------
| | |
| List all active users. | This report lists all PC users and Host Batch |
| | Facility users currently using Access Server. |
| | |
---------------------------------------------------------------------------------------------
| | |
| List all saved tables. | This report lists each saved table, the name of |
| | the user who saved it, and the number of disc |
| | sectors it occupies. Secondary DBAs see only a |
| | list of the saved tables they control. |
| | |
---------------------------------------------------------------------------------------------
To Produce a System Status Report:.
1. To produce reports on both system status options listed on the
screen, choose Select All f1.
2. To produce a specific report, type an X next to the system status
option you want and press Enter.
This sends a copy of the specified report to the file ADMLIST,
which prints to the default or other specified printer.
If you've chosen to suppress the printing of passwords, asterisks
will print in password fields.
3. When the screen clears, you can select another report.
4. To leave this screen, choose Done f8. This returns you to the
Report Main menu. From there, you can go to another screen or
exit the utility.
Printing From a Function Label
From any screen that shows Print for the f1 function label, choose that
function label to print out the information on all pages of the screen.
A copy of the information is sent to the file ADMLIST, which prints to
the default or other specified printer.
If you've chosen to suppress the printing of passwords, asterisks will
print in password fields.