Re: jBASE Journalling

[Jim Idle]

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 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 -~----------~----~----~----~------~----~------~--~---