CONTENTS Title Page Copyright Page Preface New and Changed Features 1 Introduction to Administrative Concepts 1.1 Administrator and Account Manager Responsibilities 1.2 Administrator and Operator Accounts 1.3 Database and Datafile Concepts 1.4 Server and Client Structures and Directories 1.4.1 Detached Processes 1.4.2 Global Sections 1.4.3 Logical Names for VMS 1.4.4 Environment Variables for UNIX, ULTRIX, and MS-DOS Clients 1.4.5 Logical Names for the VMS Central Process 1.4.6 Command Line Qualifiers Used When Invoking EDCS II 1.4.7 Specific Directory Files 1.4.8 Callable Interface Files 1.4.9 Database and Client Directory Structures and Directory Protection 1.4.10 Datafile Format 1.5 Data Flow 2 Configuring EDCS II 2.1 EDCS II Configuration with One Database 2.2 EDCS II Configuration with UNIX, ULTRIX, or MS-DOS Clients 2.3 EDCS II Configuration with Multiple Databases 2.4 VAXcluster Configuration with One Database 2.4.1 VAXcluster Configuration That Uses a Cluster Alias for EDCS II 2.4.2 VAXcluster Configuration That Does Not Use a Cluster Alias for EDCS II 2.4.3 EDCS_MAIL Process Considerations 2.5 Registering Clients and Databases 2.6 Adding Additional Servers to Your Configuration 2.7 Selecting an Appropriate EDCS II Configuration 3 Startup, Shutdown, and Tuning the System 3.1 Preparing for EDCS II Startup 3.2 Starting Up EDCS II 3.2.1 Specifying Command Line Qualifiers in the VMS Central Process Startup File 3.2.2 Controlling Notification During Detached Process Restarts 3.3 Tuning and Configuring Parameter Files 3.3.1 Placement of Parameter Files in a VAXcluster 3.4 Tuning and Configuring the Server Parameter File 3.4.1 Server Global Section Parameters 3.4.2 Multiple Utility Images on One Server 3.4.3 Multiple Command Processors on One Server 3.4.4 Mail Parameters 3.4.5 Review Timer Parameters 3.4.6 Server PROCESS_ENTRY Parameters 3.4.7 NOTIFICATION_DISK Parameter 3.4.8 RDB_ENTRY Parameter 3.4.9 DATA_DISK_ENTRY Parameter 3.4.10 CLIENT_ENTRY Parameters 3.4.11 Sample Server Parameter File 3.5 Tuning and Configuring the Client Parameter File 3.5.1 Client Global Section Parameters 3.5.2 Multiple Utility Images on One Client 3.5.3 Client PROCESS_ENTRY Parameters 3.5.4 DATABASE_ENTRY Parameters 3.5.5 Sample Client Parameter File 3.6 Tuning Detached Process Parameter Files 3.6.1 Improving File Transfer Performance 3.6.2 Double Verifying File Transfer 3.7 Shutting Down EDCS II 4 Account Manager Responsibilities 4.1 Creating User Accounts 4.1.1 Specifying User Names, Passwords, and Reasons 4.1.2 Assigning Privileges to Users 4.1.2.1 Assigning General Command Processing Privileges 4.1.2.2 Assigning Review Process Privileges 4.1.3 Specifying Mail Addresses 4.1.4 Specifying Personal Names 4.2 Copying User Accounts 4.3 Modifying User Accounts 4.4 Deleting User Accounts 4.5 Modifying Default Lists 4.6 Entering Log-In Notices 5 EDCS II Utilities 5.1 Archiving and Retrieving Elements 5.1.1 Archiving 5.1.1.1 Fetching Archived Elements ARCHIVE ELEMENT 5.1.2 Retrieving RETRIEVE ELEMENT 5.2 Verifying and Repairing a Database 5.2.1 Verifying a Database with the Verify Element Utility VERIFY ELEMENT 5.2.2 Verifying a Database by Using the Verify Files Utility VERIFY FILES 5.2.3 Verifying the Hierarchy of a Database VERIFY HIERARCHY 5.2.4 Repairing a Database REPAIR ELEMENT 5.3 Setting the Password for the Administrator Account SET PASSWORD 5.4 Suspending and Resuming a Database SUSPEND DATABASE RESUME DATABASE 5.5 Registering Clients REGISTER CLIENT 5.6 Adding a Disk for the Database ADD DISK_STRUCTURE 5.7 Showing the EDCS II System, Statistics, Databases, Clients, and Disks 5.7.1 Showing the EDCS II System SHOW SYSTEM 5.7.2 Showing EDCS II Statistics SHOW STATISTICS 5.7.3 Showing EDCS II Databases SHOW DATABASES 5.7.4 Showing EDCS II Clients SHOW CLIENTS 5.7.5 Showing EDCS II Disks SHOW DISKS 6 Managing the EDCS II Database and Datafiles 6.1 Loading Data into a Database 6.1.1 Load Database Restrictions 6.1.2 Creating an Input File 6.1.3 Information that You Must Supply 6.1.4 Sample Load Database Log File 6.1.5 Post Load Database Tasks 6.2 Renaming a Database 6.3 Backing Up and Restoring a Database 6.4 Journaling and Recovery 6.5 Defining Database Protection 6.5.1 Using RDO to Define, Change, and Delete Database Protection 6.5.2 Using VAX SQL to Grant and Revoke Database Protection 6.6 Changing the Physical Layout of a Database 6.7 Tuning a Database 6.7.1 Tune Database Command Procedure 6.7.1.1 Information that You Must Supply 6.7.1.2 Sample Tune Database Log File 6.8 Moving a Database 6.9 Moving Datafiles 6.10 Adding More Datafile Space 6.11 Showing Datafile Names Associated with Elements 6.11.1 Show File Restrictions 6.11.2 Information that You Must Supply 6.11.3 Sample Show File Log File 7 Recommendations and Troubleshooting 7.1 General Recommendations 7.1.1 Limit Concurrent Users 7.1.2 Limit Servers and Command Processors in Configurations 7.1.2.1 Factors that Influence Performance and Command Throughput 7.1.2.2 Guidelines for Multiple Command Processor Use 7.1.2.3 DECnet and SYSGEN Settings for Configurations with More Than Fifteen Remote Clients 7.1.3 Limit Batch Jobs 7.1.4 Use /NODELIVER Qualifier 7.1.5 Use Multiple Disks for Database Files 7.1.6 Relocate and Periodically Delete .AIJ File 7.1.7 Delete Global Sections 7.1.8 Limit Use of /IN_GROUP Qualifier 7.1.9 Limit Use of /MULTIPLE_FILE Qualifier 7.1.10 Refrain from Using Cancel Command and Ctrl/Y 7.1.11 Specify Other Characters with Wildcard Character ( * ) in SHOW Commands 7.1.12 Periodically Delete History Records 7.1.13 Limit DECnet MAX LINKS Parameter 7.1.14 Delete Temporary Files from the Scratch Directory 7.2 Troubleshooting 7.2.1 System Hang Due to Detached Process Failure 7.2.2 System Hang Due to Failure to Log Out of EDCS II 7.2.3 Failures That Occur in Configurations with Many Remote Clients 7.2.4 Inability to Execute EDCS II Commands Due to Unknown Passwords 7.2.5 Login Information Invalid 7.2.6 System Hang Due to Incorrectly Defined Logicals 7.2.7 Datafile Directories Become Full 7.2.8 Inability to Create Elements 7.2.9 Inability to Execute EDCS II Utility Commands 7.2.10 Client Cannot Connect to Server at Startup 7.2.11 Inability to Manipulate DECwindows Menus A Messages for Administrators ADMINNAME . . . ECASTARTING ECATOOLARGE . . . INVALIDDBNUM INVALIDDISK . . . NODIRFND NODISKS . . . OPERNAME OPERPRIV . . . SHUTINPROG STARTLINE . . . VERINVFILESPEC VERLOOSEFILE . . . VERWHICHFILE B Utility Commands Quick-Reference List ADD DISK_STRUCTURE device ARCHIVE ELEMENT element saveset REGISTER CLIENT nodename REPAIR ELEMENT element RESUME DATABASE RETRIEVE ELEMENT element SET PASSWORD new_password SHOW CLIENTS SHOW DATABASES SHOW DISKS database SHOW STATISTICS SHOW SYSTEM SUSPEND DATABASE VERIFY ELEMENT element VERIFY FILES VERIFY HIERARCHY EXAMPLES 3-1 Sample Server Parameter File 3-2 Sample Client Parameter File 5-1 Output from Show System Utility 5-2 Output from Show Statistics Utility 6-1 Load Database Example 6-2 Tune Database Example 6-3 Show File Example FIGURES 1-1 Directory Structure for Each Database Disk 1-2 Directory Structure for a Client 1-3 EDCS II Data Flow 2-1 EDCS II Configuration with Server and Client on Same Node 2-2 EDCS II Configuration with Server and Client on Separate Nodes 2-3 EDCS II Configuration with One Server and Multiple Clients 2-4 EDCS II Configuration with UNIX, ULTRIX, or MS-DOS Client 2-5 Multiple Database Configuration 2-6 VAXcluster Configuration with One Database 2-7 Configuration for Mainspring Clock Company 2-8 Configuration for Bobcat Bus Company 2-9 Configuration for Pharmaceutical Interests Laboratory 5-1 Verify Element Utility 5-2 Verify Files Utility 5-3 Looping of Groups in Hierarchy Structure Not Allowed by EDCS II 5-4 Looping of Groups in Hierarchy Structures that Require the Verify Hierarchy Utility 5-5 Car Group Looping Example 6-1 Physical Layout of an EDCS II Database TABLES 1-1 Administrator and Account_Manager Command Summary 1-2 Database Area Files 1-3 Detached Process Names and Functions 1-4 Global Sections 1-5 Logical Names for VMS 1-6 Environment Variables for UNIX, ULTRIX, and MS-DOS 1-7 Command Line Qualifiers Used When Invoking EDCS II 1-8 SYS$ERRORLOG Directory 1-9 SYS$HELP Directory 1-10 SYS$LIBRARY Directory 1-11 Each Individual User's SYS$LOGIN Directory 1-12 SYS$MANAGER Directory 1-13 SYS$MESSAGE Directory 1-14 SYS$SHARE Directory 1-15 SYS$STARTUP Directory 1-16 SYS$SYSTEM Directory 1-17 [EDCS] Directory on Notification Disk 1-18 [EDCS] Directory on Client Disk 1-19 [EDCS.FTX] Directory on Client Disk 1-20 Callable Interface Literal and Message Files 1-21 Callable Interface Sample Program Files 1-22 Protection for Database Directory Structure 1-23 EDCS II Database Subdirectories 1-24 Protection for Client Directory Structure 1-25 EDCS II Client Subdirectories 3-1 VMS Central Process Qualifiers 3-2 Parameters in Server Parameter File 3-3 Parameters in Client Parameter File 3-4 Parameter Files for the Detached Processes 3-5 Error Log Files for the Detached Processes 4-1 General Command Processing Privileges 4-2 General Command Processing Privilege Hierarchy 4-3 Review Process Privileges 4-4 Review Process Privilege Hierarchy 4-5 Default Lists 4-6 Notices Files 5-1 EDCS II Utility Commands 5-2 Archiving and Retrieving Overview 5-3 Verify and Repair Utilities Overview 5-4 Verify Element Error Messages 5-5 Verify Files Error Messages 5-6 Errors Fixed by the Repair Element Utility 5-7 Errors Not Fixed by the Repair Element Utility 6-1 RDO Statements for Defining, Changing, and Deleting Database Protection 6-2 VAX SQL Statements for Granting and Revoking Database Protection 6-3 Relations, Areas, and Indexes (Alphabetical by Relation Name) 6-4 Relations, Areas, and Indexes (Alphabetical by Area Name) 7-1 DECnet Parameter Settings for the Server Node A-1 Severity of Messages