Hp Integrity NonStop J-Series Manuel d'utilisateur

HP NonStop SQL DDL Replicator User’s GuideAbstractHP NonStop™ SQL DDL Replicator Software replicates NonStop SQL DDL operations to one or more backup

About This ManualHP NonStop SQL DDL Replicator User’s Guide—545799-007viChange Bar Notation

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-36TIMETIMEDisplays the current local time of day as obtained from the local Guardia

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-37LOGNORMAL is the default.TRACEdisplays low level activity for problem analysis an

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-38BACKUPCPUBACKUPCPUThe BACKUPCPU command specifies the cpu for the monitor backup

HP NonStop SQL DDL Replicator User’s Guide—545799-007A-1A SQL DDL StatementsThis appendix describes the SQL DDL statements that are replicated and, in

SQL DDL StatementsHP NonStop SQL DDL Replicator User’s Guide—545799-007A-2DDL StatementsCREATE INDEX If the CREATE INDEX statement contains the option

SQL DDL StatementsHP NonStop SQL DDL Replicator User’s Guide—545799-007A-3The RESTORE UtilityThe RESTORE UtilityWhen restoring SQL tables and indexes,

SQL DDL StatementsHP NonStop SQL DDL Replicator User’s Guide—545799-007A-4PHYSVOL References in StatementsSDR will translate catalog references even i

HP NonStop SQL DDL Replicator User’s Guide—545799-007B-1B SDR EMS MessagesIn each message description, the following information appears:Message numb

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-2Informational Messages103.Cause. The SDR monitor primary process or its CPU ha

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-3Informational MessagesEffect. Status information is placed in the EMS log.Reco

HP NonStop SQL DDL Replicator User’s Guide—545799-007iHP NonStop SQL DDL Replicator User’s GuideLegal Notices 1-1Introducing SDR 1-1Introduction 1-1Pr

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-4Informational Messages157Cause. A utility process started by SDR has unexpecte

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-5Informational Messages177Cause. An SDR updater has stopped, usually due to a s

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-6Informational Messages181Cause. After SDR has replicated SQL DDL, it tells the

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-7Informational MessagesEffect. The SDR updater will await further instructions

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-8Critical MessagesCritical Messages402Cause. The monitor process has been inten

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-9Critical Messages411Cause. A logic error has been detected by the process.Eff

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-10Critical MessagesEffect. The process abends.Recovery. Either correct the TMF

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-11Critical Messages451Cause. An SDRUPDT process on a remote system was not able

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-12Critical Messages455Cause. SDR was unable to obtain the label of a SQL table.

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-13Critical Messages459Cause. SDR encountered an error when using the IOEDIT rou

HP NonStop SQL DDL Replicator User’s Guide—545799-007iiDisabling DDL Capture 2-10Removing SDR Software 2-10Changes to RDF Operations 2-10ZRDF-EVT-Msg-

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-14Critical MessagesEffect. SDR updating is temporarily interrupted.Recovery. No

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-15Critical Messages468Cause. The file name in a NSA STOP UPDATE record is inval

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-16Critical MessagesRecovery. Correct the cause of the failure and the process w

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-17Critical MessagesEffect. The SQL DDL statement fails.Recovery. Either change

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-18Critical MessagesRecovery. If the operation is not successful after many retr

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-19Critical MessagesRecovery. Either correct the RDF NETWORK configuration or CA

SDR EMS MessagesHP NonStop SQL DDL Replicator User’s Guide—545799-007B-20Critical Messages490Cause. SDR DDL capture is configured as REQUIRED, but som

HP NonStop SQL DDL Replicator User’s Guide—545799-007C-1C Testing SDROverviewTesting of SDR is dependent on the resources available. If you have a sep

Testing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-007C-2Testing5. To prevent accidental updates, turn off replication by setting the RDFCON

Testing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-007C-3Testing Automated Operations on the PrimaryTo prevent the capture of DDL operations

HP NonStop SQL DDL Replicator User’s Guide—545799-007iiiDDL Capture Operation 4-4Special cases 4-5Create Catalog 4-5CREATE Collation 4-5User Transacti

Testing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-007C-4Testing Automated Operations on the Primary

HP NonStop SQL DDL Replicator User’s Guide—545799-0071IndexSymbols$ZSDRSDR monitor 4-1AACCESSIDSDR configuration 3-6AUTOCREATECATALOGSDR configuration

HP NonStop SQL DDL Replicator User’s Guide—545799-0072INCLUDE and EXCLUDE 3-2LOGFILE 3-2RDF network 3-1REPLICATEPURGE 3-1SMF virtual volumes 3-2UPDATE

HP NonStop SQL DDL Replicator User’s Guide—545799-007ivEXECUTE RDF-control 5-8CANCEL RDF-control 5-9RETRY RDF-control 5-10SDR Commands 6-1Running the

HP NonStop SQL DDL Replicator User’s Guide—545799-007vCOMMENT 6-30DELAY 6-30ENV 6-30EXIT 6-30FC AND! 6-30FILEINFO 6-31FILES 6-31HELP 6-32HISTORY 6-33L

HP NonStop SQL DDL Replicator User’s Guide—545799-007viTesting SDR C-1Overview C-1Setting up the Test Environment C-1Testing C-2Moving to production C

HP NonStop SQL DDL Replicator User’s Guide—545799-0071-11 Introducing SDR This manual describes HP NonStop SQL DDL Replicator (SDR). This section is a

Introducing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0071-2Product OverviewProduct OverviewSDR installs quickly. Once the product files ar

Introducing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0071-3Data FilesSDR Monitor ($ZSDR)The SDR monitor (SDRMON) is a NonStop process pair

Document History Part Number Product Version Published545799-005 NonStop SQL DDL Replicator AAE (Upd 5) March 2011545799-006 NonStop SQL DDL Replicato

Introducing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0071-4NonStop Kernel and RDF CompatibilityNonStop Kernel and RDF CompatibilitySDR is

HP NonStop SQL DDL Replicator User’s Guide—545799-0072-12 InstaThis section describes the installation of SDR. It covers the following topics:Prerequi

Installing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0072-2Move Files from the Product Media to the InstallationSubvolume6. Enable SQL for

Installing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0072-3Install Product FilesInstall Product FilesThe INSTALL macro is used for the init

Installing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0072-4Start an EMS distributorRunning INSTALL:If for any reason you want to install SD

Installing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0072-5Create the SDR System DatabaseCreate the SDR System DatabaseThe SDR System Datab

Installing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0072-6Install the SDR License1. Creates the REGISTRY table in subvolume $SYSTEM.SDRSYS

Installing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0072-7Enable SQL for DDL ReplicationAfter you have successfully installed your SDR lic

Installing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0072-8Install EMS templatesInstall EMS templatesThe file ZSDRTMPL contains EMS templat

Installing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0072-9Install Product Files for SDR Update1. Replace the SDR software components in th

Legal Notices Copyright 2012 Hewlett-Packard Development Company L.P. Legal NoticeConfidential computer software. Valid license from HP required for

Installing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0072-10Disabling DDL CaptureDisabling DDL CaptureTo disable SDR DDL capture, set the D

Installing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0072-11ZRDF-EVT-Msg-736RDF by monitoring RDF events. The installation of SDR on your s

Installing SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0072-12ZRDF-EVT-Msg-700, ZRDF-EVT-Msg-705In such RDF configurations, the operator can

HP NonStop SQL DDL Replicator User’s Guide—545799-0073-13 Configuring SDRThis section discusses the SDR configuration options and, because many functi

Configuring SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0073-2RDF Configurationtable partition. See the discussion below in Configuring the S

Configuring SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0073-3Configuring SDRConfiguring SDRThe following paragraphs describe global settings

Configuring SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0073-4Configuring SDR CaptureBy default, SDR allows the DDL operation to be performed

Configuring SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0073-5Configuring SDR ReplicationYou can configure how you want SDR to handle DDL ope

Configuring SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0073-6Configuring SDR ReplicationIn cases where the table is created on the backup sy

Configuring SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0073-7Configuring SDR ReplicationReplicating Unaudited TablesSDR is designed to opera

Configuring SDRHP NonStop SQL DDL Replicator User’s Guide—545799-0073-8Configuring SDR Replication

HP NonStop SQL DDL Replicator User’s Guide—545799-0074-14 SDR OperationsThis section describes how SDR captures, replicates and executes DDL operation

SDR OperationsHP NonStop SQL DDL Replicator User’s Guide—545799-0074-2DDL CaptureRule 1 - DDL CaptureThe “capture” or extraction of SQL DDL on any sys

SDR OperationsHP NonStop SQL DDL Replicator User’s Guide—545799-0074-3DDL Capture ArtifactsMarker FilesSDR Depot FilesSDR depot files are automatical

SDR OperationsHP NonStop SQL DDL Replicator User’s Guide—545799-0074-4DDL Capture Operation$DATA.ZASDR004.AA000123. Marker files are managed automatic

SDR OperationsHP NonStop SQL DDL Replicator User’s Guide—545799-0074-5Special casesSQL eventually commits or aborts the transaction used to perform th

SDR OperationsHP NonStop SQL DDL Replicator User’s Guide—545799-0074-6Special casesBecause there are additional files involved, there are potential is

SDR OperationsHP NonStop SQL DDL Replicator User’s Guide—545799-0074-7DDL ReplicationSee paragraph Handling DDL Operations performed under a User Tran

SDR OperationsHP NonStop SQL DDL Replicator User’s Guide—545799-0074-8SDR Updater ProcessesSDR Updater ProcessesThe SDR monitor is responsible for mon

SDR OperationsHP NonStop SQL DDL Replicator User’s Guide—545799-0074-9Replication OperationsRestarting RDF UpdateCreating the SDR Depot Files on the B

HP NonStop SQL DDL Replicator User’s Guide—545799-007iWhat’s New in This ManualManual InformationHP NonStop SQL DDL Replicator User’s GuideAbstractHP

SDR OperationsHP NonStop SQL DDL Replicator User’s Guide—545799-0074-10Replication Operationsreplicated. It simply monitors RDF and performs the assoc

SDR OperationsHP NonStop SQL DDL Replicator User’s Guide—545799-0074-11SDR and RDF TakeoverWhen executing replicated DDL, SDR reports SQL errors in th

SDR OperationsHP NonStop SQL DDL Replicator User’s Guide—545799-0074-12Distributed Table Replicationname contains a primary volume on the remote syste

HP NonStop SQL DDL Replicator User’s Guide—545799-0075-15 SDR Monitoring and ControlThis section describes the commands available to query the status

SDR Monitoring and ControlHP NonStop SQL DDL Replicator User’s Guide—545799-0075-2STATUS CommandsSDRLOG is created when the first DDL operation is rep

SDR Monitoring and ControlHP NonStop SQL DDL Replicator User’s Guide—545799-0075-3STATUS CommandsSTATUS SDRSTATUS SDR shows a combined summary of RDF

SDR Monitoring and ControlHP NonStop SQL DDL Replicator User’s Guide—545799-0075-4Controlling ReplicationSTATUS UPDATEThe STATUS UPDATER command shows

SDR Monitoring and ControlHP NonStop SQL DDL Replicator User’s Guide—545799-0075-5Monitor-Level CommandsMonitor-Level CommandsThe SDR monitor starts a

SDR Monitoring and ControlHP NonStop SQL DDL Replicator User’s Guide—545799-0075-6Updater-level CommandIn the following example, STATUS UPDATE shows t

SDR Monitoring and ControlHP NonStop SQL DDL Replicator User’s Guide—545799-0075-7Updater-level CommandRETRY RDF-controlYou must be a SUPER user to ex

HP NonStop SQL DDL Replicator User’s Guide—545799-007ii

SDR Monitoring and ControlHP NonStop SQL DDL Replicator User’s Guide—545799-0075-8Updater-level CommandIn the following example, the SDR updater is on

SDR Monitoring and ControlHP NonStop SQL DDL Replicator User’s Guide—545799-0075-9Updater-level CommandIn the example below, the updater is in a hold

SDR Monitoring and ControlHP NonStop SQL DDL Replicator User’s Guide—545799-0075-10Updater-level Command RETRY RDF-controlIf an updater has a pending

SDR Monitoring and ControlHP NonStop SQL DDL Replicator User’s Guide—545799-0075-11Updater-level CommandThe operator purges the table on the backup sy

SDR Monitoring and ControlHP NonStop SQL DDL Replicator User’s Guide—545799-0075-12Updater-level Command

HP NonStop SQL DDL Replicator User’s Guide—545799-0076-16SDR CommandsThe command interpreter for SDR, SDRCOM, is used to install, configure, control a

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-2Command Syntaxcommand also restores all parameters displayed by the ENV command to

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-3Command Description Overview.INFO GLOBALS Displays SDR global valuesINFO MONITORDi

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-4Command Description OverviewTable 6-3. Monitor commandsLOG Output a copy of comman

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-5SDR Configuration and Management CommandsSDR Configuration and Management Commands

HP NonStop SQL DDL Replicator User’s Guide—545799-007iiiAbout This ManualThis manual describes the uses, installation, and all other operational aspec

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-6ALTER GLOBALSetting the global ACCESSID to USER[ID] instructs the SDR updater to u

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-7ALTER GLOBALIf SDR aborts a DDL operation on the primary system, a message is logg

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-8ALTER GLOBALRDF-control-subvol is an RDF configuration in the format node[suffix-c

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-9ALTER GLOBALsets the retention period for SDR Depot records that store captured DD

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-10ALTER MONITORALTER MONITORAlters monitor attributes process priority, home termin

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-11CREATE SYSDBor SDR network specification can make it impossible to restart update

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-12EXECUTEEMSCOLLECTOR $colllan EMS collector process where all SDR event messages a

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-13INFO MONITORINFO MONITORDisplays the SDR monitor process attributes.INFO RUNTIMEL

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-14READLOGINSTALL SDR must be repeated when a new version of SQL is installed on you

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-15RELEASEIf LAST is omitted, all entries within the specified interval are displaye

About This ManualHP NonStop SQL DDL Replicator User’s Guide—545799-007ivGeneral Syntax Notation{ } Braces. A group of items enclosed in braces is a

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-16RESTART UPDATE*all global parameters. In this case, the keyword GLOBAL is require

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-17START MONITORSTART MONITORStarts a SDR monitor process. You must be a SUPER user

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-18START UPDATENote that an EMS collector is not a valid Guardian home terminal. If

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-19STATUS RDF-control-subvolHOLD applies only to updaters for current RDF configurat

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-20STATUS SDRSTATUS SDRDisplays the state of DDL replication. It also checks the sta

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-21UNINSTALL SDRRDF-control-subvolan RDF configuration in the format node[suffix-cha

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-22ALTER FILEALTER FILEUtility command similar to the FUP ALTER command. Changes att

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-23ALTER FILEspecifies whether buffered writes are performed. If NO BUFFERED is spec

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-24COPYCOPYSimilar to the FUP COPY command with enhancements. Copies records from an

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-25COPYin-file file containing data to be copied.in-file can be a process, tape, ter

About This ManualHP NonStop SQL DDL Replicator User’s Guide—545799-007vChange Bar Notationa blank line. This spacing distinguishes items in a continu

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-26COPYCOUNT num-recordsthe number of records or rows to be copied. If omitted, all

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-27COPYnumber of bytes between 1 and 32767 in an input block that is requested in a

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-28COPYThis option applies to key sequenced files only.TRIM trim-characterdelete any

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-29COPYoutput tape is rewound (or not rewound) after the copy operation has complete

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-30COMMENTNO HEADomit the heading preceding each record when one of the display-opti

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-31FILEINFOThe default is the immediately previous command.integer (positive) spec

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-32HELPHELPLists the help options for SDR commands, MONITOR commands and the SDR def

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-33HISTORYis the name of the DEFINE. HELP displays the syntax and a description of t

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-34MONITORMONITORThe MONITOR command sends a command to the monitor process. Refer t

SDR CommandsHP NonStop SQL DDL Replicator User’s Guide—545799-0076-35SEMICOLONfilenamespecifies a program file to be run.run-optionsspecifies standard