Jim, I have already done this.... i.e. to build the stats onto a separate file instead of traversing through the whole TJ logs.... & here we use 1 single unix login (as recommended by Temenos...) but still my question remains UN-ANSWERED....
1. How do we find out the list of files updated by a transaction??? Is there any kind of unique reference which can be used??? 2. When I do a selective restore, how does jlogdup know that this record from TJ LOG is a part of transaction ??? Thanks & Regards, Narayan. On Tue, Apr 21, 2009 at 4:41 PM, Jim Idle <[email protected]> wrote: > Road Jogger wrote: > > Hi Jim, > > Am trying to understand more of journalling & thats why am asking you these > questions... > > In a real life environment, we will have multiple users doing transactions > and these transactions will updated in the TJ logs and also the relavent > files will be updated. Now these updates are *NOT sequential* say there > are 3 users doing different transactions & the updates in TJ is *necessarily > not in sequence*... i.e. First USER 1 transaction details are updated in > TJ logs with TRANSTART & END, then for USER 2 & USER 3.... > > So in a scenario like the above, how do I find out the list of files > updated by USER 1.... since when we do a transaction in T24, it updates > numerous files.... > > Narayan, > > Check out the docs at: > > > http://www.jbase.com/knowledgebase/manuals/3.0/30manpages/man/trj2_jlogdup.htm > > and read about the LOGFILE special data type. Here you will see that a file > is created with a DICTIONARY like this below. You can LIST and SELECT on > this file (though personally I would probably write a jBC program to > construct stats into a separate file). When you SELECT and READNEXT through > the file, you will get a series of records defined by the dictionary. Be > careful though as this will traverse the entire log file sequentially, hence > my advice to traverse the log once, and produce a stats file with indexes > and so on. > > Jim > > > > SET log Set FILENO file Number OFFSET file Offset LOGSIZE Total Log > Record Size TYPE log Record Type TIME-UTC UTC Time TIME update Time DATE > update > Date TRANS trans TYPENUM log Record Type PID update Process PORT update > Port ERR error Description TRANSID transaction Identifier PATH full file > path name RECKEY update Record Key *JBNAME* *jBASE Login Name* OSNAME platform > Login Name TTY terminal Name APPID application Identifier 1 default Macro > will list TYPE JBNAME PATH TIME DATE ALL macro will list all fields ERRORS > macro > will list TYPE JBNAME PATH ERR > > > > > > --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
