Difference between revisions of "TSM"

From dbawiki
Jump to: navigation, search
(Query the archive to see if a file is available in TSM)
(Retrieve file from TSM)
Line 26: Line 26:
 
This opens an interactive window listing all files that match the file query (note the wildcard)<br />
 
This opens an interactive window listing all files that match the file query (note the wildcard)<br />
 
Files can be toggled on and off for recovery by pressing the number associated with the file then recover with the letter O.
 
Files can be toggled on and off for recovery by pressing the number associated with the file then recover with the letter O.
 +
 +
====Show details about all management classes on the TSM server====
 +
<pre>
 +
dsmc query mgmtclass -detail
 +
</pre>
 +
====Force a management class====
 +
In the DSM.opt file, use the include options to specify a management class.<br />
 +
When you archive files, you can override the assigned management class by using the archmc option.
 +
<pre>
 +
</pre>

Revision as of 17:35, 27 February 2013

Tivoli Storage Management

Send a file to TSM

dsmc archive -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_201301030007_01.dmp"

Query the archive to see if a file is available in TSM

dsmc query archive -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_20130103*"

Query all the files sent to the monthly node since start of FEB 2013 (displaying dates in YYYY-MM-DD format)

dsmc q ar -date=3 -fromdate=2013-02-01 -subdir=yes -se=SO_U_`uname -n`_ORX_M_BAX "/oracle/export/*"

List all export jobs on this TSM node

cd /oracle/export
dsmc q ar -subdir=yes -se=SO_U_UBENOA26_ORX_D_BAX "expdp*"

Retrieve file from TSM

dsmc retrieve -pick -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_20130103*"

This opens an interactive window listing all files that match the file query (note the wildcard)
Files can be toggled on and off for recovery by pressing the number associated with the file then recover with the letter O.

Show details about all management classes on the TSM server

dsmc query mgmtclass -detail

Force a management class

In the DSM.opt file, use the include options to specify a management class.
When you archive files, you can override the assigned management class by using the archmc option.