Re: [ADSM-L] Backup procedures for PICK/UNIDATA

2007-04-23 15:52:59
Subject: Re: [ADSM-L] Backup procedures for PICK/UNIDATA
From: Kelly Lipp <lipp AT STORSERVER DOT COM>
Date: Mon, 23 Apr 2007 13:52:35 -0600
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
lipp AT storserver DOT com

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Rick Saylor
Sent: Monday, April 23, 2007 12:39 PM
Subject: Re: [ADSM-L] Backup procedures for PICK/UNIDATA


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.

Rick Saylor

Austin Community College

At 11:21 AM 4/23/2007, you wrote:
>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.
>Kelly J. Lipp
>VP Manufacturing & CTO
>STORServer, Inc.
>485-B Elkton Drive
>Colorado Springs, CO 80907
>lipp AT storserver DOT com

Rick Saylor                  Austin Community College   Voice:
Director of System Services  9101 Tuscany Way           Fax:
Information Technology       Austin, Texas  78754

<Prev in Thread] Current Thread [Next in Thread>