Re: DB2 backup defaults?
Hi, DB2 backup reads config settings only at start up. Cleaning the config files after that wont change the running setup untill db2 gets restarted. Either check time stamp of current config files or restart db2 and see whats going to happen :) . Kind regards, Karel Op 11 sep. 2013 15:47 schreef Stackwick, Stephen stephen.stackw...@icfi.com het volgende: I got nothing (see below). Yet, the backups are working somehow. I don't think the DB2_VENDOR_LIB is relevant, since the end user is not using BACKOM. db2 get db cfg for pe1 | grep -i tsm First log archive method (LOGARCHMETH1) = TSM Second log archive method(LOGARCHMETH2) = TSM TSM management class(TSM_MGMTCLASS) = TSM node name(TSM_NODENAME) = TSM owner (TSM_OWNER) = TSM password (TSM_PASSWORD) = env | grep -i dsm env | grep -i tsm DB2_VENDOR_LIB=/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a set | grep -i dsm set | grep -i tsm STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | stephen.stackw...@icfi.com | icfi.com ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Gopikrishna Muppidi Sent: Wednesday, September 11, 2013 9:20 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 backup defaults? Hello , For DB2 backups for any systems via TSM,the below mentioned environment variables has to be define on the db2 level,then only backup to tsm will be possible,see the below example. host:db2sap 10 db2 get db cfg for sap|grep -i tsm First log archive method (LOGARCHMETH1) = TSM:DB2_STD_ARCHIVE1 Second log archive method(LOGARCHMETH2) = TSM:DB2_STD_ARCHIVE2 TSM management class(TSM_MGMTCLASS) = DB2_STD_ONLINE TSM node name(TSM_NODENAME) = TSM owner (TSM_OWNER) = TSM password (TSM_PASSWORD) = hostname:db2sap 11 env|grep -i dsm DSMI_DIR=/opt/tivoli/tsm/client/api/bin64 DSMI_LOG=/db2/db2sap/errors DSMI_CONFIG=/db2/db2sap/sqllib/adsm/dsm_host-SAP.opt DSM_DIR=/opt/tivoli/tsm/client/ba/bin DSM_CONFIG=/db2/db2sap/sqllib/adsm/dsm_host-SAP.opt DSM_LOG=/db2/db2sap/errors host name:db2pbg 12 env|grep -i tsm DSMI_DIR=/opt/tivoli/tsm/client/api/bin64 DSM_DIR=/opt/tivoli/tsm/client/ba/bin hostname:db2sap 13 Thank you! On Wed, Sep 11, 2013 at 3:07 PM, Stackwick, Stephen stephen.stackw...@icfi.com wrote: Thanks, Kurt. The file exists, but is empty. I ran ps -ef | grep db2, found the instance owner (and indeed, he's the one running the backups), and su - to him, found the empty userprofile. TSM must be using defaults of some kind STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | stephen.stackw...@icfi.com | icfi.com ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of BEYERS Kurt Sent: Wednesday, September 11, 2013 5:26 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 backup defaults? Stephen, Have a look in ~/sqllib/userprofile where ~ is the home directory of the DB2 instance owner. Regards, Kurt -Oorspronkelijk bericht- Van: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Namens Stackwick, Stephen Verzonden: dinsdag 10 september 2013 23:53 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: [ADSM-L] DB2 backup defaults? All the doc for backing up DB2 with TSM says to set the DSMI* variables. But what if they're not set? Do they default? I'm looking at a DB2 system that is apparently backing up, but I don't see those variables set anywhere (even in a DB2 GET DB CFG listing; the TSM variables are all blank); set and env never show them, for root or the DB2 user. On top of that, the ERP piece seems to be installed, but I don't see any profile or utl file that should be configured for that. Every night a cron job fires off a db2 backup db using tsm and darned if it doesn't work. Am I missing something? Steve Confused Stackwick STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | stephen.stackw...@icfi.commailto:sstackw...@icfi.com | icfi.comhttp://www.icfi.com/ ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) *** Disclaimer *** Vlaamse Radio- en Televisieomroeporganisatie Auguste Reyerslaan 52, 1043 Brussel nv van publiek recht BTW BE 0244.142.664 RPR Brussel
Re: DB2 backup defaults?
Also, make absolutely sure that the config file you located is the one DB2 is using. I had a similar situation on a system that many DBA's had administered one several years and let's just say they got pretty creative. In the end the DB2 processes was getting the parameters from another location that someone randomly created. -Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Karel Bos Sent: Thursday, September 19, 2013 2:23 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 backup defaults? Hi, DB2 backup reads config settings only at start up. Cleaning the config files after that wont change the running setup untill db2 gets restarted. Either check time stamp of current config files or restart db2 and see whats going to happen :) . Kind regards, Karel Op 11 sep. 2013 15:47 schreef Stackwick, Stephen stephen.stackw...@icfi.com het volgende: I got nothing (see below). Yet, the backups are working somehow. I don't think the DB2_VENDOR_LIB is relevant, since the end user is not using BACKOM. db2 get db cfg for pe1 | grep -i tsm First log archive method (LOGARCHMETH1) = TSM Second log archive method(LOGARCHMETH2) = TSM TSM management class(TSM_MGMTCLASS) = TSM node name(TSM_NODENAME) = TSM owner (TSM_OWNER) = TSM password (TSM_PASSWORD) = env | grep -i dsm env | grep -i tsm DB2_VENDOR_LIB=/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a set | grep -i dsm set | grep -i tsm STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | stephen.stackw...@icfi.com | icfi.com ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Gopikrishna Muppidi Sent: Wednesday, September 11, 2013 9:20 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 backup defaults? Hello , For DB2 backups for any systems via TSM,the below mentioned environment variables has to be define on the db2 level,then only backup to tsm will be possible,see the below example. host:db2sap 10 db2 get db cfg for sap|grep -i tsm First log archive method (LOGARCHMETH1) = TSM:DB2_STD_ARCHIVE1 Second log archive method(LOGARCHMETH2) = TSM:DB2_STD_ARCHIVE2 TSM management class(TSM_MGMTCLASS) = DB2_STD_ONLINE TSM node name(TSM_NODENAME) = TSM owner (TSM_OWNER) = TSM password (TSM_PASSWORD) = hostname:db2sap 11 env|grep -i dsm DSMI_DIR=/opt/tivoli/tsm/client/api/bin64 DSMI_LOG=/db2/db2sap/errors DSMI_CONFIG=/db2/db2sap/sqllib/adsm/dsm_host-SAP.opt DSM_DIR=/opt/tivoli/tsm/client/ba/bin DSM_CONFIG=/db2/db2sap/sqllib/adsm/dsm_host-SAP.opt DSM_LOG=/db2/db2sap/errors host name:db2pbg 12 env|grep -i tsm DSMI_DIR=/opt/tivoli/tsm/client/api/bin64 DSM_DIR=/opt/tivoli/tsm/client/ba/bin hostname:db2sap 13 Thank you! On Wed, Sep 11, 2013 at 3:07 PM, Stackwick, Stephen stephen.stackw...@icfi.com wrote: Thanks, Kurt. The file exists, but is empty. I ran ps -ef | grep db2, found the instance owner (and indeed, he's the one running the backups), and su - to him, found the empty userprofile. TSM must be using defaults of some kind STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | stephen.stackw...@icfi.com | icfi.com ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of BEYERS Kurt Sent: Wednesday, September 11, 2013 5:26 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 backup defaults? Stephen, Have a look in ~/sqllib/userprofile where ~ is the home directory of the DB2 instance owner. Regards, Kurt -Oorspronkelijk bericht- Van: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Namens Stackwick, Stephen Verzonden: dinsdag 10 september 2013 23:53 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: [ADSM-L] DB2 backup defaults? All the doc for backing up DB2 with TSM says to set the DSMI* variables. But what if they're not set? Do they default? I'm looking at a DB2 system that is apparently backing up, but I don't see those variables set anywhere (even in a DB2 GET DB CFG listing; the TSM variables are all blank); set and env never show them, for root or the DB2 user. On top of that, the ERP piece seems to be installed, but I don't see any profile or utl file that should be configured for that. Every
Re: DB2 backup defaults?
Stephen, Have a look in ~/sqllib/userprofile where ~ is the home directory of the DB2 instance owner. Regards, Kurt -Oorspronkelijk bericht- Van: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Namens Stackwick, Stephen Verzonden: dinsdag 10 september 2013 23:53 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: [ADSM-L] DB2 backup defaults? All the doc for backing up DB2 with TSM says to set the DSMI* variables. But what if they're not set? Do they default? I'm looking at a DB2 system that is apparently backing up, but I don't see those variables set anywhere (even in a DB2 GET DB CFG listing; the TSM variables are all blank); set and env never show them, for root or the DB2 user. On top of that, the ERP piece seems to be installed, but I don't see any profile or utl file that should be configured for that. Every night a cron job fires off a db2 backup db using tsm and darned if it doesn't work. Am I missing something? Steve Confused Stackwick STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | stephen.stackw...@icfi.commailto:sstackw...@icfi.com | icfi.comhttp://www.icfi.com/ ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) *** Disclaimer *** Vlaamse Radio- en Televisieomroeporganisatie Auguste Reyerslaan 52, 1043 Brussel nv van publiek recht BTW BE 0244.142.664 RPR Brussel http://www.vrt.be/gebruiksvoorwaarden
Re: DB2 backup defaults?
Thanks, Kurt. The file exists, but is empty. I ran ps -ef | grep db2, found the instance owner (and indeed, he's the one running the backups), and su - to him, found the empty userprofile. TSM must be using defaults of some kind STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | stephen.stackw...@icfi.com | icfi.com ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of BEYERS Kurt Sent: Wednesday, September 11, 2013 5:26 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 backup defaults? Stephen, Have a look in ~/sqllib/userprofile where ~ is the home directory of the DB2 instance owner. Regards, Kurt -Oorspronkelijk bericht- Van: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Namens Stackwick, Stephen Verzonden: dinsdag 10 september 2013 23:53 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: [ADSM-L] DB2 backup defaults? All the doc for backing up DB2 with TSM says to set the DSMI* variables. But what if they're not set? Do they default? I'm looking at a DB2 system that is apparently backing up, but I don't see those variables set anywhere (even in a DB2 GET DB CFG listing; the TSM variables are all blank); set and env never show them, for root or the DB2 user. On top of that, the ERP piece seems to be installed, but I don't see any profile or utl file that should be configured for that. Every night a cron job fires off a db2 backup db using tsm and darned if it doesn't work. Am I missing something? Steve Confused Stackwick STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | stephen.stackw...@icfi.commailto:sstackw...@icfi.com | icfi.comhttp://www.icfi.com/ ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) *** Disclaimer *** Vlaamse Radio- en Televisieomroeporganisatie Auguste Reyerslaan 52, 1043 Brussel nv van publiek recht BTW BE 0244.142.664 RPR Brussel http://www.vrt.be/gebruiksvoorwaarden
Re: DB2 backup defaults?
Hello , For DB2 backups for any systems via TSM,the below mentioned environment variables has to be define on the db2 level,then only backup to tsm will be possible,see the below example. host:db2sap 10 db2 get db cfg for sap|grep -i tsm First log archive method (LOGARCHMETH1) = TSM:DB2_STD_ARCHIVE1 Second log archive method(LOGARCHMETH2) = TSM:DB2_STD_ARCHIVE2 TSM management class(TSM_MGMTCLASS) = DB2_STD_ONLINE TSM node name(TSM_NODENAME) = TSM owner (TSM_OWNER) = TSM password (TSM_PASSWORD) = hostname:db2sap 11 env|grep -i dsm DSMI_DIR=/opt/tivoli/tsm/client/api/bin64 DSMI_LOG=/db2/db2sap/errors DSMI_CONFIG=/db2/db2sap/sqllib/adsm/dsm_host-SAP.opt DSM_DIR=/opt/tivoli/tsm/client/ba/bin DSM_CONFIG=/db2/db2sap/sqllib/adsm/dsm_host-SAP.opt DSM_LOG=/db2/db2sap/errors host name:db2pbg 12 env|grep -i tsm DSMI_DIR=/opt/tivoli/tsm/client/api/bin64 DSM_DIR=/opt/tivoli/tsm/client/ba/bin hostname:db2sap 13 Thank you! On Wed, Sep 11, 2013 at 3:07 PM, Stackwick, Stephen stephen.stackw...@icfi.com wrote: Thanks, Kurt. The file exists, but is empty. I ran ps -ef | grep db2, found the instance owner (and indeed, he's the one running the backups), and su - to him, found the empty userprofile. TSM must be using defaults of some kind STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | stephen.stackw...@icfi.com | icfi.com ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of BEYERS Kurt Sent: Wednesday, September 11, 2013 5:26 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 backup defaults? Stephen, Have a look in ~/sqllib/userprofile where ~ is the home directory of the DB2 instance owner. Regards, Kurt -Oorspronkelijk bericht- Van: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Namens Stackwick, Stephen Verzonden: dinsdag 10 september 2013 23:53 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: [ADSM-L] DB2 backup defaults? All the doc for backing up DB2 with TSM says to set the DSMI* variables. But what if they're not set? Do they default? I'm looking at a DB2 system that is apparently backing up, but I don't see those variables set anywhere (even in a DB2 GET DB CFG listing; the TSM variables are all blank); set and env never show them, for root or the DB2 user. On top of that, the ERP piece seems to be installed, but I don't see any profile or utl file that should be configured for that. Every night a cron job fires off a db2 backup db using tsm and darned if it doesn't work. Am I missing something? Steve Confused Stackwick STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | stephen.stackw...@icfi.commailto:sstackw...@icfi.com | icfi.comhttp://www.icfi.com/ ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) *** Disclaimer *** Vlaamse Radio- en Televisieomroeporganisatie Auguste Reyerslaan 52, 1043 Brussel nv van publiek recht BTW BE 0244.142.664 RPR Brussel http://www.vrt.be/gebruiksvoorwaarden
Re: DB2 backup defaults?
I got nothing (see below). Yet, the backups are working somehow. I don't think the DB2_VENDOR_LIB is relevant, since the end user is not using BACKOM. db2 get db cfg for pe1 | grep -i tsm First log archive method (LOGARCHMETH1) = TSM Second log archive method(LOGARCHMETH2) = TSM TSM management class(TSM_MGMTCLASS) = TSM node name(TSM_NODENAME) = TSM owner (TSM_OWNER) = TSM password (TSM_PASSWORD) = env | grep -i dsm env | grep -i tsm DB2_VENDOR_LIB=/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a set | grep -i dsm set | grep -i tsm STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | stephen.stackw...@icfi.com | icfi.com ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Gopikrishna Muppidi Sent: Wednesday, September 11, 2013 9:20 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 backup defaults? Hello , For DB2 backups for any systems via TSM,the below mentioned environment variables has to be define on the db2 level,then only backup to tsm will be possible,see the below example. host:db2sap 10 db2 get db cfg for sap|grep -i tsm First log archive method (LOGARCHMETH1) = TSM:DB2_STD_ARCHIVE1 Second log archive method(LOGARCHMETH2) = TSM:DB2_STD_ARCHIVE2 TSM management class(TSM_MGMTCLASS) = DB2_STD_ONLINE TSM node name(TSM_NODENAME) = TSM owner (TSM_OWNER) = TSM password (TSM_PASSWORD) = hostname:db2sap 11 env|grep -i dsm DSMI_DIR=/opt/tivoli/tsm/client/api/bin64 DSMI_LOG=/db2/db2sap/errors DSMI_CONFIG=/db2/db2sap/sqllib/adsm/dsm_host-SAP.opt DSM_DIR=/opt/tivoli/tsm/client/ba/bin DSM_CONFIG=/db2/db2sap/sqllib/adsm/dsm_host-SAP.opt DSM_LOG=/db2/db2sap/errors host name:db2pbg 12 env|grep -i tsm DSMI_DIR=/opt/tivoli/tsm/client/api/bin64 DSM_DIR=/opt/tivoli/tsm/client/ba/bin hostname:db2sap 13 Thank you! On Wed, Sep 11, 2013 at 3:07 PM, Stackwick, Stephen stephen.stackw...@icfi.com wrote: Thanks, Kurt. The file exists, but is empty. I ran ps -ef | grep db2, found the instance owner (and indeed, he's the one running the backups), and su - to him, found the empty userprofile. TSM must be using defaults of some kind STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | stephen.stackw...@icfi.com | icfi.com ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of BEYERS Kurt Sent: Wednesday, September 11, 2013 5:26 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 backup defaults? Stephen, Have a look in ~/sqllib/userprofile where ~ is the home directory of the DB2 instance owner. Regards, Kurt -Oorspronkelijk bericht- Van: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Namens Stackwick, Stephen Verzonden: dinsdag 10 september 2013 23:53 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: [ADSM-L] DB2 backup defaults? All the doc for backing up DB2 with TSM says to set the DSMI* variables. But what if they're not set? Do they default? I'm looking at a DB2 system that is apparently backing up, but I don't see those variables set anywhere (even in a DB2 GET DB CFG listing; the TSM variables are all blank); set and env never show them, for root or the DB2 user. On top of that, the ERP piece seems to be installed, but I don't see any profile or utl file that should be configured for that. Every night a cron job fires off a db2 backup db using tsm and darned if it doesn't work. Am I missing something? Steve Confused Stackwick STEPHEN STACKWICK | Senior Consultant | 301.518.6352 (m) | stephen.stackw...@icfi.commailto:sstackw...@icfi.com | icfi.comhttp://www.icfi.com/ ICF INTERNATIONAL | 410 E. Pratt Street Suite 2214, Baltimore, MD 21202 | 410.539.1135 (o) *** Disclaimer *** Vlaamse Radio- en Televisieomroeporganisatie Auguste Reyerslaan 52, 1043 Brussel nv van publiek recht BTW BE 0244.142.664 RPR Brussel http://www.vrt.be/gebruiksvoorwaarden
Re: DB2 Backup on tsm error.
Hi Richard, Thanks for your support. Now its working fine.. sorry for inconvenience.. Thanks of lots to you. Thanks and Regards Murugan From: ADSM: Dist Stor Manager on behalf of Richard Sims Sent: Sun 4/1/2007 7:04 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 Backup on tsm error. On Apr 1, 2007, at 8:32 AM, Murugan_Pachamallayan wrote: Now all the configurations are done. Then i try to backup, one more error code is coming db2 backup db sample use tsm SQL2062N An Error occurred while accessing media /home/db2inst1/sqllib/libtsm.a. Reason Code: 2032. Don't be shy about searching at the TSM Support Page (http://www-306.ibm.com/software/sysmgmt/products/support/ IBMTivoliStorageManager.html) for: SQL2062N 2032 Richard Sims DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
Re: DB2 Backup on tsm error.
On Mar 31, 2007, at 11:42 PM, Murugan_Pachamallayan wrote: DSMI_DIR=/usr/tivoli/tsm/client/api/ Hello, Murugan - One issue that stands out to me is the above DSMI_DIR being used: it needs to point to the directory where your dsmtca and dsm.sys are located, which conventionally should be one of: /usr/tivoli/tsm/client/api/bin or /usr/tivoli/tsm/client/api/bin64 depending upon your OS bitmode. Assure also that the DSMI_LOG directory is writable by those who will invoke the client software, so that they may write a dsierror.log file therein. (And, if there is now such a log file there, it might contain some helpful recordings.) Be sure to meticulously follow the instructions in the Backing up DB2 on AIX using Tivoli Storage Manager redbook. Richard Sims
Re: DB2 Backup on tsm error.
Hi Richard , Thank you for your support.. I have followed Backing up DB2 on AIX using Tivoli Storage Manager redbook. Now all the configurations are done. Then i try to backup, one more error code is coming db2 backup db sample use tsm SQL2062N An Error occurred while accessing media /home/db2inst1/sqllib/libtsm.a. Reason Code: 2032. I read the API reurn codes source file .. Explanation: PASSWORDACCESS=GENERATE establishes a session with the current login user as the owner. The application should set clientOwnerNameP to NULL when PASSWORDACCESS=GENERATE is in effect. messagemessage System action: The system returns to the calling procedure. Whether the application can continue processing depends on how the application handles the error. User response: This message applies to applications that utilize the TSM API, and is intended primarily for the vendor of the application for which the message is issued. Depending on the application, this could be a configuration issue. Consult the documentation for the application and verify that the application is configured correctly. If the problem persists, contact the application vendor for further assistance. Still i have issue , please advice how can i procees further.. Thanks and Regards \ Murugan From: ADSM: Dist Stor Manager on behalf of Richard Sims Sent: Sun 4/1/2007 5:08 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 Backup on tsm error. On Mar 31, 2007, at 11:42 PM, Murugan_Pachamallayan wrote: DSMI_DIR=/usr/tivoli/tsm/client/api/ Hello, Murugan - One issue that stands out to me is the above DSMI_DIR being used: it needs to point to the directory where your dsmtca and dsm.sys are located, which conventionally should be one of: /usr/tivoli/tsm/client/api/bin or /usr/tivoli/tsm/client/api/bin64 depending upon your OS bitmode. Assure also that the DSMI_LOG directory is writable by those who will invoke the client software, so that they may write a dsierror.log file therein. (And, if there is now such a log file there, it might contain some helpful recordings.) Be sure to meticulously follow the instructions in the Backing up DB2 on AIX using Tivoli Storage Manager redbook. Richard Sims DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
Re: DB2 Backup on tsm error.
On Apr 1, 2007, at 8:32 AM, Murugan_Pachamallayan wrote: Now all the configurations are done. Then i try to backup, one more error code is coming db2 backup db sample use tsm SQL2062N An Error occurred while accessing media /home/db2inst1/sqllib/libtsm.a. Reason Code: 2032. Don't be shy about searching at the TSM Support Page (http://www-306.ibm.com/software/sysmgmt/products/support/ IBMTivoliStorageManager.html) for: SQL2062N 2032 Richard Sims
Re: DB2 Backup on tsm error.
Hi Richard, Very Good morning.. i have read this support document about db2 backup .. I have update the same... 1. Update db cfg for dbname using TSM_OWNER NULL 2. Update db cfg for dbname using TSM_NODENAME NULL 3. Update db cfg for dbname using TSM_PASSWORD NULL dbname : entis TSM_OWNER=admin TSM_NODENAME=entisapp001 TSM_PASSWORD=admin123 Still i get same issue .. If anything did wrong , please make correct.. Thanks and Regards Murugan From: ADSM: Dist Stor Manager on behalf of Richard Sims Sent: Sun 4/1/2007 7:04 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] DB2 Backup on tsm error. On Apr 1, 2007, at 8:32 AM, Murugan_Pachamallayan wrote: Now all the configurations are done. Then i try to backup, one more error code is coming db2 backup db sample use tsm SQL2062N An Error occurred while accessing media /home/db2inst1/sqllib/libtsm.a. Reason Code: 2032. Don't be shy about searching at the TSM Support Page (http://www-306.ibm.com/software/sysmgmt/products/support/ IBMTivoliStorageManager.html) for: SQL2062N 2032 Richard Sims DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
Re: DB2 Backup on tsm error.
On Mar 31, 2007, at 10:58 AM, Murugan_Pachamallayan wrote: Hi , Doing the db2 backup, i got the following error message.. db2 backup db sample use tsm SQL2062N An Error occurred while accessing media /home/db2inst1/sqllib/libtsm.a. Reason Code: 168. ./dsmapipw Enter your current password: admin123 Enter your new password:admin123 Enter your new password again:admin123 *** Server signon failed: (137) Authentication failure! Murugan - Context for the SQL2062N message is summarized in ADSM QuickFacts. You'll find the 168 error code in the TSM API manual, generally referring to an issue where the client password must be stored, but the invoker is apparently not root. You can find more specific problem cases via the TSM Support Page, http://www-306.ibm.com/software/sysmgmt/products/support/ IBMTivoliStorageManager.html by searching on: SQL2062N 168 Richard Sims
Re: DB2 Backup on tsm error.
Hi Murugan, Looking at the errors reported, this is most definitely a password or username issue. Check your dsm.sys and dsm.opt file for username entered there. Secondly, update your new password from your TSM sever as well. (update nodename your new password). Then try to change your password again on the client server. Hope this helps. Dinesh Pahari -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Murugan_Pachamallayan Sent: Sunday, 1 April 2007 12:58 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] DB2 Backup on tsm error. Hi , Doing the db2 backup, i got the following error message.. db2 backup db sample use tsm SQL2062N An Error occurred while accessing media /home/db2inst1/sqllib/libtsm.a. Reason Code: 168. ./dsmapipw Enter your current password: admin123 Enter your new password:admin123 Enter your new password again:admin123 *** Server signon failed: (137) Authentication failure! Please can any one help me out in this regard. Thanks and Regards Murugan DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
Re: DB2 backup - connection unstable ?
On Tue, 24 Jan 2006 13:58:59 +0100, Brian Ipsen [EMAIL PROTECTED] said: Hi, I've got an issue with a DB2 database running backup towards a TSM server... for some wierd reason, it keeps dropping/re-establishing the connection towards the server... The activity log on the server says: What's your idle timeout? I've seen one factor that tends to result in dropped sessions in many environments: botched network at the client side. If you can get full bandwidth in and out of the client, then that's not it. One factor relevant for DB2 is that DB2 sometimes takes a while twiddling its thumbs between tablespaces. If your timeout is sufficiently small, this might give the session time to expire. But from your log, that'd have to be a really short time, like in the minute range or under. That sounds suspiciously low to me. - Allen S. Rout
Re: DB2 backup - connection unstable ?
Hi, Digging through the documentation from Tivoli gave me a clue - somehow, DB2 want to put logs in the archive copy group of the default management class in the domain, where the node is registered. I wonder why it isn't possible to assign a management class to the logs... Wierd - but anyway, it seems to be running now... Regards, /Brian On Tue, 24 Jan 2006 13:58:59 +0100, Brian Ipsen [EMAIL PROTECTED] said: Hi, I've got an issue with a DB2 database running backup towards a TSM server... for some wierd reason, it keeps dropping/re-establishing the connection towards the server... The activity log on the server says: What's your idle timeout? I've seen one factor that tends to result in dropped sessions in many environments: botched network at the client side. If you can get full bandwidth in and out of the client, then that's not it. One factor relevant for DB2 is that DB2 sometimes takes a while twiddling its thumbs between tablespaces. If your timeout is sufficiently small, this might give the session time to expire. But from your log, that'd have to be a really short time, like in the minute range or under. That sounds suspiciously low to me. - Allen S. Rout
Re: DB2 backup - connection unstable ?
On Tue, 24 Jan 2006 15:22:45 +0100, Brian Ipsen [EMAIL PROTECTED] said: Digging through the documentation from Tivoli gave me a clue - somehow, DB2 want to put logs in the archive copy group of the default management class in the domain, where the node is registered. I wonder why it isn't possible to assign a management class to the logs... I assign my DB2 nodes to a separate domain; I wasn't aware of the tendency you describe, but it would solve that problem, too. - Allen S. Rout
Re: DB2 Backup offline on Winnt
yes you are right !! and not only that .. but also Lotus .. just about to post one question on the policy .. i am confusd in policy for retention. Right now .. i want to just take backups of the backups taken by their application. LAter on i will automate using TSM. Can anyone kindly give me the knowledge as to what folders should i exclude from backup if: 1- I have bd2 database backup with me. 2- System state backup with me. 3- I want to restore complete system with DB2, with DB2 database backup ONLY availbale with me in a file. 4- What folders/files should i exclude from backup using BA Client, so that i don't mess up with open databases. Kind Regards, Sandra Steve Harris wrote: Sandra, You really have jumped in at the deep end haven't you? DB2, Oracle, offsite all at once. There is no need to shy away from DB2. Its interface is reasonably straightforward, and there is a redbook to tell you exactly how to set it up. http://publib-b.boulder.ibm.com/abstracts/sg246247.html?Open Regards Steve [EMAIL PROTECTED] 02/11/2004 5:39:28 Dear All, Since we don't have any DB2 Administrator therefore I am not going into taking online backups of DB2. The application that is using DB2 taking DB2 backups by first shutting doen the database and then taking backups using DB2 commands and then starting the database. They keep this backedup database with them on tapes and then rotation of tapes start. Now I am going to automate only this backedup database by taking incremental backups only. Question: For Database A, what folders should I exclude so that I get all the configuration of DB2 and then restoring database from those backups. Do I have to shutdown DB2 before I take incremental backups of entire WINNT machine? How about open file support on NT since there is no wizard to configure open file support, and not even an option to select for image etc.? Please advise and Help ! Kind Regards, Sandra *** This email, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost, if you receive it and you are not the intended recipient(s), or if it is transmitted/received in error. Any unauthorised use, alteration, disclosure, distribution or review of this email is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this email in error, you are asked to immediately notify the sender by telephone or by return email. You should also delete this email and destroy any hard copies produced. ***
Re: DB2 Backup offline on Winnt
also i have started to hear about ESS where i'll have to take flashcopy into consideration and Server free backupss hhh !!! Will be bugging you guys on this too later .. i wish after 1 week or so !! and not earlier ! Sandra ! Sandra wrote: yes you are right !! and not only that .. but also Lotus .. just about to post one question on the policy .. i am confusd in policy for retention. Right now .. i want to just take backups of the backups taken by their application. LAter on i will automate using TSM. Can anyone kindly give me the knowledge as to what folders should i exclude from backup if: 1- I have bd2 database backup with me. 2- System state backup with me. 3- I want to restore complete system with DB2, with DB2 database backup ONLY availbale with me in a file. 4- What folders/files should i exclude from backup using BA Client, so that i don't mess up with open databases. Kind Regards, Sandra Steve Harris wrote: Sandra, You really have jumped in at the deep end haven't you? DB2, Oracle, offsite all at once. There is no need to shy away from DB2. Its interface is reasonably straightforward, and there is a redbook to tell you exactly how to set it up. http://publib-b.boulder.ibm.com/abstracts/sg246247.html?Open Regards Steve [EMAIL PROTECTED] 02/11/2004 5:39:28 Dear All, Since we don't have any DB2 Administrator therefore I am not going into taking online backups of DB2. The application that is using DB2 taking DB2 backups by first shutting doen the database and then taking backups using DB2 commands and then starting the database. They keep this backedup database with them on tapes and then rotation of tapes start. Now I am going to automate only this backedup database by taking incremental backups only. Question: For Database A, what folders should I exclude so that I get all the configuration of DB2 and then restoring database from those backups. Do I have to shutdown DB2 before I take incremental backups of entire WINNT machine? How about open file support on NT since there is no wizard to configure open file support, and not even an option to select for image etc.? Please advise and Help ! Kind Regards, Sandra *** This email, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost, if you receive it and you are not the intended recipient(s), or if it is transmitted/received in error. Any unauthorised use, alteration, disclosure, distribution or review of this email is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this email in error, you are asked to immediately notify the sender by telephone or by return email. You should also delete this email and destroy any hard copies produced. ***
Re: DB2 Backup offline on Winnt
Sandra, You really have jumped in at the deep end haven't you? DB2, Oracle, offsite all at once. There is no need to shy away from DB2. Its interface is reasonably straightforward, and there is a redbook to tell you exactly how to set it up. http://publib-b.boulder.ibm.com/abstracts/sg246247.html?Open Regards Steve [EMAIL PROTECTED] 02/11/2004 5:39:28 Dear All, Since we don't have any DB2 Administrator therefore I am not going into taking online backups of DB2. The application that is using DB2 taking DB2 backups by first shutting doen the database and then taking backups using DB2 commands and then starting the database. They keep this backedup database with them on tapes and then rotation of tapes start. Now I am going to automate only this backedup database by taking incremental backups only. Question: For Database A, what folders should I exclude so that I get all the configuration of DB2 and then restoring database from those backups. Do I have to shutdown DB2 before I take incremental backups of entire WINNT machine? How about open file support on NT since there is no wizard to configure open file support, and not even an option to select for image etc.? Please advise and Help ! Kind Regards, Sandra *** This email, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost, if you receive it and you are not the intended recipient(s), or if it is transmitted/received in error. Any unauthorised use, alteration, disclosure, distribution or review of this email is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this email in error, you are asked to immediately notify the sender by telephone or by return email. You should also delete this email and destroy any hard copies produced. ***
Re: DB2 backup environment variables
Get the redbook on Backing up DB2 using TSM. I believe in there they suggest that any changes be made to the file userprofile instead of the .profile for the instance. You also need to stop and start the instance for the changes to take effect. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Paul Genest Sent: Tuesday, March 16, 2004 1:04 PM To: [EMAIL PROTECTED] Subject: DB2 backup environment variables I am trying to set up a DB2 backup using TSM. My test instance is db2inst1. AIX 5.2 DB@ 8.1 TSM Client 5.2.2 TSM api 5.2.2 All are the 64 bit versions. The following variables were set in the .profile of user db2inst1: export DSMI_DIR=/usr/tivoli/tsm/client/api/bin64 export DSMI_CONFIG=/home/db2inst1/tsm/dsm.opt export DSMI_LOG=/home/db2inst1/tsm As root, and with the above DSMI variables set in the environment, db2inst1/sqllib/adsm/dsmapipw was executed without error and verified with db2adutl query. The above environment variables were used, as confirmed by looking at the results and a trace. Logged in as db2inst1, and after verifying that the environment variables are ok, I executed the db2 backup db sample use tsm command and the backup was successful. The problem is that the environment DSMI variables above were ignored and the defaults were used. This is confirmed by a trace. Can anyone suggest why this is happening. Thanks in advance.
Re: DB2 backup
Hi Nicolas, you might have to reinstall the APi code, but think about stopping DB2 during reinstallation, yours René LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center SD/ESN Av. Nestlé 55 CH-1800 Vevey (Switzerland) tél +41 (0)21 924'35'43 fax +41 (0)21 924'45'89 local REL-5 01 mailto:[EMAIL PROTECTED] This message is intended only for the use of the addressee and may contain information that is privileged and confidential. -Original Message- From: Nicolas Launay [mailto:[EMAIL PROTECTED] Sent: Thursday,11. March 2004 11:08 To: [EMAIL PROTECTED] Subject: DB2 backup Hi, I'm trying to backup a db2 database with tsm. (DB2 V7.2.5, TSM 5.2). When I launch my backup (db2 backup db DBNAME use TSM), the following message appears. SQL2062N An error occured while accessing media D: \Progra~1\SQLLIB\bin\db2tadsm.dll Reason code:2041. I think that I've made all the configurations described in the RedBook. Thank you. Nicolas
Re: DB2 backup
Are you using db2 with SAP R3 ? -Original Message- From: Nicolas Launay [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 12:08 PM To: [EMAIL PROTECTED] Subject: DB2 backup Hi, I'm trying to backup a db2 database with tsm. (DB2 V7.2.5, TSM 5.2). When I launch my backup (db2 backup db DBNAME use TSM), the following message appears. SQL2062N An error occured while accessing media D: \Progra~1\SQLLIB\bin\db2tadsm.dll Reason code:2041. I think that I've made all the configurations described in the RedBook. Thank you. Nicolas This email and any accompanying attachments may contain confidential and proprietary information. This information is private and protected by law and accordingly if you are not the intended recipient you are requested to delete this entire communication immediately and are notified that any disclosure copying or distribution of or taking any action based on this information is prohibited. Emails cannot be guaranteed to be secure or free of errors or viruses. The sender does not accept any liability or responsibility for any interception corruption destruction loss late arrival or incompleteness of or tampering or interference with any of the information contained in this email or for its incorrect delivery or non-delivery for whatsoever reason or for its effect on any electronic device of the recipient. If verification of this email or any attachment is required please request a hard-copy version
Re: DB2 backup
Hi Linda! Could you tell me the of your redbook ??? _ Nguyen Duc Thanh FPT Software Solution-Government Business Unit Address: 3th Fl, 51th, Ledaihanh.str, Haibatrung.dst, Hanoi, Vietnam Tel: (84-4) 974-5451/974-5476, ext 304 Fax: (84-4) 974-5475 Mobile: (090) 411-9847 Website: www.fpt.com.vn -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Crawford, Lindy Sent: 11 thang ba 2004 6:22 CH To: [EMAIL PROTECTED] Subject: Re: DB2 backup Are you using db2 with SAP R3 ? -Original Message- From: Nicolas Launay [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 12:08 PM To: [EMAIL PROTECTED] Subject: DB2 backup Hi, I'm trying to backup a db2 database with tsm. (DB2 V7.2.5, TSM 5.2). When I launch my backup (db2 backup db DBNAME use TSM), the following message appears. SQL2062N An error occured while accessing media D: \Progra~1\SQLLIB\bin\db2tadsm.dll Reason code:2041. I think that I've made all the configurations described in the RedBook. Thank you. Nicolas This email and any accompanying attachments may contain confidential and proprietary information. This information is private and protected by law and accordingly if you are not the intended recipient you are requested to delete this entire communication immediately and are notified that any disclosure copying or distribution of or taking any action based on this information is prohibited. Emails cannot be guaranteed to be secure or free of errors or viruses. The sender does not accept any liability or responsibility for any interception corruption destruction loss late arrival or incompleteness of or tampering or interference with any of the information contained in this email or for its incorrect delivery or non-delivery for whatsoever reason or for its effect on any electronic device of the recipient. If verification of this email or any attachment is required please request a hard-copy version
Réf. : Re: DB2 backup
No... |-+ | | Crawford, Lindy| | | [EMAIL PROTECTED]| | | P.CO.ZA | | | Envoyé par : | | | ADSM: Dist Stor | | | Manager | | | [EMAIL PROTECTED]| | | .EDU| | || | || | | 11/03/2004 12:22 | | | Veuillez répondre| | | à ADSM: Dist| | | Stor Manager| | || |-+ --| | | | Pour :[EMAIL PROTECTED] | | cc : | | Objet : Re: DB2 backup | --| Are you using db2 with SAP R3 ? -Original Message- From: Nicolas Launay [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 12:08 PM To: [EMAIL PROTECTED] Subject: DB2 backup Hi, I'm trying to backup a db2 database with tsm. (DB2 V7.2.5, TSM 5.2). When I launch my backup (db2 backup db DBNAME use TSM), the following message appears. SQL2062N An error occured while accessing media D: \Progra~1\SQLLIB\bin\db2tadsm.dll Reason code:2041. I think that I've made all the configurations described in the RedBook. Thank you. Nicolas This email and any accompanying attachments may contain confidential and proprietary information. This information is private and protected by law and accordingly if you are not the intended recipient you are requested to delete this entire communication immediately and are notified that any disclosure copying or distribution of or taking any action based on this information is prohibited. Emails cannot be guaranteed to be secure or free of errors or viruses. The sender does not accept any liability or responsibility for any interception corruption destruction loss late arrival or incompleteness of or tampering or interference with any of the information contained in this email or for its incorrect delivery or non-delivery for whatsoever reason or for its effect on any electronic device of the recipient. If verification of this email or any attachment is required please request a hard-copy version
Re: DB2 backup
Can anyone have link to understand backup DB2 using TSM? I need to know how to backup logs using api, if it is possible? Regards, Rosa Leung Integrated Storage Management Services IBM Global Services - SDC North/Central Tel: 416-490-5151, Fax: 416-490-5283 E-Mail: [EMAIL PROTECTED] ___
Re: DB2 backup
Have you tried the IBM Redbook, Backing Up DB2 Using Tivoli Storage Manager? I used to to setup mine and had no problems with it, very straight forward. http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006 bb65f/ca11be93f3ae47b2852569f800819a82?OpenDocumentHighlight=0,db2 Michael French Savvis Communications IDS01 Santa Clara, CA (408)450-7812 -- desk (408)239-9913 -- mobile -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rosa Leung Sent: Tuesday, February 17, 2004 11:48 AM To: [EMAIL PROTECTED] Subject: Re: DB2 backup Can anyone have link to understand backup DB2 using TSM? I need to know how to backup logs using api, if it is possible? Regards, Rosa Leung Integrated Storage Management Services IBM Global Services - SDC North/Central Tel: 416-490-5151, Fax: 416-490-5283 E-Mail: [EMAIL PROTECTED] ___
Re: DB2 backup problem
On Wed, Jan 22, 2003 at 12:20:05PM +0100, Lars Bebensee wrote: The only hint I was able to find was in DB2's diag logs: 2003-01-19-18.02.51.509653 Instance:db2minst Node:001 PID:51956(db2agent (DB2MPROD) 1) Appid:*N1.db2minst.030119170156 database_utilities sqlubcka Probe:20 Database:DB2MPROD fbf5 556e 6162 6c65 2074 6f20 6f62 Unable to ob 7461 696e 2073 7570 6572 2065 7863 6c75 tain super exclu 7369 7665 2063 6f6e 6e65 6374 696f 6e00 sive connection. Anyone there to translate?? In order to backup the database _offline_, you need a super exclusive connection to the database, thus no other client connections are allowed. It seems there were another connections to the database during the attempt of the offline backup. You have two options. a. run an online backup and save the logs, b. before the scheduled offline backup, force all client connections off the db. (db2 force application all) -- bx Seize the day - I heard him say - life will not always be this way, Look around, hear the sounds, cherish your life while you're still around.
Re: DB2 backup on AIX
We have our important DB2 databases being backed up to local DASD then TSM backs up the flat files with the required management class for database retention. This alleviated problems we were seeing with the db2 backups being interrupted and causing an out-of-sync condition, which only a restart of the application could fix. This also enables us (TSM) to control the expiration of the database files instead of relying on the DBA to expire them. This has decreased our storage requirements on some of these servers to a quarter of what they were using. Tony Garrison I/T Sr. Systems Programmer USAA 210-913-9836 -Original Message- From: Daniel Sparrman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 6:26 AM To: [EMAIL PROTECTED] Subject: Re: DB2 backup on AIX Hi DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin. It also explains how to do it in Backing up databases with Tivoli Storage Manager Best Regards Daniel Sparrman --- Daniel Sparrman Exist i Stockholm AB Propellervägen 6B 183 62 HÄGERNÄS Växel: 08 - 754 98 00 Mobil: 070 - 399 27 51
Re: DB2 backup on AIX
Hi DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin. It also explains how to do it in Backing up databases with Tivoli Storage Manager Best Regards Daniel Sparrman --- Daniel Sparrman Exist i Stockholm AB Propellervägen 6B 183 62 HÄGERNÄS Växel: 08 - 754 98 00 Mobil: 070 - 399 27 51
Re: DB2 backup on AIX
Thanks Daniel, I'll try to contact him (if any exists :-)). But I have one more question ... is any redbook or documentation about backing up DB2 database with TSM available? I would like to do some plans and pre-studying steps to accomplish this workaround. Thanks -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Daniel Sparrman Sent: Wednesday, December 11, 2002 1:26 PM To: [EMAIL PROTECTED] Subject: Re: DB2 backup on AIX Hi DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin. It also explains how to do it in Backing up databases with Tivoli Storage Manager Best Regards Daniel Sparrman --- Daniel Sparrman Exist i Stockholm AB Propellervdgen 6B 183 62 HDGERNDS Vdxel: 08 - 754 98 00 Mobil: 070 - 399 27 51
Re: DB2 backup on AIX
Try this link: http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg246247.html?Open Best regards, Kolbeinn Josepsson 7 Systems Engineer Tel: +354 569-7700 7 Fax: +354 569-7799 www.nyherji.is Tomas Hrouda [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: ADSM: cc: Dist StorSubject: Re: DB2 backup on AIX Manager [EMAIL PROTECTED] T.EDU 11.12.2002 12:44 Please respond to ADSM: Dist Stor Manager Thanks Daniel, I'll try to contact him (if any exists :-)). But I have one more question ... is any redbook or documentation about backing up DB2 database with TSM available? I would like to do some plans and pre-studying steps to accomplish this workaround. Thanks -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Daniel Sparrman Sent: Wednesday, December 11, 2002 1:26 PM To: [EMAIL PROTECTED] Subject: Re: DB2 backup on AIX Hi DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin. It also explains how to do it in Backing up databases with Tivoli Storage Manager Best Regards Daniel Sparrman --- Daniel Sparrman Exist i Stockholm AB Propellervdgen 6B 183 62 HDGERNDS Vdxel: 08 - 754 98 00 Mobil: 070 - 399 27 51
Re: DB2 backup on AIX
Many many thanks Davide. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Davide Giacomazzi Sent: Wednesday, December 11, 2002 2:13 PM To: [EMAIL PROTECTED] Subject: R: DB2 backup on AIX Hi Tom`s, you can find a redbook concerning db2 backup using tsm to the following link : http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65 f/ca11be93f3ae47b2852569f800819a82?OpenDocument Best regards Davide Giacomazzi Information Technology - TSM manager Tel. (+39) 045.8182215 Gruppo Assicurativo Arca Via San Marco 48 - 37138 Verona -Messaggio originale- Da: Tomas Hrouda [mailto:[EMAIL PROTECTED]] Inviato: mercoledl 11 dicembre 2002 13.45 A: [EMAIL PROTECTED] Oggetto: Re: DB2 backup on AIX Thanks Daniel, I'll try to contact him (if any exists :-)). But I have one more question ... is any redbook or documentation about backing up DB2 database with TSM available? I would like to do some plans and pre-studying steps to accomplish this workaround. Thanks -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Daniel Sparrman Sent: Wednesday, December 11, 2002 1:26 PM To: [EMAIL PROTECTED] Subject: Re: DB2 backup on AIX Hi DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin. It also explains how to do it in Backing up databases with Tivoli Storage Manager Best Regards Daniel Sparrman --- Daniel Sparrman Exist i Stockholm AB Propellervdgen 6B 183 62 HDGERNDS Vdxel: 08 - 754 98 00 Mobil: 070 - 399 27 51
Re: DB2 backup on AIX
... is any redbook or documentation about backing up DB2 database with TSM http://www.redbooks.ibm.com/ has a search capability, where you can enter things like db2 backup and it will reveal the Redbooks and Redpieces which contain such information. Richard Sims, BU
Re: DB2 Backup using different node names
Hi Eduardo, could you please provide the content of your dsm.opt and dsm.sys? Also, are you trying to backup your database with scheduler or by hand from command line. When you want backup one database with two different node names, you have to have correct environment DSMI_CONFIG,(I assume your platform is Unix) for particular TSM node in user environment, who owns database instance. Are tou sure you are switching your environment correctly? Ing. Jozef Zatko Login a.s. Dlha 2, Stupava tel.: (421) (2) 60252618
Re: DB2 Backup using different node names(MORE)
Ed - Bill, There is a way to do this. We have a 32way 690, only 18 partitions/nodes/clients(whatever ya wanna call em, I call virtnodez) backing up DB2. The 18 p/n/c have the DB2 database spread across multiple sharks adding up to about 2TB for this DB, each p/n/c has a partition at about 180GB or so. The backups are initiated thru maestro 10 seconds apart. We Linked the /usr/tivoli/tsm/client/*/ba/bin/dsm.opt file to a file called /tmp/dsm.opt. We gave the DB2 instance/user sudo access to only modify this file when the backup starts, the script changes the /tmp/dsm.opt to the instance or desired name. Since it is linked when the backup starts it assumes that desired name. We do this on a 12TB DB2 DB as well with 25 p/n/c. It works quite well. We had to add in another script to copy the original dsm.opt file to the /tmp/dsm.opt file, cause /tmp filled up and someone removed the file, it now checks for the file, if it isn't there it copies it. You need to have the desired names in your dsm.sys file also. I would give you the script, but I know it wouldn't work in your environment. Too many oddities here. :) If you didn't get lost in this email, GOOD LUCK! PS- I am trying to get them to do this(NODEXXDB2LOGXX) for the archive logging that happens periodically. Am I crazy? ZZ --- Bill Boyer [EMAIL PROTECTED] wrote: In Unix, my testing has shown that the DB2 instance uses the values set when that instance was started. If using the steps in the Backing up DB2 using TSM redbook, then the DSMI_* variables are set in the ~HOME/sqllib/userprofile script. The DB2 BACKUP DB ...USE TSM command is internal to the instance and uses those values. Not the values you have specified in your script. You would have to move in a different DSM.OPT file referencing a different NODENAME before each backup command. I don't quite understand why you want the same DB backed up as 2 different nodes??!!?! Assuming Unix. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Jozef Zatko Sent: Monday, November 18, 2002 2:59 AM To: [EMAIL PROTECTED] Subject: Re: DB2 Backup using different node names Hi Eduardo, could you please provide the content of your dsm.opt and dsm.sys? Also, are you trying to backup your database with scheduler or by hand from command line. When you want backup one database with two different node names, you have to have correct environment DSMI_CONFIG,(I assume your platform is Unix) for particular TSM node in user environment, who owns database instance. Are tou sure you are switching your environment correctly? Ing. Jozef Zatko Login a.s. Dlha 2, Stupava tel.: (421) (2) 60252618 __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com
Re: DB2 backup
Hi Mario , First define DSMI_DIR , DSMI_CONFIG as sistem environment parameters in NT client for example : DSMI_DIR C:\Programfiles\tivoli\tsm\client\api\bin (this is your TSM installition api\bin directory) DSMI_CONFIG C:\Programfiles\tivoli\tsm\client\api\bin\dsm.opt and at db2 command promt isue db2 backup db your_db online use adsm open (session numbers) sessions Mario Behring mariobehring@YA To: [EMAIL PROTECTED] HOO.COM cc: (bcc: MUSTAFA BAYTAR/BILSIS/ANADOLU) Sent by: ADSM: Subject: DB2 b Dist Stor Manager [EMAIL PROTECTED] T.EDU 17.10.2002 00:25 Please respond to ADSM: Dist Stor Manager Gentlemen, Does anyone know or have some reliable configuration steps for DB2 for Windows NT online backup using the TSM client ? My environment is this: = TSM Server 5.1.1.0 running on a Windows 2000 Server machine = TSM Backup-Archive Client 4.1.2.14 running on a Windows NT Server 4.0 SP6a machine with 2GB RAM The regular backup is running fine, but I need to backup the DB2 instances without having to stop them or the DB2 services. Thanks in advance. Mario Behring IT Consultant 55 11 9540-8383 __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com
Re: DB2 backup
Thanks !! --- Zlatko Krastev/ACIT [EMAIL PROTECTED] wrote: Redbook SG24-6247-00 Backing Up DB2 Using Tivoli Storage Manager Zlatko Krastev IT Consultant Mario Behring [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 17.10.2002 00:25 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:DB2 backup Gentlemen, Does anyone know or have some reliable configuration steps for DB2 for Windows NT online backup using the TSM client ? My environment is this: = TSM Server 5.1.1.0 running on a Windows 2000 Server machine = TSM Backup-Archive Client 4.1.2.14 running on a Windows NT Server 4.0 SP6a machine with 2GB RAM The regular backup is running fine, but I need to backup the DB2 instances without having to stop them or the DB2 services. Thanks in advance. Mario Behring IT Consultant 55 11 9540-8383 __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com
Re: DB2 backup
Redbook SG24-6247-00 Backing Up DB2 Using Tivoli Storage Manager Zlatko Krastev IT Consultant Mario Behring [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 17.10.2002 00:25 Please respond to ADSM: Dist Stor Manager To: [EMAIL PROTECTED] cc: Subject:DB2 backup Gentlemen, Does anyone know or have some reliable configuration steps for DB2 for Windows NT online backup using the TSM client ? My environment is this: = TSM Server 5.1.1.0 running on a Windows 2000 Server machine = TSM Backup-Archive Client 4.1.2.14 running on a Windows NT Server 4.0 SP6a machine with 2GB RAM The regular backup is running fine, but I need to backup the DB2 instances without having to stop them or the DB2 services. Thanks in advance. Mario Behring IT Consultant 55 11 9540-8383 __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com
Re: DB2 backup problem..
These return codes are documented in the dsmrc.h file, located in the tsm\api\include directory. The return code here means: #define DSM_RC_NO_OWNER_REQD 2032 /* owner not allowed. Allow default */ Do you have an owner specified in the dsm.sys file stanza? You need to remove it. At 01:27 PM 5/31/2002 -0700, you wrote: I can't find this return code anywhere.. anyone know what this means? DB2 7.1 EE, TSM 4.2.2 server/client.. both boxes are solaris 2.8 db2 = backup db ds50 online use tsm SQL2062N An error occurred while accessing media /opt/db2udb/sqllib/adsm/libadsm.a. Reason code: 2032. db2 = ? sql2062n SQL2062N An error occurred while accessing media media. Reason code: reason-code Explanation: An unexpected error occurred while accessing a device, file, TSM or the vendor shared library during the processing of a database utility. The following is a list of reason codes: 1 An attempt to initialize a device, file, TSM or the vendor shared library failed. 2 An attempt to terminate a device, file, TSM or the vendor shared library failed. other If you are using TSM, this is an error code returned by TSM. The utility stops processing. User Response: Ensure the device, file, TSM or vendor shared library used by the utility is available and resubmit the utility command. If the command is still unsuccessful, contact your technical service representative. $ ls -l /opt/db2udb/sqllib/adsm/libadsm.a -r-r-r-1 bin bin 93664 Apr 17 2001 /opt/db2udb/sqllib/adsm/libadsm.a Regards, Gerald Wichmann Senior Systems Development Engineer Zantaz, Inc. 925.598.3099 (w) Money is not the root of all evil - full backups are.
Re: DB2 backup problem..
Nope.. my dsm.sys is: SErvername TSM COMMmethod TCPip TCPPort1500 TCPServeraddress dev36 passwordaccess generate SCHEDMODe PROMPT maxcmdretries 10 Nodename DB2 schedlogname /opt/tivoli/tsm/client/ba/bin/dsmsched.log schedlogretention 3 errorlogname /opt/tivoli/tsm/client/ba/bin/dsmerror.log errorlogretention 3 I notice in TSM messages theres this which is similar to what you mentioned: 2032 E DSM_RC_NO_OWNER_REQD Explanation: PASSWORDACCESS=generate establishes a session with the current login user as the owner. System Action: The system returns to the calling procedure. User Response: When using PASSWORDACCESS=generate, set clientOwnerNameP to NULL. Question is, why is this happening? I don't have an owner specified anywhere.. Regards, Gerald Wichmann Senior Systems Development Engineer Zantaz, Inc. 925.598.3099 (w) -Original Message- From: Dave Canan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 2:21 PM To: [EMAIL PROTECTED] Subject: Re: DB2 backup problem.. These return codes are documented in the dsmrc.h file, located in the tsm\api\include directory. The return code here means: #define DSM_RC_NO_OWNER_REQD 2032 /* owner not allowed. Allow default */ Do you have an owner specified in the dsm.sys file stanza? You need to remove it. At 01:27 PM 5/31/2002 -0700, you wrote: I can't find this return code anywhere.. anyone know what this means? DB2 7.1 EE, TSM 4.2.2 server/client.. both boxes are solaris 2.8 db2 = backup db ds50 online use tsm SQL2062N An error occurred while accessing media /opt/db2udb/sqllib/adsm/libadsm.a. Reason code: 2032. db2 = ? sql2062n SQL2062N An error occurred while accessing media media. Reason code: reason-code Explanation: An unexpected error occurred while accessing a device, file, TSM or the vendor shared library during the processing of a database utility. The following is a list of reason codes: 1 An attempt to initialize a device, file, TSM or the vendor shared library failed. 2 An attempt to terminate a device, file, TSM or the vendor shared library failed. other If you are using TSM, this is an error code returned by TSM. The utility stops processing. User Response: Ensure the device, file, TSM or vendor shared library used by the utility is available and resubmit the utility command. If the command is still unsuccessful, contact your technical service representative. $ ls -l /opt/db2udb/sqllib/adsm/libadsm.a -r-r-r-1 bin bin 93664 Apr 17 2001 /opt/db2udb/sqllib/adsm/libadsm.a Regards, Gerald Wichmann Senior Systems Development Engineer Zantaz, Inc. 925.598.3099 (w) Money is not the root of all evil - full backups are.
Re: DB2 backup problem..
Well that was painful but I found the problem after digging around on my own.. The Backing up DB2 using Tivoli Storage Manager redbook lacks a step in the section Chapter 6 : Backing up DB2 UDB on the Sun Solaris Platform. I closely followed the steps there and did it on two different DB2 installations with the same result.. Eventually after trying to troubleshoot and running out of ideas I read Appendix A Quick start/checklist for configuration which has a Sun Solaris section. After following the steps in there I found a section which was never mentioned in the main Installation section in chapter 6.. mainly this at the end of the quick start: - Get db cfg for DBNAME. - Update db cfg for DBNAME using TSM_PASSWORD NULL. (Similar syntax for other Tivoli Storage Manager parameters. NULL causes the parameter to be reset to nothing.) db2 = get db cfg for ds50 relevant portion of output: TSM management class(TSM_MGMTCLASS) = DB2_MGMTCLASS TSM node name(TSM_NODENAME) = ds-s0-99-1 TSM owner (TSM_OWNER) = admin TSM password (TSM_PASSWORD) = * db2 = update db cfg for ds50 using TSM_PASSWORD NULL DB2I The UPDATE DATABASE CONFIGURATION command completed successfully. DB21026I For most configuration parameters, all applications must disconnect from this database before the changes become effective. db2 = update db cfg for ds50 using TSM_MGMTCLASS NULL DB2I The UPDATE DATABASE CONFIGURATION command completed successfully. DB21026I For most configuration parameters, all applications must disconnect from this database before the changes become effective. db2 = update db cfg for ds50 using TSM_OWNER NULL DB2I The UPDATE DATABASE CONFIGURATION command completed successfully. DB21026I For most configuration parameters, all applications must disconnect from this database before the changes become effective. db2 = update db cfg for ds50 using TSM_NODENAME NULL DB2I The UPDATE DATABASE CONFIGURATION command completed successfully. DB21026I For most configuration parameters, all applications must disconnect from this database before the changes become effective. db2 = backup db ds50 use tsm Backup successful. The timestamp for this backup image is : 20020531164955 db2 = Thus why it was gripping RC 2032 complaining about ownership.. it was a parameter in DB2 all along.. Regards, Gerald Wichmann Senior Systems Development Engineer Zantaz, Inc. 925.598.3099 (w) -Original Message- From: William F. Colwell [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 2:32 PM To: [EMAIL PROTECTED] Subject: Re: DB2 backup problem.. Gerald, The return codes for tsm products that use the api are in the api folder, include folder, dsmrc.h file. TDPO and db2/udp use the api. In this case rc=2032 means -- #define DSM_RC_NO_OWNER_REQD 2032 /* owner not allowed. Allow default */ Exactly what to change to fix this? I have no idea. Hope this helps, Bill At 01:27 PM 5/31/2002 -0700, you wrote: I can't find this return code anywhere.. anyone know what this means? DB2 7.1 EE, TSM 4.2.2 server/client.. both boxes are solaris 2.8 db2 = backup db ds50 online use tsm SQL2062N An error occurred while accessing media /opt/db2udb/sqllib/adsm/libadsm.a. Reason code: 2032. db2 = ? sql2062n SQL2062N An error occurred while accessing media media. Reason code: reason-code Explanation: An unexpected error occurred while accessing a device, file, TSM or the vendor shared library during the processing of a database utility. The following is a list of reason codes: 1 An attempt to initialize a device, file, TSM or the vendor shared library failed. 2 An attempt to terminate a device, file, TSM or the vendor shared library failed. other If you are using TSM, this is an error code returned by TSM. The utility stops processing. User Response: Ensure the device, file, TSM or vendor shared library used by the utility is available and resubmit the utility command. If the command is still unsuccessful, contact your technical service representative. $ ls -l /opt/db2udb/sqllib/adsm/libadsm.a -r-r-r-1 bin bin 93664 Apr 17 2001 /opt/db2udb/sqllib/adsm/libadsm.a Regards, Gerald Wichmann Senior Systems Development Engineer Zantaz, Inc. 925.598.3099 (w) -- Bill Colwell C. S. Draper Lab Cambridge Ma.
Re: DB2 backup RC=157
Sorry, code levels as below: Server: TSM 4.2.0.0 on AIX 4.3.3 Client: TSM 4.2.0.0 on NT4 DB2:v7 fixpack 5 Qlogic FC catd is at firmware 1.61 and driver 8.00.08 On the client side there is nothing in the dsmerror.log other than 20-05-2002 22:33:11 sessRecvVerb: Error -72 from call to 'readRtn'. 20-05-2002 22:33:11 cuConfirm: Received rc: -72 trying to receive ConfirmResp verb 20-05-2002 22:33:12 sessSendVerb: Error sending Verb, rc: -1 20-05-2002 22:33:12 sessRecvVerb: Error -72 from call to 'readRtn'. 20-05-2002 22:33:12 cuConfirm: Received rc: -72 trying to receive ConfirmResp verb 20-05-2002 22:33:12 sessSendVerb: Error sending Verb, rc: -1 From dsmrc.h: /*-- -*/ /* Return codes (-71)-(-90) are reserved for CommTSM error codes */ /*-- -*/ #define DSM_RC_TSM_ABORT -72 /* Session aborted abnormally */ In the dsmaccnt.log 4,0,ADSM,05/20/2002,22:34:30,DB2RSLTSBDC1001_DB2,,DB2/NT,1,Named Pipe,0,0,0,0,0,0,0,0,0,12696744,2008,2,1731,52,4,0,0,0,0,2,0 4,0,ADSM,05/20/2002,22:35:15,DB2RSLTSBDC1001_DB2,,DB2/NT,1,Named Pipe,0,0,0,0,0,0,0,0,0,11574426,1924,2,1655,51,4,0,0,0,0,2,0 Nothing in the dsmsched.log since the DB2 backups aren't under the scheduler's control. On the Server side of things: Sessions aborted abnormally, however there are no related errors in the server log, only the following warnings: ate/Time Message -- 05/20/02 22:01:07 ANR0406I Session 25934 started for node DB2RSLTSBDC1001_- DB2 (DB2/NT) (Tcp/Ip 10.255.128.226(4315)). 05/20/02 22:34:01 ANR0480W Session 25934 for node DB2RSLTSBDC1001_DB2 (DB2/NT) terminated - connection with client severed. Sessions start then terminate some time later. The only other error/warning in the acct log is: 05/20/02 22:35:46 ANR8264W (Session: 25948, Origin: DB2RSLTSBDC1001_STA) Error reading data on Named Pipes, session 242. ReadFile return code is 233. 05/20/02 22:35:46 ANR8264W (Session: 25948, Origin: DB2RSLTSBDC1001_STA) Error reading data on Named Pipes, session 242. ReadFile return code is 233. 05/20/02 22:35:46 ANR8264W (Session: 25948, Origin: DB2RSLTSBDC1001_STA) Error reading data on Named Pipes, session 246. ReadFile return code is 233. ANR8264W (Windows NT) Error reading data on Named Pipes, session session number. ReadFile return code is return code. Explanation: The server experiences an error return code from the ReadFile Windows NT API while reading data from Named Pipes in the indicated session. This may be a normal event if either side of the connection is ended abruptly. System Action: The session is ended. Server operation continues. User Response: If the session is ended as a result of intentionally stopping either the client or server, no response is required. This is apparently an extraneous error fixed as of clinet v4.2.1.0 (we are at 4.2.0.0) IC30272 ANR8264W ...ERROR READING DATA ON NAMED PIPES, SESSION 22153844 SYSROUTES: An extraneous Named Pipe Read error may be reported when a session is cancelled for exceeding the idle time out period or is cancelled by administrative command. The P3A server IdleTimeOut is currently set at 60 minutes. CommTimeOut is also one hour. No session lasted more than about 30 minutes. -Original Message- From: Dave Canan [mailto:[EMAIL PROTECTED]] Sent: 15 May 2002 17:00 To: [EMAIL PROTECTED] Subject: Re: DB2 backup RC=157 Check to see if the activity log contains any error messages. I have seen these errors before when TSM is trying to mount a volume for the DB2 backup that has been marked read-only. Also, what is your DB2 fixpack level? Your TSM level? At 04:43 PM 5/15/2002 +0100, you wrote: *SMers, Our DBAs are having a few problems backing up a DB2 database to a TSM 3590 tape pool via LANfree. There are no errors in the dsmerror.log on the client, nor any indicated errors in the server actlog, nor any errors in the NT Event Viewer that could be related. The storage agent is running fine and not prodg any errors. When our DBAs run db2= backup db dbtest use TSM open 2 sessions they get an error message in the DB2 logs: SQL2025N An I/O error '157' occurred on media 'TSM' In the API messages it merely states that the transaction will be aborted: In dsmrc.h #define DSM_RC_WILL_ABORT 157 /* Transaction will be aborted */ Which doesn't really indicate what cause the abort. Any ideas/suggestions appreciated? Ta, Matt LTSB Storage Support * internal.7-430-3213 * external. 020-7922-3213 * fax020-7922-3302 * e-mail
Re: DB2 backup RC=157
Check to see if the activity log contains any error messages. I have seen these errors before when TSM is trying to mount a volume for the DB2 backup that has been marked read-only. Also, what is your DB2 fixpack level? Your TSM level? At 04:43 PM 5/15/2002 +0100, you wrote: *SMers, Our DBAs are having a few problems backing up a DB2 database to a TSM 3590 tape pool via LANfree. There are no errors in the dsmerror.log on the client, nor any indicated errors in the server actlog, nor any errors in the NT Event Viewer that could be related. The storage agent is running fine and not prodg any errors. When our DBAs run db2= backup db dbtest use TSM open 2 sessions they get an error message in the DB2 logs: SQL2025N An I/O error '157' occurred on media 'TSM' In the API messages it merely states that the transaction will be aborted: In dsmrc.h #define DSM_RC_WILL_ABORT 157 /* Transaction will be aborted */ Which doesn't really indicate what cause the abort. Any ideas/suggestions appreciated? Ta, Matt LTSB Storage Support * internal.7-430-3213 * external. 020-7922-3213 * fax020-7922-3302 * e-mail[EMAIL PROTECTED] --- This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. evolvebank.com is a division of Lloyds TSB Bank plc. Lloyds TSB Bank plc, 71 Lombard Street, London EC3P 3BS. Registered in England, number 2065. Telephone No: 020 7626 1500 Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street, Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone No: 0131 225 4555 Lloyds TSB Bank plc and Lloyds TSB Scotland plc are regulated by the Financial Services Authority and represent only the Scottish Widows and Lloyds TSB Marketing Group for life assurance, pensions and investment business. Signatories to the Banking Codes. --- Money is not the root of all evil - full backups are.