ADSM-L

Re: [ADSM-L] TDP SQL backup fails but is reported as a success ??

2017-01-19 08:09:37
Subject: Re: [ADSM-L] TDP SQL backup fails but is reported as a success ??
From: "Schofield, Neil (Storage & Middleware, Backup & Restore)" <Neil.Schofield AT LLOYDSBANKING DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 19 Jan 2017 13:07:50 +0000
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.