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:[EMAIL PROTECTED] On Behalf Of Minns, Farren; Chichester Sent: 31 January 2008 11:30 To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of Jeff White Sent: 31 January 2008 11:05 To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of Minns, Farren; Chichester Sent: 31 January 2008 10:56 To: ADSM-L@VM.MARIST.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 [EMAIL PROTECTED] ************************************************************************ **** 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 [EMAIL PROTECTED] **************************************************************************** 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