Archive list query

[Paul Dudley]

I would like to run a query that will give me a list of all the archives
we have done.
I don't want a list of every file archived, just the general list of the
archive backups on each server.

I have found this command:

select distinct description from archives

But when I ran it TSM replied with a warning that this command may
create a very large table and take a long time to complete.

I would rather do this from the TSM server and not have to go to each
individual client to get this information.

Am I on the right track with the above command or is there another one I
should be running?

Regards
Paul

 
Paul Dudley
ANL IT Operations Dept.
ANL Container Line
[EMAIL PROTECTED]





ANL - CELEBRATING 50 YEARS

ANL DISCLAIMER
This e-mail and any file attached is confidential, and intended solely to the 
named addressees. Any unauthorised dissemination or use is strictly prohibited. 
If you received this e-mail in error, please immediately notify the sender by 
return e-mail from your system. Please do not copy, use or make reference to it 
for any purpose, or disclose its contents to any person.

Re: TDPO and encryption

[Prather, Wanda]

Ditto.
It's supported, and we've used it (with Oracle), and it works.
 



From: ADSM: Dist Stor Manager on behalf of Neil Rasmussen
Sent: Thu 3/22/2007 3:59 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: TDPO and encryption



Encryption is supported through the TSM API starting at 5.3. To set it up
with DP Oracle/RMAN you need to make the following changes in your dsm.sys
for the DP Oracle stanza, for instance:


enableclientencryptkey   yes
encryptiontype   AES128
include.encrypt  /adsmorc/.../*

This assumes that your TDPO_FS is 'adsmorc' (the default) and that you
want all Oracle backups to be encrypted.


Regards,

Neil Rasmussen
Software Development
Data Protection for Oracle
[EMAIL PROTECTED]




Hans Christian Riksheim <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" 
03/22/2007 02:24 AM
Please respond to
"ADSM: Dist Stor Manager" 


To
ADSM-L@VM.MARIST.EDU
cc

Subject
TDPO and encryption






Hi,

does anyone have any experience with rman/tdpo and encryption?

I have not found any detailed information on how to implement it and the
redbook from 2001(Backing up Oracle using TSM) does not mention it.

I have learned that there are two ways of doing it:

Client handles encryption through the API. Here I have not seen how to
set this up with RMAN.


API handles it transparently and stores the key on the TSM-server. I
haven't fully understood the security implications of this method. I
don't understand how this method can be as secure as for example
BA-encryption where the key is held by the administrator of the client.


Anyway, any tip on how to do it or pointers to information is much
appreciated.


Best regards

Hans Chr. Riksheim


This email
originates from Steria AS, Biskop Gunnerus' gate 14a, N-0051 OSLO,
http://www.steria.no  . This email and any attachments 
may contain
confidential/intellectual property/copyright information and is only for
the use of the addressee(s). You are prohibited from copying, forwarding,
disclosing, saving or otherwise using it in any way if you are not the
addressee(s) or responsible for delivery. If you receive this email by
mistake, please advise the sender and cancel it immediately. Steria may
monitor the content of emails within its network to ensure compliance with
its policies and procedures. Any email is susceptible to alteration and
its integrity cannot be assured. Steria shall not be liable if the message
is altered, modified, falsified, or even edited.

Re: Windows 2000 and 2003 servers backups very poor performance

[Timothy Hughes]

Thanks  Justin and Miguel

Miguel for the client we are using those recommended settings, they have
been in place since we started backung up the clients. As for the TSM
server settings I don't believe they need to be adjusted as we have many
other clients that are running fine.

Thanks




Miguel Saez wrote:


Review the following tunning:


Client TSM:

 - Set Ethernet speed and duplex settings (Don't rely on Auto Detect)
 - Specifies:
   tcpwindowssize  63(recommended)   2048
(max) in KB
   tcpbufsize  32(recommended)   2048
(max) in KB
   tcpnodelay  yes
   diskbuffsize  32 (recommended)
1023 (max) in KB
   compression yes

Server TSM

 - Set Ethernet speed and duplex settings (Don't rely on Auto Detect)
 - Specifies

   BufPoolSize   131072 (for server with 1 GB RAM)
   UseLargeBuffers   yes
   tcpwindowsize   63 (recommended)2048 (max) in
KB
   tcpbuffsize   32 (recommended)2048 (max) in KB
-- Use up to 3/4 of real memory for a dedicated TSM server

(no other applications).
   tcpnodelayyes


And  Use dedicated networks for backup (LAN or SAN).

Regards

Miguel Sáez Sáez
IBM Certified Deployment Professional
Tivoli Configuration Manager
IT Specialist
IBM de Chile S.A.C.
mail: [EMAIL PROTECTED]
Phone: 562-2006638