Password synchronisation of TDPERP for SAP HANA on a scale-out cluster
Many thanks Efim I was almost there with it and your assistance pointed me at my problem. Although having thought I'd set up the proxy nodes correctly, I'd missed the ASNODENAME parameter from the dsm.sys files and wasn't actually accessing TSM via these nodes. I've re-configured it now and can see the proxy sessions coming through so all looks good now. Thanks again for your help. Andrew - Spotted a leak? If you spot a leak please report it immediately. Call us on 0800 57 3553 or go to http://www.yorkshirewater.com/leaks Get a free water saving pack Don't forget to request your free water and energy saving pack, it could save you money on your utility bills and help you conserve water. http://www.yorkshirewater.com/savewater The information in this e-mail, and any files transmitted with it, is confidential and may also be legally privileged. The contents are intended solely for the addressee only and are subject to the legal notice available at http://www.keldagroup.com/email.htm. This email does not constitute a binding offer, acceptance, amendment, waiver or other agreement, or create any obligation whatsoever, unless such intention is clearly stated in the body of the email. If you are not the intended recipient, please return the message by replying to it and then delete the message from your computer. Any disclosure, copying, distribution or action taken in reliance on its contents is prohibited and may be unlawful. Yorkshire Water Services Limited Registered Office Western House, Halifax Road, Bradford, BD6 2SZ Registered in England and Wales No 2366682
Re: sql assistance with getting files backed up and their sizes
The symptoms you are describing sound more like retries of files that changed while TSM was reading them than growth in the size of individual files. Having the 'compress' option set to 'no' would, as far as I know, rule out the possibility of growth in the size of individual backup files. The worst growth I have ever seen for individual files was about 30%, not the almost 100% you mention. Retries caused by changing files would be noted explicitly in the client log files. Thomas Denier Thomas Jefferson University -Gary Lee wrote: - I have at least two linux clients v6.4 tsm server 6.3.4 whose bytes backed up are nearly double the bytes inspected. Compress is set to no. I would like to find the offending files which are growing. The following script shows files backed up yesterday, for a specific node, (thanks andy raibeck), but I would like to add and order by file size. How do I add the object_id field for comparison with the contents table, but not print it? Script follows: [Script removed] The information contained in this transmission contains privileged and confidential information. It is intended only for the use of the person named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. CAUTION: Intended recipients should NOT use email communication for emergent or urgent health care matters.
Re: Activate SKLM on existing TS3500 partition
We only relabel scratch on our VTL. On the 3500 physical library, we don't relabel the tapes. Once a scratch tape is mounted, it will encrypt the data on that tape. When we implemented the TKLM encryption, I created another copypool to speed up the process just to get all of the tapes encrypted quickly. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Maurice van 't Loo Sent: Wednesday, November 04, 2015 5:14 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Activate SKLM on existing TS3500 partition Hello Kevin, Thanks for your answer. It entered in my spambox, so it took a while before I noticed it :-) So if I understand well, we can safely activate encryption on our existing library partition. But do we need to use "relabel scratch" on the library definition in TSM? Or does the robot recognise the use of normal scratch tapes without relabel as well? Thanks, Maurice 2015-10-21 22:34 GMT+02:00 Kevin Boatright : > Once you enable encryption on the tape library, it will encrypt the > data as it mounts the scratch tapes. > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf > Of Plair, Ricky > Sent: Wednesday, October 21, 2015 3:45 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Activate SKLM on existing TS3500 partition > > Hey Maurice, > > Did anyone reply to your email? > > We are performing about the same thing. We have the SKLM server built > and we are migrating from EKM. > > Rick > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf > Of Maurice van 't Loo > Sent: Wednesday, October 14, 2015 8:29 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] Activate SKLM on existing TS3500 partition > > Friends, > > We currently have TSM 7.1.1.3 with TS3500's and LTO6 drives in use. > SLKM server is build and tested successfully. > > Now we want to activate tape encryption. > > Can we just activate it on the library partition that is already in use? > Will it start using encryption when a new scratch tape is used? Or > when we relabel a volumes? (relabel scratch) > > Thanks, > Maurice van 't Loo > > _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ > _ _ _ CONFIDENTIALITY NOTICE: This email message, including any > attachments, is for the sole use of the intended recipient(s) and may > contain confidential and privileged information and/or Protected > Health Information (PHI) subject to protection under the law, > including the Health Insurance Portability and Accountability Act of > 1996, as amended (HIPAA). If you are not the intended recipient or the > person responsible for delivering the email to the intended recipient, > be advised that you have received this email in error and that any > use, disclosure, distribution, forwarding, printing, or copying of > this email is strictly prohibited. If you have received this email in > error, please notify the sender immediately and destroy all copies of the > original message. > "This electronic mail message contains information which may be > confidential, privileged and protected from further disclosure. Such > information relates to and is used for all purposes outlined in the > statutes below, including Peer Review, Performance Improvement, > Quality Assurance and Claims Management and Handling functions and/or > Attorney-Client Communications. It is being produced within the scope > of all Georgia and Federal laws governing record confidentiality, > including (but not limited to) Official Code of Georgia Annotated > Sections 31-7-15; 31-7-130; 31-7-131; 31-7-132; 31-7-133; 31-7-140; > 31-7-143. If you are not the intended recipient, please be aware that > any disclosure, photocopying, distribution or use of the contents of > the received information is prohibited. If you have received this > e-mail in error, please reply to the sender immediately and > permanently delete this message and all copies of it. Thank you. > Communication of electronic protected health information > (ePHI) is protected under the Health Insurance Portability and > Accountability Act (HIPAA) Act of 1996. Electronic mail (e-mail) > communication is not encrypted or secure. The HIPAA Security Rule > allows for patients to initiate communication of personal health > information over this medium and for providers to respond accordingly > with the understanding that privacy of communication is not guaranteed." > "This electronic mail message contains information which may be confidential, privileged and protected from further disclosure. Such information relates to and is used for all purposes outlined in the statutes below, including Peer Review, Performance Improvement, Quality Assurance and Claims Management and Handling functions and/or Attorney-Client Communications. It is being produced within the scope of all Georgia and Federal laws governing record confidentiality, including (but not l
Re: Password synchronisation of TDPERP for SAP HANA on a scale-out cluster
This section in the User's Guide may help you: http://www-01.ibm.com/support/knowledgecenter/SSZHVN_7.1.3/erp.hana/c_dperp_saphana_cfg_scaleout.html It is best if the /opt file system (more specifically the dsm.sys file) does not fail over. That way, each host uses its own TSM node name/password for authentication. Del "ADSM: Dist Stor Manager" wrote on 11/10/2015 05:32:31 AM: > From: Andrew Collyer > To: ADSM-L@VM.MARIST.EDU > Date: 11/10/2015 05:34 AM > Subject: Password synchronisation of TDPERP for SAP HANA on a scale- > out cluster > Sent by: "ADSM: Dist Stor Manager" > > Hi all > > I?m hoping for some advice on the configuration of TDPERP for HANA. > > In our environment we have two HANA Linux servers running a single > instance in an Active/Passive setup. TDP is configured on both servers > and I have a single TDP node defined on a single TSM server. I am using a > proxy node within the TDP configuration of the two servers to handle the > communication back to the single TDP node on the TSM Server. > > The problem I have is that when a HANA failover occurs, the TDP config on > the newly active server does not have the correct TDP node password as it > isn?t maintained or synchronised with that on the original server. I > looked at copying the init.bki file but this seems to be encrypted > with something unique to the server. > > Is there a mechanism for synchronising the TDP node password between > servers on Linux? Any recommendations or work-arounds? > > Thanks in advance. > > Andrew > > Technical Architect ? Infrastructure > Yorkshire Water >
sql assistance with getting files backed up and their sizes
I have at least two linux clients v6.4 tsm server 6.3.4 whose bytes backed up are nearly double the bytes inspected. Compress is set to no. I would like to find the offending files which are growing. The following script shows files backed up yesterday, for a specific node, (thanks andy raibeck), but I would like to add and order by file size. How do I add the object_id field for comparison with the contents table, but not print it? Script follows: select concat(filespace_name, concat(hl_name, ll_name)) as "FILE NAME", - backup_date - from backups - where - backup_date>=(select actual_start - from events - where scheduled_start>'2013-01-01' and - date(scheduled_start)=date(current_timestamp - 1 day) and - node_name='upper($1)' and - status='Completed') - and - backup_date<=(select completed - from events - where scheduled_start>'2013-01-01' and - date(scheduled_start)=date(current_timestamp ) and - node_name='upper($1)' and - status='Completed') - order by backup_date
Password synchronisation of TDPERP for SAP HANA on a scale-out cluster
Hi all I?m hoping for some advice on the configuration of TDPERP for HANA. In our environment we have two HANA Linux servers running a single instance in an Active/Passive setup. TDP is configured on both servers and I have a single TDP node defined on a single TSM server. I am using a proxy node within the TDP configuration of the two servers to handle the communication back to the single TDP node on the TSM Server. The problem I have is that when a HANA failover occurs, the TDP config on the newly active server does not have the correct TDP node password as it isn?t maintained or synchronised with that on the original server. I looked at copying the init.bki file but this seems to be encrypted with something unique to the server. Is there a mechanism for synchronising the TDP node password between servers on Linux? Any recommendations or work-arounds? Thanks in advance. Andrew Technical Architect ? Infrastructure Yorkshire Water - Spotted a leak? If you spot a leak please report it immediately. Call us on 0800 57 3553 or go to http://www.yorkshirewater.com/leaks Get a free water saving pack Don't forget to request your free water and energy saving pack, it could save you money on your utility bills and help you conserve water. http://www.yorkshirewater.com/savewater The information in this e-mail, and any files transmitted with it, is confidential and may also be legally privileged. The contents are intended solely for the addressee only and are subject to the legal notice available at http://www.keldagroup.com/email.htm. This email does not constitute a binding offer, acceptance, amendment, waiver or other agreement, or create any obligation whatsoever, unless such intention is clearly stated in the body of the email. If you are not the intended recipient, please return the message by replying to it and then delete the message from your computer. Any disclosure, copying, distribution or action taken in reliance on its contents is prohibited and may be unlawful. Yorkshire Water Services Limited Registered Office Western House, Halifax Road, Bradford, BD6 2SZ Registered in England and Wales No 2366682