Re: ISC and Tivoli Storage Administration Center Passwords

2007-03-22 Thread Sandeep Jain

Further in addition you can check your TSM server password by using
following command.

C:\progra~1\tivoli\tsm\baclient\dsmadmc

userid: admin  password:

Try this to check whether you are able to login.
 

 ( o )
 ---
I,I ' ' I,I
  "(("

))



With Best Regards,

Sandeep Jain

 

 

** Legal Disclaimer
*

"This email may contain confidential and privileged material for the sole
use of the intended recipient. Any unauthorized review, use or distribution
by others is strictly prohibited. If you have received the message in error,
please advise the sender by reply email and delete the message. Thank you." 


* 

 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Helder Garcia
Sent: Thursday, March 22, 2007 8:57 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] ISC and Tivoli Storage Administration Center Passwords

I think there are some misunderstandings.
First step: you receive an userid/password to login to ISC, AdminCenter is
there.
IF you have an userid/password for TSM Server A, you can add it to your view
on ISC to able to manage it. You use the "Add Server Connection" task for
that.
IF you have an userid/password for TSM Server B, , and so on.

The users and password can be completely differents, you want that! The ISC
plays a role of single sign-on for the TSM instances. You log in ISC once,
and all relationships TSM_Server/Admin/Password are kept encrypted inside
ISC, so you don't need to provide them again when commanding some task on
those TSM servers.


On 3/20/07, Sandeep Jain <[EMAIL PROTECTED]> wrote:
>
> Hi
> 1. Both ISC and TSM server password are unique
> 2. if you are able to login to ISC and not able to Add a TSM server
> connection that there is a possibility that either password which you are
> giving is wrong or your TSM server is not UP.
>
>
>
>   ( o )
> ---
> I,I ' ' I,I
>   "(("
> ))
>
> With Best Regards,
> Sandeep Jain
>
>
> ** Legal Disclaimer
> *
>
> "This email may contain confidential and privileged material for the sole
> use of the intended recipient. Any unauthorized review, use or
> distribution
> by others is strictly prohibited. If you have received the message in
> error,
> please advise the sender by reply email and delete the message. Thank
> you."
>
>
>

> *
>
>
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
> Werner Nussbaumer
> Sent: Tuesday, March 20, 2007 3:53 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: [ADSM-L] ISC and Tivoli Storage Administration Center Passwords
>
> Hi
>
> Is it necessary that both passwords of the "IBM Integrated Solutions
> Console" and the "IBM Tivoli Storage Administration Center" must be the
> same. Or is there a way to say in the ISC that the synchronizes the
> password, lets say that you can open a user, give a default password
> which then must be changed in the ISC and which is synchronized with
> TSM. If not, the user starts the ISC but is not able to connect to the
> TSM server because the password does not match. And then also the user
> has no possibility to change the password for TSM server in the ISC.
>
> Thanks for any help
> regards
> Werner Nussbaumer
>
>
>
>
> This email has been scanned for any virus infection at the sending end.




--
Helder Garcia




This email has been scanned for any virus infection at the sending end.

Re: Select command for TOTAL DAILY BACKUP

2007-03-22 Thread Steven Harris

Luc

If you have a straightforward backup of every storage pool every day, 
then amount backed up = amount copied to storagepools.
This number can be gotten from the actlog for each process or from the 
summary table.


Hope this helps.

Steve

Steven Harris
AIX and TSM Admin
Brisbane Australia


Luc Beaudoin wrote:

I have a blank

I want to know how many GB I'm taking in backup everyday  ...  I would 
like the TOTAL not by nodes ...


any ideas

thanks

Luc Beaudoin
Administrateur Réseau / Network Administrator
Hopital General Juif S.M.B.D.
Tel: (514) 340-8222 ext:8254 



  


Re: Wiindows 2000 and 2003 servers backups very poor performance

2007-03-22 Thread Jeremy Curtis
I agree on the speed/duplex.  I have personally seen speed/duplex
mismatch cause this.  I don't personally have issues with Auto, just
make sure both sides(server and switch) match. 

Jeremy Curtis
Backup Administrator / Network Technician
Vail Resorts, Inc. 
(970) 845-1921



-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Kelly Lipp
Sent: Thursday, March 22, 2007 3:56 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Wiindows 2000 and 2003 servers backups very poor
performance

I will amplify Curtis' call on this: check the NICs.  Especially if you
are on 100MB Ethernet.  For GigE, you generally can't choose, but make
it all the same in the path between the server and TSM.

As for testing: try an ftp of a large file (a gig or so so it stays on
the wire for a minute or so).  If this is faster than you are getting
from TSM, you have a TSM problem.  If it is the same speed, you have a
network problem. 


Kelly J. Lipp
VP Manufacturing & CTO
STORServer, Inc.
485-B Elkton Drive
Colorado Springs, CO 80907
719-266-8777
[EMAIL PROTECTED]

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Carpenter, Curtis
Sent: Thursday, March 22, 2007 3:52 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Wiindows 2000 and 2003 servers backups very poor
performance

I would make sure whatever speed and duplex setting you have the nic set
to, you should set the switch port to match.  I would try to avoid
setting both to autonegotiate, as I have personally seen horrible
performance with that setting.  Also, run diags on network interfaces to
rule out any hardware problems.  Are u using a seperate nic for your
tivoli backups or are u using just one nic for all network communication
on these servers?
--Original Message--
From: Timothy Hughes
To: ADSM-L
ReplyTo: ADSM-L
Sent: Mar 22, 2007 3:33 PM
Subject: [ADSM-L] Wiindows 2000 and 2003 servers backups very poor
performance

Hello,


We have about 5 or 6 Windows Servers whose backups performance is very
very poor these backups start a midnight and run throughout the whole
day and sometimes run for a couple days I have been reading different
options including the DISKBuffsize option,  I know poor networking
performance can be caused by a number of factors and not sure which
parameter to look at first.

Here is an example of one of the clients dsm.opt file, They all
basically look the same and the parameters matches TSM windows clients
recommendations.


Lang Ameng
Domain ALL-LOCAL
TCPSERVERADDRESS  .xxx.x.xx.xx
Passwordaccess generate
TCPCLIENTADDRESS  xx.xx.xxx.xx
NODENAME 
SUBDIR YES
REPLACE PROMPT
TCPB 32
TCPW 63
SCHEDMODE PROMPTED
TXNBYTELIMIT 25600
ERRORLOGNAME
SCHEDLOGNAME
ERRORLOGRETENTION 14
SCHEDLOGRETENTION 7
TCPNODELAY YES
RESOURCEUTILIZATION 3
LARGECOMMBUFFERS YES
CHANGINGRETRIES 2
COMPRESSION
BACKUPREG YES
MANAGEDSERVICES WEBCLIENT SCHEDULE



Windows 2000 and 2003 servers
TSM server 5.3.4
TSM client 5.3.4


Re: Re: Select command for TOTAL DAILY BACKUP

2007-03-22 Thread David Bronder
Richard Rhodes wrote:
>
> If you trust the summary table (which you probably shouldn't) this is
> interesting for all activity in last 25hr by activity( I overlap 1 hr
> for my reports).  It's a start to add a where clase for just backup
> activity.

I use some similar queries for a daily "feel" of the TSM workload,
wrapped in a perl script and run from cron.  Broader scope than just
daily backup volume, but I figured I'd share.  I don't actually do
anything formal with this output, it's just taking the pulse of TSM.

Here are the raw select statements:

Activity Summary:

  select activity as "Operation  ", -
cast(count(activity) as decimal(5,0)) as "Times", -
cast(sum(affected) as integer) as "Objects", -
cast(sum(examined) as integer) as "Examined", -
cast(sum(bytes) / 1024 / 1024 as decimal(9,0)) as "Megabytes" -
from summary where end_time>current_timestamp-(1)day -
group by activity


Storage Pool Backup Summary:

  select entity as "Storage Pool", -
cast(sum(affected) as integer) as "Objects", -
cast(sum(bytes) / 1024 / 1024 as integer) as "Megabytes" -
from summary where activity='STGPOOL BACKUP' and -
end_time>current_timestamp-(1)day group by entity


Database Performance Summary:

  select activity,cast((end_time) as date) as "Date", -
(examined/cast((end_time-start_time) seconds as -
decimal(18,13))*3600) "Pages/Objects per Hour" from summary -
where (activity='FULL_DBBACKUP' or activity='EXPIRATION') -
and days(end_time)-days(start_time)=0 -
and end_time>current_timestamp-(1)day


--
Hello World.David Bronder - Systems Admin
Segmentation Fault ITS-SPA, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   [EMAIL PROTECTED]


Re: Wiindows 2000 and 2003 servers backups very poor performance

2007-03-22 Thread Kelly Lipp
I will amplify Curtis' call on this: check the NICs.  Especially if you
are on 100MB Ethernet.  For GigE, you generally can't choose, but make
it all the same in the path between the server and TSM.

As for testing: try an ftp of a large file (a gig or so so it stays on
the wire for a minute or so).  If this is faster than you are getting
from TSM, you have a TSM problem.  If it is the same speed, you have a
network problem. 


Kelly J. Lipp
VP Manufacturing & CTO
STORServer, Inc.
485-B Elkton Drive
Colorado Springs, CO 80907
719-266-8777
[EMAIL PROTECTED]

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Carpenter, Curtis
Sent: Thursday, March 22, 2007 3:52 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Wiindows 2000 and 2003 servers backups very poor
performance

I would make sure whatever speed and duplex setting you have the nic set
to, you should set the switch port to match.  I would try to avoid
setting both to autonegotiate, as I have personally seen horrible
performance with that setting.  Also, run diags on network interfaces to
rule out any hardware problems.  Are u using a seperate nic for your
tivoli backups or are u using just one nic for all network communication
on these servers?
--Original Message--
From: Timothy Hughes
To: ADSM-L
ReplyTo: ADSM-L
Sent: Mar 22, 2007 3:33 PM
Subject: [ADSM-L] Wiindows 2000 and 2003 servers backups very poor
performance

Hello,


We have about 5 or 6 Windows Servers whose backups performance is very
very poor these backups start a midnight and run throughout the whole
day and sometimes run for a couple days I have been reading different
options including the DISKBuffsize option,  I know poor networking
performance can be caused by a number of factors and not sure which
parameter to look at first.

Here is an example of one of the clients dsm.opt file, They all
basically look the same and the parameters matches TSM windows clients
recommendations.


Lang Ameng
Domain ALL-LOCAL
TCPSERVERADDRESS  .xxx.x.xx.xx
Passwordaccess generate
TCPCLIENTADDRESS  xx.xx.xxx.xx
NODENAME 
SUBDIR YES
REPLACE PROMPT
TCPB 32
TCPW 63
SCHEDMODE PROMPTED
TXNBYTELIMIT 25600
ERRORLOGNAME
SCHEDLOGNAME
ERRORLOGRETENTION 14
SCHEDLOGRETENTION 7
TCPNODELAY YES
RESOURCEUTILIZATION 3
LARGECOMMBUFFERS YES
CHANGINGRETRIES 2
COMPRESSION
BACKUPREG YES
MANAGEDSERVICES WEBCLIENT SCHEDULE



Windows 2000 and 2003 servers
TSM server 5.3.4
TSM client 5.3.4


Re: Wiindows 2000 and 2003 servers backups very poor performance

2007-03-22 Thread Carpenter, Curtis
I would make sure whatever speed and duplex setting you have the nic set to, 
you should set the switch port to match.  I would try to avoid setting both to 
autonegotiate, as I have personally seen horrible performance with that 
setting.  Also, run diags on network interfaces to rule out any hardware 
problems.  Are u using a seperate nic for your tivoli backups or are u using 
just one nic for all network communication on these servers?
--Original Message--
From: Timothy Hughes
To: ADSM-L
ReplyTo: ADSM-L
Sent: Mar 22, 2007 3:33 PM
Subject: [ADSM-L] Wiindows 2000 and 2003 servers backups very poor performance

Hello,


We have about 5 or 6 Windows Servers whose backups performance is very
very poor these
backups start a midnight and run throughout the whole day and sometimes
run for a couple days
I have been reading different options including the DISKBuffsize
option,  I know poor networking
performance can be caused by a number of factors and not sure which
parameter to look at first.

Here is an example of one of the clients dsm.opt file, They all
basically look the same and
the parameters matches TSM windows clients recommendations.


Lang Ameng
Domain ALL-LOCAL
TCPSERVERADDRESS  .xxx.x.xx.xx
Passwordaccess generate
TCPCLIENTADDRESS  xx.xx.xxx.xx
NODENAME 
SUBDIR YES
REPLACE PROMPT
TCPB 32
TCPW 63
SCHEDMODE PROMPTED
TXNBYTELIMIT 25600
ERRORLOGNAME
SCHEDLOGNAME
ERRORLOGRETENTION 14
SCHEDLOGRETENTION 7
TCPNODELAY YES
RESOURCEUTILIZATION 3
LARGECOMMBUFFERS YES
CHANGINGRETRIES 2
COMPRESSION
BACKUPREG YES
MANAGEDSERVICES WEBCLIENT SCHEDULE



Windows 2000 and 2003 servers
TSM server 5.3.4
TSM client 5.3.4





Re: Wiindows 2000 and 2003 servers backups very poor performance

2007-03-22 Thread Lawrence Clark
Not alwaysbut on a number of occassions I seen long
running backups on Windows servers
because they have the nic card set at an explicit setting, and the
network has auto-negotiate on the ports,
or some such mismatch between the client NIC and the port config.

>>> [EMAIL PROTECTED] 03/22/07 2:33 PM >>>
Hello,


We have about 5 or 6 Windows Servers whose backups performance is very
very poor these
backups start a midnight and run throughout the whole day and
sometimes
run for a couple days
I have been reading different options including the DISKBuffsize
option,  I know poor networking
performance can be caused by a number of factors and not sure which
parameter to look at first.

Here is an example of one of the clients dsm.opt file, They all
basically look the same and
the parameters matches TSM windows clients recommendations.


Lang Ameng
Domain ALL-LOCAL
TCPSERVERADDRESS  .xxx.x.xx.xx
Passwordaccess generate
TCPCLIENTADDRESS  xx.xx.xxx.xx
NODENAME 
SUBDIR YES
REPLACE PROMPT
TCPB 32
TCPW 63
SCHEDMODE PROMPTED
TXNBYTELIMIT 25600
ERRORLOGNAME
SCHEDLOGNAME
ERRORLOGRETENTION 14
SCHEDLOGRETENTION 7
TCPNODELAY YES
RESOURCEUTILIZATION 3
LARGECOMMBUFFERS YES
CHANGINGRETRIES 2
COMPRESSION
BACKUPREG YES
MANAGEDSERVICES WEBCLIENT SCHEDULE



Windows 2000 and 2003 servers
TSM server 5.3.4
TSM client 5.3.4


The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain information that is confidential, privileged, and/or otherwise exempt 
from disclosure under applicable law.  If this electronic message is from an 
attorney or someone in the Legal Department, it may also contain confidential 
attorney-client communications which may be privileged and protected from 
disclosure.  If you are not the intended recipient, be advised that you have 
received this message in error and that any use, dissemination, forwarding, 
printing, or copying is strictly prohibited.  Please notify the New York State 
Thruway Authority immediately by either responding to this e-mail or calling 
(518) 436-2700, and destroy all copies of this message and any attachments.


Re: Wiindows 2000 and 2003 servers backups very poor performance

2007-03-22 Thread Lamarr Kelley
Try setting the NIC cards to 100 mb Full duplex.
Also the switch port (if they're connected to switches) to match.


Lamarr Kelley
Network Specialist II
Information Technology
Huntsville Hospital
(c) 256-990-5003
(o) 256-265-9112

 Confidentiality Note: http://www.huntsvillehospital.org/footer/disclaimer/

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Timothy Hughes
Sent: Thursday, March 22, 2007 2:33 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Wiindows 2000 and 2003 servers backups very poor
performance

Hello,


We have about 5 or 6 Windows Servers whose backups performance is very
very poor these
backups start a midnight and run throughout the whole day and sometimes
run for a couple days
I have been reading different options including the DISKBuffsize
option,  I know poor networking
performance can be caused by a number of factors and not sure which
parameter to look at first.

Here is an example of one of the clients dsm.opt file, They all
basically look the same and
the parameters matches TSM windows clients recommendations.


Lang Ameng
Domain ALL-LOCAL
TCPSERVERADDRESS  .xxx.x.xx.xx
Passwordaccess generate
TCPCLIENTADDRESS  xx.xx.xxx.xx
NODENAME 
SUBDIR YES
REPLACE PROMPT
TCPB 32
TCPW 63
SCHEDMODE PROMPTED
TXNBYTELIMIT 25600
ERRORLOGNAME
SCHEDLOGNAME
ERRORLOGRETENTION 14
SCHEDLOGRETENTION 7
TCPNODELAY YES
RESOURCEUTILIZATION 3
LARGECOMMBUFFERS YES
CHANGINGRETRIES 2
COMPRESSION
BACKUPREG YES
MANAGEDSERVICES WEBCLIENT SCHEDULE



Windows 2000 and 2003 servers
TSM server 5.3.4
TSM client 5.3.4

Confidentiality Note:  http://www.huntsvillehospital.org/footer/disclaimer/



Confidentiality Note:  http://www.huntsvillehospital.org/footer/disclaimer/


Re: Running both 32- and 64-bit TDPOracle on same machine

2007-03-22 Thread Neil Rasmussen
Yes, this configuration is possible and supported.


Regards,

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




William Boyer <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" 
03/22/2007 11:55 AM
Please respond to
"ADSM: Dist Stor Manager" 


To
ADSM-L@VM.MARIST.EDU
cc

Subject
Running both 32- and 64-bit TDPOracle on same machine






I have a client with 2 versions of Oracle on the same Solaris machine.
They want to be able to do TSM backups using RMAN and TDP for
both instances.

Solaris 5.8
TSM Server 5.2.9 on AIX 5.2ML9
TSM Client 5.2.2.0
TDPO 32-bit 5.2.0

Oracle 32 bit version = 9.2.0.6
ORACLE_HOME Path = /oraapps/ipocdb/9.2.0

Oracle 64 bit version = 10.2.0.1.0
ORACLE_HOME = /oradb/oracle/10.2.0


Is it possible to install and run a TDPO 64-bit 5.3? As long as I install
the appropriate 64-bit TSM API.

The package names are different, and they install in different directories
(/bin and /bin64). Even looks like the libobk.so goes in
different places for creating the link.

Bill Boyer
>Select * from USERS where CLUE>0
0 rows returned


Re: TDPO and encryption

2007-03-22 Thread Neil Rasmussen
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: TDPO and encryption

2007-03-22 Thread Allen S. Rout
>> On Thu, 22 Mar 2007 10:24:32 +0100, Hans Christian Riksheim <[EMAIL 
>> PROTECTED]> said:

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

The last docs I saw about it, when distilled down, said "It might
work.  If it doesn't, then it's not supported.".

Underwhelming, but I understand that much of the API workflow is just
plain different than the B/A client flow.

- Allen S. Rout


Re: ISC and Tivoli Storage Administration Center Passwords

2007-03-22 Thread Robert Clark

It was meant to be tongue-in-cheek. Failure is additive when you
depend on services or systems outside your control. I've seen backups
fail because DNS was unavailable for example.

On the flip side, I've seen TSM loose out in a competitive situation
because it doesn't integrate into AD as well as some other products do.

This week, someone suggested backing up the Decru LKM (Lifetime Key
Manager) to TSM. I had to point out that in a real disaster, we'd
need the LKM to rebuild that dataforts to read TSM tapes. And if the
keys are stored on the tape?

Fun stuff. [RC]

On Mar 22, 2007, at 12:13 PM, Allen S. Rout wrote:


On Wed, 21 Mar 2007 17:09:21 -0700, Robert Clark
<[EMAIL PROTECTED]> said:



So when they call and ask us to restore the LDAP server, I can say
"I can't login, cause the LDAP server is down.".


I think you're confusing the tail and the dog.  If you're in a site
emergency like that, you can stand a momentary outage to permit
SERVER_CONSOLE to update RCLARK to use native authentication.

If you're in normal operations, having IDs and passwords consistent
across services saves many many people much time and confusion.  Far
from the least of these is the time and effort of the TSM
administrator who has to do a lot of commo to reset passwords for
rarely-accessd IDs which are out of sync with single signon.


- Allen S. Rout
- Wag, wag, woof.


Wiindows 2000 and 2003 servers backups very poor performance

2007-03-22 Thread Timothy Hughes

Hello,


We have about 5 or 6 Windows Servers whose backups performance is very
very poor these
backups start a midnight and run throughout the whole day and sometimes
run for a couple days
I have been reading different options including the DISKBuffsize
option,  I know poor networking
performance can be caused by a number of factors and not sure which
parameter to look at first.

Here is an example of one of the clients dsm.opt file, They all
basically look the same and
the parameters matches TSM windows clients recommendations.


Lang Ameng
Domain ALL-LOCAL
TCPSERVERADDRESS  .xxx.x.xx.xx
Passwordaccess generate
TCPCLIENTADDRESS  xx.xx.xxx.xx
NODENAME 
SUBDIR YES
REPLACE PROMPT
TCPB 32
TCPW 63
SCHEDMODE PROMPTED
TXNBYTELIMIT 25600
ERRORLOGNAME
SCHEDLOGNAME
ERRORLOGRETENTION 14
SCHEDLOGRETENTION 7
TCPNODELAY YES
RESOURCEUTILIZATION 3
LARGECOMMBUFFERS YES
CHANGINGRETRIES 2
COMPRESSION
BACKUPREG YES
MANAGEDSERVICES WEBCLIENT SCHEDULE



Windows 2000 and 2003 servers
TSM server 5.3.4
TSM client 5.3.4


Re: Select command for TOTAL DAILY BACKUP

2007-03-22 Thread Richard Rhodes
If you trust the summary table (which you probably shouldn't) this is
interesting for all activity in last 25hr by activity( I overlap 1 hr
for my reports).  It's a start to add a where clase for just backup
activity.

 select  count(*) as count, -
   sum(bytes)/1024/1024/1024 as GigaBytes, -
   activity -
 from  summary -
 where cast((current_timestamp-start_time)hours as decimal(8,0)) < 25 -
 or  cast((current_timestamp-end_time)hours as decimal(8,0)) < 25 -
   group by activity

Rick



btw . . .  I have a ksh script that generates a large report each morning
of the following reports.  We run
this against all our tsm servers each morning.  It's a fairly ugly AIX ksh
script that's highly
customized for our site, but it  might be useful for someone out there.  If
interested . . . please email directly.


== r000 ===
== morning_report for tsm3 on rsfebkup7p
== Sun Mar  4 06:00:02 EST 2007
===
=
= REPORT INDEX
=
= r000 report index and beginning time stamp
= r005 lib info
= r010 activity summary
= r015 scratch count
= r019 scratch tape usage
= r021 reclaimable tapes by pct-reclaim
= r022 volume info
= r023 volumes per stgpool status and maxscratch
= r024 volume average utilization by stgpool
= r025 q dr
= r030 q path
= r035 q mount
= r036 drive activity
= r040 q db
= r045 q log
= r050 log consumption and utilization
= r055 log pin info (not emailed)
= r060 q pro
= r065 q sess
= r070 q stgpool
= r075 q copygroup (not emailed)
= r076 q events for exceptions - missed backups (not emailed)
= r077 slow backups
= r080 db backups
= r085 expiration - completions
= r090 expiration - detail (not emailed)
= r095 drive and media errors
= r100 recplan dir listings
= r105 q volhost type=dbb
= r110 q volhost type=dbs (not emailed)
= r120 stgpool volumes: 7 day trend (not emailed)
= r125 aix errpt
= r129 tdp notes - summary
= r130 tdp notes - full (not emailed)
= r131 tdp notes - incremental (not emailed)
= r132 tdp notes - logs (not emailed)
= r140 session per node where count > 1 (not emailed)
= r141 q option (not emailed)
= r145 occupancy by server
= r150 occupancy by domain
= r152 occupancy by stgpool
= r155 occupancy by node (not emailed)
= r157 q audotocc (not emailed)
= r160 nodes with no associations
= r161 nodes with no associations EXCLUSION LIST
= r165 nodes never backed up (not emailed)
= r166 zzrt nodes with associations (not emailed)
= r170 filespaces not backed up in 7 days (not emailed)
= r175 filespaces never backed up (not emailed)
= r180 server critical errors
= r184 backup objects and bytes per domain (not emailed)
= r185 backup objects and bytes per node (not emailed)
= r190 q vol (not emailed)
= r195 q libvol (not emailed)
= r999 report end timestamp









   
 Luc Beaudoin  
 <[EMAIL PROTECTED] 
 MCGILL.CA> To 
 Sent by: "ADSM:   ADSM-L@VM.MARIST.EDU
 Dist Stor  cc 
 Manager"  
 <[EMAIL PROTECTED] Subject 
 .EDU> Select command for TOTAL DAILY  
   BACKUP  
   
 03/22/2007 02:13  
 PM
   
   
 Please respond to 
 "ADSM: Dist Stor  
 Manager"  
 <[EMAIL PROTECTED] 
   .EDU>   
   
   




I have a blank

I want to know how many GB I'm taking in backup everyday  ...  I would
like the TOTAL not by nodes ...

any ideas

thanks

Luc Beaudoin
Administrateur Réseau / Network Administrator
Hopital General Juif S.M.B.D.
Tel: (514) 340-8222 ext:8254


-
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If
the reader of

Running both 32- and 64-bit TDPOracle on same machine

2007-03-22 Thread William Boyer
I have a client with 2 versions of Oracle on the same Solaris machine. They 
want to be able to do TSM backups using RMAN and TDP for
both instances.

Solaris 5.8
TSM Server 5.2.9 on AIX 5.2ML9
TSM Client 5.2.2.0
TDPO 32-bit 5.2.0

Oracle 32 bit version = 9.2.0.6
ORACLE_HOME Path = /oraapps/ipocdb/9.2.0

Oracle 64 bit version = 10.2.0.1.0
ORACLE_HOME = /oradb/oracle/10.2.0


Is it possible to install and run a TDPO 64-bit 5.3? As long as I install the 
appropriate 64-bit TSM API.

The package names are different, and they install in different directories 
(/bin and /bin64). Even looks like the libobk.so goes in
different places for creating the link.

Bill Boyer
>Select * from USERS where CLUE>0
0 rows returned


Re: ISC and Tivoli Storage Administration Center Passwords

2007-03-22 Thread Allen S. Rout
>> On Wed, 21 Mar 2007 17:09:21 -0700, Robert Clark <[EMAIL PROTECTED]> said:

> So when they call and ask us to restore the LDAP server, I can say
> "I can't login, cause the LDAP server is down.".

I think you're confusing the tail and the dog.  If you're in a site
emergency like that, you can stand a momentary outage to permit
SERVER_CONSOLE to update RCLARK to use native authentication.

If you're in normal operations, having IDs and passwords consistent
across services saves many many people much time and confusion.  Far
from the least of these is the time and effort of the TSM
administrator who has to do a lot of commo to reset passwords for
rarely-accessd IDs which are out of sync with single signon.


- Allen S. Rout
- Wag, wag, woof.


Re: Select command for TOTAL DAILY BACKUP

2007-03-22 Thread Richard Sims

On Mar 22, 2007, at 2:13 PM, Luc Beaudoin wrote:


I have a blank

I want to know how many GB I'm taking in backup everyday  ...  I would
like the TOTAL not by nodes ...

any ideas


Something like the following, for backups ended thus far today:

SELECT Dec((SUM(BYTES) / (1024 * 1024 *1024)),15) as "BACKUP GB TODAY" -
from SUMMARY where (DATE(END_TIME) = CURRENT DATE) and ACTIVITY =
'BACKUP'

But the TSM accounting log is a better data source.

   Richard Sims


Select command for TOTAL DAILY BACKUP

2007-03-22 Thread Luc Beaudoin
I have a blank

I want to know how many GB I'm taking in backup everyday  ...  I would 
like the TOTAL not by nodes ...

any ideas

thanks

Luc Beaudoin
Administrateur Réseau / Network Administrator
Hopital General Juif S.M.B.D.
Tel: (514) 340-8222 ext:8254 


dsmaccnt help script ...

2007-03-22 Thread goc

hi all,
maybe will someone find this script useful, or at least anyone who
uses this http://people.bu.edu/rbs/adsm-report

the script automaticaly handles dsmaccnt.log and extracts stats for
last month with adsm-report.pl script and some other minor yada yada
...

greetz.

--

#!/bin/sh
#set -x
#
###
# generating statistics, bla bla ...
# working direcotory is : /usr/local/bin/adsm-report
# info : http://people.bu.edu/rbs/adsm-report
#
# RELATED : crontab entry which kicks of every 1st of the month for
previous month
#   crontab: 0 1 1 * * /usr/local/bin/adsm-report/adsm-report.sh >>
/usr/local/adsm-report/adsm-report.log 2>&1 # every 1st of the month
at 1AM o'clock make ADSM-REPORT for previous month
# TODO : finding out last months name - DONE
#   command line variable input possibility
#   customizing report outputname in perl script ...
#   bunch of other stuff
#   yada yada yada
###
#
###
# ENV
###
VER="v1.3"
WORK_DIR="/usr/local/bin/adsm-report"
REP_SCRIPT="adsm-report.pl"
DATE_DET="`date +\"%d%m%Y%H%M\"`"
DATE="`date +\"%d%m%Y\"`"
#CUR_MONTH="`date +\"%B\"`" # uncomment if doing current month
#CUR_YEAR="`date +\"%Y\"`"  # uncomment if doing current month
#EMAIL_ME="[EMAIL PROTECTED]" # CUSTOMIZE IT !
MAILEXE="mailx -s"
#MAIL_SUBJECT="ADSM-REPORT stats for $CUR_MONTH|$CUR_YEAR"# uncomment
if doing current month
#REP_FILE_NAME="ADSM-REP-$CUR_MONTH$CUR_YEAR" # uncomment if doing current month
HOST="`uname -n`"
BASE="`basename $0`"
DSMSERV_DIR="/usr/tivoli/tsm/server/bin"
ACCNT_LOG="dsmaccnt.log"
LWN="dsmaccnt.log.WORK"
DEF_OUTPUT="adsm-report-file"
FY="fromyear"
FM="frommonth"
TY="toyear"
TM="tomonth"
GZIP="/usr/bin/gzip -f" # forced overwrite gzipping
SLEEP="sleep 2"
CP="cp"
MV="mv"
PRI="print"
GZ_EXT="gz"
GZ_REDIR="-c"
TXT_EXT="txt"
UUENC="uuencode"
HR="#"
HR2="-"
CD="cd"
###
# ENV END
###
#
###
# FUNCTIONS
###
function last_month {
# this function finds out last months name and if it's December return
last year also as variable
${PRI} "Finding previous month name and year, if Dec return current
year as year - 1 ;-) ."
if [ `date +'%m'` -eq 1 ]; then
MONTH="Dec"
YEAR=`expr \`date +'%Y' \` - 1`
${PRI} ${HR2}
${SLEEP}
${PRI} "Last month is ${MONTH}, year is ${YEAR}."
else
MONTH=`echo "Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec"|awk -v
x=\`expr \\\`date +'%m' \\\` - 1\` '{print $x}'`
YEAR=`date +'%Y'`
${PRI} ${HR2}
${SLEEP}
${PRI} "Last month is ${MONTH}, year is ${YEAR}."
fi
}
###
function copy {
# copy account log to work dir - WARNING: it can be BIG
${PRI} "Copying account log to ${WORK_DIR} ."
#${PRI} "${CP} ${DSMSERV_DIR}/${ACCNT_LOG} ${WORK_DIR}/${ACCNT_LOG}"
${PRI} "${CP} ${DSMSERV_DIR}/${ACCNT_LOG} ${WORK_DIR}/${LWN}"
${PRI} ${HR2}
${SLEEP}
${CP} ${DSMSERV_DIR}/${ACCNT_LOG} ${WORK_DIR}/${LWN}
${PRI} "Finished copy."
${SLEEP}
}
###
function rename {
# renaming account log into work wersion ... ya i know i could do that
in previous function during copy but. no :-) ... actually this func is
not in use right now
${PRI} "Renaming account log into ${LWN} as working version name ."
${PRI} "${MV} ${WORK_DIR}/${ACCNT_LOG} ${WORK_DIR}/${LWN}"
${PRI} ${HR2}
${SLEEP}
${MV} ${WORK_DIR}/${ACCNT_LOG} ${WORK_DIR}/${LWN}
${PRI} "Renaming finished."
${SLEEP}
}
###
function start_report {
# starting report script
${PRI} "Starting report script ."
#${PRI} "${WORK_DIR}/${REP_SCRIPT} ${FY} ${CUR_YEAR} ${FM}
${CUR_MONTH} ${TY} ${CUR_YEAR} ${TM} ${CUR_MONTH} ${LWN}"   # uncomment
if doing current month
${PRI} "${WORK_DIR}/${REP_SCRIPT} ${FY} ${YEAR} ${FM} ${MONTH} ${TY}
${YEAR} ${TM} ${MONTH} ${LWN}"
${PRI} ${HR2}
${SLEEP}
# for current month and year decomment line below, for previous month
look 2 lines below LOL
#${WORK_DIR}/${REP_SCRIPT} ${FY} ${CUR_YEAR} ${FM} ${CUR_MONTH} ${TY}
${CUR_YEAR} ${TM} ${CUR_MONTH} ${LWN}# uncomment if doing current
month
# working as designed with year/mo

Re: ISC and Tivoli Storage Administration Center Passwords

2007-03-22 Thread Helder Garcia

I think there are some misunderstandings.
First step: you receive an userid/password to login to ISC, AdminCenter is
there.
IF you have an userid/password for TSM Server A, you can add it to your view
on ISC to able to manage it. You use the "Add Server Connection" task for
that.
IF you have an userid/password for TSM Server B, , and so on.

The users and password can be completely differents, you want that! The ISC
plays a role of single sign-on for the TSM instances. You log in ISC once,
and all relationships TSM_Server/Admin/Password are kept encrypted inside
ISC, so you don't need to provide them again when commanding some task on
those TSM servers.


On 3/20/07, Sandeep Jain <[EMAIL PROTECTED]> wrote:


Hi
1. Both ISC and TSM server password are unique
2. if you are able to login to ISC and not able to Add a TSM server
connection that there is a possibility that either password which you are
giving is wrong or your TSM server is not UP.



  ( o )
---
I,I ' ' I,I
  "(("
))

With Best Regards,
Sandeep Jain


** Legal Disclaimer
*

"This email may contain confidential and privileged material for the sole
use of the intended recipient. Any unauthorized review, use or
distribution
by others is strictly prohibited. If you have received the message in
error,
please advise the sender by reply email and delete the message. Thank
you."



*



-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Werner Nussbaumer
Sent: Tuesday, March 20, 2007 3:53 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] ISC and Tivoli Storage Administration Center Passwords

Hi

Is it necessary that both passwords of the "IBM Integrated Solutions
Console" and the "IBM Tivoli Storage Administration Center" must be the
same. Or is there a way to say in the ISC that the synchronizes the
password, lets say that you can open a user, give a default password
which then must be changed in the ISC and which is synchronized with
TSM. If not, the user starts the ISC but is not able to connect to the
TSM server because the password does not match. And then also the user
has no possibility to change the password for TSM server in the ISC.

Thanks for any help
regards
Werner Nussbaumer




This email has been scanned for any virus infection at the sending end.





--
Helder Garcia


Re: TDPO and encryption

2007-03-22 Thread Richard Sims

On Mar 22, 2007, at 5:24 AM, Hans Christian Riksheim wrote:


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.
...


Hans -

I see that the TDPO 5.3 manual talks of using the
ENABLECLIENTENCRYPTKEY API option to achieve that goal.  Perhaps you
could employ that?

  Richard Sims


TDPO and encryption

2007-03-22 Thread Hans Christian Riksheim
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.