Hi Chris
There are so many IX and S locks when i run ttxactadmin as below, and there are error 6003 in the tterrors.log. I am not sure how it comes and how i can do to avoid so many locks (IX,S), as the locks seem to lead to the poor performance.
Regards
Li
[timesten@policies info]$ ttxactadmin tt_1122
2014-06-10 19:39:59.124
/opt/TimesTen/tt1122/info/TT_1122
TimesTen Release 11.2.2.6.0
Outstanding locks
PID Context TransID TransStatus Resource ResourceID Mode SqlCmdID Name
Program File Name: ttcserver
Client: zhanglei01 (192.168.3.97) PID: 652 ConnId: 3
13193 0x122141e0 3.6218256 Active Database 0x01312d0001312d00 IX 0
Command 63070070280 S 63070070280
Command 63070088488 S 63070088488
Program File Name: java
22898 0x2abb70744190 68.192079 Active Database 0x01312d0001312d00 IX 0
Command 63135962640 S 63135962640
0x2abb740a8fd0 26.332773 Active Database 0x01312d0001312d00 IX 0
Command 63135962640 S 63135962640
Program File Name: java
27257 0x1ee88010 28.61798 Active Database 0x01312d0001312d00 IX 0
0x1efabdc0 14.135708 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x1f234d60 20.212847 Active Database 0x01312d0001312d00 IX 0
0x1f3c4d20 69.61019 Active Database 0x01312d0001312d00 IX 0
Command 63078042632 S 63078042632
0x1f42bb50 61.55575 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x1f520090 18.144761 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x1f75fd50 40.54027 Active Database 0x01312d0001312d00 IX 0
0x1f802700 32.60926 Active Database 0x01312d0001312d00 IX 0
0x1f96ee00 13.133386 Active Database 0x01312d0001312d00 IX 0
0x1fa97510 23.66043 Active Database 0x01312d0001312d00 IX 0
Command 63078042632 S 63078042632
0x1fab74a0 15.263987 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x1fb13ee0 62.58715 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x1fbe70b0 22.54699 Active Database 0x01312d0001312d00 IX 0
0x1fd67b80 70.58108 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x1fe5a1e0 108.19195 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x20569c50 83.48231 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x206c74d0 88.44535 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x20795c60 94.135147 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2aaab80fbfe0 82.51766 Active Database 0x01312d0001312d00 IX 0
0x2aaab8198070 39.66183 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2aaac85cb210 4.4862402 Active Database 0x01312d0001312d00 IX 0
Command 63078042632 S 63078042632
0x2aaac8a79070 5.4231353 Active Database 0x01312d0001312d00 IX 0
0x2aaac8ade2b0 6.2251763 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2aaac8b4f630 7.1958134 Active Database 0x01312d0001312d00 IX 0
Command 63078042632 S 63078042632
0x2aaac8bd1360 8.2970264 Active Database 0x01312d0001312d00 IX 0
0x2aaac8c53090 9.948962 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2aaac8cd4dc0 10.4442556 Active Database 0x01312d0001312d00 IX 0
0x2aaac8d56af0 11.3089531 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2aaac8dd8820 12.3377348 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb7001aca0 16.1092282 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb700983f0 17.216793 Active Database 0x01312d0001312d00 IX 0
Command 63078042632 S 63078042632
0x2abb700fd630 19.546665 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb701dd740 27.62472 Active Database 0x01312d0001312d00 IX 0
Command 63078042632 S 63078042632
0x2abb70287980 54.131520 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb703267b0 100.161812 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb703a0ce0 114.18564 Active Database 0x01312d0001312d00 IX 0
0x2abb780393a0 29.61830 Active Database 0x01312d0001312d00 IX 0
0x2abb7807f6b0 33.69272 Active Database 0x01312d0001312d00 IX 0
Command 63078042632 S 63078042632
0x2abb7811cd40 46.59031 Active Database 0x01312d0001312d00 IX 0
0x2abb78131930 47.57511 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb781e5d40 86.49723 Active Database 0x01312d0001312d00 IX 0
0x2abb782149f0 37.60371 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb782be9e0 106.16739 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb7c0dd800 34.59934 Active Database 0x01312d0001312d00 IX 0
Command 63078042632 S 63078042632
0x2abb7c1717b0 43.58632 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb7c1b69d0 50.48246 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb7c2c7290 99.77142 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb800f7ce0 42.58233 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb8014ca40 49.45579 Active Database 0x01312d0001312d00 IX 0
Command 63078042632 S 63078042632
0x2abb801ef220 55.53388 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb802db740 101.205712 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb84016810 30.59694 Active Database 0x01312d0001312d00 IX 0
Command 63078042632 S 63078042632
0x2abb8403ba10 31.61627 Active Database 0x01312d0001312d00 IX 0
0x2abb840a7710 35.49096 Active Database 0x01312d0001312d00 IX 0
Command 63078042632 S 63078042632
0x2abb84171bd0 41.62948 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb841c9480 45.62825 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb8428d650 48.59628 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb843a5730 76.60185 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb843d2c10 80.47384 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb844890e0 95.158977 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb844ebcb0 113.17537 Active Database 0x01312d0001312d00 IX 0
0x2abb88069430 36.68769 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb880e7110 38.55534 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb88183df0 44.54232 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb8820d230 53.29378 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb88261e60 51.59713 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb882b6a90 52.60489 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb882fb6b0 56.59902 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb8835e750 64.56058 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb883f4b80 72.56333 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb884b2090 98.70919 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
0x2abb885172d0 102.88736 Active Database 0x01312d0001312d00 IX 0
Command 62926043208 S 62926043208
[timesten@policies logs]$ tail -50 tterrors.log
18:56:23.96 Warn: : 3644: 3648/0x41bae200: sbOLUndoByConn: oplog stack for connid 21 (java) pid 23180: <none>
18:56:23.96 Warn: : 3644: 3648/0x444a9200: sbOLUndoByConn: oplog stack for connid 130 (java) pid 23180: <none>
18:56:23.96 Warn: : 3644: 3648/0x46acf200: sbOLUndoByConn: oplog stack for connid 172 (java) pid 23180: <none>
18:56:23.96 Warn: : 3644: 3648/0x44cb1200: sbOLUndoByConn: oplog stack for connid 140 (java) pid 23180: <none>
18:56:23.96 Warn: : 3644: 3648/0x44db2200: sbOLUndoByConn: oplog stack for connid 141 (java) pid 23180: <none>
18:56:23.96 Warn: : 3644: 3648/0x44eb3200: sbOLUndoByConn: oplog stack for connid 142 (java) pid 23180: <none>
18:56:23.96 Warn: : 3644: 3648/0x4359a200: sbOLUndoByConn: oplog stack for connid 111 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x446ab200: sbOLUndoByConn: oplog stack for connid 133 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x452b7200: sbOLUndoByConn: oplog stack for connid 146 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x44fb4200: sbOLUndoByConn: oplog stack for connid 143 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x42287200: sbOLUndoByConn: oplog stack for connid 14 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x453b8200: sbOLUndoByConn: oplog stack for connid 147 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x455ba200: sbOLUndoByConn: oplog stack for connid 149 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x454b9200: sbOLUndoByConn: oplog stack for connid 148 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x456bb200: sbOLUndoByConn: oplog stack for connid 150 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x458bd200: sbOLUndoByConn: oplog stack for connid 152 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x459be200: sbOLUndoByConn: oplog stack for connid 153 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x45bc0200: sbOLUndoByConn: oplog stack for connid 155 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x45abf200: sbOLUndoByConn: oplog stack for connid 154 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x460c5200: sbOLUndoByConn: oplog stack for connid 161 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x463c8200: sbOLUndoByConn: oplog stack for connid 164 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x472d7200: sbOLUndoByConn: oplog stack for connid 181 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x464c9200: sbOLUndoByConn: oplog stack for connid 165 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x462c7200: sbOLUndoByConn: oplog stack for connid 163 (java) pid 23180: <none>
18:56:23.97 Warn: : 3644: 3648/0x4288d200: sbOLUndoByConn: oplog stack for connid 96 (java) pid 23180: <none>
18:56:23.98 Warn: : 3644: 3648/0x461c6200: sbOLUndoByConn: oplog stack for connid 162 (java) pid 23180: <none>
18:56:23.98 Warn: : 3644: 3648/0x45dc2200: sbOLUndoByConn: oplog stack for connid 157 (java) pid 23180: <none>
18:56:23.98 Warn: : 3644: 3648/0x45fc4200: sbOLUndoByConn: oplog stack for connid 160 (java) pid 23180: <none>
18:56:23.98 Warn: : 3644: 3648/0x467cc200: sbOLUndoByConn: oplog stack for connid 169 (java) pid 23180: <none>
18:56:23.98 Warn: : 3644: 3648/0x442a7200: sbOLUndoByConn: oplog stack for connid 128 (java) pid 23180: <none>
18:56:23.98 Warn: : 3644: 3648/0x468cd200: sbOLUndoByConn: oplog stack for connid 170 (java) pid 23180: <none>
18:56:23.98 Warn: : 3644: 3648/0x44aaf200: sbOLUndoByConn: oplog stack for connid 138 (java) pid 23180: <none>
18:56:23.98 Warn: : 3644: 3648/0x44bb0200: sbOLUndoByConn: oplog stack for connid 139 (java) pid 23180: <none>
18:56:23.98 Warn: : 3644: 3648/0x447ac200: sbOLUndoByConn: oplog stack for connid 134 (java) pid 23180: <none>
18:56:23.98 Warn: : 3644: 3648/0x46cd1200: sbOLUndoByConn: oplog stack for connid 174 (java) pid 23180: <none>
18:56:23.99 Warn: : 3644: 3648/0x46ed3200: sbOLUndoByConn: oplog stack for connid 177 (java) pid 23180: <none>
18:56:23.99 Warn: : 3644: 3648/0x46fd4200: sbOLUndoByConn: oplog stack for connid 178 (java) pid 23180: <none>
18:56:23.99 Warn: : 3644: 3648/0x46dd2200: sbOLUndoByConn: oplog stack for connid 175 (java) pid 23180: <none>
18:56:23.99 Warn: : 3644: 3648/0x46bd0200: sbOLUndoByConn: oplog stack for connid 173 (java) pid 23180: <none>
18:56:23.99 Warn: : 3644: 3648/0x470d5200: sbOLUndoByConn: oplog stack for connid 179 (java) pid 23180: <none>
18:56:23.99 Warn: : 3644: 3648/0x471d6200: sbOLUndoByConn: oplog stack for connid 180 (java) pid 23180: <none>
18:56:23.99 Warn: : 3644: 3648/0x40573250: sbOLUndoByConn: oplog stack for connid 186 (java) pid 23180: <none>
18:56:23.99 Warn: : 3644: 3648/0x476db200: sbOLUndoByConn: oplog stack for connid 185 (java) pid 23180: <none>
18:56:23.99 Warn: : 3644: 3648/0x475da200: sbOLUndoByConn: oplog stack for connid 184 (java) pid 23180: <none>
18:56:23.99 Warn: : 3644: 3648/0x473d8200: sbOLUndoByConn: oplog stack for connid 182 (java) pid 23180: <none>
18:56:23.99 Warn: : 3644: 3648/0x474d9200: sbOLUndoByConn: oplog stack for connid 183 (java) pid 23180: <none>
18:56:24.00 Warn: : 3644: 3648/0x45ec3200: sbOLUndoByConn: oplog stack for connid 158 (java) pid 23180: <none>
19:06:41.64 Warn: : 3644: 3718/0x1570ca20: sbLogBufGCLockENQNoErr: The commit is performed without the benefit of group commit optimization (error 6003)
19:15:41.69 Warn: : 3644: 3718/0x1570ca20: sbLogBufGCLockENQNoErr: The commit is performed without the benefit of group commit optimization (error 6003)
19:32:41.67 Warn: : 3644: 3718/0x1570ca20: sbLogBufGCLockENQNoErr: The commit is performed without the benefit of group commit optimization (error 6003)