R
Rob Fitzpatrick
Guest
RHEL 5.9 OE 64-bit 11.6.3.017 I'm investigating a recent issue at a client site. Their BI grew until it hit the threshold, which at the time was 2 GB. I am analyzing aimage scan verbose output using George's code (thank you George!) and am uncertain how to interpret what I see. I have identified three very long-running transactions (4328, 7665, and 2179 seconds) so I know why the BI grew. The next step is to understand what certain other users were doing in that time frame. I don't know whether it is normal activity or not. I'll be analyzing more AI files from the week prior to try to figure that out. Several of them were not doing the typical record/index CUD activity I would expect; they just had a ton of save points: Trid Userid AiNum BegTime EndTime Len Notes SubTrans Notes/Sub NoteList 32560737 alice 73134 Fri Nov 17 09:25:26 2017 Fri Nov 17 10:37:34 2017 4328 6 2 3 (RL_TMSAVE,RL_RMCHG:7)*2 34745864 alice 73145 Fri Nov 17 12:07:12 2017 Fri Nov 17 12:12:38 2017 326 1728970 1728968 1 (RL_TMSAVE)*1728968 34756650 bob 73145 Fri Nov 17 12:11:07 2017 Fri Nov 17 12:15:18 2017 251 1172022 1172020 1 (RL_TMSAVE)*1172020 34766381 bob 73146 Fri Nov 17 12:32:41 2017 Fri Nov 17 12:36:11 2017 210 1086047 1086044 1 (RL_TMSAVE)*1086044,RL_LSTMOD:6 34769079 bob 73147 Fri Nov 17 12:38:17 2017 Fri Nov 17 14:46:02 2017 7665 20010227 20010222 1 (RL_TMSAVE)*20010222,RL_LSTMOD:6*3 34780858 carol 73148 Fri Nov 17 12:57:06 2017 Fri Nov 17 13:33:25 2017 2179 9239104 9239100 1 (RL_TMSAVE)*9239100,RL_LSTMOD:6*2 34838161 carol 73156 Fri Nov 17 16:17:33 2017 ? 743 4448476 4448475 1 (RL_TMSAVE)*4448475 Can someone help me to understand what these remote ABL users might have been doing to cause all these TMSAVE notes? Thanks.
Continue reading...
Continue reading...