HP 3000 Manuals HP 3000 Manuals
Table of Contents
Information Access Server: Database Administration
Information Access Server: Database Administration : COPYRIGHT NOTICE
Ch 1. Part I: OVERVIEW
Ch 1. Database Administration and Access Server
What Access Server Does
How Access Server Works
Description of Software
Data Dictionary
Administrator Utility
Translator Utility
Host Batch Facility
UDC File
The Database Administrator Tasks
Setting Up Access Server
Managing Access Server
Security Issues
You Decide Who Sees What
You Can Secure the Administrator Utility
Your PC Users' Saved Data is Safe
Data Access Across Groups and Accounts
Ch 2. Part II: THE ADMINISTRATOR UTILITY
Ch 2. Getting Started
What This Utility Lets You Do
What This Utility Lets You Do
Task Summary
Data Dictionary Databases: HDPDIC and HDPENV
Administrator Utility Screen Map
Administrator Utility Screen Map
DBA Capabilities
DBA Capabilities
Primary DBA Capabilities
Secondary DBA Capabilities
Rules
Assigning Secondary DBA Capabilities
How to Use the Screens
Menus and Screens
Menu Path
Menu Path Icons
How to Go to Any Screen
How to Go to Any Screen
Using the Menu Path
Going Directly to a Screen
Function Label Definitions
Function Label Definitions
On-Screen Help
Leaving a Menu or Screen
Next and Previous
Printing
When You Need Help
How to Exit
Running the Administrator Utility
Running the Administrator Utility
Controlling PC User Access While Running the Utility
Functional List of UDCs That Run ADMIN
Entering the Administrator Utility
Entry Screen
Main Menu
To Enter the Administrator Utility:
Configuring the Data Dictionary
Configuring the Data Dictionary
Impact on PC Users
Configuration Main Menu
Environment Configuration
Controlling Password Visibility
Controlling Password Visibility
Default Settings
Changing Maximum Active Users
To Change the Maximum Number of Active Users:
Changing Maximum Table Size
To Change the Maximum Table Size:
Configuring a View Table Editor
To Configure a View Table Editor:
Ground Rules
Order for Additions and Deletions
Impact on Active Users
Redirecting Printed Output
Reserved Words as Table and Item Names
When to Use the Translator Utility
Data Access Across Groups or Accounts
To Release Databases:
To Release Files:
Configuring for the Tutorial
Ch 3. Configuring Remote HP 3000 Systems
Defining Remote HP 3000 Systems
Adding a Remote HP 3000 System Definition
DBA Capabilities
To Add a Remote HP 3000 System Definition:
Maintaining Security
Changing a Remote HP 3000 System Definition
DBA Capabilities
Impact on PC Users
To Change a Remote HP 3000 System Definition:
Deleting a Remote HP 3000 System Definition
Impact on PC Users
DBA Capabilities
To Delete a Remote HP 3000 System Definition:
Examining Remote HP 3000 System Information
DBA Capabilities
To Show a Particular Remote HP 3000 System Definition:
To List All Currently Defined Remote HP 3000 Systems:
Ch 4. Configuring Data Sources
Data Sources Menu
Defining Databases on the HP 3000
Adding a Database Definition
To Add a Database Definition:
Security Issues
Changing a Database Definition
DBA Capabilities
Password Change Ground Rules
Example of the same view
Example of a broader view
To Change a Database Definition:
Deleting an IMAGE Database Definition
Impact on PC Users
DBA Capabilities
To Delete a Database Definition:
Examining Database Information
DBA Capabilities
To Show a Particular Database Definition:
To List All Currently Defined Databases:
Defining Files on the HP 3000
Using File Equations
Overriding FOPTIONs and AOPTIONs
Adding a File Definition
To Add a File Definition:
Security Issues
Changing a File Definition
DBA Capabilities
Change Checking
To Change a File Definition:
Deleting a File Definition
Impact on PC Users
DBA Capabilities
To Delete a File Definition:
Examining File Information
DBA Capabilities
To Show a Particular File Definition:
To List All Currently Defined Files:
Ch 5. Configuring Tables
About Tables
Table Menu
Adding a New Table
Adding a View Table Definition
DBA Capabilities
Using the Add View Table Screen
Compound Items
Binary File Output
To Add a View Table with the Add View Table Screen:
Using an Editor to Add a View Table
To Add a View Table With an Editor:
Maintaining Security
Table Menu (continued)
Adding an IMAGE Table Definition
DBA Capabilities
IMSAM Keys
To Add an IMAGE Table Definition:
IMAGE Data Conversion
Maintaining Security
Adding a File Table Definition
DBA Capabilities
To Add a File Table Definition:
File Data Conversion
Changing a Table Definition
DBA Capabilities
Compound Items
Adding or Changing IMSAM Keys
To Change a View Table Definition with the Change View and Table Screen:
To Change a View Table Definition with an Editor:
To Change an IMAGE Table Definition:
To Change a File Table Definition:
Deleting a Table Definition
Impact on PC Users
DBA Capabilities
To Delete a Table Definition:
Examining Table Definitions
DBA Capabilities
Showing a Table Definition
To Show a Particular Table Definition:
Show Item Characteristics
IMAGE Tables and View Tables
File Tables
Listing Tables
To List All Currently Defined Tables:
Copying or Renaming a Table Definition
DBA Capabilities
To Copy or Rename a Table:
To Rename a Table from which a View Table is Derived:
Ch 6. Configuring Access Groups
Access Group Menu
Adding an Access Group Definition
DBA Capabilities
To Add an Access Group Definition:
Changing an Access Group Definition
DBA Capabilities
To Change an Access Group Definition:
Deleting an Access Group Definition
Impact on PC Users
DBA Capabilities
To Delete an Access Group Definition:
Examining Access Group Information
DBA Capabilities
To Show a Particular Access Group Definition:
To List All Currently Defined Access Groups:
Ch 7. Configuring Users
User Menu
Default Users
Assigning Secondary DBA Capabilities
Adding a User Definition
DBA Capabilities
To Add a User Definition:
Changing a User Definition
DBA Capabilities
Impact on PC Users
To Change a User Definition:
Deleting a User Definition
Impact on PC Users
DBA Capabilities
To Delete a User Definition:
Examining User Information
DBA Capabilities
To Show a Particular User Definition:
To List All Currently Defined Users:
Ch 8. Configuring Security
Security Menu
Table Security Menu
Table Security Menu
Privileged Users
Adding Table Security by Table
DBA Capabilities
To Add Table Security by Table:
Deleting Table Security by Table
Impact on PC Users
DBA Capabilities
To Delete Table Security by Table
Adding Table Security by Access Group
DBA Capabilities
To Add Table Security by Access Group:
Deleting Table Security by Access Group
DBA Capabilities
To Delete Table Security by Access Group
Changing Default Table Security
To Change Default Table Security:
Examining Table Security Information
DBA Capabilities
To Show Table Security for a Specific Table:
To Show Table Security for a Specific Access Group:
Listing Public Tables
DBA Capabilities
To List Public Tables:
Item Security Menu
Adding an Item Security Definition
DBA Capabilities
Things to Know About Adding Item Security
To Add Item Security:
Deleting Item Security
Impact on PC Users
DBA Capabilities
To Delete Item Security:
Examining Item Security Information
DBA Capabilities
To Show Item Security for a Particular Item:
Changing a Controlling DBA
Changing the Controlling DBA for a Data Source
DBA Capabilities
To Change the Controlling DBA for an IMAGE Database:
To Change the Controlling DBA for a File:
Changing the Controlling DBA for an Access Group
DBA Capabilities
To Change the Controlling DBA for an Access Group:
Ch 9. Synchronizing Tables
About Synchronization
Why Problems Arise
When to Check
What's Checked
IMAGE tables
File Tables
View tables
Correcting Problems
Avoiding Problems
Selecting Tables to Synchronize
Selecting Tables to Synchronize
DBA Capabilities
To Check All Configured Tables Interactively:
To Check Individual Tables Interactively:
To Check Groups of Tables Interactively:
To Create and Process a Batch Input File:
Batch Input File Format
Examining Errors
Examining Errors
To Check for Errors:
Ch 10. Monitoring the Administrator Utility
System Status Main Menu
Examining User and Saved Table Information
DBA Capabilities
To List All Currently Active Users:
To List All Saved Tables:
To Show a Particular User's Saved Tables:
Deleting a Saved Table
Impact on PC Users
DBA Capabilities
To Delete a Saved Table Definition:
Printing Reports
Printing from Report Screens
Report on Configuration Screen
DBA Capabiliities
To Produce a Configuration Report:
Report on System Status Screen
DBA Capabilities
To Produce a System Status Report:
Printing From a Function Label
Ch 11. Part III: THE TRANSLATOR UTILITY
Ch 11. How to Use the Translator Utility
What This Utility Lets You Do
How the Utility Works
Limitations
DBA Capabilities
Running the Translator Utility
Entering the Translator Utility
Entering the Translator Utility
To Enter the Translator Utility:
Specifying the Dictionary
Specifying the Dictionary
To Specify a Dictionary/3000 Data Dictionary:
Specifying Databases
Specifying Databases
To Specify Which Databases to Translate:
Print Log File
Ch 12. Part IV: MANAGING THE SYSTEM
Ch 12. PC User Interaction with the Host HP 3000
Host Sessions
Establishing a Host Session
PC Users Running an MPE Interface Program
Using an IAFILE
The Spoolfiles HDSPERR and HDSPNSE
Saved Tables
Saving PC Result Tables on the Host
Saving Information as an ASCII File
Saving Information as a Binary File
Saving Information as a BRW/IRF File
Saved Versus Configured Tables
Restoring Saved Tables from a Backup Tape
T-Files and Saved Table Definitions
If a Saved Table is Deleted By Mistake
PC Users Running a Previous Release of Access PC
Ch 13. Batch Processing with Command Files
Batch Processing
How to Set Up Command Files
Ground Rules
Capturing a Session Model
Examples
Testing and Fine-Tuning the Command File
Command File Execution
Running the Job Through MPE or HDPBATCH
Frequently Used Commands
Establishing Access to the Host Batch Facility
SQL Command
Saving a Result Table
Concluding a Session
Other Useful Commands
Prompt Commands
Configuring a Database
Access Server Commands
Selecting and Manipulating Tables
Choosing Columns
Requesting a Query
Requesting a Sort
Requesting a Summary
Status and Error Tracking
Clearing the JOB-STATUS Dataset
Command Summary
Ch 14. Performance Tuning
Effective Utility Management
Configuration
System Status
Reports
Table Synchronization
Limits on Table Size
Handling Large IMAGE Tables
When Does a Load Occur?
Using the Where Clause to Reduce Table Size
Serial Reads Using the MATCH Operator
Chained Reads
Structuring for Chained or KSAM Keyed Reads
KSAM and IMSAM Keyed Reads
Partial Match
Ranges
Inequalities
Other Ways to Tune Performance
Using Access PC Command Files
Using the MPE Priority Queue
Ap A. Data Dictionary Information
When to Modify the Schemas
Changing Dataset Capacities
Changing Data Dictionary Passwords
Maintaining the Data Dictionary
Modifying Databases
Optimizing the Database Chains
Limits on Data Dictionary Size
The HDPDIC Database
Structure of HDPDIC Database
Size Considerations
Configuration Rules
Schema for HDPDIC Database
The HDPENV Database
Structure of HDPENV Database
Size Considerations
Configuration Rules
Schema for HDPENV Database
Ap B. Constructing View Tables
Some Simple Ways to Define View Tables
PRODUCTION Operation
JOIN Operation
Where Clause
More Advanced Ways to Define View Tables
Item Clause
SUB Function
Item Concatenation
CASE Statement
ROW Functions
Using Clause
Where Clause
Sort Clause
Example Showing View Table Flexibility
The IMAGE Tables
Three Ways to Create the Desired View of the Data
Using the SUB Function in the Item Clause
Using Concatenation in the Item Clause
Using the SUB Function in the Where Clause
Examples of JOIN Operations
JOINing Two Tables
JOINing Three Tables
JOINing Four Tables
Outer JOINs
IMSAM Composite Keys
Manipulating View Tables With the SQL Command
Selecting All Items
Query on Result
Configuring IMAGE Array Items
CASE Statement
Example 1
Example 2
SUB Function
Example 1
Example 2
JOINs
Example 1
Example 2
Left Outer JOINs
Three-Way JOINs
Summarize Operations
Ap C. View Table Syntax
Ap D. ISO-7 Support
Specifying Your Character Set
Mapping at a Glance
ISO-7 to ROMAN-8 Mapping
Standard Mappings
Mute Exception
ROMAN-8 to ISO-7 Mapping
Uniform Mappings
Dropped Diacritical Markings
Other Uniform Mappings
Variant Mappings
Limitations
Round Trips
Mute Languages
Sorting
Sorting Data
All Other Sorts
Selection Criteria
IMAGE and File Data
Wildcard Characters
GLOSSARY
INDEX
Index