Re: Inactive active filesystem for vm in script

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Classification: Public

Robert

I'm not sure this is the best answer to your question, but in the absence of 
any other replies I thought it might at least prompt somebody to come up with 
something better.

I'm assuming here that your hypervisor is vSphere and not Hyper-V? In which 
case empirical evidence from my systems suggests that for every backup of a 
snapshot of the VM called bodev, I get one bodev.ovf backup object.

I would normally shy away from running Selects against the Backups table, so 
use the following at your own risk. However to determine how many snapshots 
you've got stored for the VM called bodev, maybe try something like the 
following?

SELECT COUNT(*) FROM BACKUPS WHERE FILESPACE_NAME='\VMFULL-bodev' AND LL_NAME 
LIKE '%.ovf'

It looks like all versions of bodev.ovf will show as Active versions, but 
perhaps you can just assume the number of inactive backups is 1 less than the 
total?

Regards

Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: delete volume

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Classification: Public

Eric

My experience of DELETE VOLUME going back to ADSM 3.1 is that it will 
immediately make the library volume (physical or virtual) scratch with no 
pending reuse delay.

By typing the words DISCARDDATA=YES, I guess you are explicitly consenting to 
never being able to access the data again. You might have a way back if by 
chance a physical tape hasn't been re-used by the time you realise your 
mistake, but with virtual tape the data erasure is immediate when the volume is 
relabelled.

I suppose my advice would be to only use DISCARDDATA=YES in the event that all 
remaining data on the volume has already proven (through MOVE DATA operations, 
or whatever) to be unreadable, and you don't have the option to recover it from 
a copy pool. In this case, a pending reuse delay wouldn't help make the data 
any more readable. I realise this doesn't address your concerns around 
accidental deletion of a volume, but I believe there's a saying about great 
responsibility accompanying great power.

Regards
Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP



Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: DOMAIN.vmfull on multiple lines in dsm.opt

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Classification: Public

Hans Christian

I have no solution for splitting the DOMAIN.VMFULL option over multiple lines 
but if this gets unwieldy you may want to think about the alternative approach 
of creating tags in the virtual machine inventory to exclude specific VMs from 
scheduled backups using the -VMTAGDATAMOVER client option.

I believe the case sensitivity of VM names in the DOMAIN.VMFULL option was an 
unintended defect in 7.1.6.0. You should be able to revert to the previous 
behaviour by applying an interim fix or maintenance release that includes APAR 
IT15975.

Regards
Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Thinking about replicate node command RFE, feedback welcome

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Classification: Public

Stefan

I wholeheartedly agree that this is harder than it should be.

We set up bi-directional node replication and, even though every node should be 
either a source or target for replication, we opted to put them in different 
node groups to avoid the exact errors you are seeing. However this had to be 
combined with some bespoke alerting scripts to take into account the human 
factor and ensure we didn't miss any through being omitted from the node 
groups, etc.

I'd certainly vote for an RFE that added WHEREREPLSTATE=SEND,SYNCSEND or 
similar to the REPLICATE NODE command.

Regards



Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: TDP SQL backup fails but is reported as a success ??

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Classification: Public

Tom

-50 is the return code for DSM_RC_TCPIP_FAILURE. It can be indicative of a 
number of problems including password errors, but since 6 of the 11 are 
succeeding it's probably something else. Check the server activity log for 
messages corresponding to the time of the client errors.

The scheduler is reporting the overall status of the SQLFULL.BAT script rather 
than the part of the script that ran the TDPSQLC.EXE command. If subsequent 
lines of the script reset errorlevel back to 0, then this will be the return 
code of the overall script and the scheduler will report it being successful.

So either ensure that the TDPSQLC.EXE command is the last command in the 
script, or capture the errorlevel immediately after the backup and set it on 
completion of the script.

Regards

Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP



Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

ADSM-L list archives

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Classification: Public

I'm aware of 3 (there may be more) archives of this list:
http://www.mail-archive.com/adsm-l@vm.marist.edu/
http://marc.info/?l=adsm-l
http://adsm.org/lists/html/ADSM-L/

Each provides a single location for the years of accumulated wisdom of the 
contributors and I'm grateful to every one of you.

For no particular reason, I've tended to use the last of the 3 above but it 
doesn't seem to have been updated in over a month. Does anyone know if this is 
just a temporary glitch?

Regards
Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Help to Operational Report.

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Classification: Public

Bo

If I understand you correctly, you want everything from the 16th character of 
the message up to the character before the bracket and the word SESSION? In 
that case, would something like the following be suitable?

select nodename, substr(char(date_time), 1, 20) as TME, substr(char(message), 
16, instr(char(message), '(SESSION')-16) as MSG from actlog where (msgno=4005 
or msgno=4007 or msgno=4018 or msgno=4037 or msgno=4987) and 
date_time>(current_timestamp-24 hours) and domainname='LINUX_DOMAIN_SQKO'

Regards
Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

IBM reneges on Enhanced support policy for TSM 6.4?

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Classification: Public

I always thought IBM's 'Enhanced' support policy was supposed to guarantee 
customers a *minimum* of 5 years support from the GA date of a product version.

Was anyone else surprised to see the recent announcement that TSM 6.4 customers 
will be cut adrift after only 4 years and 10 months?
http://www.ibm.com/software/support/lifecycleapp/PLCDetail.wss?synkey=V649976C05962P29-Z752595R47563G59-C915146G66275T24

Regards

Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Advice on backup and restore of virtualised vCenter Server / Platform Services Controller instances

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

It's interesting to see how Chapter 12 of the vSphere Installation and Setup 
Guide has changed between Updates 1 and 2 of vSphere 6.0:

Update 1: 
https://pubs.vmware.com/vsphere-60/topic/com.vmware.ICbase/PDF/vsphere-esxi-vcenter-server-601-installation-setup-guide.pdf
Update 2: 
https://pubs.vmware.com/vsphere-60/topic/com.vmware.ICbase/PDF/vsphere-esxi-vcenter-server-602-installation-setup-guide.pdf

Update 2 now makes explicit the possibility of using a third party product 
which employs VADP (such as IBM Spectrum Protect?) as an alternative to vSphere 
Data Protection for backing up VMs containing a vCenter Server and/or Platform 
Services Controller. However the backup and recovery steps within are still 
very much focused on using vSphere Data Protection.

So if I did want to use Spectrum Protect for VMware, are there any specific 
guidelines relating to VMs containing vCenter Server / Platform Services 
Controller? For instance VMware only support full image backups of such VMs and 
require that all vCenter Server and Platform Services Controller instances are 
backed up at the same time. Do IBM have any best practices as to how these 
recommendations should be implemented with Spectrum Protect?

There are probably also specific considerations when recovering such a VM using 
Spectrum Protect for VMware - eg recovering the VM containing the vCenter 
Server when no vCenter Server is available. Please can anyone point me at any 
helpful IBM docs which cover this scenario?

Regards

Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: TSM4VE 7.1.3 - Backup report for a specific VM?

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Eric

For a VM called VMNAME, you can try something like the following from a server 
command line and see if it meets your needs.

select sub_entity as "VM",start_time as "Backup Start",end_time as "Backup 
End",successful as "Success?" from summary_extended where sub_entity='VMNAME' 
and activity='BACKUP' order by 2

Operations Centre can be used to run the report periodically and email it to 
the server owner.

Regards
Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Reg: tsm ba client autodeploy package 7.1.4.1

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Andy

Thanks for the link to the official statement of IBM policy.

Now can I ask that anyone who feels unhappy with the direction IBM are heading 
with this please petition your IBM account representative for a change. As I 
see it the only way to get autodeploy packages published for interim fixes is 
if customers demand it in sufficient numbers.

Regards
Neil


Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: TSM Server 7.1.4 woes

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

For info, the full text of APAR IT15117 is now available on the IBM website at
http://www.ibm.com/support/entdocview.wss?uid=swg1IT15117

I'd like to express my gratitude to Michael Prix for uncovering this issue, and 
to Andrew Raibeck for his tenacity in getting to the bottom of it.

Regards
Neil Schofield
Tivoli Storage Manager SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: TSM Server 7.1.4 woes

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Andy

Thanks for looking into this. We've got an upgrade from 7.1.1 to 7.1.4 planned 
for next week so this thread got me a little worried as it does involve some 
legacy clients.

Just so we're clear, can I reassure our users that with regards to this 
specific issue there will be no difference in the behaviour of the legacy 
clients between the two server versions? I know you managed to reproduce the 
issue that Mark described on a 7.1.4 server, but I wondered whether you'd been 
able to prove it also existed with any server version prior to 7.1.4?

Regards
Neil Schofield
Tivoli Storage Manager SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Reg: tsm ba client autodeploy package 7.1.4.1

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Srikanth

I complained about the very same thing last month:
https://adsm.org/lists/html/ADSM-L/2016-03/msg8.html

I've since discovered that IBM have indeed made the decision to no longer 
supply exported packages for interim fixes. If you're using auto-deployment 
then you need to find another mechanism for pushing out interim fixes because 
it now only works for fix packs. (But then if you've got such a mechanism, why 
bother with TSM auto-deployment in the first place?)

I've not given up hope that IBM will see how perverse this approach is and 
reverse its decision. The current client fix pack (7.1.4) was released in 
November and was followed by a flash in February which described how data loss 
could occur and recommended 7.1.4.1 be installed on vulnerable systems. How 
exactly did they think large shops were supposed to push that update out to 
affected systems? Maybe customers should wait for the 7.1.5 client? No, hang on 
- they skipped that one so we're currently waiting on 7.1.6 with its associated 
.EXP files.

I agree that there are good reasons why customers should think carefully before 
auto-deploying interim fixes. For what it's worth I think IBM should tell them 
the reasons, publish the exported packages anyway and give them the *choice* of 
being able to perform tightly targeted deployments where there is a requirement 
to do so.

Regards
Neil



Neil Schofield
Tivoli Storage Manager SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

EoS for TSM 6.3

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

In case anyone missed it, IBM last week announced the End-of-Support date for 
TSM 6.3 would be April 30th 2017:
http://www.ibm.com/common/ssi/rep_ca/2/897/ENUS916-072/index.html


Regards

Neil Schofield
Tivoli Storage Manager SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Protect for VE 7.1.4 looking for TDPVMwareMount.conf

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Koen

On my 7.1.3 installation it's in
C:\ProgramData\Tivoli\TSM\RecoveryAgent\mount

Regards
Neil Schofield
Tivoli Storage Manager SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP



Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

APAR IT12942

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

VMware this week released VDDK 6.0.2 which opens up the possibility of a fix to 
IT12942:

Would anyone from IBM care to speculate about how long it will take before a 
TSM BA client based on this update will be forthcoming? We've got some 
deployment decisions to make that depend on the answer.

Regards
Neil Schofield
Tivoli Storage Manager SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Self-contained application protection and ANS9499W messages

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Thanks Del

The PMR was previously logged and the message currently coming back is that 
'this is a wanted and designed behaviour' but I'll keep pushing it.

Regards
Neil Schofield
Tivoli Storage Manager SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Self-contained application protection and ANS9499W messages

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

We're doing some testing of the self-contained application protection features 
of TSM for VE 7.1 and have come across a troubling problem that I would 
appreciate your thoughts on.

The application protection features are disabled if the VMware Tools on the 
guest are not 'current'. Fair enough if the Tools are years out-of-date, but 
the TSM client software seems to use a strange way to check. We have seen 
clients happily running application protection only to have it switched off 
because a newer version of the VMware tools have been made available to the 
client by an update to the ESX host. At least I'm assuming that's what happens 
based on the following message in the logs:
ANS9499W VMware tools on virtual machine 'XX' need to be updated. IBM 
Tivoli Storage Manager application protection will not be used.

Never mind that the guest continues to run the same version of the tools which 
were previously working without issue - if there is an even slightly newer 
version of the Tools available to the client then application protection will 
be disabled until the guest is updated.

Just think about that for a minute. You update your vSphere hosts to the latest 
patch levels with a view to updating the guests at your leisure and all of a 
sudden your guests no longer have application protection. You're exposed. Am I 
alone in thinking that disabling application protection in this scenario is a 
bug, or at the least a very poor design choice? I'm guessing most shops will 
have a lag between making the latest VMware Tools available and completing the 
update on all their guests?

Regards
Neil Schofield
Tivoli Storage Manager SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP



Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Automatic deployment of interim fixes

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Does anyone know if IBM have changed their policy on providing exported 
packages for automatic deployment of interim fixes?

I've got .exp files for the 7.1.4 client fixpacks, but I am unable to find any 
.exp files for client interim fixes beyond 7.1.3.2.

Using the Windows clients as an example, I would have expected to find exported 
packages for 7.1.4.1 and 7.1.4.2 at the following location:
http://public.dhe.ibm.com/storage/tivoli-storage-management/patches/client/v7r1/Windows/autodeploy

What determines if an exported package is released alongside an interim fix?

Regards

Neil Schofield
Tivoli Storage Manager SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Identifying empty nodes

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Eric

It was my understanding that there was only an entry for a file space in the 
occupancy table if it had a non-zero number of objects stored on the server.

If this is true then you probably need something like this:

select node_name from nodes where node_name not in (select node_name from 
occupancy)

Regards
Neil Schofield
Tivoli Storage Manager SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Things I learnt installing a v7.1.4 TSM for VE data mover

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Mike

I agree wholeheartedly.


> *Thank you for pointing this out, Neil,* I will sadly have to lock my
environment down at 7.1.2 or 7.1.3.

Sadly it may not be that simple. The new thing I learnt today is that while IBM 
use the 'good' VDDK (v6.0.0) with both 7.1.3.0 and 7.1.3.1, the interim fix 
7.1.3.2  actually installs the 'bad' VDDK (v6.0.1)!

Regards
Neil

Neil Schofield
Tivoli Storage Manager SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Things I learnt installing a v7.1.4 TSM for VE data mover

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

A couple of gotchas that caught me out today might be useful info for somebody:


-  The following document suggests TSM for VE 7.1.4 will work with 
vSphere 5.1, 5.5 and 6.0:
http://www.ibm.com/support/docview.wss?uid=swg21970882#Supported%20VMware%20vSphere%20versions

As I discovered the hard way, this seems to be stretching things a little. The 
VDDK version that ships with the 7.1.4 client - v6.0.1 - has a rather nasty 
limitation which means you can't back up VMs on vShpere 5.1 or 5.5 using the 
SAN transport. IBM don't seem to have gone out of their way to draw your 
attention to this, but details are in the VDDK 6.0.1 release notes embedded in 
the following:
http://www.ibm.com/support/docview.wss?uid=swg21672351


-  In common I believe with TSM for VE 7.1.3, version 7.1.4 goes to 
almost absurd lengths to conceal the fact that it isn't going to install the 
Recovery Agent Device Driver. When presented with what is on the face of it a 
full set of features to be installed, you have to expand the Recovery Agent 
feature to realise that the Recovery Agent Device Driver sub-feature is now an 
option that must be manually selected for installation (even if upgrading from 
a version where the functionality was previously enabled.)

Regards
Neil Schofield
Tivoli Storage Manager SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services | 
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP



Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0345 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: SKIPSYSTEMEXCLUDE test flag - what's the worst that could happen?

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

Thanks Andy - that's great info.

I've done some testing of the client without the test flag, and also running 
the 'list writers detailed' command and we don't appear to suffer from any of 
the issues the test flag is intended to work around.

My plan now is to arrange with our Windows admins to get the flag removed and 
re-test the recovery.

Regards
Neil


Neil Schofield
Tivoli Storage Manager SME
LLOYDS BANKING GROUP


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 08457 21 31 41. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0845 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

SKIPSYSTEMEXCLUDE test flag - what's the worst that could happen?

[Schofield, Neil (Storage & Middleware, Backup & Restore)]

For historic reasons that I've yet to track down, the following option was 
added to the client options file on one of our Windows 2008 R2 servers:

TESTFLAG SKIPSYSTEMEXCLUDE

Now as a result of us using this test flag the Boot Configuration Data in 
C:\BOOT is backed up as part of both the system state and the C: drive backup. 
During a recent recovery test of the server both were restored and the server 
didn't boot. The symptoms (and a probable cause) are exactly as described in 
the following MS KB article:
https://support.microsoft.com/en-us/kb/2261423

So I was wondering if anyone else had had cause to use this particular test 
flag and whether it had impacted on your ability to do a full system restore?

Regards

Neil Schofield
Tivoli Storage Manager SME
LLOYDS BANKING GROUP


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 08457 21 31 41. Cheltenham & Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0845 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham & Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: So long, and thank you...

[Schofield, Neil (Storage Middleware, Backup Restore)]

I'd just like to echo the sentiments expressed by others.

Wanda's sage advice (along with that of many others on this list) over my last 
16 years working on ADSM/TSM has been a great source of support.

Wanda, I wish you a long and happy retirement.

Best regards
Neil


Neil Schofield
Tivoli Storage Manager SME
Backup  Recovery | Storage  Middleware | Service Delivery | Group IT
LLOYDS BANKING GROUP


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 08457 21 31 41. Cheltenham  Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0845 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham  Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham  Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Availability of 7.1.1.200 server code

[Schofield, Neil (Storage Middleware, Backup Restore)]

Thomas

I don't know whether IBM have already communicated this to you, but it looks 
like server interim fix 7.1.1.200 that you were waiting for has now been 
slipped to Q2. It was previously slated for Q1 but I've just noticed the new 
information in the link below:

https://www.ibm.com/developerworks/community/wikis/home?lang=en#/wiki/Tivoli%20Storage%20Manager/page/TSM%20Schedule%20for%20Fix-Packs

Time to dust off plan B?

Regards
Neil Schofield


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 08457 21 31 41. Cheltenham  Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0845 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham  Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham  Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Changed SQL behavior under server 6.2.3.1

[Schofield, Neil (Storage Middleware, Backup Restore)]

Wanda

Brilliant! Thanks to you and your DBA for the tip along with the explanation. 
That works just fine on my systems too.

I'd seen the filespace with the null node name before but never made the 
connection.
Regards
Neil Schofield
Tivoli Storage Manager SME
Backup  Recovery | Storage  Middleware | Service Delivery | Group IT
LLOYDS BANKING GROUP


 Subject:  Re: [ADSM-L] Changed SQL behavior under server 6.2.3.1
 From:  Prather, Wanda Wanda.Prather AT ICFI DOT COM
 To:  ADSM-L AT VM.MARIST DOT EDU
 Date:  Fri, 9 Jan 2015 17:32:19 +

 Oooh, that's evil.
 Had a consult with the in-house DBA.

 This works for me on V7.1.1:

 select count(*) from nodes  where node_name not in (select node_name from
 filespaces where node_name is not null)

 ...


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 08457 21 31 41. Cheltenham  Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0845 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham  Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham  Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Changed SQL behavior under server 6.2.3.1

[Schofield, Neil (Storage Middleware, Backup Restore)]

David

Thanks for the suggestion. I would have thought both were equivalent, but I 
tried each of them anyway and both gave the wrong answer:

tsm: Xselect count(*) from nodes where node_name not in (select node_name 
from filespaces)

  Unnamed[1]

   0

tsm: Xselect count(*) from nodes where not node_name in (select node_name 
from filespaces)

  Unnamed[1]

   0

Regards
Neil


 Hi,
 the last query should be select count(*) from nodes where node_name not in
 (select node_name from filespaces)

 NOT keyword between column name and IN keyword.

 David RIGAUDIERE


Neil Schofield
Tivoli Storage Manager SME
Backup  Recovery | Storage  Middleware | Service Delivery | Group IT
LLOYDS BANKING GROUP

I: 75813101 | T: 0113 235 3101 | M: 07979 703303 | E: 
neil.schofi...@lloydsbanking.commailto:neil.schofi...@lloydsbanking.com
50 Cote Lane, Dawsons Corner, Pudsey, LEEDS LS28 5ED TNT46 (PUD/FL1/WW/098)


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 08457 21 31 41. Cheltenham  Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0845 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham  Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham  Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Changed SQL behavior under server 6.2.3.1

[Schofield, Neil (Storage Middleware, Backup Restore)]

Zoltan

Thanks for the response. I'm not sure whether this is platform related - all my 
tests were conducted on servers running on AIX. While the problem is not 
apparent on v5.x instances, it seems to affect v6.x instances at all our levels.

Like Margaret's experience back in 2012, the problem seems to relate 
specifically to the use of NOT in the WHERE clause -eg in the following 
example, only the last returns incorrect results:

tsm: Xselect count(*) from nodes

  Unnamed[1]

1519

tsm: Xselect count(*) from nodes where node_name in (select node_name from 
filespaces)

  Unnamed[1]

1413

tsm: Xselect count(*) from nodes where not node_name in (select node_name 
from filespaces)

  Unnamed[1]

   0

Regards
Neil


Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 08457 21 31 41. Cheltenham  Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0845 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham  Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham  Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.

Re: Changed SQL behavior under server 6.2.3.1

[Schofield, Neil (Storage Middleware, Backup Restore)]

I've just tried the select statement on v6.3.5.0 that Margaret tried below in 
2012 and it still returns no rows. Does anyone have a work-around that can be 
used?

Regards
Neil

On 6/21/2012 9:55 AM, Clark, Margaret wrote:
 Using TSM server 6.2.3.1, the following SQL command no longer works:

 select node_name from nodes where node_name not in (select node_name
 from filespaces)

 It still works correctly if you take out the not.

 Any ideas?


 -  Margaret




Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ. 
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc. 
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England 
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered 
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000. 
Telephone: 08457 21 31 41. Cheltenham  Gloucester plc. Registered Office: 
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428. 
Telephone: 0845 603 1637

Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential 
Regulation Authority and regulated by the Financial Conduct Authority and 
Prudential Regulation Authority.

Cheltenham  Gloucester plc is authorised and regulated by the Financial 
Conduct Authority.

Halifax is a division of Bank of Scotland plc. Cheltenham  Gloucester Savings 
is a division of Lloyds Bank plc.

HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in 
Scotland no. SC218813.

This e-mail (including any attachments) is private and confidential and may 
contain privileged material. If you have received this e-mail in error, please 
notify the sender and delete it (including any attachments) immediately. You 
must not copy, distribute, disclose or use any of the information in it or any 
attachments. Telephone calls may be monitored or recorded.