Home > Ask the AS/400 Experts > iSeries Backup and Recovery Questions & Answers > Journaling production files
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

Journaling production files

Ken Graap EXPERT RESPONSE FROM: Ken Graap

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 28 April 2005
I recently read an article where someone said they journaled all of their production files. Is there a way to do this by library? Creating a journal and receiver for all our production files could take weeks? Is there a way to estimate the space required to journal all your production files? Is there a way to estimate the amount of processor drain on the system when journal all of your production files?

>
The preferred way is to do this by library. The steps for setting this up are quite easy, too. Here is how I do it on my system. Note: I do this process for each individual application library I want to start journaling on:

1. Create a message queue to receive journal messages:

CRTMSGQ MSGQ(QGPL/Jrn_Name)
TEXT('Journal Messages')

2. Create a journal receiver (Tip: Put receivers in a different library)

CRTJRNRCV JRNRCV(JrnRcvLib/App1JR0001)
THRESHOLD(1000000)

3. Create a journal referencing the receiver just created:

CRTJRN JRN(App1Lib/App1JRN)
JRNRCV(JrnRcvLib/App1JR0001)
MSGQ(QGPL/Jrn_Name)
MNGRCV(*SYSTEM) „² Lets the system manage the receiver names
DLTRCV(*NO)
RCVSIZOPT(*RMVINTENT *MAXOPT2)

4. Start journaling for all files in the library (Note: STRJRNLIB is a TAATOOL. If you don't have TAATOOLS on your system then you will have to start journaling manually using the appropriate system commands:

STRJRNAP Start Journal Access Path
STRJRNOBJ Start Journal Object
STRJRNPF Start Journal Physical File

STRJRNLIB LIB(App1Lib)
JRN(App1Lib/App1JRN)
STRJRNAP(*NO)
IMAGES(*BOTH)
OMTJRNE(*OPNCLO)

You might notice that in step 4 I also specified DLTRCV(*NO) ... This is because I prefer to delete journal receivers after I have saved them to tape. I don't want the system to automatically delete them for me.

Journaling your production objects is a good way to enhance your ability to recover in the event of an outage. However, if you lose the system and you haven't saved your receivers to tape you're out of luck. Save your receivers to tape often and move these tapes off site along with your regular backup tapes. Even better yet, use "remote journaling" to replicate your journal receivers to another system, in real time. (That's a whole topic I won't go into right now though.)

Another advantage to journaling data is that you have a detailed audit record of everything that has happened to your production data. This can be an invaluable resource to tap when you are trying to figure out "what happened" when something goes wrong.

The performance penalty for journaling has been decreasing significantly with just about every new release of OS400. In today's environments with faster disk drives and processors I'd venture to say you won't even be able to notice that you have turned on journaling.

I personally have created a separate ASP (Auxiliary Storage Pool) for my production journal receivers, too. This moves the disk IO associated with journaling to a separate set of disk arms. It also provides additional protection of your data. For example, if you were unfortunate enough to lose two disk drives in a RAID set that contained your production data your would have to recover this data from tape. If your receivers are in a separate ASP then after restoring your data you could apply the journaled transactions thereby fully recovering your production application data to the point of failure. You ask, "How much disk space will this take" ... It all depends on how "active" your data is. If you have 2,500 changes a day to a journaled set of objects, very little disk space is required. If you have 25,000.000 changes a day like we do, you could eat up 60-100GB of disk space every few days! You do have control over how much disk space is used, though. Back up your receivers to tape often and then remove them from disk using the DLRJRNRCV command.

Good luck! I hope you find this information to be helpful.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Visit the ITKnowledge Exchange and get answers to your backup & recovery questions fast.

Search400.com's targeted search engine: Get relevant information on backup & recovery.

Check out this Search400.com Featured Topic on 30 backup/recovery tips in 30 minutes .


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Data backup, storage and retrieval on iSeries
How to migrate old *ALLUSR data using BRMS to V6R1
Authority restrictions on the AUTL on backup/test systems and AUTL on live system
Perform a full system backup without user profile QSECOFR
Faster backup method for System i
Solve problems concerning the ALLOW OBJECT DIFFERENCES parameter when restoring a library
System i backup not advised using network NETBACKUP
How to clear expired BRMS created *SAVF files from System i
Restore a full system backup from the production partition to the test partition
Tivoli Service Manager 6 released with DB2 integration and dedupe
Remove a media with a *PERM expiration date from the inventory
Data backup, storage and retrieval on iSeries Research

iSeries Backup and Recovery
Parallel backups using save option 21
How to migrate old *ALLUSR data using BRMS to V6R1
How to save HMC critical data through the console
Authority restrictions on the AUTL on backup/test systems and AUTL on live system
Perform a full system backup without user profile QSECOFR
Faster backup method for System i
Solve problems concerning the ALLOW OBJECT DIFFERENCES parameter when restoring a library
System i backup not advised using network NETBACKUP
How to clear expired BRMS created *SAVF files from System i
Restore a full system backup from the production partition to the test partition

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



iSeries Networking - Printing, Remote Access, TCP/IP
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts