Re: jBASE Journalling

[Jim Idle]

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 jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---