Hi Folks,
Is it possible to find the table/record from transaction id only?
We use MFG/Pro together with QXtend on OpenEdge 10.1B03 on a Linux box.
Occasionally QXtend leaves an open transaction behind, causing our BI file to grow until the database is taken down for backup on Saturday night.
Using protop (Tom: great tool!) I found that qxtend is the cause of the growing BI file, but I can't find what it is doing when it happens. Usually this happens on a Sunday, when the database is idle (no users, no transactions, I can only think of user logon history).
When I run this:
rfutil /mfg/data/mfghelp -C aimage scan verbose -a /mfg/ai/db2/mfgprod.a20 | less
And find this:
Trid: 1500228144 Sun Oct 12 15:24:10 2008. (2598)
Trid: 1500228144 User Id: qextend (12531)
Trid: 1500228144 code = RL_TBGN version = 1 (12528)
Trid: 1500228144 dbkey = 0 update counter = 0 (12530)
Trid: 1500228144 code = RL_TMSAVE version = 2 (12528)
Trid: 1500228144 dbkey = 0 update counter = 0 (12530)
Can I find the table/record that this ID 1500228144 applies to?
Any hints are welcome, thanks in advance!
Willem
Is it possible to find the table/record from transaction id only?
We use MFG/Pro together with QXtend on OpenEdge 10.1B03 on a Linux box.
Occasionally QXtend leaves an open transaction behind, causing our BI file to grow until the database is taken down for backup on Saturday night.
Using protop (Tom: great tool!) I found that qxtend is the cause of the growing BI file, but I can't find what it is doing when it happens. Usually this happens on a Sunday, when the database is idle (no users, no transactions, I can only think of user logon history).
When I run this:
rfutil /mfg/data/mfghelp -C aimage scan verbose -a /mfg/ai/db2/mfgprod.a20 | less
And find this:
Trid: 1500228144 Sun Oct 12 15:24:10 2008. (2598)
Trid: 1500228144 User Id: qextend (12531)
Trid: 1500228144 code = RL_TBGN version = 1 (12528)
Trid: 1500228144 dbkey = 0 update counter = 0 (12530)
Trid: 1500228144 code = RL_TMSAVE version = 2 (12528)
Trid: 1500228144 dbkey = 0 update counter = 0 (12530)
Can I find the table/record that this ID 1500228144 applies to?
Any hints are welcome, thanks in advance!
Willem