Justin, YOu must first define a device class of type FILE. For example:
DEFINE DEVCLASS dbbkupondisk DEVTYPE=FILE FORMAT=DRIVE MAXCAPACITY=500M MOUNTLIMIT=1 DIRECTORY=/var/adsmpool SHARED=NO * dbbkupondisk is a name I made up, pick anything you like. * DIRECTORY is just the path/directory name where you want to put the disk database dump. If your TSM server is Windows, yours will look more like: C:\TEMP\TSMdir * MAXCAPACITY is the max size you want the output to be; make it large enough to handle 1 DB backup. (It will still work if you make it too small, but gets more complicated.) One you have created the devclass, you start your DB backup pointing to that device class: BACKUP DB TYPE=INCR DEVCLASS=DBBACKUPONDISK SCRATCH=YES Watch your activity log to see what happens. TSM will start the DB backup, CREATE a backup for you in that directory. You will see in the activity log the name of the file that gets created. (If the DB backup is bigger than MAXCAPACITY, TSM just keeps creating more files as needed.) Hope that helps. ************************************************************************ Wanda Prather The Johns Hopkins Applied Physics Lab 443-778-8769 [EMAIL PROTECTED] "Intelligence has much less practical application than you'd think" - Scott Adams/Dilbert ************************************************************************ -----Original Message----- From: Justin Bleistein [mailto:[EMAIL PROTECTED]] Sent: Monday, June 17, 2002 10:47 PM To: [EMAIL PROTECTED] Subject: Re: db backups to disk files... Anyone have procedures onto how to make these disk database dumps to disk like the one below. I can't seem to dump the database to disk. Any syntax would be appreciated thanks! --Justin Richard Bleistein Alex Paschal <AlexPaschal@FREIGHT To: [EMAIL PROTECTED] LINER.COM> cc: Sent by: "ADSM: Dist Subject: Re: db backups to disk files... Stor Manager" <[EMAIL PROTECTED] U> 06/17/2002 09:48 PM Please respond to "ADSM: Dist Stor Manager" Maybe they hired an ex-Microsoft programmer? <grin> Watch, my next job interview will be with an ex-Microsoft programmer who belongs to this list. Alex -----Original Message----- From: Cook, Dwight E [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 10:58 AM To: [EMAIL PROTECTED] Subject: db backups to disk files... Just noticed, if you back up your db to a disk file, at least on AIX 4.3.3 with TSM server 4.2.2.0 the reported file name and the actual file name are different ! ! ! tsm: TSMUTL01>q volhist t=dbb Date/Time: 06/14/2002 11:46:20 Volume Type: BACKUPFULL Backup Series: 8 Backup Operation: 0 Volume Seq: 1 Device Class: FLATFILE Volume Name: /usr/adsm/24073180.DBB Volume Location: Command: tsm: TSMUTL01> root@tsmutl01/usr/adsm > ls -l total 165016 -rw------- 1 root system 84424780 Jun 14 11:46 24073180.dbb The difference is in the case of the DBB vs dbb I've checked and the "del volhist t=dbb tod=blah" will still properly clear the old files from disk but why oh why have they done this to us ! ? ! just checked as reported by the actual process Process Process Description Status Number -------- -------------------- ------------------------------------------------- 2 Database Backup Full backup: 0 pages of 20571 backed up. Current output volume: /usr/adsm/24077489.DBB. same thing, upper in one place and lower in the other root@tsmutl01/usr/adsm > ls -l total 329928 -rw------- 1 root system 84424780 Jun 14 11:46 24073180.dbb -rw------- 1 root system 84432479 Jun 14 12:58 24077489.dbb just FYI... Dwight E. Cook Software Application Engineer III Science Applications International Corporation 509 S. Boston Ave. Suit 220 Tulsa, Oklahoma 74103-4606 Office (918) 732-7109
