Re: [ADSM-L] DB2 back-up issues on Windows
2017-02-02 17:11:35
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.
|
|
|