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

Reply via email to