ADSM-L

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

2017-02-16 09:49:30
Subject: Re: [ADSM-L] DB2 back-up issues on Windows
From: Karel Bos <tsm.wad AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 16 Feb 2017 15:48:04 +0100
Hi,

Seems there are issues with handle leaks in (at least) the V7.1.6 client.
Got this link from IBM support
http://www-01.ibm.com/support/docview.wss?uid=swg1IT16364

Suggestion was to apply interim fix pack V7.1.6.3 (don't know why not
V7.1.6.4 as that's also available). Asked support when the fix pack will be
released as we have a policy to not implement interim fix packs on
production systems.

Regards,

Karel

-----Oorspronkelijk bericht-----
Van: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Namens Harris,
Steven
Verzonden: donderdag 2 februari 2017 23:05
Aan: ADSM-L AT VM.MARIST DOT EDU
Onderwerp: Re: [ADSM-L] DB2 back-up issues on Windows

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>