Q
qasimpatwekar
Guest
Hi All, OpenEdge Release 10.2B0853 OS Linux I have on case where customer is reporting rapid growth in AI. They have 5 Fixed AI extents of 950 MB each and 6th AI is variable extent. During issue time 6 AI reaches to around 20+ GB and consumes all the space on the disk drive. 24 th June I can see multiple large files were created ending at the below times. 11:13am - 14GB 1:06pm – 19GB 2:22pm – 23GB 3:29pm – 27GB 27 th June 8:55am – 26GB 10:32am - 24GB Example of 27 @10:32am: till 9:31 everything was good...it switched to variable .a6 and at the time of switch at 10:31, the size was reached to 24 GB ++++++++++++++++++++++++ [2016/06/27@09:31:27.328+1000] P-20387 T-139663675033376 I APPSRV224: (3777) Switched to ai extent /Qadbi/QAD2012.1EE/Live/q2012live.a6. [2016/06/27@09:31:27.328+1000] P-20387 T-139663675033376 I APPSRV224: (3778) This is after-image file number 72 since the last AIMAGE BEGIN [2016/06/27@09:31:32.128+1000] P-3723 T-139701022000896 I AIMGT 201: (13199) After-image extent /Qadbi/QAD2012.1EE/Live/q2012live.a5 has been copied to /Qadbi/QAD2012.1EE/AI/Live/Qaddb~QAD2012.1EE~Live~q2012live.20160624.200748.00000071.q2012live.a5. [2016/06/27@09:31:32.130+1000] P-3723 T-139701022000896 I AIMGT 201: (3789) Marked after-image extent /Qadbi/QAD2012.1EE/Live/q2012live.a5 EMPTY. [2016/06/27@10:31:32.336+1000] P-3723 T-139701022000896 I AIMGT 201: (3777) Switched to ai extent /Qadbi/QAD2012.1EE/Live/q2012live.a1. [2016/06/27@10:31:32.336+1000] P-3723 T-139701022000896 I AIMGT 201: (3778) This is after-image file number 73 since the last AIMAGE BEGIN [2016/06/27@10:32:02.242+1000] P-3723 T-139701022000896 I AIMGT 201: (13199) After-image extent /Qadbi/QAD2012.1EE/Live/q2012live.a6 has been copied to /Qadbi/QAD2012.1EE/AI/Live/Qaddb~QAD2012.1EE~Live~q2012live.20160624.200748.00000072.q2012live.a6. [2016/06/27@10:32:25.732+1000] P-3723 T-139701022000896 I AIMGT 201: (3789) Marked after-image extent /Qadbi/QAD2012.1EE/Live/q2012live.a6 EMPTY. [2016/06/27@10:38:47.164+1000] P-10724 T-140068781840160 I APPSRV248: (3777) Switched to ai extent /Qadbi/QAD2012.1EE/Live/q2012live.a2. [2016/06/27@10:38:47.164+1000] P-10724 T-140068781840160 I APPSRV248: (3778) This is after-image file number 74 since the last AIMAGE BEGIN [2016/06/27@10:38:51.720+1000] P-3723 T-139701022000896 I AIMGT 201: (13199) After-image extent /Qadbi/QAD2012.1EE/Live/q2012live.a1 has been copied to /Qadbi/QAD2012.1EE/AI/Live/Qaddb~QAD2012.1EE~Live~q2012live.20160624.200748.00000073.q2012live.a1. [2016/06/27@10:38:51.730+1000] P-3723 T-139701022000896 I AIMGT 201: (3789) Marked after-image extent /Qadbi/QAD2012.1EE/Live/q2012live. ++++++++++++++++++++++++++++++ We have the aiscan verbose output which says at the end: 6163872 notes were processed. (1634) 12 in-flight transactions. (3785) 171966 transactions were started. (1635) 171967 transactions were completed. (11138) At the end of the .ai file, 11 transactions were still active. (1636) Now I would like to know the details of 171966 transactions..i.e from which table it belongs? I do see entries like this: Example for Trid: 721645606: Trid: 721645606 Mon Jun 27 09:31:29 2016. (2598) Trid: 721645606 User Id: root (12531) Trid: 721645606 code = RL_TBGN version = 1 (12528) Trid: 721645606 dbkey = 0 update counter = 0 (12530) Trid: 721645606 code = RL_RMDEL version = 2 (12528) Trid: 721645606 area = 53 dbkey = 5651616 update counter = 1129 (12529) Trid: 721645606 code = RL_RMCR version = 2 (12528) Trid: 721645606 area = 53 dbkey = 5651616 update counter = 1130 (12529) Trid: 721645606 code = RL_RMDEL version = 2 (12528) ..... ...... ..... Trid: 721645606 area = 53 dbkey = 5623360 update counter = 2023 (12529) Trid: 721645606 code = RL_RMCR version = 2 (12528) Trid: 721645606 area = 53 dbkey = 5623360 update counter = 2024 (12529) Trid: 721645606 Mon Jun 27 09:31:30 2016. (2598) Trid: 721645606 code = RL_TEND version = 1 (12528) Trid: 721645606 dbkey = 0 update counter = 0 (12530) I see that there have been millions of Delete/Create pairs in the AIScan to area 53. Question: 1) Is there a way to see what data is written with a progress Transaction ID and DB Key from the AI scan? 2) if we have Trid, area, and dbkey, can we find which table is being hit? 3) if it is possible to see what was written there? Can you please share your valuable input please. I searched almost all kbase related to aiscan verbose but could not find any relevant information or answers to my query. Any help will be appreciated.... -- Thanks, Qasim.
Continue reading...
Continue reading...