Was the DB has been EXTENDed or REDUCEd? -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Markus Engelhard Sent: Tuesday, January 16, 2007 8:28 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Criteria for full DBbackup
Hi all, just a quick one we just stumbled upon: running incremental/full dbb using following script: ***snip*** select * from db where LAST_BACKUP_DATE is NULL if(rc_ok) goto ba_full select * from db where num_backup_incr=20 if(rc_ok) goto ba_full if(rc_notfound) goto ba_incr ba_full: backup db devcl=$1_FILEDEV type=full wait=yes goto done ba_incr: backup db devcl=$1_FILEDEV type=incremental wait=yes done: ***snip*** we just got: 16.01.2007 08:56:45 ANR2017I Administrator xxx issued command: select * from db where LAST_BACKUP_DATE is NULL 16.01.2007 08:56:45 ANR2034E SELECT: No match found using this criteria. 16.01.2007 08:56:45 ANR2753I (MAINTAINANCE_LOCAL):ANR2034E SELECT: No match found using 16.01.2007 08:56:45 ANR2753I (MAINTAINANCE_LOCAL):this criteria. 16.01.2007 08:56:45 ANR2017I Administrator xxx issued command: select * from db where num_backup_incr=20 16.01.2007 08:56:45 ANR2034E SELECT: No match found using this criteria. 16.01.2007 08:56:45 ANR2753I (MAINTAINANCE_LOCAL):ANR2034E SELECT: No match found using 16.01.2007 08:56:45 ANR2753I (MAINTAINANCE_LOCAL):this criteria. 16.01.2007 08:56:45 ANR2017I Administrator xxx issued command: BACKUP DB devcl=xxx_FILEDEV type=incremental wait=yes 16.01.2007 08:57:08 ANR2361E BACKUP DB: A full database backup is required. The odd thing about it ist that we have only 13 incrementals, so neither the scripted nor the system criteria (20/32 incrementals) are met. I got no additional clue from the Reference or tsmwiki. Any Idea? Platform: Solaris 9 Server Version 5, Release 3, Level 3.2 Regards, Markus -- Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail oder von Teilen dieser Mail ist nicht gestattet. Wir haben alle verkehrsüblichen Maßnahmen unternommen, um das Risiko der Verbreitung virenbefallener Software oder E-Mails zu minimieren, dennoch raten wir Ihnen, Ihre eigenen Virenkontrollen auf alle Anhänge an dieser Nachricht durchzuführen. Wir schließen außer für den Fall von Vorsatz oder grober Fahrlässigkeit die Haftung für jeglichen Verlust oder Schäden durch virenbefallene Software oder E-Mails aus. Jede von der Bank versendete E-Mail ist sorgfältig erstellt worden, dennoch schließen wir die rechtliche Verbindlichkeit aus; sie kann nicht zu einer irgendwie gearteten Verpflichtung zu Lasten der Bank ausgelegt werden. ______________________________________________________________________ This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail or of parts hereof is strictly forbidden. We have taken precautions to minimize the risk of transmitting software viruses but nevertheless advise you to carry out your own virus checks on any attachment of this message. We accept no liability for loss or damage caused by software viruses except in case of gross negligence or willful behaviour. Any e-mail messages from the Bank are sent in good faith, but shall not be binding or construed as constituting any kind of obligation on the part of the Bank. -------------------------------------------------------- If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/ --------------------------------------------------------
