SET Transaction | Compaq AA-Q88CE-TE instruction

SET TRANSACTION

SET TRANSACTION

Sets various transaction related options.

Format

SET TRANSACTION transaction-id

Command Qualiﬁers	Defaults
/BEFORE[=date]	today
/STATE=current_state
/FACILITY=facility_name	/RTR$DEFAULT_FACILITY (D)
/NEW_STATE=new_state
/NODE[=node_list	/default_node_list
/OUTPUT[=ﬁle-spec]	/OUTPUT=stdout
/PARTITION=partition_name
/SINCE[=date]	today
/USER=username	all users

Description

Note

The SET TRANSACTION command could damage your journal and database integrity if used incorrectly. Ensure that you fully understand the reason and impact for changing a transaction state before altering your RTR system.

The SET TRANSACTION command allows you to modify the state of a transaction or set of transactions stored in the RTR journal.

This command is complementary to the DUMP JOURNAL and SHOW TRANSACTION commands in that it gives capability of reading and modifying the status of a transaction status in the RTR journal. For example, if a shadow recovery is known to be unnecessary, you may want to clean up the RTR journal to prevent the committed transactions in the journal from being replayed. Using the SET TRANSACTION command, the RTR administrator is able to delete that set of transactions from the journal.

In addition, the SET TRANSACTION command also helps users to better control the RTR runtime environment in difﬁcult operational situations. For example, a transaction while still in SENDING state on the backend may appear to be hung and cannot proceed. Using the SET TRANSACTION command, an RTR administrator can abort this transaction ``on-the-ﬂy'' and free runtime resources.

While the SET TRANSACTION command enables RTR users to have full control of RTR transactions, it introduces the risk that a transaction could be lost or corrupted. The command must be used with discretion and should only be used by expeerienced RTR system administrators.

After using the SET TRANSACTION command complete, you may use the DUMP JOURNAL command to verify the results.

RTR Command Line Interface 6–125

Image 201

Compaq AA-Q88CE-TE manual SET Transaction transaction-id

Contents

Reliable Transaction Router System Managers Manual June Contents RTR Monitoring Transaction Management RTR Command Line Interface 103 100104 105 RTR Utility Error Messages RTR log messages Index Examples Server Shadowing and RecoveryCreating Monitor Pictures XA Support Tables Arithmetic Operators in Display Commands Page Purpose of this Manual Intended AudienceStructure of Document Related Documentation Readers CommentsConventions Convention Meaning Conventions Used in this GuidePage Getting Started Entering Commands Online Help Introduction Entering Commands Remote Commands Command ProceduresIntroduction Online Help Rtralrsta Introduction Remote Commands Introduction Setting Up-An Example Starting and Setting Up RTR Setting Up-An Example FrontendsFERoutersTRBackendsBEExample 2-1 Local Conﬁguration of each Node Example 2-2 Remote Setup from one Node Creating a Recovery Journal Changing a Facility Starting and Setting Up RTR Creating a Recovery Journal Example 2-3 Reconﬁguration Using Delete and Create Facility Starting and Setting Up RTR Changing a Facility O N T E N D S U T E R S Example 2-4 Reconﬁguration Using Extend Facility Setting up Callout Servers 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 OpenVMS Systems Starting and Setting Up RTR RTR PrivilegesSetting RTR Privileges on Windows NT Systems RTR ACP Virtual Memory Sizing Astlm Biolm Diolm Fillm Pgflquota Starting and Setting Up RTR RTR ACP Virtual Memory Sizing Unix Virtual Memory Sizing Specifying the Link Transport Protocol Network Transports Troubleshooting Tunnel and Wildcard Connections Using the Tunnel PreﬁxTCP Services File Anonymous Clients Interoperation with RTR Version 2 Using DECnet Starting and Setting Up RTR Network Transports 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 Router Backend a Backend B Show Partition command on each backend node is as follows SET Partition test/PRIORITYLIST=bronze,gold Router Site a Node-A1 Site B Node-B1 Node-A2 Node-B2 Router Selection RTR Create Facility test/FRONTEND=Z/ROUTER=A,B,C What is a Partition? What is Partition Management?Overview Life Cycle of a Partition Partition Naming Binding Server Channels to Named Partitions Explicit Partition CreationPersistence of Partition Deﬁnitions Partition Management Entering Partition Commands Entering Partition CommandsCommand Line Usage Programmed Partition Management Managing Partitions Command Line ExampleControlling Shadowing Programming Information Example usage of the qualiﬁers Controlling Recovery Controlling the Active Site Partition Management Managing Partitions Char Controlling Failover Rtruns32t newLimit Controlling Transaction Replay RTR$DEFAULTFACILITY Displaying Partition InformationPartition Management Displaying Partition Information Transaction Management Command Line Examples Transaction Management OverviewException Transactions 19 Valid Transaction State Transitions Transaction Management Overview Transaction State Changes 4Transaction Management Standard Monitor Pictures RTR Monitoring Standard Monitor Pictures RTR Monitoring Standard Monitor Pictures Cont Standard Monitor Pictures Dmark DEC.ZKO.DMARK Monitor Accfail Link Acceptance Failures Monitor ACP2APP Monitor APP2ACP RTR Monitoring Standard Monitor Pictures Monitor ActiveMonitor Broadcast PID -ALL Monitor Channel RTR Monitoring Standard Monitor Pictures Monitor CallsMonitor Connects Calls Monitor Facility Monitor Event RTR Monitoring Standard Monitor Pictures Monitor Flow Monitor GroupMonitor Group Fields RTR Monitoring Standard Monitor Pictures Monitor IPC Monitor IpcrateMonitor Journal Monitor Netbytes Monitor Link RTR Monitoring Standard Monitor Pictures Monitor Netstat Monitor PartitMonitor Partition States Nodea RTR$DEFAULTFACILITY Monitor RecoveryMonitor Queues Monitor Quorum Monitor Recovery States Monitor RejectsMonitor Rejects Fields Monitor Response RTR Monitoring Standard Monitor Pictures Monitor RejhistProcess 38009A8B Monitor Rejhist Fields Monitor Routers RTR Monitoring Standard Monitor Pictures Monitor RolequorumMonitor Routing Quorum Counts by Facility 7-JAN-1999 143248, Node -ALL Monitor RTR RTR Monitoring Standard Monitor Pictures Monitor Rscbe RTR Monitoring Standard Monitor Pictures Monitor Stalls Type Monitor Connects RTR Monitoring Standard Monitor Pictures Monitor System Monitor Trafﬁc RTR Monitoring Standard Monitor Pictures Monitor TPSMonitor Trans Servers RTR Monitoring Standard Monitor Pictures Monitor V2CALLS Monitor XAMonitor XA Page RTR Command Reference RTR Command Line Interface ADD Facility Format Call RtraccepttxDescription Call Rtraccepttx Qualiﬁers CHANNELNAME=RTR$DEFAULTCHANNELForget Noforget Independent Noindependent Accept the current transaction with a reason Related Commands Parameters Call RtrbroadcasteventCall Rtrbroadcastevent message-ﬁeld1 ,message-ﬁeld2 Message-ﬁeld1 ,message-ﬁeld2 Parameters for rtrbroadcastevent CHANNELNAME=channel-nameEVENTNUMBER=user-event-number LENGTHOFFIELD=ﬁeld-length Generated Format StringsRECIPIENTSPEC=rcpspc TYPEOFDATA=STRING Signed Unsigned /TYPEOFDATA=STRING D Call Rtrbroadcastevent Call Rtrclosechannel Call RtrclosechannelParameters for rtrclosechannel This command closes the channel named ``client1 Immediate IMMEDIATE=RTR$DEFAULTCHANNEL Call Rtrerrortext Call RtrerrortextParameters for rtrerrortext STATUS=status-code No default Call Rtrgettid Call RtrgettidParameters for rtrgettid Tid e100b810,0,0,0,0,3bc5,6eb02001 Call Rtropenchannel Call Rtropenchannel Parameter Name Parameter Value Example Parameters for rtropenchannel Concurrent D Noconcurrent Client Noclient FACILITYNAME=facility-name FACILITY=RTR$DEFAULTFACILITY DHIGHBOUND=high-bound HIGHBOUND=max-val-for-key-type D KEYn=keysegdesc LOWBOUND=low-bound LOWBOUND=min-val-for-key-type D Standby D Nostandby PARTITIONNAME=partition-name Call Rtrclosechannel Call Rtrpreparetx Call RtrpreparetxParameters for rtrpreparetx DATA=0 DATA=data 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 message-ﬁeld1 ,message-ﬁeld2 Call Rtrreplytoclient Accept Noaccept 11 Parameters for rtrreplytoclient 12 Generated Format Strings Following example replies a message to the client Call Rtrrequestinfo Call Rtrrequestinfo13 Parameters for rtrrequestinfo INFCLA=infoclass No default GETITM=item-name,item-name... No defaultSELITM=item-name No default SELVAL=item-value No default RTR Call RTRRECEIVEMESSAGE/CHANNEL=INFOCHAN/TIMEOUT Call Rtrsendtoserver Call Rtrsendtoserver message-ﬁeld1 ,message-ﬁeld2Message-ﬁeld ,message-ﬁeld2 Expendable Noexpendable 14 Parameters for rtrsendtoserver Readonly Noreadonly 15 Generated Format Strings Examples Call Rtrstarttx Call Rtrstarttx16 Parameters for rtrstarttx Nested Transaction Usage Nojointxid JOINTXID=txid-numberTxidtype 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 Unix 17 Platform Speciﬁc Information Delete Journal Modify Journal Show Journal Create Partition PartitionnamePartitionname Facility Create Facility SET Partition Define /KEY key-name equivalence-string Define /KEYKey-name Key names Echo D Noecho Equivalence-string RTR PF3 RTR Define /KEY PF3 Show RTR /TERMINATERTR Define /KEY PF1 Help /SETSTATE=GOLD /NOTERMINATE /ECHO RTR Define /KEY PF1 Create /TERMINATE /IFSTATE=GOLD /ECHO 60RTR Command Line Interface Delete Facility facilityname Delete Facility 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 Noseparate SEPARATE=keyword TOTALIZE=keyword Nototalize=column =previous-column D Display Numeric expression Display Numeric DECIMALS=decimal-places /DECIMALS=0 D KeywordMeaning =column /X=previous-column D 76RTR Command Line Interface Display String expression Display String 78RTR Command Line Interface WIDTH=ﬁeld-width /WIDTH=0 D 80RTR Command Line Interface Display Symbolic expression text-string ,text-string Display Symbolic 82RTR Command Line Interface Display Text Display Text textText Node Nonode Related Commands DCL-command Do operating-system-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 facilityname Extend Facility BACKEND=FETRBE $ RTR RTR SET Environment /NODE=FE,FETRBE$ RTR 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 RTR Modify Journal DISK1$/BLOCKS=3000/MAXIMUMBLOCKS=20000 OpenVMS Example Monitor Monitor monitor-ﬁle-specMonitor-ﬁle-spec Noidentification D IDENTIFICATION=process-id 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 Scroll direction amount ScrollDirection Amount SET Environment SET EnvironmentCluster NODE=node-list SET Facility facility-name SET Facility Balance Nobalance RTR SET Facility FINANCE/BALANCE RTR SET Facility FINANCE/QUORUMTHRESHOLD=4 SET Link link-name SET Link Enable Disable Suspect Nosuspect RTR SET Link JOEY/AUTOISOLATE RTR SET Link JOEY/ENABLE SET LOG SET LOG RTR SET LOG/FILE=RTRLOG.LOG/OPERATOR RTR SET LOG/NOFILE/NOOPERATORRTR SET LOG/OPERATOR SET Mode SET ModeGROUP=user-id Nogroup RTR SET MODE/NOGROUP RTR SET MODE/GROUP SET node SET Node RTR SET Node /NOISOLATE SET Partition SET Partition partition-namePartition-name Restartrecovery RECOVERYRETRYCOUNT=nPRIORITYLIST=backend-node-list Resume Suspend Timeout SET Transaction transaction-id SET Transaction Usage Notes Facility FACILITY=RTR$DEFAULTFACILITY DTransaction-id 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 RTR Show CHANNEL/ALLWINDOWS RTR$DEFAULTCHANNELClichn CLICHN2 Show Client Show ClientFull none D RTR Show CLIENT/FULL TEST43CLI Show Display Show Display=column /Y=row Display Numeric RTR MON Calls RTR Show DISPLAY/ALLBlank WIDTH=9 Show Environment Show EnvironmentRTR SET ENVIRONMENT/NODE=FE2,FE3 RTR Show Environment Show Facility Show Facility facility-nameFacility-name State Nostated Link to Airola Frontend Yes Router Backend RTR Show FACILITY/FULL/NODE=BRONZE RTR Show FACILITY/BALANCE Show Journal Show Journal Create Journal Delete Journal Initialize Journal Show KEY key-name Show KEY RTR Show KEY/FULL Show Link Show Link node-nameNode-name RTR Show LINK/FULL Iron Full 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/BACKEND RTR Show PARTITION/ROUTER/FULL Show Partition Show Process Show Process Processes Process-id Process Name Show Requester Show RM resourcename Show Resource Manager Show RM Rmid Show RTR Show RTR RTR Show RTR Status D Nostatus Show Segment Show Segment RTR$DEFAULTFACILITY Unsigned Testfac Signed Show Server Show Server22 Key-range States Server Flags SRV RTR Show ServerRTR Show SERVER/FULL Lowerserv Show Transaction Show Transaction24 Transaction Invocation Types 25 Key-Range States RTR Show TRANSACTION/BACKEND/FULL Key-Range StatesReceiving Original Operating-system-command Spawn operating-system-commandSpawn Noutput Start RTR Start RTR BIOLM=io-buffered ASTLM=ast-limit 174RTR Command Line Interface PRCLM=subprocess-limit /PRCLM=10 D Show RTR Stop RTR Stop RTR Stop RTRAbort Show RTR Start RTR Trim Facility facilityname Trim Facility FRONTEND=frontend-list RTR RTR SET Environment /NODE=FE,FETRBE,NFE Nofrontend D Unregister Resource Manager Unregister RM Table A-1 Information Classes Creating Monitor Pictures Example A-1 Interactive Picture Deﬁnition Interactive Deﬁnition of a Monitor Picture Table A-2 Substitution symbols Substitution SymbolsArithmetic Expressions and Operators Test Picture AT Some Data Item Other Data Item Example A-2 Arithmetic Operators Examples Table A-3 Arithmetic Operators in Display Commands Some output has been omitted for clarity Aggregation of Data ItemsPage Automatic Features Primary and Secondary RolesShadow Events RTR Journal System Server Shadowing and Recovery Automatic Features Shadow Site Failure and Journaling Server Shadowing and Recovery RTR Journal System Performance Standby for Shadows Server Shadowing and Recovery Performance Shadows in ActionApplication Considerations Server Shadowing and Recovery Application Considerations Server StatesCHAN2 Figure B-2 Server States Server Shadowing and Recovery Server States Client States Server Shadowing and Recovery Client StatesRequester State Transitions CHAN3 Partition States Server Shadowing and Recovery Partition StatesPage XA Support New Qualiﬁer to Create Facility Command XA Support Introduction Microsoft DTC SupportModiﬁed RTR API 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