ADSM-L

Re: [ADSM-L] DB2 back-up issues on Windows

2017-02-02 17:11:35
Subject: Re: [ADSM-L] DB2 back-up issues on Windows
From: "Harris, Steven" <steven.harris AT BTFINANCIALGROUP DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 2 Feb 2017 22:04:30 +0000
Karel

In my previous role I had a couple of TPC (now known as "Spectrum Control") 
database servers running DB2 under windows with exactly this problem.

They ran for years without issue then started being unable to find dsm.opt 10 
or so days after a reboot.

Never did get to the bottom of why, but rest assured you are not going mad.

Regards

Steve

Steven Harris
TSM Admin/Consultant 
Canberra Australia

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Karel Bos
Sent: Friday, 3 February 2017 12:39 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] DB2 back-up issues on Windows

Yeah, but don't you think that would be allways the case and not after some 
time........ Restart DB2, backup runs again (no change to any config item) and 
after X amount of time errors start again.


Btw, its a windows system and DB2 runs under local admin account so default 
permissions are always enough for such an account. Further more, just to be 
sure, directory of opt and log file has gotten full control for everybody and 
automaticly created .lock files confirmed to have expected and sufficient 
rights.

-K

-----Oorspronkelijk bericht-----
Van: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Namens Rick 
Adamson
Verzonden: donderdag 2 februari 2017 14:33
Aan: ADSM-L AT VM.MARIST DOT EDU
Onderwerp: Re: [ADSM-L] DB2 back-up issues on Windows

I have found that most all of the "cannot find, or cannot read" I run into are 
ultimately permission related, especially with DB2.


-Rick


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Karel Bos
Sent: Thursday, February 02, 2017 6:43 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] DB2 back-up issues on Windows

Hi,



Every day I have to restart DB2 (sometimes multiple times) due to backups stop 
working. The DB2 database is doing log file and normal backups to TSM and the 
backups stop working after the following couple of errors:



31.01.2017 10:48:04 instrStart: Unable to get write file lock or report file 
handler.

31.01.2017 10:48:16 ANS1035S Options file 'D:\TSM\client\dsm.opt' could not be 
found, or it cannot be read.

31.01.2017 10:48:31 instrStop: Unable to get write file lock or report file 
handler.



My idea is this has nothing to do with the dsm.opt itself but with the 
dsmopt.lock file and the handler stops working. This leads me to believe it has 
something to do with:



https://urldefense.proofpoint.com/v2/url?u=http-3A__www-2D01.ibm.com_support
_docview.wss-3Fuid-3Dswg21646969&d=DwICAg&c=AzgFQeXLLKhxSQaoFCm29A&r=eqh5PzQ
PIsPArLoI_uV1mKvhIpcNP1MsClDPSJjFfxw&m=NYVXmJstnwXOL1D-oICuOCJtMLO01UY9BP_P6
Hazv40&s=ppbHkreaOeHpE_RvUd4NGYQUx08O5dTlezN0U_pVems&e=



but ofc its al directed to Unix as although IBM supports their products on 
Windows their support and documentation are mostly based on AIX installations.



Also note, this symptom should be fixed in TSM V7.1.4 but this environment is 
running BAclient V7.1.6.2 on Windows 2008R2 64b. Support ticket with IBM has 
been opened but sofar they are not really helpfull.



I wonder if someone is running into the same issues and if its only on windows 
or also still on AIX (as I have multiple AIX servers running DB2 without the 
option to restart them everytime the backup stops working which are about to be 
upgraded to this TSM client version).



Kind regards,



Karel

This message and any attachment is confidential and may be privileged or 
otherwise protected from disclosure. You should immediately delete the message 
if you are not the intended recipient. If you have received this email by 
mistake please delete it from your system; you should not copy the message or 
disclose its content to anyone. 

This electronic communication may contain general financial product advice but 
should not be relied upon or construed as a recommendation of any financial 
product. The information has been prepared without taking into account your 
objectives, financial situation or needs. You should consider the Product 
Disclosure Statement relating to the financial product and consult your 
financial adviser before making a decision about whether to acquire, hold or 
dispose of a financial product. 

For further details on the financial product please go to http://www.bt.com.au 

Past performance is not a reliable indicator of future performance.

<Prev in Thread] Current Thread [Next in Thread>