Oninit cdi / Archive
Talk to an expert →

output from onstat -x

Posted in 2018

REINHARD HABICHTSBERG — — source: IIUG Forums & Mailing Lists

Hi all onstat -x shows the running transactions. What does the following output mean?See the decreasing negative times at the end of the rows and the increasing number of locks. Also the flags (A-B----). What is implied? Are we running in a Long Transaction? B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 24723 2061059:0xd1270e0 2061064:0x9ed71f8 DIRTY 00:-55:-34 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 24729 2061059:0xd1270e0 2061064:0xa68b0bc DIRTY 00:-55:-34 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 24741 2061059:0xd1270e0 2061064:0xb4e5768 DIRTY 00:-55:-33 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 24747 2061059:0xd1270e0 2061064:0xbb110bc DIRTY 00:-55:-33 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 24777 2061059:0xd1270e0 2061064:0xdc5a1e8 DIRTY 00:-55:-32 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 24836 2061059:0xd1270e0 2061064:0x115ed0bc DIRTY 00:-55:-29 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 24927 2061059:0xd1270e0 2061064:0x17876518 DIRTY 00:-55:-25 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 24939 2061059:0xd1270e0 2061064:0x184ed5a4 DIRTY 00:-55:-24 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 25173 2061059:0xd1270e0 2061065:0xfe6a2a8 DIRTY 00:-55:-13 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 25360 2061059:0xd1270e0 2061066:0x4c760c0 DIRTY 00:-55:-5 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 25372 2061059:0xd1270e0 2061066:0x58032e8 DIRTY 00:-55:-4 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 25378 2061059:0xd1270e0 2061066:0x5ec00bc DIRTY 00:-55:-4 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 25468 2061059:0xd1270e0 2061066:0xc60f254 DIRTY 00:-55:00 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 25486 2061059:0xd1270e0 2061066:0xdb4f0bc DIRTY 00:-54:-59 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 25498 2061059:0xd1270e0 2061066:0xe9420e4 DIRTY 00:-54:-58 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 25504 2061059:0xd1270e0 2061066:0xefee178 DIRTY 00:-54:-58 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 25510 2061059:0xd1270e0 2061066:0xf7140bc DIRTY 00:-54:-58 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 25516 2061059:0xd1270e0 2061066:0xfe376a4 DIRTY 00:-54:-58 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 25523 2061059:0xd1270e0 2061066:0x104b70f4 DIRTY 00:-54:-57 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 25535 2061059:0xd1270e0 2061066:0x1112c6c8 DIRTY 00:-54:-57 0 1c260dc28 A---- 1d52d9458 0 - - NOTRANS - 0 B40DBS0S-db1:/home/informix%onstat -x | grep 1d52d9458 1a6675258 A-B-- 1d52d9458 25541 2061059:0xd1270e0 2061066:0x117e643c DIRTY 00:-54:-57 0 TIA, Reinhard.

Related threads