ADSM-L

Re: [ADSM-L] A TSM DB2 API question

2008-01-31 07:03:07
Subject: Re: [ADSM-L] A TSM DB2 API question
From: Jeff White <Jeff.White AT WOOLWORTHS.CO DOT UK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 31 Jan 2008 12:01:39 -0000
Farren

Without knowing what your specific error is, could it be that the
database may still be in use?

In the environment i worked, in C:\SQLLIB\BIN, run command: DB2CMD

Command:        db2 list applications for database <database-name>

Output:
Auth ID Application             Application     Application ID
DB Name # of
                Name                    Handle
Agents
DBADMIN FLTABLES.EXE    61              13456.123.1234567
SAMPLE  1

Any active applications can be forced:
        db2 "force application (61)"
Or
        db2 force application all               but will force all apps
from all databases!
Backup:
        db2 backup database sample use tsm

What happens when you run that backup

Regards

Jeff


-----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 11:30
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] A TSM DB2 API question

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.
----------------------------------------------------------------------
------------------------------------------------------------------------
--------------
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