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.... Any ideas.... Will be keen to know your inputs.... Narayan On Mon, Apr 20, 2009 at 6:11 PM, Jim Idle <[email protected]> wrote: > Road Jogger wrote: > > Hi All, > > How does jBASE know that an entry in journal(jbase journalling) is part of > TRANSACTION?? > > The fact is recorded in the transaction journal. If you use TRANSTART and > TRANSEND to wrap writes, then this is recorded in the journal. If you try to > restore from the journal, then only completed entries will be restored, as > in the journal must contain the start and end boundary conditions. > > Say for example a transaction(FUNDS.TRANSFER) updates the below > files... assuming that the FT id is FT09110001000009 > > 1. FUNDS.TRANSFER LIVE FILE > 2. STMT.ENTRY > 3. ACCOUNT > 4. ACCT.ACTIVITY > 5. STMT.PRINTED > 6. STMT.VAL.ENTRY > > > For files from 2-6, we will have 2 entries in journal(1 for Debit a/c & > other for the credit a/c) > > Now, say if I want to restore only the FT record from the journal using > jlogdup, We will get an error(unless I say *"set notrans=true"* in my > jlogdup statement) > > OK - you need to tell us: > > 1) What is the error; > 2) What command are you using to restore; > 3) Why are you restoring? > 4) Why do you think you need to restore something that was not a complete > transaction? The idea is that you only restore complete transactions of > course :-) > > My question is > > 1. How does jbase know that the record am trying to restore is a part of > transaction? > > 2. Is there any specific identifiers in jBASE Journalling where we can find > out the list of all the files updated for 1 single transaction? > > I checked the TRANSID in jBASE journalling, but it has a value only for > TRANSTART & TRANSEND. > > This information is embedded in the journal entry in a non-public way and > isn't something that you can query I think. Maybe the records are just > bounded by the transaction on the journal - I am afraid I no longer > remember. However, it is unlikely that you want to restore incomplete > transactions, even if you feel that you do, as presumably there is a reason > that T24 has bound these updates and that reason is important. > > Now you say that you want to restore the FT record only, and presuming that > you have a valid reason for that, then you are using the correct option of > setting notrans=true, which means the restore will ignore boundaries. As > logically there is only respecting and ignoring transactions, then you have > the correct option. However, perhaps you should say what it is you are > trying to do and why as there may be better solutions to your problem. > > Jim > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
