Hi Jeff
Well that's certainly pointed me in the right direction and can indeed see that
those variables are set. Sadly however the output files have not been updated
for a long time, possibly since this was all set up. So I'm confused.
I have managed to track down some information in the DB2 Control Centre and it
looks like, for what ever reason, the database that keeps failing is already in
a quiesced state before TSM tries to do the same, so it just fails. Very odd.
Sadly I am not a Win or DB2 administrator so I'm fumbling around in the dark a
bit :-)
Thanks anyway for the pointer, much appreciated.
All the best
Farren
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Jeff White
Sent: 31 January 2008 11:05
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] A TSM DB2 API question
Farren
If i remember correctly, there is a variable called DSMI_LOG in the TSM
client which allows for logging. On the server where DB2 resides:
>From START bar, select SETTINGS
Select CONTROL PANEL
Select SYSTEM
Select ADVANCED (W2K only)
Select ENVIRONMENT VARIABLES button (W2K only)
>From the SYSTEM VARIABLES panel (lower half of screen) that is opened,
select NEW
Variable Name: DSMI_CONFIG
Variable Value: c:\tsm\baclient\dsmdb2.opt
Variable Name: DSMI_DIR
Variable Value: c:\tsm\baclient\
Variable Name: DSMI_LOG
Variable Value: c:\tsm\baclient\
If you have set this up, your logs may be in there.
Regards
Jeff White
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Minns, Farren; Chichester
Sent: 31 January 2008 10:56
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] A TSM DB2 API question
Good morning all
I am trying to track down why certain DB2 to TSM backups are failing
rather regularly. I don't believe it's a TSM issue and would point the
finger at DB2 not being able to quiesce the datafiles in question etc.
However, where do I find logging for this kind of thing? Is there
anything similar to the BA Client dsmsched.log or is it all housed
somewhere within DB2.. and if so, where? :-)
I have set the backup schedules to notify me if they fail, but I don't
know why, and I really need to.
Many thanks in advance for any pointers on this.
Farren Minns
----------------------------------------------------------------------
The information contained in this e-mail and any subsequent
correspondence is private and confidential and intended solely
for the named recipient(s). If you are not a named recipient,
you must not copy, distribute, or disseminate the information,
open any attachment, or take any action in reliance on it. If you
have received the e-mail in error, please notify the sender and delete
the e-mail.
Any views or opinions expressed in this e-mail are those of the
individual sender, unless otherwise stated. Although this e-mail has
been scanned for viruses you should rely on your own virus check, as
the sender accepts no liability for any damage arising out of any bug
or virus infection.
John Wiley & Sons Limited is a private limited company registered in
England with registered number 641132.
Registered office address: The Atrium, Southern Gate, Chichester,
West Sussex, PO19 8SQ.
----------------------------------------------------------------------
------------------------------------------------------------------------
--------------
Email scanned for viruses and spam by the Woolworths
anti-virus systems.
If you believe this email is spam, please forward to
suspectspam AT woolworths.co DOT uk
****************************************************************************
Woolworths plc
Registered Office: Woolworth House, 242/246 Marylebone Road, London NW1 6JL
Registered in England, Number 104206
This e-mail is only intended for the person(s) to whom it is addressed and
may contain confidential information. Unless stated to the contrary, any
opinions or comments are personal to the writer and do not represent the
official view of the company. If you have received this e-mail in error,
please notify us immediately by reply e-mail and then delete this message
from your system. Please do not copy it or use it for any purposes, or
disclose its contents to any other person. Thank you for your co-operation.
****************************************************************************
------------------------------------------------------------------------------------
Email scanned for viruses and unwanted content by emailsystems
Information regarding this service can be found at www.emailsystems.com
----------------------------------------------------------------------
The information contained in this e-mail and any subsequent
correspondence is private and confidential and intended solely
for the named recipient(s). If you are not a named recipient,
you must not copy, distribute, or disseminate the information,
open any attachment, or take any action in reliance on it. If you
have received the e-mail in error, please notify the sender and delete
the e-mail.
Any views or opinions expressed in this e-mail are those of the
individual sender, unless otherwise stated. Although this e-mail has
been scanned for viruses you should rely on your own virus check, as
the sender accepts no liability for any damage arising out of any bug
or virus infection.
John Wiley & Sons Limited is a private limited company registered in
England with registered number 641132.
Registered office address: The Atrium, Southern Gate, Chichester,
West Sussex, PO19 8SQ.
----------------------------------------------------------------------
|