CONTENTS Title Page Copyright Page Send Us Your Comments Preface 1 Verifying and Rebuilding Repositories 1.1 Backing Up Repositories 1.1.1 Before You Begin a Backup 1.1.2 Locating Repositories 1.1.3 Regular Repository Backup 1.1.4 Restoring a Repository from a Regular Backup 1.2 Using the CDO VERIFY Command 1.2.1 Verifying Repository Condition 1.2.2 Logging Repository Verification 1.2.3 Recovering the Directory System 1.2.4 Reducing the Snapshot File 1.3 Moving a Repository 1.3.1 Moving a Repository to a Different Location on the Same Cluster 1.3.2 Moving a Repository from One System to Another System Not on the Same Cluster 1.3.2.1 Move Solution 1 1.3.2.2 Move Solution 2 1.3.2.3 Move Solution 3 1.3.2.4 Move Solution 4 1.3.2.5 Distributed Repository Move Operations Requiring Remote Network Proxy Access 1.3.2.6 Restrictions for Moving a Repository to Another System 1.3.3 Moving a DMU Dictionary to Another System 1.4 Deleting a Repository 2 Enhancing Repository Performance 2.1 Performance Concepts 2.2 General System Tuning Tasks 2.3 Performance Optimizations 2.3.1 Internal Operations During a Session 2.3.2 CHANGE and DEFINE FIELD Command Enhancements 2.3.3 CDO Commands Improve Performance 2.4 Tasks for the Repository Administrator 2.4.1 Designing the Repository Structure 2.4.2 Adjust the Working Set of the User 2.4.3 Managing the Physical Repositories 2.4.3.1 Linked Repositories 2.4.3.2 Separate Repositories 2.5 Maintaining the Repository 2.5.1 Monitoring Repository I/O Performance and Locking 2.5.2 Moving Repositories Off the System Disk 2.5.3 Trading I/O for Memory 2.5.4 Controlling the Number of Objects in Memory 2.5.5 Controlling Pages in Cache Memory 2.5.6 Using the CDD$WAIT Logical Name 2.5.7 Improving the I/O Performance of Repository Database 2.5.7.1 Moving Repository Database to Multiple Disks 2.5.7.2 Reducing Repository Database Extensions 2.5.7.3 Reducing Snapshots of the Database to Improve I/O 2.5.7.3.1 Enabled Immediate Snapshots 2.5.7.3.2 Enabled Deferred Snapshots 2.5.7.3.3 Disabled Snapshots 2.5.7.4 Reducing Index Node Depth 3 Upgrading a Dictionary or Repository 3.1 Preparing for an Upgrade of a Dictionary or Repository 3.2 Executing CDD$UPGRADE.COM 3.2.1 Submitting CDD$UPGRADE.COM in Batch Mode 3.2.2 Upgrading an Extended Repository 3.3 Using the CDO CONVERT/REPOSITORY Command 3.4 Using the CDDX Utility 3.4.1 Exporting with CDDX 3.4.2 Importing a Repository from an Export File 3.4.3 Sample Upgrade of Version 4.3 Dictionary 4 Using Oracle CDD/Repository with Oracle Rdb 4.1 Introduction 4.2 Creating Shareable Definitions 4.2.1 Examples of Creating Shareable Definitions 4.2.2 Creating Record Constraints 4.2.2.1 CDO DEFINE RECORD Syntax 4.2.2.2 CDO CHANGE RECORD Syntax 4.2.3 Differences Between CDO IN Clause and SQL IN Operator 4.3 Modifying Repository Definitions and Database Metadata 4.3.1 Modifying Repository Definitions Using CDO 4.3.2 Using SQL INTEGRATE to Synchronize the Repository and the Database 4.3.2.1 Modifying Repository Definitions Using SQL 4.3.2.2 Creating Repository Definitions Using SQL 4.3.3 Making a Database Table Shareable in the Repository 4.3.4 Changing a Field's Datatype Using CDO 4.3.5 Updating the Database File Using the Repository Definitions 4.4 Deleting Definitions Using SQL and CDO 4.5 Deciding Whether to Use Oracle CDD/Repository 4.6 Restoring a Database That Uses Shareable Repository Definitions 4.6.1 Backing Up and Restoring Databases 4.6.2 Restructuring and Reloading Databases 4.7 Deleting Databases EXAMPLES 1-1 Remote Test Sample 2-1 CDO SHOW Command Examples 2-2 Trading I/O with Memory During an Integrate Operation 2-3 RMU/DUMP Output Showing Extensions 2-4 Removing the Database Extensions 4-1 Defining Shareable Fields in CDO 4-2 Verifying Field Definitions 4-3 Defining a Record 4-4 Using Repository Definitions to Create a Database 4-5 Using the CDO DEFINE RECORD Command to Establish Primary, Unique, Check, and Foreign Key Constraints 4-6 Using the CDO DEFINE RECORD Command with NOT NULL and DEFERRABLE Field Attributes 4-7 Using CDO DEFINE RECORD Field Attributes to Specify BASED ON Attributes 4-8 Using CDO DEFINE RECORD Field Attributes to Specify BASED ON and ALIGNED ON Attributes 4-9 Defining Fields Using BASED ON Attributes within Record Definitions in Different Directories 4-10 Using the CHANGE RECORD Command to Add a New Field 4-11 Using the CHANGE RECORD Command to Delete a Constraint and Add a NOT NULL Field 4-12 Using the CDO CHANGE RECORD Command to Specify a Primary Key Constraint 4-13 Using the CHANGE RECORD Command to Delete a Field, Then Redefine It 4-14 Modifying Repository Definitions Using the INTEGRATE Statement with ALTER DICTIONARY Clause 4-15 Storing Existing Definitions in the Repository 4-16 Updating the Database to Match Repository Definitions 4-17 Using the CDO SHOW USES Command to Track the Uses of a Field 4-18 Repository Definition Not Removed After SQL DROP COLUMN 4-19 Deleting a Database Using the SQL DROP DATABASE PATHNAME Statement 4-20 Deleting a Database Using the SQL DROP DATABASE FILENAME Statement FIGURES 4-1 Sharing Repository Definitions Among Database Products 4-2 Shareable Fields in Oracle CDD/Repository TABLES 1 Documentation Conventions 1-1 Solution Choices for Remote Move Operations 1-2 Oracle CDD/Repository Version Compatibility 2-1 Number of Names Defined 2-2 Recommended Quotas 2-3 SQL INTEGRATE Changed Domain 3-1 Oracle Rdb Database and PGFLQUOTA Values 4-1 Modify Repository Definitions and Database Metadata