====== Tivoli Storage Manager Server ======

===== TSM Schedules =====
**Query TSM Schedule for node :**
<sxh bash>
q sch * n=*<NODENAME>*
q sch * <SCHEDULENAME> f=d
</sxh>

**Create TSM Schedule :**
<sxh bash>
define schedule TSM_DOMAIN HOT_BACKUP description="Hot backup" starttime=18:45:00 duration=4 period=1
define schedule TSM_DOMAIN DAILY_BACKUP description="Backup run every night" starttime=00:00:00 duration=4 period=1
define schedule TSM_DOMAIN NOON_BACKUP description="Backup at 12:00 (laptops etc.)" starttime=12:00:00 dayofweek=weekday duration=4 period=1
 
define association TSM_DOMAIN HOT_BACKUP tsmsrv01
</sxh>

===== TSM Server =====

**Assign new volume in storage pool :**
<sxh bash>
q stgpool
def vol backuppool G:\backuppool\bk1.dsm f=10000
def vol archivepool I:\archivepool\arc1.dsm f=10000
q stgpool
</sxh>

**Create new policy domain,policy set, management class for DB backups (Oracle/DB2) : **
<sxh bash>
define domain DB2PD DESCription="DB2 policy domain"
define policyset DB2PD DB2POL description="DB2 policy"
define mgmtclass DB2PD DB2POL DB2BKPCLASS1 description="DB2 Backups"
assign defmgmtclass DB2PD DB2POL DB2BKPCLASS1
 
define copygroup DB2PD DB2POL DB2BKPCLASS1 destination=BACKUPPOOL verexists=1 verdeleted=0 retextra=0 retonly=0
define copygroup DB2PD DB2POL DB2BKPCLASS1 type=archive destination=ARCHIVEPOOL retver=nolimit
 
validate policyset DB2PD DB2POL
activate policyset DB2PD DB2POL
</sxh>

**Register node for DB (Oracle/DB2) :**
<sxh bash>
register node DB2ASN01_DB2INST1 broodi1 domain=DB2PD archdelete=yes backdelete=yes
</sxh>

===== TDP for DB2 =====
**API Settings :**
<sxh bash>
export DSMI_CONFIG=/opt/tivoli/tsm/client/api/bin64/dsm_db2inst1.opt
export DSMI_DIR=/opt/tivoli/tsm/client/api/bin64
export DSMI_LOG=/home/db2inst1/ibm_dba/logs
</sxh>

===== TDP for Oracle =====

**/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt :**
<sxh bash>
***************************************************************************
* IBM Tivoli Storage Manager for Databases
*    Data Protection for Oracle
*
* Sample tdpo.opt for the LinuxAMD64 Data Protection for Oracle
*********************************************************************

DSMI_ORC_CONFIG    /opt/tivoli/tsm/client/api/bin64/dsm.opt
DSMI_LOG           /opt/tivoli/tsm/client/oracle/bin64

TDPO_FS            /ORADEV01ORA
TDPO_NODE           ORADEV01
TDPO_OWNER         root
TDPO_PSWDPATH      /opt/tivoli/tsm/client/oracle/bin64

TDPO_DATE_FMT      1
TDPO_NUM_FMT       1
TDPO_TIME_FMT      1

*TDPO_MGMT_CLASS_2   mgmtclass2
*TDPO_MGMT_CLASS_3   mgmtclass3
*TDPO_MGMT_CLASS_4   mgmtclass4
</sxh>

**/opt/tivoli/tsm/client/api/bin64/dsm.opt :**
<sxh bash>
Servername TSMSRV01_ORACLE
</sxh>

**/opt/tivoli/tsm/client/api/bin64/dsm.sys :**
<sxh bash>
SErvername  TSMSRV01_ORACLE
   COMMMethod         TCPip
   TCPPort            1500
   TCPServeraddress   tsmsrv01-bck
   Nodename	      ORADEV01
   Passwordaccess     prompt
</sxh>

**Create password file and verify TDP environment :**
<sxh bash>
/opt/tivoli/tsm/client/oracle/bin64/tdpoconf passw
/opt/tivoli/tsm/client/oracle/bin64/tdpoconf SHOWENVironment
</sxh>

===== Backup / Restore =====
**Selective backup of FS :**
<sxh bash>
dsmc selective /path/to/be/backed/* -subdir=yes
</sxh>

**Restore FS :**
<sxh bash>
dsmc restore /path/to/be/restored/* -subdir=yes
</sxh>