If TSM won't let you write a new DB backup to it, TSM must think there is still valid data on it, yes?
Try: select volume_name, date(date_time),type from volhistory where volume_name like 'DB%' -----Original Message----- From: Wolfgang Rest [mailto:[EMAIL PROTECTED]] Sent: Friday, March 01, 2002 12:37 PM To: [EMAIL PROTECTED] Subject: AW: ANR4583E Database backup terminated hi, no it does show up as private. adsm> q libv Library Name Volume Name Status Last Use Home Element ------------ ----------- ----------------- --------- ------- ----- DLTLIB02 ARCHIVE001 Private Data 2 DLTLIB02 ARCHIVE002 Private 3 DLTLIB02 BKCOPY005 Private 6 DLTLIB02 BKCOPY008 Private 4 DLTLIB02 BKCOPY009 Private 5 DLTLIB02 DB_MO Private 1 DLTLIB02 LOGOVERFLOW Private DbBackup 7 adsm> the logoverflow was checked in as scratch.. db backup worked to this tape... if have now db_mo in the library.. the next db backup runs on monday.. and should backup to db_mo i will see what happens.. post my results on monday to this list. best regards wolfgang rest -----Urspr|ngliche Nachricht----- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]Im Auftrag von Prather, Wanda Gesendet: Donnerstag, 28. Februar 2002 18:44 An: [EMAIL PROTECTED] Betreff: Re: ANR4583E Database backup terminated try: q libv whatever DB_DO Does it show up as scratch? -----Original Message----- From: Wolfgang Rest [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 9:27 AM To: [EMAIL PROTECTED] Subject: AW: ANR4583E Database backup terminated Hello, i have this schedule defined "DEL VOLH TYPE=DBB TODATE=TODAY-4" it runs every day at 07:20am on monday 07:30am the command "BACKUP DB DEV=DLTCLS02 T=F VOL=DB_MO SCR=N WAIT=NO" executes. then i checkout DB_MO and do a checkin for DB_DO on thuesday the command "BACKUP DB DEV=DLTCLS02 T=F VOL=DB_MO SCR=N WAIT=NO" executes. and so on... should be ok, or? best regards Wolfgang Rest -----Urspr|ngliche Nachricht----- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]Im Auftrag von Cook, Dwight E (SAIC) Gesendet: Donnerstag, 28. Februar 2002 13:56 An: [EMAIL PROTECTED] Betreff: Re: ANR4583E Database backup terminated OK, "delete volhist type=dbb tod=today" will not delete all of your data base backup volumes... TSM will never delete your latest/only db backup copy. If you are trying to reuse that same tape volser DB_DO you will never be able to do it ! You have to have AT LEAST TWO volumes, one which remains the active one while a new one is created... then (once a new one on a second volume is created) if you do a "delete volhist type=dbb tod=today" you can free the first on to be reused... hope this helps... Dwight -----Original Message----- From: Wolfgang Rest [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 6:12 AM To: [EMAIL PROTECTED] Subject: ANR4583E Database backup terminated Hello, i wanna backup the database every monday and thuesday on a tape (DB_MO) for monday and (DB_DO) for thuesday. the command "BACKUP DB DEV=DLTCLS02 T=F VOL=DB_DO SCR=N WAIT=NO" for thuesday is a Admin Command Schedule. the strange thing is that i always get the following error.. also when i start it directly in the console. adsm> backup db dev=dltcls02 type=full vol=db_do scr=no wait=yes ANR0984I Process 81 for DATABASE BACKUP started in the FOREGROUND at 11:29:35. ANR2280I Full database backup started as process 81. ANR4583E Database backup terminated - output media full and scratch media could not be mounted. ANR0985I Process 81 for DATABASE BACKUP running in the FOREGROUND completed with completion state FAILURE at 11:30:40. ANS8001I Return code 8. adsm> ??? the tape DB_DO is empty and located in the library.. also there is a empty scratch tape in this lib. and the loader is OK. adsm> q libv Library Name Volume Name Status Last Use Home Element ------------ ----------- ----------------- --------- ------- ----- DLTLIB02 ARCHIVE001 Private Data 2 DLTLIB02 ARCHIVE002 Private 3 DLTLIB02 ARCHIVE003 Private 5 DLTLIB02 ARCHIVE004 Private 6 DLTLIB02 BKCOPY003 Private Data 1 DLTLIB02 DB_DO Private 4 DLTLIB02 LOGOVERFLOW Scratch 7 adsm> when i start the db backup like this it works: adsm> backup db dev=dltcls02 type=full scr=yes wait=yes ANR0984I Process 83 for DATABASE BACKUP started in the FOREGROUND at 11:50:35. ANR2280I Full database backup started as process 83. ANR4554I Backed up 15488 of 123915 database pages. ANR4554I Backed up 30976 of 123915 database pages. ANR4554I Backed up 46464 of 123915 database pages. ANR4554I Backed up 61952 of 123915 database pages. ANR4554I Backed up 77440 of 123915 database pages. ANR4554I Backed up 92928 of 123915 database pages. ANR4554I Backed up 108416 of 123915 database pages. ANR4554I Backed up 120608 of 123915 database pages. ANR4550I Full database backup (process 83) complete, 123915 pages copied. ANR0985I Process 83 for DATABASE BACKUP running in the FOREGROUND completed with completion state SUCCESS at 11:55:19. Library Name Volume Name Status Last Use Home Element ------------ ----------- ----------------- --------- ------- ----- DLTLIB02 ARCHIVE001 Private Data 2 DLTLIB02 ARCHIVE002 Private 3 DLTLIB02 ARCHIVE003 Private 5 DLTLIB02 ARCHIVE004 Private 6 DLTLIB02 BKCOPY003 Private Data 1 DLTLIB02 DB_DO Private 4 DLTLIB02 LOGOVERFLOW Private DbBackup 7 server is running: ADSTAR Distributed Storage Manager Command Line Administrative Interface - Version 3, Release 1, Level 0.8 (C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved. any indeas? best regards Wolfgang Rest
