IDENTIFICATION=process-id, Key-Range States | Compaq AA-Q88CE-TE

SHOW TRANSACTION

Note: In environments that do not support clustering, use of the /CLUSTER qualiﬁer will cause the relevant command to be executed on the local node only.

/FRONTEND /NOFRONTEND (D)

Speciﬁes that information should be listed for transactions in a frontend node. If none of /BACKEND, /FRONTEND or /ROUTER are speciﬁed, then information for all of them are displayed. If either /BACKEND or /ROUTER are speciﬁed, then the default (/NOFRONTEND) inhibits display of frontend transaction information.

/IDENTIFICATION=process-id

/NOIDENTIFICATION (D)

Speciﬁes the PID of the process for which information is displayed. The default (/NOIDENTIFICATION) displays information for all processes.

/FACILITY /FACILITY="*" (D)

Speciﬁes the facility name for which information should be displayed.

By default, information is displayed for all Facilities.

/FULL /NOFULL (D)

Produces a detailed listing of transaction information.

/NODE[=node-list] /NODE=default-node-list (D)

Speciﬁes that the command is executed on all nodes speciﬁed in node-list. If node-listis omitted then the command is executed only on the node where the command was issued.

/OUTPUT[=ﬁle-spec] /OUTPUT=stdout (D)

Speciﬁes that the resulting information is written to the ﬁle file-spec. If /OUTPUT or file-specis omitted then the standard or default output is used.

/ROUTER /NOROUTER (D)

Speciﬁes that information should be listed for transactions in a router node. If none of /BACKEND, /FRONTEND or /ROUTER are speciﬁed, then information for all of them are displayed. If either /BACKEND or /FRONTEND are speciﬁed, then the default (/NOROUTER) inhibits display of router transaction information.

The ``Key-Range-State'' ﬁeld for SHOW TRANSACTION /ROUTER /FULL shows the following states:

Table 6–25 Key-Range States

State	Meaning

locl_rec	Local recovery in progress
shad_rec	Shadow recovery in progress

(continued on next page)

RTR Command Line Interface 6–169

Image 245

Compaq AA-Q88CE-TE manual IDENTIFICATION=process-id, Key-Range States

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 Structure of Document Purpose of this ManualIntended Audience Conventions Related DocumentationReaders Comments 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 Example 2-1 Local Conﬁguration of each Node Starting and Setting Up RTR Setting Up-An ExampleFrontendsFERoutersTRBackendsBE 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 Example 2-5 Conﬁguration of Callout Servers Starting and Setting Up RTR 2.5 Setting up Callout ServersRouter Load Balancing RTR Privileges Starting and Setting Up RTR Router Load BalancingSetting RTR Privileges on Unix Systems 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 $ DEFINE/SYSTEM Rtrprefprot Rtrdnafirst Running RTR as a Service on Windows NTNetwork Protocol Selection on OpenVMS Files Created by the RTR Windows NT Service Active How RTR Selects Processing-states Roles for NodesRole Assignment for Backend Node Partitions 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 Overview What is a Partition?What is Partition Management? Life Cycle of a Partition Partition Naming Persistence of Partition Deﬁnitions Binding Server Channels to Named PartitionsExplicit Partition Creation 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 Partition Management Displaying Partition Information RTR$DEFAULTFACILITYDisplaying Partition Information Transaction Management Exception Transactions Command Line ExamplesTransaction Management Overview 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 Monitor Group Fields RTR Monitoring Standard Monitor Pictures Monitor FlowMonitor Group Monitor Journal RTR Monitoring Standard Monitor Pictures Monitor IPCMonitor Ipcrate Monitor Netbytes Monitor Link Monitor Partition States RTR Monitoring Standard Monitor Pictures Monitor NetstatMonitor Partit Nodea RTR$DEFAULTFACILITY Monitor RecoveryMonitor Queues Monitor Quorum Monitor Rejects Fields Monitor Recovery StatesMonitor Rejects 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 Monitor XA RTR Monitoring Standard Monitor Pictures Monitor V2CALLSMonitor 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 EVENTNUMBER=user-event-number Parameters for rtrbroadcasteventCHANNELNAME=channel-name LENGTHOFFIELD=ﬁeld-length Generated Format StringsRECIPIENTSPEC=rcpspc TYPEOFDATA=STRING Signed Unsigned /TYPEOFDATA=STRING D Call Rtrbroadcastevent Parameters for rtrclosechannel Call RtrclosechannelCall Rtrclosechannel This command closes the channel named ``client1 Immediate IMMEDIATE=RTR$DEFAULTCHANNEL Call Rtrerrortext Call RtrerrortextParameters for rtrerrortext STATUS=status-code No default Parameters for rtrgettid Call RtrgettidCall 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 Parameters for rtrpreparetx Call RtrpreparetxCall Rtrpreparetx DATA=0 DATA=data Prepare the current transaction with a reason Parameters for rtrreceivemessage Call RtrreceivemessageCall Rtrreceivemessage 26RTR Command Line Interface Msgsb msgtype msglen usrhdl 0 tid 10 Parameters for rtrrejecttx Call RtrrejecttxCall 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 13 Parameters for rtrrequestinfo Call RtrrequestinfoCall 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 Message-ﬁeld ,message-ﬁeld2 Call RtrsendtoserverCall Rtrsendtoserver message-ﬁeld1 ,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 =column =row ClearClear 46RTR Command Line Interface Facilityname Create FacilityCreate Facility facilityname Default for role-list is ROUTER,BACKEND RESOURCEMANAGER=resource-list 50RTR Command Line Interface Disk-1, ... disk-n Create JournalCreate Journal disk-1 ... ,disk-n Unix 17 Platform Speciﬁc Information Delete Journal Modify Journal Show Journal Partitionname Create PartitionPartitionname 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 Expression Display BARDisplay BAR expression CHARACTER=char AVERAGE=keywordNoaverage Noseparate SEPARATE=keyword =column TOTALIZE=keywordNototalize =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 Text Display TextDisplay Text text Node Nonode Related Commands DCL-command Do operating-system-command RTR DO/NODE=TR2,TR1 Show Logical Mylogical ExampleRTR DO/CLUSTER Show Time Flush Namecache Flush Namecache ﬁle-spec ExecuteExecute ﬁ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 Disk-1 ... disk-n Modify JournalModify Journal disk-1 ... ,disk-n RTR Modify Journal DISK1$/BLOCKS=3000/MAXIMUMBLOCKS=20000 OpenVMS Example Monitor-ﬁle-spec MonitorMonitor monitor-ﬁle-spec Noidentification D IDENTIFICATION=process-id RTR Monitor TRAFFIC/COUNT=10/OUTPUT=PICTURE.LIS Quit Quit Recall Recall command-speciﬁerCommand-speciﬁer Resourcename Register Resource Manager Register RMResourcename 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/OPERATOR RTR SET LOG/FILE=RTRLOG.LOG/OPERATORRTR SET LOG/NOFILE/NOOPERATOR SET Mode SET ModeGROUP=user-id Nogroup RTR SET MODE/NOGROUP RTR SET MODE/GROUP SET node SET Node RTR SET Node /NOISOLATE Partition-name SET PartitionSET Partition partition-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 SINCE=date Newstate19 Valid Transaction State Changes RTR SET Transaction /NEW=ABORT /CURRENT=VOTED /PART=DBPART Channel-name Show ChannelShow Channel channel-name RTR Show CHANNEL/ALLWINDOWS RTR$DEFAULTCHANNELClichn CLICHN2 Full none D Show ClientShow Client CLI RTR Show CLIENT/FULLTEST43 =column /Y=row Show DisplayShow Display Display Numeric RTR MON Calls RTR Show DISPLAY/ALLBlank WIDTH=9 RTR SET ENVIRONMENT/NODE=FE2,FE3 RTR Show Environment Show EnvironmentShow Environment Facility-name Show FacilityShow Facility facility-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 Node-name Show LinkShow Link node-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 20 Key-Range States Show PartitionShow Partition 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 22 Key-range States Show ServerShow Server Server Flags SRV RTR Show ServerRTR Show SERVER/FULL Lowerserv 24 Transaction Invocation Types Show TransactionShow Transaction 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 Abort Stop RTRStop RTR 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 Shadow Events Automatic FeaturesPrimary and Secondary Roles 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 Application Considerations Server Shadowing and Recovery PerformanceShadows in Action CHAN2 Server Shadowing and Recovery Application ConsiderationsServer States 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