4Transaction Management | Compaq AA-Q88CE-TE guide

Transaction Management

4.1 Overview

This is the case where, for example, a server crashed while performing an SQL commit immediately after receiving a mt_accepted message. The transaction is in COMMIT state as recorded in the RTR journal and the transaction is also committed in the underlying database.

After the SET TRANSACTION command is executed the DUMP JOURNAL command can be used to verify the result.

4–4Transaction Management

Image 54

Compaq AA-Q88CE-TE manual 4Transaction Management

Contents

Reliable Transaction Router System Managers Manual June Contents Transaction Management RTR Monitoring RTR Command Line Interface 104 100103 105 Creating Monitor Pictures Server Shadowing and RecoveryRTR Utility Error Messages RTR log messages Index Examples XA Support Tables Arithmetic Operators in Display Commands Page Purpose of this Manual Intended AudienceStructure of Document Related Documentation Readers CommentsConventions Conventions Used in this Guide Convention MeaningPage Entering Commands Getting Started Introduction Entering Commands Online Help Introduction Online Help Command ProceduresRemote Commands Rtralrsta Introduction Remote Commands Setting Up-An Example Introduction Starting and Setting Up RTR Setting Up-An Example FrontendsFERoutersTRBackendsBEExample 2-1 Local Conﬁguration of each Node Creating a Recovery Journal Example 2-2 Remote Setup from one Node Starting and Setting Up RTR Creating a Recovery Journal Changing a Facility Starting and Setting Up RTR Changing a Facility Example 2-3 Reconﬁguration Using Delete and Create Facility O N T E N D S U T E R S Setting up Callout Servers Example 2-4 Reconﬁguration Using Extend Facility Starting and Setting Up RTR 2.5 Setting up Callout Servers Router Load BalancingExample 2-5 Conﬁguration of Callout Servers Starting and Setting Up RTR Router Load Balancing Setting RTR Privileges on Unix SystemsRTR Privileges Setting RTR Privileges on Windows NT Systems Starting and Setting Up RTR RTR PrivilegesSetting RTR Privileges on OpenVMS Systems RTR ACP Virtual Memory Sizing Starting and Setting Up RTR RTR ACP Virtual Memory Sizing Astlm Biolm Diolm Fillm Pgflquota Unix Virtual Memory Sizing Network Transports Specifying the Link Transport Protocol TCP Services File Using the Tunnel PreﬁxTroubleshooting Tunnel and Wildcard Connections Anonymous Clients Starting and Setting Up RTR Network Transports Interoperation with RTR Version 2 Using DECnet Running RTR as a Service on Windows NT Network Protocol Selection on OpenVMS$ DEFINE/SYSTEM Rtrprefprot Rtrdnafirst Files Created by the RTR Windows NT Service How RTR Selects Processing-states Roles for Nodes Role Assignment for Backend Node PartitionsActive Show Partition command on each backend node is as follows Router Backend a Backend B SET Partition test/PRIORITYLIST=bronze,gold Router Selection Router Site a Node-A1 Site B Node-B1 Node-A2 Node-B2 RTR Create Facility test/FRONTEND=Z/ROUTER=A,B,C What is a Partition? What is Partition Management?Overview Partition Naming Life Cycle of a Partition Binding Server Channels to Named Partitions Explicit Partition CreationPersistence of Partition Deﬁnitions Command Line Usage Entering Partition CommandsPartition Management Entering Partition Commands Programmed Partition Management Controlling Shadowing Command Line ExampleManaging Partitions Programming Information Controlling Recovery Example usage of the qualiﬁers Partition Management Managing Partitions Controlling the Active Site Controlling Failover Char Controlling Transaction Replay Rtruns32t newLimit RTR$DEFAULTFACILITY Displaying Partition InformationPartition Management Displaying Partition Information Transaction Management Command Line Examples Transaction Management OverviewException Transactions Transaction Management Overview Transaction State Changes 19 Valid Transaction State Transitions 4Transaction Management RTR Monitoring Standard Monitor Pictures RTR Monitoring Standard Monitor Pictures Standard Monitor Pictures Cont Standard Monitor Pictures Monitor Accfail Link Acceptance Failures Dmark DEC.ZKO.DMARK Monitor ACP2APP Monitor Broadcast RTR Monitoring Standard Monitor Pictures Monitor ActiveMonitor APP2ACP PID -ALL Monitor Connects RTR Monitoring Standard Monitor Pictures Monitor CallsMonitor Channel Calls Monitor Event Monitor Facility RTR Monitoring Standard Monitor Pictures Monitor Flow Monitor GroupMonitor Group Fields RTR Monitoring Standard Monitor Pictures Monitor IPC Monitor IpcrateMonitor Journal Monitor Link Monitor Netbytes RTR Monitoring Standard Monitor Pictures Monitor Netstat Monitor PartitMonitor Partition States Monitor Queues Monitor RecoveryNodea RTR$DEFAULTFACILITY Monitor Quorum Monitor Recovery States Monitor RejectsMonitor Rejects Fields Process 38009A8B RTR Monitoring Standard Monitor Pictures Monitor RejhistMonitor Response Monitor Rejhist Fields Monitor Routing RTR Monitoring Standard Monitor Pictures Monitor RolequorumMonitor Routers Quorum Counts by Facility 7-JAN-1999 143248, Node -ALL RTR Monitoring Standard Monitor Pictures Monitor Rscbe Monitor RTR RTR Monitoring Standard Monitor Pictures Monitor Stalls RTR Monitoring Standard Monitor Pictures Monitor System Type Monitor Connects Monitor Trans RTR Monitoring Standard Monitor Pictures Monitor TPSMonitor Trafﬁc Servers RTR Monitoring Standard Monitor Pictures Monitor V2CALLS Monitor XAMonitor XA Page RTR Command Line Interface RTR Command Reference ADD Facility Description Call RtraccepttxFormat Call Rtraccepttx Forget Noforget CHANNELNAME=RTR$DEFAULTCHANNELQualiﬁers Independent Noindependent Related Commands Accept the current transaction with a reason Call Rtrbroadcastevent message-ﬁeld1 ,message-ﬁeld2 Call RtrbroadcasteventParameters Message-ﬁeld1 ,message-ﬁeld2 Parameters for rtrbroadcastevent CHANNELNAME=channel-nameEVENTNUMBER=user-event-number RECIPIENTSPEC=rcpspc Generated Format StringsLENGTHOFFIELD=ﬁeld-length TYPEOFDATA=STRING Signed Unsigned /TYPEOFDATA=STRING D Call Rtrbroadcastevent Call Rtrclosechannel Call RtrclosechannelParameters for rtrclosechannel Immediate IMMEDIATE=RTR$DEFAULTCHANNEL This command closes the channel named ``client1 Parameters for rtrerrortext Call RtrerrortextCall Rtrerrortext STATUS=status-code No default Call Rtrgettid Call RtrgettidParameters for rtrgettid Tid e100b810,0,0,0,0,3bc5,6eb02001 Call Rtropenchannel Call Rtropenchannel Parameters for rtropenchannel Parameter Name Parameter Value Example Client Noclient Concurrent D Noconcurrent HIGHBOUND=high-bound HIGHBOUND=max-val-for-key-type D FACILITY=RTR$DEFAULTFACILITY DFACILITYNAME=facility-name KEYn=keysegdesc LOWBOUND=low-bound LOWBOUND=min-val-for-key-type D PARTITIONNAME=partition-name Standby D Nostandby Call Rtrclosechannel Call Rtrpreparetx Call RtrpreparetxParameters for rtrpreparetx DATA=data DATA=0 Prepare the current transaction with a reason Call Rtrreceivemessage Call RtrreceivemessageParameters for rtrreceivemessage 26RTR Command Line Interface Msgsb msgtype msglen usrhdl 0 tid Call Rtrrejecttx Call Rtrrejecttx10 Parameters for rtrrejecttx Call Rtropenchannel Call Rtraccepttx Reject the current transaction with a reason Call Rtrreplytoclient Call Rtrreplytoclient message-ﬁeld1 ,message-ﬁeld2 11 Parameters for rtrreplytoclient Accept Noaccept 12 Generated Format Strings Following example replies a message to the client Call Rtrrequestinfo Call Rtrrequestinfo13 Parameters for rtrrequestinfo SELITM=item-name No default GETITM=item-name,item-name... No defaultINFCLA=infoclass No default SELVAL=item-value No default RTR Call RTRRECEIVEMESSAGE/CHANNEL=INFOCHAN/TIMEOUT Call Rtrsendtoserver Call Rtrsendtoserver message-ﬁeld1 ,message-ﬁeld2Message-ﬁeld ,message-ﬁeld2 14 Parameters for rtrsendtoserver Expendable Noexpendable 15 Generated Format Strings Readonly Noreadonly Examples 16 Parameters for rtrstarttx Call RtrstarttxCall Rtrstarttx Nested Transaction Usage Txidtype JOINTXID=txid-numberNojointxid Ddtm Call Rtrrejecttx Call Rtraccepttx Clear Clear=column =row 46RTR Command Line Interface Create Facility Create Facility facilitynameFacilityname Default for role-list is ROUTER,BACKEND RESOURCEMANAGER=resource-list 50RTR Command Line Interface Create Journal Create Journal disk-1 ... ,disk-nDisk-1, ... disk-n 17 Platform Speciﬁc Information Unix Delete Journal Modify Journal Show Journal Create Partition PartitionnamePartitionname Facility Create Facility SET Partition Key-name Define /KEYDefine /KEY key-name equivalence-string Key names Equivalence-string Echo D Noecho RTR Define /KEY PF1 Help /SETSTATE=GOLD /NOTERMINATE /ECHO RTR Define /KEY PF3 Show RTR /TERMINATERTR PF3 RTR Define /KEY PF1 Create /TERMINATE /IFSTATE=GOLD /ECHO 60RTR Command Line Interface Delete Facility Delete Facility facilityname Create Facility Show Facility Delete Journal Delete Journal 64RTR Command Line Interface Delete Partition Create Partition Show Partition Display BAR Display BAR expressionExpression AVERAGE=keyword NoaverageCHARACTER=char SEPARATE=keyword Noseparate TOTALIZE=keyword Nototalize=column =previous-column D Display Numeric Display Numeric expression DECIMALS=decimal-places /DECIMALS=0 D KeywordMeaning =column /X=previous-column D 76RTR Command Line Interface Display String Display String expression 78RTR Command Line Interface WIDTH=ﬁeld-width /WIDTH=0 D 80RTR Command Line Interface Display Symbolic Display Symbolic expression text-string ,text-string 82RTR Command Line Interface Display Text Display Text textText Node Nonode Related Commands Do operating-system-command DCL-command Example RTR DO/CLUSTER Show TimeRTR DO/NODE=TR2,TR1 Show Logical Mylogical Flush Namecache Flush Namecache Execute Execute ﬁle-specﬁle-spec Exit Exit Extend Facility Extend Facility facilityname $ RTR $ RTR RTR SET Environment /NODE=FE,FETRBEBACKEND=FETRBE ROUTER=FETRBE Default for role-list is ROUTER,BACKEND Create Facility Delete Facility Show Facility Trim Facility Initialize Journal LOG LOG RTR LOG/OUTPUT=RTRLOG.LOG Message check here Modify Journal Modify Journal disk-1 ... ,disk-nDisk-1 ... disk-n OpenVMS Example RTR Modify Journal DISK1$/BLOCKS=3000/MAXIMUMBLOCKS=20000 Monitor Monitor monitor-ﬁle-specMonitor-ﬁle-spec IDENTIFICATION=process-id Noidentification D RTR Monitor TRAFFIC/COUNT=10/OUTPUT=PICTURE.LIS Quit Quit Recall command-speciﬁer Command-speciﬁerRecall Register Resource Manager Register RM ResourcenameResourcename 106RTR Command Line Interface Direction ScrollScroll direction amount Amount Cluster SET EnvironmentSET Environment NODE=node-list SET Facility SET Facility facility-name Balance Nobalance RTR SET Facility FINANCE/QUORUMTHRESHOLD=4 RTR SET Facility FINANCE/BALANCE SET Link SET Link link-name Enable Disable Suspect Nosuspect RTR SET Link JOEY/ENABLE RTR SET Link JOEY/AUTOISOLATE SET LOG SET LOG RTR SET LOG/FILE=RTRLOG.LOG/OPERATOR RTR SET LOG/NOFILE/NOOPERATORRTR SET LOG/OPERATOR GROUP=user-id SET ModeSET Mode Nogroup RTR SET MODE/GROUP RTR SET MODE/NOGROUP SET Node SET node RTR SET Node /NOISOLATE SET Partition SET Partition partition-namePartition-name PRIORITYLIST=backend-node-list RECOVERYRETRYCOUNT=nRestartrecovery Resume Timeout Suspend SET Transaction SET Transaction transaction-id Transaction-id Facility FACILITY=RTR$DEFAULTFACILITY DUsage Notes BEFORE=date Newstate 19 Valid Transaction State ChangesSINCE=date RTR SET Transaction /NEW=ABORT /CURRENT=VOTED /PART=DBPART Show Channel Show Channel channel-nameChannel-name Clichn RTR$DEFAULTCHANNELRTR Show CHANNEL/ALLWINDOWS CLICHN2 Show Client Show ClientFull none D RTR Show CLIENT/FULL TEST43CLI Show Display Show Display=column /Y=row Blank RTR MON Calls RTR Show DISPLAY/ALLDisplay Numeric WIDTH=9 Show Environment Show EnvironmentRTR SET ENVIRONMENT/NODE=FE2,FE3 RTR Show Environment Show Facility Show Facility facility-nameFacility-name State Nostated RTR Show FACILITY/FULL/NODE=BRONZE Link to Airola Frontend Yes Router Backend RTR Show FACILITY/BALANCE Show Journal Show Journal Create Journal Delete Journal Initialize Journal Show KEY Show KEY key-name RTR Show KEY/FULL Show Link Show Link node-nameNode-name Full RTR Show LINK/FULL Iron Show LOG Show LOG RTR Show LOG Show Mode Show Mode RTR Show Mode Show Node Show Node RTR Show Node Show Partition Show Partition20 Key-Range States 21 Router Partition States RTR Show PARTITION/ROUTER/FULL RTR Show PARTITION/BACKEND Show Partition Show Process Show Process Processes Process-id Process Name Show Requester Show Resource Manager Show RM Show RM resourcename Rmid Show RTR Show RTR Status D Nostatus RTR Show RTR Show Segment Show Segment RTR$DEFAULTFACILITY Unsigned Testfac Signed Show Server Show Server22 Key-range States Server Flags RTR Show SERVER/FULL RTR Show ServerSRV Lowerserv Show Transaction Show Transaction24 Transaction Invocation Types 25 Key-Range States Receiving Key-Range StatesRTR Show TRANSACTION/BACKEND/FULL Original Spawn Spawn operating-system-commandOperating-system-command Noutput Start RTR Start RTR ASTLM=ast-limit BIOLM=io-buffered 174RTR Command Line Interface PRCLM=subprocess-limit /PRCLM=10 D Show RTR Stop RTR Stop RTR Stop RTRAbort Show RTR Start RTR Trim Facility Trim Facility facilityname RTR RTR SET Environment /NODE=FE,FETRBE,NFE FRONTEND=frontend-list Nofrontend D Unregister Resource Manager Unregister RM Creating Monitor Pictures Table A-1 Information Classes Interactive Deﬁnition of a Monitor Picture Example A-1 Interactive Picture Deﬁnition Arithmetic Expressions and Operators Substitution SymbolsTable A-2 Substitution symbols Test Picture AT Some Data Item Other Data Item Table A-3 Arithmetic Operators in Display Commands Example A-2 Arithmetic Operators Examples Aggregation of Data Items Some output has been omitted for clarityPage Automatic Features Primary and Secondary RolesShadow Events Server Shadowing and Recovery Automatic Features RTR Journal System Server Shadowing and Recovery RTR Journal System Shadow Site Failure and Journaling Standby for Shadows Performance Server Shadowing and Recovery Performance Shadows in ActionApplication Considerations Server Shadowing and Recovery Application Considerations Server StatesCHAN2 Server Shadowing and Recovery Server States Figure B-2 Server States Requester State Transitions Server Shadowing and Recovery Client StatesClient States CHAN3 Server Shadowing and Recovery Partition States Partition StatesPage New Qualiﬁer to Create Facility Command XA Support Modiﬁed RTR API Microsoft DTC SupportXA Support Introduction RTR Open Channel RTR Utility Error Messages RTR Utility Error Messages RTR Utility Error Messages D-3 4RTR Utility Error Messages RTR Utility Error Messages D-5 6RTR Utility Error Messages RTR Utility Error Messages D-7 8RTR Utility Error Messages RTR Utility Error Messages D-9 Explanation RTR Utility Error Messages D-11 12RTR Utility Error Messages RTR Utility Error Messages D-13 Blocks RTR Utility Error Messages D-15 16RTR Utility Error Messages RTR Utility Error Messages D-17 18RTR Utility Error Messages RTR Utility Error Messages D-19 20RTR Utility Error Messages RTR Utility Error Messages D-21 22RTR Utility Error Messages RTR-S-RTRLOGENT, a 24RTR Utility Error Messages RTR Utility Error Messages D-25 26RTR Utility Error Messages RTR log messages 2RTR log messages RTR log messages E-3 4RTR log messages RTR-I-FACSTOPPED, Facility a stopped on local node 6RTR log messages RTR-I-LOGFILENT, a a a 8RTR log messages RTR log messages E-9 10RTR log messages RTR log messages E-11 12RTR log messages RTR log messages E-13 Page Index Index-2 Index-3 Index-4