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. --
Re: 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
Re: 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
Re: A TSM DB2 API question
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 NameHandle Agents DBADMIN FLTABLES.EXE61 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
Re: A TSM DB2 API question
Download the redbook Backing Up DB2 Using IBM Tivoli Storage Management, which covers the subject. Richard Sims
Antwort: [ADSM-L] TSM DB2 API - Question Virus checked
Hello Charles, your db2 admins are right; but there is a work-around: We run Linux as OS, and we TSMers create the dsm.sys only, this means we leave all doings on dsm.opt for db2 to the db2admins. And the db2admins createed an individual dsm.opt (e.g. dsm_db2name.opt) for several situations; so we can use different machines to run the db2 but with the same tsm instance, and other way round. Yes, there has to be a complet concept for this, and may be you will need one stop before this helps. Catch your db2ers and talk about it. regards, Dierk Hart, Charles A [EMAIL PROTECTED] Gesendet von: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 18.12.2007 22:14 Bitte antworten an ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU An ADSM-L@VM.MARIST.EDU Kopie Thema [ADSM-L] TSM DB2 API - Question Virus checked We are in the midst of Migrating DB backup clients to a new TSM instance. Our DB2 DBA's stated that they can not repoint their DB backups to the new TSM instance without stopping / starting the DB2 DB itself, as the DB2 API Backup cfg is only read upon the starting of the DB2 DB. Is this true? I really hope not as you would think there would be a db2util re-read cfg cmd or something... Does anyone know any different? I'm poking through the manuals Regards, Charles This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. Bürgel Wirtschaftsinformationen GmbH Co. KG Gasstraße 18 22761 Hamburg Geschäftsführer: Rolf Pries, Hans-Werner Scherer, Dr. Norbert Sellin Registergericht: Hamburg HRA 85212, USt-IdNr. DE 117 981 371, Steuer-Nr. 27/541/00020, Sitz der Gesellschaft: Hamburg Geschäftsführende Gesellschafterin: Bürgel Wirtschaftsinformationen Verwaltungs-GmbH, Registergericht: Hamburg HRB 45 704
Re: TSM DB2 API - Question
Great Thanks! I'll work with the DB2 DBA's -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Francisco Molero Sent: Tuesday, December 18, 2007 4:16 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM DB2 API - Question Hi Charles, I am not sure, but I think if you change in the option file the TCPServeraddress and/or TPCServer port options you could run the backup without stopping/ Starting DB2. In addition, DBA should compile db2uext2.c program after changing the option file. There are two possibilities to configure DB2, one is including the environment variables in the DB2 configuration and the other is, including the variables in the user profile. If you have defined it inside DB2, you will need to create the same password/mgmt class and nodename under new TSM instance Regards, Fran - Mensaje original De: Hart, Charles A [EMAIL PROTECTED] Para: ADSM-L@VM.MARIST.EDU Enviado: martes, 18 de diciembre, 2007 22:12:57 Asunto: TSM DB2 API - Question We are in the midst of Migrating DB backup clients to a new TSM instance. Our DB2 DBA's stated that they can not repoint their DB backups to the new TSM instance without stopping / starting the DB2 DB itself, as the DB2 API Backup cfg is only read upon the starting of the DB2 DB. Is this true? I really hope not as you would think there would be a db2util re-read cfg cmd or something... Does anyone know any different? I'm poking through the manuals Regards, Charles This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. __ ¿Chef por primera vez? Sé un mejor Cocinillas. http://es.answers.yahoo.com/info/welcome This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.