dba-db2.com - db2 performance tuning, DB2 tuning,db2 performance,sql tuning db2, DBA in DB2, DBA Scripts,DB2,DB2 consulting,DB2 consultant,DB2 architecture,DB2 training

Avamar avtar command option cheat sheet

15 March,2016 by Tom Collins

I've started getting into Avamar as a backup and restore system for DB2. I'm learning all sorts of avtar client command options. I've decided to set up this page as a quick reference.  I'll update regularly

To view all the command options

# ./avtar --help

To view the command line option usages

# ./avtar --usage


To recover information on databases through the avtar

# ./avtar --flagfile=/usr/local/avamar/avdb2.flg --backups

 

To view  the database details grab the value from --backiups and then run

./avtar --flagfile=/usr/local/avamar/avdb2.flg -tv --labelnum=38

 To list backups completed and stored on the data storage system

./avtar --flagfile=/usr/local/avamar/avdb2.flg --list

To encode a clear text password : its corresponding encrypted password will be displayed to STDOUT 

./avtar --encodepassword=my_clear_text_password

Read More on DB2 backup and restore

DB2 – Restore database from a ONLINE backup - DBA DB2

DB2 – Backup history - DBA DB2

How to terminate a DB2 backup - DBA DB2

DB2 - Backup all databases on Primary Server - DBA DB2

 

Author: Rambler(http://www.dba-db2.com)

Share:

Posted by Tom Collins at 12:51 PM in Backup & Restore | Permalink | Comments (4)

very nice. I'm a very experienced DB2 DBA , but Avamar DB2 API is new to me. My support team is used to a GUI annd couldn't assist me in finding missing transaction log files in Avamar.

I found the recover information and the logs. Now I have to figure out why DB2 isn't finding the tran logs in Avamar. my rollforward to PIT is failing - cann't find the file.

Posted by: Anke | May 31, 2016 12:33:01 PM

Anke , Are you connecting to a data domain? Are you using Avtar to list the backups taken?
The list command is further up this page.

Have the transaction logs expired and been removed from the backup system ?

Posted by: Jack Vamvas | Aug 17, 2016 8:29:38 AM

Hi

Can I initiate a backup on a remote PC in my domain / network, Perhaps using a CMD or any other method?

Posted by: Rami Metanes | Jul 12, 2017 12:27:28 AM

Hi Rami - there a number of ways you could make this happen
1)Through the Avamar Console
2)Through connecting to the remote PC via WSMan or similar and executing a command (or wrap it up in a batch file)

Posted by: Jack Vamvas | Jul 12, 2017 6:40:00 AM

Verify your Comment

Previewing your Comment

Posted by: |

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Avamar avtar command option cheat sheet

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright