HP 3000 Manuals HP 3000 Manuals
ALLBASE/Replicate User's Guide 900 Series HP 3000 Computer Systems HP Part No. B2494-90005 Printed in U.S.A. Edition First Edition E1294
________________________________________________________________________ |The information in this document is subject to change without | |notice. | | | |Hewlett-Packard makes no warranty of any kind with regard to this | |manual, including, but not limited to, the implied warranties of | |merchantability and fitness for a particular purpose. Hewlett-Packard| |shall not be liable for errors contained herein or for direct, | |indirect, special, incidental or consequential damages in connection | |with the furnishing or performance or use of this material. | | | |Hewlett-Packard assumes no responsibility for the use or reliability | |of its software on equipment that is not furnished by Hewlett-Packard.| | | |This document contains proprietary information which is protected by | |copyright. All rights are reserved. Reproduction, adaptation, or | |translation without prior written permission is prohibited, except as | |allowed under the copyright laws. | ________________________________________________________________________ Copyright (c) 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994 by Hewlett-Packard Company ________________________________________________________________________ |Use, duplication or disclosure by the U.S. Government is subject to | |restrictions as set forth in subparagraph (c) (1) (ii) of the Rights | |in Technical Data and Computer Software clause at DFARS 252.227-7013 | |for DOD agencies, and subparagraphs (c) (1) and (c) (2) of the | |Commercial Computer Software Restricted Rights clause at FAR 52.227-19| |for other agencies. | | | |HEWLETT-PACKARD COMPANY | |3000 Hanover Street | |Palo Alto, California 94304 U.S.A. | | | |Use of this manual and flexible disk(s) or tape cartridge(s) supplied | |for this pack is restricted to this product only. Additional copies | |of the programs may be made for security and back-up purposes only. | |Resale of the programs in their present form or with alterations, is | |expressly prohibited. | ________________________________________________________________________ Restricted Rights Legend Printed 1994 Printing History The following table lists the printings of this document, together with the respective release dates for each edition. The software version indicates the version of the software product at the time this document was issued. Many product releases do not require changes to the document. Therefore, do not expect a one-to-one correspondence between product releases and document editions. Edition Date Software Version --------------------------------------------------------------------------------------- First Edition December 1994 36216-02A.01.G0 ALLBASE/SQL Manuals Title Customer Order Number -------------------------------------------------------------------------------------- ALLBASE/NET User's Guide 36216-90031 ALLBASE/SQL Advanced Application Programming Guide 36216-90100 ALLBASE/SQL C Application Programming Guide 36216-90023 ALLBASE/SQL COBOL Application Programming Guide 36216-90006 ALLBASE/SQL Database Administration Guide 36216-90005 ALLBASE/SQL FORTRAN Application Programming Guide 36216-90030 ALLBASE/SQL Message Manual 36216-90009 ALLBASE Pascal Application Programming Guide 36216-90007 ALLBASE/SQL Performance and Monitoring Guidelines 36216-90102 ALLBASE/SQL Reference Manual 36216-90001 HP ALLBASE/QUERY User's Guide 92534-90011 HP PC API User's Guide for ALLBASE/SQL and IMAGE/SQL 36216-90104 ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL 36216-90096 Up and Running with ALLBASE/SQL 36389-90011 Preface This manual presents the basic concepts, syntax, and semantics of ALLBASE/Replicate on HP 3000 computers running under the MPE/iX operating system. ALLBASE/Replicate is Hewlett-Packard's proprietary relational database replication product. This manual contains basic information about ALLBASE/Replicate as well as information about ALLBASE/SQL statements modified to support ALLBASE/Replicate and newly created ALLBASE/SQL statements unique to the operation of ALLBASE/SQL. All chapters are for experienced SQL users and SQL application programmers. The following briefly describes the contents of the chapters: * Chapter 1, "Introduction to ALLBASE/Replicate," gives an overview of fundamental ALLBASE/Replicate concepts and terms and describes the components of the resynchronization process. * Chapter 2, "Basic Concepts of ALLBASE/Replicate," describes basic ALLBASE/Replicate concepts including: partitions, partition configurations, audit elements, synchronization checkpoint record Arrays, audit logging, ALLBASE/SQL statements that support ALLBASE/Replicate, types of resynchronization, and other issues. * Chapter 3, "Soft Resynchronization," presents step-by-step instructions for setting up and using the soft resynchronization process. * Chapter 4, "Hard Resynchronization," presents the hard resynchronization techniques using: ISQL UNLOAD/LOAD, SQLUtil static STORE/RESTORE, and SQLUtil STOREONLINE and associated restore commands. * Chapter 5, "Hints and Suggestions," describes ways of managing both soft and hard resynchronization for several different ALLBASE/Replicate configurations including replication of: an entire DBEnvironment to a dedicated slave, a subset of a DBEnvironment to a dedicated slave, multiple master DBEnvironments to a single slave, two DBEnvironments in a two-way configuration, and non-ALLBASE/Replicate DBEnvironments that must be converted for use with ALLBASE/Replicate. * Chapter 6, "ALLBASE/Replicate Statement Syntax Reference," describes in detail the syntax and semantics for all ALLBASE/SQL statements that support ALLBASE/Replicate. * Appendix A, "ALLBASE/Replicate Messages," describes the messages, causes, and actions for all warning and error messages produced by ALLBASE/Replicate. Most of the examples in this manual are based on the tables, views, and other objects in the sample DBEnvironment called "PartsDBE." For complete information about PartsDBE, refer to appendix C, of the ALLBASE/SQL Reference Manual. Conventions UPPERCASE In a syntax statement, commands and keywords are shown in uppercase characters. The characters must be entered in the order shown; however, you can enter the characters in either uppercase or lowercase. For example: COMMAND can be entered as any of the following: command Command COMMAND It cannot, however, be entered as: comm com_mand comamnd italics In a syntax statement or an example, a word in italics represents a parameter or argument that you must replace with the actual value. In the following example, you must replace filename with the name of the file: COMMAND filename punctuation In a syntax statement, punctuation characters (other than brackets, braces, vertical bars, and ellipses) must be entered exactly as shown. In the following example, the parentheses and colon must be entered: (filename):(filename) underlining Within an example that contains interactive dialog, user input and user responses to prompts are indicated by underlining. In the following example, yes is the user's response to the prompt: Do you want to continue? >> yes { } In a syntax statement, braces enclose required elements. When several elements are stacked within braces, you must select one. In the following example, you must select either ON or OFF: COMMAND { ON } { OFF} [ ] In a syntax statement, brackets enclose optional elements. In the following example, OPTION can be omitted: COMMAND filename [OPTION] When several elements are stacked within brackets, you can select one or none of the elements. In the following example, you can select OPTION or parameter or neither. The elements cannot be repeated. COMMAND filename [ OPTION ] [ parameter] Conventions (continued) [...] In a syntax statement, horizontal ellipses enclosed in brackets indicate that you can repeatedly select the element(s) that appear within the immediately preceding pair of brackets or braces. In the example below, you can select parameter zero or more times. Each instance of parameter must be preceded by a comma: [,parameter][...] In the example below, you only use the comma as a delimiter if parameter is repeated; no comma is used before the first occurrence of parameter: [parameter][,...] |...| In a syntax statement, horizontal ellipses enclosed in vertical bars indicate that you can select more than one element within the immediately preceding pair of brackets or braces. However, each particular element can only be selected once. In the following example, you must select A, AB, BA, or B. The elements cannot be repeated. { A} |...| { B} ... In an example, horizontal or vertical ellipses indicate where portions of an example have been omitted. In a syntax statement, the space symbol shows a required blank. In the following example, parameter and parameter must be separated with a blank: (parameter) (parameter) The symbol indicates a key on the keyboard. For example, RETURN represents the carriage return key or Shift represents the shift key. CTRLcharacter CTRLcharacter indicates a control character. For example, CTRLY means that you press the control key and the Y key simultaneously.