Difference between revisions of "TSM"

From dbawiki
Jump to: navigation, search
(Force a management class)
(Tivoli Storage Management)
Line 1: Line 1:
===Tivoli Storage Management===
+
==Tivoli Storage Management==
  
====Send a file to TSM====
+
===Send a file to TSM===
 
<pre>
 
<pre>
 
dsmc archive -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_201301030007_01.dmp"
 
dsmc archive -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_201301030007_01.dmp"
 
</pre>
 
</pre>
  
====Query the archive to see if a file is available in TSM====
+
===Query the archive to see if a file is available in TSM===
 
<pre>
 
<pre>
 
dsmc query archive -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_20130103*"
 
dsmc query archive -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_20130103*"
Line 14: Line 14:
 
dsmc q ar -date=3 -fromdate=2013-02-01 -subdir=yes -se=SO_U_`uname -n`_ORX_M_BAX "/oracle/export/*"</pre>
 
dsmc q ar -date=3 -fromdate=2013-02-01 -subdir=yes -se=SO_U_`uname -n`_ORX_M_BAX "/oracle/export/*"</pre>
  
====List all export jobs on this TSM node====
+
===List all export jobs on this TSM node===
 
<pre>
 
<pre>
 
cd /oracle/export
 
cd /oracle/export
Line 20: Line 20:
 
</pre>
 
</pre>
  
====Retrieve file from TSM====
+
===Retrieve file from TSM===
 
<pre>
 
<pre>
 
dsmc retrieve -pick -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_20130103*"
 
dsmc retrieve -pick -server=SO_U_ubenoa31_ORX_D_BAX "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_20130103*"
Line 27: Line 27:
 
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====
+
===Show details about all management classes on the TSM server===
 
<pre>
 
<pre>
 
dsmc query mgmtclass -detail
 
dsmc query mgmtclass -detail
 
</pre>
 
</pre>
 +
 
===Force a management class===
 
===Force a management class===
 
In the DSM.opt file, use the include options to specify a management class.<br />
 
In the DSM.opt file, use the include options to specify a management class.<br />

Revision as of 13:27, 27 September 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.

dsmc archive -archmc=D01MAC_M14 "/oracle/export/NSWORKP1/export_NSWORKP1_D_FULL_201301030007_01.dmp"

Restart LANFree Storage agent

udevdba31:root[/home/root]# ps -ef|grep dsmsta
    root 13828246        1   0   Mar 26      - 512:39 /usr/tivoli/tsm/StorageAgent/bin/dsmsta
    root 29491300 62259284   0 11:58:29  pts/1  0:00 grep dsmsta
udevdba31:root[/home/root]# kill 13828246
udevdba31:root[/home/root]# ps -ef|grep dsmsta
    root 41418862 62259284   0 11:58:48  pts/1  0:00 grep dsmsta
udevdba31:root[/home/root]# cat /etc/inittab | grep stg
autostgagnt:2:off:/usr/tivoli/tsm/StorageAgent/bin/rc.tsmstgagnt
udevdba31:root[/home/root]# at now
/usr/tivoli/tsm/StorageAgent/bin/rc.tsmstgagnt<CTRL-D>
Job root.1366365724.a will be run at Fri Apr 19 12:02:04 DFT 2013.
udevdba31:root[/home/root]# ps -ef|grep dsmsta
    root 20906202 62259284   0 12:02:28  pts/1  0:00 grep dsmsta
    root 64225302  3735904   0 12:02:16      -  0:01 dsmsta quiet
udevdba31:root[/home/root]#

Update number of mount points for a node

tsm: TSMSRV1>upd node CLUBDEV maxnummp=4
ANR2063I Node CLUBDEV updated.