Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Unix SQL Advanced SQL 4GL Applications Advanced 4GL IDS Admin Migrating to V14 IDS Performance Managing & Optimising SPL and Triggers IDS V14 Upgrading Very Old Versions Custom Training
Onstat Guide Error Code Guide Reference Datablades The Dumb DBA Sysmaster Fault Finder
Co-Location Web Hosting Managed Servers Web Development
BenchMark Tookkit RegExp Datablade
Partnerships Contact
Onstat
-g act -g afr -g all -g amx -g aqt -g arc -g ath -g btc -g buf -g cac -g cdr -g cluster -g cdr config -g cfg -g cmsm -g con -g cpu -g dbc -g ddr -g dic -g dis -g dll -g dmp -g dri -g dsc -g dsk -g dss
-g env -g ffr -g glo -g grp -g imc -g ioa -g iob -g iof -g iog -g ioq -g iov -g ipl -g lap -g laq -g lmm -g lmx -g lsc -g mem -g mgm -g nbm -g nif -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-g opn -g osi -g pgp -g pos -g ppd -g ppf -g pqs -g prc -g proxy -g qst -g rah -g ras -g rbm -g rcv -g rep -g rea -g rss -g sch -g scn -g sds -g seg -g ses -g sle -g smb -g smx -g spi -g sql -g src -g ssc -g stk -g stm -g stq -g sts -g sym -g sync
-g rwm -g tgp -g tpf -g ufr -g wai -g vpcache -g wmx -g wst
-b/-B -F -g cac -g dic -g dsc -g prc -g ssc -g vpcache -h -p -X
-t/-T -g buf -g lap -g opn -g ppf -g scn
-g cat -g cdr -g cdrconfig -g ddr -g dss -g dtc -g grp -g nif -g que -g rcv -g rep -g rqm -g sync
-g cluster -g cmsm -g dri -g ipl -g laq -g proxy -g rss -g sds -g smx
-R -g afr -g ffr -g lmm -g lsc -g mem -g mgm -g nbm -g rbm -g seg -g ses -g stm -g stq -g ufr
-g imc -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-G -u -x -g env -g his -g pqs -g ses -g sql
-g act -g ath -g cpu -g rea -g sle -g stk -g sts -g tpf -g wai -g wst
-a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -x Transactions

onstat -H Clean Up Transactionsi [Undoc'd]

The onstat -x command lists the transactions currently active in the system. 

Transactions                                                                   
address   flags userthread  locks  begin    current     isol   est.     retrys coord
                                    logpos   logpos             rb_time
14102018 A---- 140d3018   0         -        -           COMMIT   -     0
141021dc A---- 140d35d8   0         -        -           COMMIT   -     0
141023a0 A---- 140d3b98   0         -        -           COMMIT   -     0
14102564 A---- 140d4158   0         -        -           COMMIT   -     0
14102728 A---- 140d4718   0         -        -           COMMIT   -     0
.....
14102564 -LH-G 0          0     22:0x0     28:0x276e5e0  COMMIT  0:00     0
14102728 -LH-G 0          0     22:0x0     28:0x26e9524  COMMIT  0:00     0
141028ec A---- 140d4cd8   0         -        -           COMMIT   -     0
14a878ec A---- 14a58b98   0         -        -           NOTRANS  -     0
14a87ab0 A---- 14a59cd8   1         -        -           DIRTY    -     0         
14a87c74 A---- 14a5a298   502   33:0x25018  34:0x486fc   COMMIT   0:07  0
14a87e38 A---- 14a5a858   1         -        -           DIRTY    -     0       hobbit921shm
 137 active, 256 total, 138 maximum concurrent

Output Description

Not all fields are avaialable in all versions

Heading Description Format See Also
address The in-memory address of the transaction structure Hex  
flags Describes the status of the transaction using the following coded flags:
Position 1: 
 A Userthread attached to transaction
 C TP/XA waiting for rollback
 S TP/XA suspended transaction
Position 2: 
 L Loosely-coupled mode (default mode)
 T Tightly-coupled mode (MTS)
Position 3: 
 B Begin work
 C Committing or committed
 H Heuristically rolling back or rolled back
 P Informix-Star prepare for commit
 R Rolling back or rolled back
 X TP/XA prepare for commit
Position 5: 
 B Both distibuted Star coordinator and subordinate
 C Informix-Star coordinator
 G Global transaction
 M Redirected Global transaction
 S Informix-Star subordinate
Str  
userthread The address of the userthread that owns this transaction. Hex onstat -u
locks The number of locks held by the transaction. Dec onstat -k
begin logpos The number of the Logical Log in which this transaction was begun. Dec onstat -l
current logpos The current log position of the most recent record that the transaction is wrote to Dec onstat -l
log begin The number of the Logical Log in which this transaction was begun. Dec onstat -l
isolation The isolation level of the transaction. Str  
est. rb time The estimated time the server needs to rollback the transaction. As a transaction goes forward, this time increases. If a transaction rolls back, the time decreases as the transaction unwinds. Time  
retrys The number of times the transaction attempted to complete. Dec  
coordinator The name of the coordinator system if this is a two-phase commit (distributed) transaction. Str  

Summary Definitions

Heading Description
active The number of currently active transactions.
total The current number of transactions that the engine has been dynamically allocated to handle.
maximum concurrent The maximum number of transactions that have been running at the same time.

Notes

  • The onstat -x command is not included with onstat -a
    The transaction information is required only in the following situations:
  • X/Open environment
  • Database server participation in distributed queries
  • Database server uses the Microsoft Transaction Server (MTS) transaction manager
  • An upgrade can fail due to 'open transactions'. These can be found via onstat -x and then killed via onmode -Z <addr> or onmode -H <addr>

Note: the onmode -H is an undocumented option and takes the Hex TransID

  • As a transaction rolls back, the current log position will actually wind back until it gets to the beginning log position. When the beginning log position is reached, the rollback is complete

If the onmode -H and onstat -Z fail then the download and compile xa_tool.ec

Monitoring and Tuning

    If a long transaction is in the process of being rolled back, it can be identified by examining the transaction with the lowest log begin value.

To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.