hi, try the following in jsh prompt:
CREATE-FILE TJ1 TYPE=TJLOG Then you can see the contents of the current log set using LIST TJ1 etc. Maybe the set is empty? If it's not, you can proceed wit partial restore. See http://www.jbase.com/r5/knowledgebase/manuals/3.0/30manpages/man/trj2_jlogdup.htm for more detail. VK On Apr 15, 3:58 pm, Wilson Chikatala <[email protected]> wrote: > Hi, > Here is the command: > > jlogdup -v INPUT set=CURRENT OUTPUT set=database > rename=/emerge/database/live, /emerge/database/pastel > > That is the command. > > Thanks, > Regards > > > > > > > > On Fri, Apr 15, 2011 at 1:06 PM, VK <[email protected]> wrote: > > Hi, > > post here the restore command you're using. > > > On Apr 14, 5:57 pm, Wilson Chikatala <[email protected]> wrote: > > > Hi VK, > > > > Kindly guide me with an example. > > > > From the backup live.110104.20110106T1809.DATA.EOD-journal.tar.bz2, I > > > restored the following log set files into emerge/journal of test database > > > area: log2.1, log2.2, log2.3 and log2.4. When I do a restoration, this is > > > what I get: > > > > 17:08:29 14 APR 2011 : STATUS: > > > Termination Statistics: usr 0.02 , sys 0.01 , elapsed 0m0.00 > > > INPUT : 0 records , 0 blocks , 0 record bytes , 0 errors > > > OUTPUT: 0 records , 0 blocks , 0 bytes , 0 errors > > > 17:08:29 14 APR 2011 : STATUS: > > > Program terminated. Exit code is 0 > > > > It is drawing zeros. > > > > Can you please show me with an example, how I can restore TT for > > instance? > > > > Thanks, > > > Wilson. > > > > On Thu, Apr 14, 2011 at 2:05 PM, Wilson Chikatala <[email protected] > > >wrote: > > > > > VK, > > > > > Not really. I had just shelved the research. Was working on quarterly > > > > reports. Will try your good solution and tell you how it goes. > > > > > On Thu, Apr 14, 2011 at 9:26 AM, VK <[email protected]> wrote: > > > > >> Hi, > > > >> the extraction took so much time? :))) > > > > >> To restore with jlogdup you'll need an older full copy of your area > > > >> where to apply the journal. If you want only TT then restore > > > >> FBNK.TELLER table, for FT it's FBNK.FUNDS.TRANSFER (assuming that you > > > >> have so-called "single-company setup", it might be different prefix in > > > >> the other case and several files instead of each mentioned above). > > > > >> For DC tables are STMT.ENTRY or CATEG.ENTRY, see above the note about > > > >> prefix (and you'll have to filter the records since these tables > > > >> contain all accounting entries - unless some of them being archived). > > > > >> If you have certain tables extracted and nothing else, you're not able > > > >> to see the data properly in T24 - just raw records (yes there are many > > > >> dependencies which are usually not documented). > > > > >> VK > > > > >> On Apr 12, 7:43 am, Wilson Chikatala <[email protected]> wrote: > > > >> > Thanks Pat. I need further help. I was able to extract the log sets > > > >> using > > > >> > the tar archiver. Now I need to restore the data using jlogdup. > > > >> preferrably, > > > >> > I just want to restore TT, DC, and FT. However, if this can't work, > > even > > > >> a > > > >> > full restoration is okay. > > > > >> > Thanks > > > > >> > On Thu, Mar 31, 2011 at 10:47 PM, pat <[email protected]> wrote: > > > >> > > 'tar' files ( assuming the 'naming convention' of this file > > suggests > > > >> > > it is a 'tar' file ), are restored on Unix systems using the Unix > > > >> > > 'tar' command, eg : > > > > >> > > tar -xvf live.110104.20110106T1521.FULL.SOD-journal.tar > > > > >> > > See 'man tar' for further details > > > > >> > > I suspect however that extracting the files from this 'tar' file > > is > > > >> > > just the start of your restoration process > > > > >> > > Pat. > > > > >> > > On Mar 31, 6:42 pm, wchikatala <[email protected]> wrote: > > > >> > > > Hi Friends! > > > > >> > > > Kindly help if you can. I have been using T24 for about six > > months > > > >> > > > now. I want restore data from backup files sitting on hard disk > > of > > > >> > > > backup server. I want to restore to a test database also sitting > > on > > > >> > > > the backup server. Transaction journaling is enabled in the live > > > >> > > > database, the source of these backups. Backups are in this > > format: > > > >> > > > live.110104.20110106T1521.FULL.SOD-journal.tar. > > > > >> > > > Can someone help me on how I can restore from such backups using > > > >> > > > jlogdup. I want to restore TT, DC, and FT data only. If this > > can’t > > > >> > > > work I wouldn’t mind to have a full restoration. > > > > >> > > > Regards > > > > >> > > -- > > > >> > > 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 > > > > >> -- > > > >> 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 > > > -- > > 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 -- 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
