You don't always need to take a backup frequently: a backup plus logs can recover the DB. The less Imagecopies you take, the more logfiles you must process. The backup cycle then becomes a tradeoff.
Kees. > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Edward Gould > Sent: 13 December, 2017 23:10 > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Back up of your largest DB > > Hi all: > > This question I am posing caught me off guard and was wondering what the > MF world does about Data Base backups. > The largest DB I had e been exposed to was around 60 3350 volumes and > that was 20+ years ago. > The backup of the entire DB took about 3 hours and that was by a special > back program written by the vendor. > > The webinar that I watched was of course a PC Data base. > > One of the questions was: > Have a file system so large or dense that you haven't completed a full > backup in several months, if ever > —————————————————— > Have any of you had this much data to back up you couldn’t do it … for > several months??!!!! > > I talked with a friend whose company has a large (credit history of all > the people in the US (plus a few over seas)) and according to him they > back the data up in several ways, but the current back up is to > replicate the data and then back it up off the replicated data and he > said 3-4 hours. When I told him of the comment that was made in the > webinar, he said: “If I couldn’t back up the data in 4 hours tops, he > would be fired.” > > I though this might be an interesting question for the people on here. > How long does it take to backup your largest DB ? > What are the various methodologies do you use for backup of your largest > DB? > Finally would you still have your job, if any portion of your DB went > for say over 1 day without a proper backup? > The 1 day is a variable and I plucked it out of nowhere and was > wondering what is your magic number? > > Ed > > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ******************************************************** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ******************************************************** ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
