Hi Jim, Can you help on the questions pls???
Regards, Narayan. On Mon, Apr 20, 2009 at 9:14 PM, Road Jogger <[email protected]> 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.... > > 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 -~----------~----~----~----~------~----~------~--~---
