The environment under scrutiny here is Unidata on Solaris. We, too, want to do the snapshot thing to minimize the downtime.
Seems like this is pretty darn straightforward? Kelly J. Lipp VP Manufacturing & CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rick Saylor Sent: Monday, April 23, 2007 12:39 PM To: [email protected] Subject: Re: [ADSM-L] Backup procedures for PICK/UNIDATA Kelly, Our Unidata database is backed up with TSM and as you've suggested the dbpause and dbresume are used to ensure a good backup. A TSM prebackup script pauses the database, takes a snapshot of the database and then resumes the database access. TSM then backs up the now static copy of the database. This way the database is only paused for a few seconds. Once the backup is complete a postbackup scripts removes the snapshot. You didn't say what your environment is but ours is AIX 5.2 with the database on a mirrored JFS2 filesystem. This has worked well for us. Each day the backup is restored to a remote site as well as our test system. We've never had any problems. Let me know if you have any other questions. Thanks, Rick Saylor Austin Community College At 11:21 AM 4/23/2007, you wrote: >Folks, > >Any of you esteemed folks using TSM to backup/restore UNIDATA or other >implementations of a PICK database? Specifically, are you using the >dbpause and dbresume commands? > >Easy, hard, impossible? > >Thoughts as always much appreciated. > >Thanks, > >Kelly J. Lipp >VP Manufacturing & CTO >STORServer, Inc. >485-B Elkton Drive >Colorado Springs, CO 80907 >719-266-8777 >[EMAIL PROTECTED] > ------------------------------------------------------------------------ ---- Rick Saylor Austin Community College Voice: (512)223-1182 Director of System Services 9101 Tuscany Way Fax: (512)223-1211 Information Technology Austin, Texas 78754
