Do you have roll-forward mode enabled or database backup trigger enabled? Do a 'Q ST' and see if you do. If so, you might have to set your database backup trigger higher than its set now.
Rob. From: "Taha, Hana" <[EMAIL PROTECTED]> on 11/18/2002 02:39 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Database Backups Hello TSMers, This is probably a very basic question to some of you, but one that has had me going crazy for the last two weeks. My problem is this.... I have two schedules to perform database backups. One is full and the other is incremental. See my schedules below. Schedule Name ADSM_DATABASE_BACKUP Description Full backup of ADSM Database Command backup db dev=8mmexdev type=full Priority 5 Start date 2002-06-24 Start time 06:00:00 Duration 10 Duration units MINUTES Period 1 Period units DAYS Day of Week MONDAY Expiration - Active? YES Last Update Date/Time 2002-06-25 13:47:24.000000 Last Update by (administrator) HANA Managing profile - Schedule Name ADSM_DATABASE_BACKUP_INCR Description Incremental Backup of ADSM Database on Thurs. ONLY Command ba db dev=8mmexdev t=incr Priority 5 Start date 2002-03-18 Start time 06:00:00 Duration 15 Duration units MINUTES Period 1 Period units DAYS Day of Week THURSDAY Expiration - Active? YES Last Update Date/Time 2002-06-25 13:47:40.000000 Last Update by (administrator) HANA Managing profile - My question is this: Why am I getting database backups on days that I am not supposed to get dbb's? On saturday, I logged in and I had delete 8 dbb's to free up some tapes for our full backups. This mess is eating up all my scratch tapes. This morning, I logged in and I had a backup done on Sunday and two done today. I was only expecting to see one backup performed this morning at 6am. So where am I going wrong. Is the schedule working as it should, or am I correct that I have a problem? Please review the Activity log below for more information. Thanks in advance! Date/Time: 11/17/02 08:00:11 Volume Type: BACKUPFULL Backup Series: 396 Backup Operation: 0 Volume Seq: 1 Device Class: 8MMEXDEV Volume Name: 00000021 Volume Location: Command: Date/Time: 11/18/02 06:00:10 Volume Type: BACKUPFULL Backup Series: 397 Backup Operation: 0 Volume Seq: 1 Device Class: 8MMEXDEV Volume Name: 00000050 Volume Location: Command: Date/Time: 11/18/02 08:00:04 Volume Type: BACKUPFULL Backup Series: 398 Backup Operation: 0 Volume Seq: 1 Device Class: 8MMEXDEV Volume Name: 00000076 Volume Location: Command: Operation Results Date/Time Message -------------------- ---------------------------------------------------------- 11/11/02 15:30:18 ANR2017I Administrator HANA issued command: QUERY EVENT ADSM_DATABASE_BACKUP TYPE=ADMIN BEGINDATE=11/11/2002 BEGINTIME=00:00 ENDDATE=11/11/2002 ENDTIME="15:30:06 " EXCEPTIONSONLY=NO FORMAT=STANDARD 11/12/02 08:00:12 ANR0984I Process 330 for DATABASE BACKUP started in the BACKGROUND at 08:00:12. 11/12/02 08:00:12 ANR2280I Full database backup started as process 330. 11/12/02 08:01:50 ANR4554I Backed up 8496 of 68093 database pages. 11/12/02 08:01:57 ANR4554I Backed up 16992 of 68093 database pages. 11/12/02 08:02:03 ANR4554I Backed up 25488 of 68093 database pages. 11/12/02 08:02:11 ANR4554I Backed up 33984 of 68093 database pages. 11/12/02 08:02:17 ANR4554I Backed up 42480 of 68093 database pages. 11/12/02 08:02:24 ANR4554I Backed up 50976 of 68093 database pages. 11/12/02 08:02:30 ANR4554I Backed up 59472 of 68093 database pages. 11/12/02 08:02:50 ANR4554I Backed up 67968 of 68093 database pages. 11/12/02 08:02:59 ANR4550I Full database backup (process 330) complete, 68093 pages copied. 11/12/02 08:02:59 ANR0985I Process 330 for DATABASE BACKUP running in the BACKGROUND completed with completion state SUCCESS at 08:02:59. 11/13/02 08:00:16 ANR0984I Process 337 for DATABASE BACKUP started in the BACKGROUND at 08:00:16. 11/13/02 08:00:16 ANR2280I Full database backup started as process 337. 11/13/02 08:01:32 ANR4554I Backed up 8512 of 68099 database pages. 11/13/02 08:01:41 ANR4554I Backed up 17024 of 68099 database pages. 11/13/02 08:01:50 ANR4554I Backed up 25536 of 68099 database pages. 11/13/02 08:01:59 ANR4554I Backed up 34048 of 68099 database pages. 11/13/02 08:02:09 ANR4554I Backed up 42560 of 68099 database pages. 11/13/02 08:02:18 ANR4554I Backed up 51072 of 68099 database pages. 11/13/02 08:02:29 ANR4554I Backed up 59584 of 68099 database pages. 11/13/02 08:02:55 ANR4554I Backed up 68096 of 68099 database pages. 11/13/02 08:03:04 ANR4550I Full database backup (process 337) complete, 68099 pages copied. 11/13/02 08:03:04 ANR0985I Process 337 for DATABASE BACKUP running in the BACKGROUND completed with completion state SUCCESS at 08:03:04. 11/14/02 06:00:15 ANR2750I Starting scheduled command ADSM_DATABASE_BACKUP- _INCR ( ba db dev=8mmexdev t=incr ). 11/14/02 06:00:25 ANR0984I Process 342 for DATABASE BACKUP started in the BACKGROUND at 06:00:25. 11/14/02 06:00:25 ANR2281I Incremental database backup started as process 342. 11/14/02 06:00:25 ANR2753I (ADSM_DATABASE_BACKUP_INCR):ANR2281I Incremental database 11/14/02 06:00:25 ANR2753I (ADSM_DATABASE_BACKUP_INCR):backup started as process 342. 11/14/02 06:00:25 ANR2756I Scheduled command ADSM_DATABASE_BACKUP_INCR started successfully. 11/14/02 06:01:30 ANR4554I Backed up 224 of 1891 database pages. 11/14/02 06:01:31 ANR4554I Backed up 448 of 1891 database pages. 11/14/02 06:01:31 ANR4554I Backed up 672 of 1891 database pages. 11/14/02 06:01:32 ANR4554I Backed up 896 of 1891 database pages. 11/14/02 06:01:32 ANR4554I Backed up 1120 of 1891 database pages. 11/14/02 06:01:33 ANR4554I Backed up 1344 of 1891 database pages. 11/14/02 06:01:34 ANR4554I Backed up 1568 of 1891 database pages. 11/14/02 06:01:34 ANR4554I Backed up 1792 of 1891 database pages. 11/14/02 06:01:44 ANR4551I Incremental database backup (process 342) complete, 1891 pages copied. 11/14/02 06:01:44 ANR0985I Process 342 for DATABASE BACKUP running in the BACKGROUND completed with completion state SUCCESS at 06:01:44. 11/14/02 08:00:12 ANR0984I Process 343 for DATABASE BACKUP started in the BACKGROUND at 08:00:12. 11/14/02 08:00:12 ANR2280I Full database backup started as process 343. 11/14/02 08:01:30 ANR4554I Backed up 8512 of 68141 database pages. 11/14/02 08:01:37 ANR4554I Backed up 17024 of 68141 database pages. 11/14/02 08:01:44 ANR4554I Backed up 25536 of 68141 database pages. 11/14/02 08:01:51 ANR4554I Backed up 34048 of 68141 database pages. 11/14/02 08:01:58 ANR4554I Backed up 42560 of 68141 database pages. 11/14/02 08:02:04 ANR4554I Backed up 51072 of 68141 database pages. 11/14/02 08:02:10 ANR4554I Backed up 59584 of 68141 database pages. 11/14/02 08:02:30 ANR4554I Backed up 68096 of 68141 database pages. 11/14/02 08:02:40 ANR4550I Full database backup (process 343) complete, 68141 pages copied. 11/14/02 08:02:40 ANR0985I Process 343 for DATABASE BACKUP running in the BACKGROUND completed with completion state SUCCESS at 08:02:40. 11/15/02 08:00:11 ANR0984I Process 348 for DATABASE BACKUP started in the BACKGROUND at 08:00:11. 11/15/02 08:00:11 ANR2280I Full database backup started as process 348. 11/15/02 08:01:23 ANR4554I Backed up 8512 of 68200 database pages. 11/15/02 08:01:28 ANR4554I Backed up 17024 of 68200 database pages. 11/15/02 08:01:36 ANR4554I Backed up 25536 of 68200 database pages. 11/15/02 08:01:43 ANR4554I Backed up 34048 of 68200 database pages. 11/15/02 08:01:50 ANR4554I Backed up 42560 of 68200 database pages. 11/15/02 08:01:56 ANR4554I Backed up 51072 of 68200 database pages. 11/15/02 08:02:03 ANR4554I Backed up 59584 of 68200 database pages. 11/15/02 08:02:25 ANR4554I Backed up 68096 of 68200 database pages. 11/15/02 08:02:34 ANR4550I Full database backup (process 348) complete, 68200 pages copied. 11/15/02 08:02:35 ANR0985I Process 348 for DATABASE BACKUP running in the BACKGROUND completed with completion state SUCCESS at 08:02:35. 11/16/02 08:00:12 ANR0984I Process 354 for DATABASE BACKUP started in the BACKGROUND at 08:00:12. 11/16/02 08:00:12 ANR2280I Full database backup started as process 354. 11/16/02 08:01:26 ANR4554I Backed up 8528 of 68235 database pages. 11/16/02 08:01:34 ANR4554I Backed up 17056 of 68235 database pages. 11/16/02 08:01:43 ANR4554I Backed up 25584 of 68235 database pages. 11/16/02 08:01:53 ANR4554I Backed up 34112 of 68235 database pages. 11/16/02 08:02:03 ANR4554I Backed up 42640 of 68235 database pages. 11/16/02 08:02:12 ANR4554I Backed up 51168 of 68235 database pages. 11/16/02 08:02:22 ANR4554I Backed up 59696 of 68235 database pages. 11/16/02 08:02:50 ANR4554I Backed up 68224 of 68235 database pages. 11/16/02 08:02:59 ANR4550I Full database backup (process 354) complete, 68235 pages copied. 11/16/02 08:02:59 ANR0985I Process 354 for DATABASE BACKUP running in the BACKGROUND completed with completion state SUCCESS at 08:02:59. 11/17/02 08:00:11 ANR0984I Process 359 for DATABASE BACKUP started in the BACKGROUND at 08:00:11. 11/17/02 08:00:11 ANR2280I Full database backup started as process 359. 11/17/02 08:01:22 ANR4554I Backed up 8528 of 68253 database pages. 11/17/02 08:01:28 ANR4554I Backed up 17056 of 68253 database pages. 11/17/02 08:01:35 ANR4554I Backed up 25584 of 68253 database pages. 11/17/02 08:01:41 ANR4554I Backed up 34112 of 68253 database pages. 11/17/02 08:01:48 ANR4554I Backed up 42640 of 68253 database pages. 11/17/02 08:01:54 ANR4554I Backed up 51168 of 68253 database pages. 11/17/02 08:02:00 ANR4554I Backed up 59696 of 68253 database pages. 11/17/02 08:02:20 ANR4554I Backed up 68224 of 68253 database pages. 11/17/02 08:02:29 ANR4550I Full database backup (process 359) complete, 68253 pages copied. 11/17/02 08:02:29 ANR0985I Process 359 for DATABASE BACKUP running in the BACKGROUND completed with completion state SUCCESS at 08:02:29. 11/18/02 06:00:00 ANR2750I Starting scheduled command ADSM_DATABASE_BACKUP ( backup db dev=8mmexdev type=full ). 11/18/02 06:00:10 ANR0984I Process 362 for DATABASE BACKUP started in the BACKGROUND at 06:00:10. 11/18/02 06:00:10 ANR2280I Full database backup started as process 362. 11/18/02 06:00:10 ANR2753I (ADSM_DATABASE_BACKUP):ANR2280I Full database backup 11/18/02 06:00:10 ANR2753I (ADSM_DATABASE_BACKUP):started as process 362. 11/18/02 06:00:10 ANR2756I Scheduled command ADSM_DATABASE_BACKUP started successfully. 11/18/02 06:01:22 ANR4554I Backed up 8528 of 68256 database pages. 11/18/02 06:01:28 ANR4554I Backed up 17056 of 68256 database pages. 11/18/02 06:01:36 ANR4554I Backed up 25584 of 68256 database pages. 11/18/02 06:01:45 ANR4554I Backed up 34112 of 68256 database pages. 11/18/02 06:01:55 ANR4554I Backed up 42640 of 68256 database pages. 11/18/02 06:02:04 ANR4554I Backed up 51168 of 68256 database pages. 11/18/02 06:02:14 ANR4554I Backed up 59696 of 68256 database pages. 11/18/02 06:02:42 ANR4554I Backed up 68224 of 68256 database pages. 11/18/02 06:02:52 ANR4550I Full database backup (process 362) complete, 68256 pages copied. 11/18/02 06:02:52 ANR0985I Process 362 for DATABASE BACKUP running in the BACKGROUND completed with completion state SUCCESS at 06:02:52. 11/18/02 08:00:04 ANR0984I Process 363 for DATABASE BACKUP started in the BACKGROUND at 08:00:04. 11/18/02 08:00:04 ANR2280I Full database backup started as process 363. 11/18/02 08:01:14 ANR4554I Backed up 8528 of 68238 database pages. 11/18/02 08:01:21 ANR4554I Backed up 17056 of 68238 database pages. 11/18/02 08:01:27 ANR4554I Backed up 25584 of 68238 database pages. 11/18/02 08:01:34 ANR4554I Backed up 34112 of 68238 database pages. 11/18/02 08:01:41 ANR4554I Backed up 42640 of 68238 database pages. 11/18/02 08:01:47 ANR4554I Backed up 51168 of 68238 database pages. 11/18/02 08:01:54 ANR4554I Backed up 59696 of 68238 database pages. 11/18/02 08:02:13 ANR4554I Backed up 68224 of 68238 database pages. 11/18/02 08:02:22 ANR4550I Full database backup (process 363) complete, 68238 pages copied. 11/18/02 08:02:22 ANR0985I Process 363 for DATABASE BACKUP running in the BACKGROUND completed with completion state SUCCESS at 08:02:22. 11/18/02 13:17:33 ANR2017I Administrator HANA issued command: QUERY ACTLOG BEGINDATE=11/11/2002 BEGINTIME=NOW-1:00 ENDDATE=11/18/2- 002 ENDTIME=NOW SEARCH=Database ORIGINATOR=ALL 11/17/02 11:30:09 ANR2017I Administrator HANA issued command: DELETE VOLHISTORY tod=today-2 t=dbb 11/17/02 11:30:09 ANR2467I DELETE VOLHISTORY: 6 sequential volume history entries were successfully deleted. 11/17/02 11:30:33 ANR2017I Administrator HANA issued command: DELETE VOLHISTORY tod=today-1 t=dbb 11/17/02 11:30:34 ANR2467I DELETE VOLHISTORY: 1 sequential volume history entries were successfully deleted. 11/17/02 11:30:58 ANR2467I DELETE VOLHISTORY: 1 sequential volume history entries were successfully deleted. Hana Taha Parker Drilling Company 281.406.2486