Re: Freed logical log files Online 7.13 UC3

In article <5hb9eq$f1k@cssun.mathcs.emory.edu>, JEAN-FRANCOIS_LE-CARRE-PETIT@Non-HP-France-om4.om.hp.com wrote: >Hello, > >I am working on online 7.13UC3 and I wonder how can I be sure that a >logical log file has been freed since it has no more the F flag in onstat >-l command but U-B. > >How can I be sure that a logical log file with U-B- flags does not >contain a non commited transaction ? > >Can I find this kind of information in sysmaster ? > >Thanks for your answers. >Jean-Francois. 'onstat -x' seems to provide your answer. The column 'log begin' indicates the log in which 'open' transactions have started. A shell script which extracts transactions which have 'log begin' with a value other than 0, then pipes it to a appropriate sort should tell you the earliest log file with an open transaction. Information about the user can be got by 'joining' the onstat -x output with that of onstat -u. Further details? Use onstat -g ses. sysmaster : systrans should have held some information, but I couldn't make much sense of it. HTH. ----------------------- Rudy Fernandes GIC, Kuwait OL 7.20UC4, 4GL 6.04UC1 -----------------------