Re: ISC and Tivoli Storage Administration Center Passwords
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
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
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
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
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
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
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
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
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
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
>> 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
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
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
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
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
>> 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
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
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 ...
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
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
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
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.