ADMS-L - DB2 backup
Currently we are backing up daily, DB2 using TSM 6 DB2 API client LAN-Free to our TM 6 server/Virtual tape library. Once a week I need to do a DB2 backup with a different retention. I am looking for options to this solution. Here are some I have come up with, I am looking for other options. * Copy dsm.sys file to dsm.sys.weekly. In the weekly file create a new node_name with the new retention. Weekly cp dsm.sys.weekly to dsm.sys. This way the database doesn't need to be stopped to read in a new dsm.opt file. Can you have 1 stg agent servicing 2 different TSM nodes on the same physical server? Or would you need to create 2 different stg agents? * Weekly modify existing TSM stgpool (autocopy=client, copystgpool=weeklystgpool) perform the backup. The copystgpool could be a VTL which could later be copied to physical tape or physical tape - writing directly would be an issue since we have fewer physical drives then virtual. Will the backupstgpool use multiple streams to copy data from the primary pool to the copystgpool if the DB2 backup is viewed by q occ in TSM as 1 filesystem (multiple streams are used to backup this environment to TSM)? * Clone on storage array - requires offsite array for CLONE. Thanks
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 http
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
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)
TSM database backup versus db2 backup of TSM database
All, One can make TSM database backups within the TSM application (ba db dev=devclass t=f), since version 6 one can make also a db2 backup of it (db2 backup db tsminst1 online use tsm). Does anybody knows if there are advantages of making db2 backups compared to TSM database backups? Kind Regards, Ruud Meuleman ** This transmission is confidential and must not be used or disclosed by anyone other than the intended recipient. Neither Tata Steel Europe Limited nor any of its subsidiaries can accept any responsibility for any use or misuse of the transmission by anyone. For address and company registration details of certain entities within the Tata Steel Europe group of companies, please visit http://www.tatasteeleurope.com/entities **
Re: TSM database backup versus db2 backup of TSM database
Ruud Not sure on advantaged, but the only supported way of getting a V6.x TSM instance back from a DB backup is one done with ba db... Steven On 6 November 2012 14:11, Meuleman, Ruud ruud.meule...@tatasteel.comwrote: All, One can make TSM database backups within the TSM application (ba db dev=devclass t=f), since version 6 one can make also a db2 backup of it (db2 backup db tsminst1 online use tsm). Does anybody knows if there are advantages of making db2 backups compared to TSM database backups? Kind Regards, Ruud Meuleman ** This transmission is confidential and must not be used or disclosed by anyone other than the intended recipient. Neither Tata Steel Europe Limited nor any of its subsidiaries can accept any responsibility for any use or misuse of the transmission by anyone. For address and company registration details of certain entities within the Tata Steel Europe group of companies, please visit http://www.tatasteeleurope.com/entities **
Re: TSM database backup versus db2 backup of TSM database
Ruud, Under the hood 'ba db ' does perform a 'db2 backup db ...', but with added features like being able to restore the TSM database while TSM is unavailable because the database needs to be restored. I can think of no good reason to not use the supported and perfectly functional 'backup db' from TSM. On 6 nov. 2012, at 15:11, Meuleman, Ruud ruud.meule...@tatasteel.com wrote: All, One can make TSM database backups within the TSM application (ba db dev=devclass t=f), since version 6 one can make also a db2 backup of it (db2 backup db tsminst1 online use tsm). Does anybody knows if there are advantages of making db2 backups compared to TSM database backups? Kind Regards, Ruud Meuleman -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622
Re: Deleted DB2 backup still in TSM
Perhaps it's a timing issue. For DB2 you have to issue db2adutl delete older than x days without prompting otherwise DB2 will keep backups forever. In TSM you run expire inventory. Both are necessary to remove all pieces of the db2 backup. Perhaps for this database you run the DB2 command AFTER the TSM one. This would allow a not so short period of time where you are able to display these expire immediate objects. Date:Sun, 7 Oct 2007 12:36:01 -0400 From:Daad Ali [EMAIL PROTECTED] Subject: Re: Deleted DB2 backup still in TSM Thanks Richard, =20 Yes, I am running expire inventory daily. And I don't see anything in t= he activity log that would indicate that the expiration is not working. =20 DESCRIPTION: Daily Script to run Expiration process to remove expired d= ata COMMAND: expire inventory wait=3Dno PRIORITY: 5 STARTDATE: 2003-01-18 STARTTIME: 23:00:00 DURATION: 1 DURUNITS: HOURS PERIOD: 1 PERUNITS: DAYS DAYOFWEEK: ANY EXPIRATION: ACTIVE: YES CHG_TIME: 2003-07-25 08:43:52.00 CHG_ADMIN: BBROWN PROFILE: SCHED_STYLE: CLASSIC ENH_MONTH: DAYOFMONTH: WEEKOFMONTH: Richard Sims [EMAIL PROTECTED] wrote: On Oct 6, 2007, at 7:30 AM, Daad Ali wrote: ... 1- Is there a way of restoring these database backups? If it's expired, it's beyond your retrieval capability: the only recourse is to restore your TSM system to some time in the past, which is unpalatable, if even possible to the point you may need. 2- Since they are deleted from the client , how do I remove it from showing up in TSM. Are you running Expire Inventory regularly, and allowing it to run to completion? I would expect that operation to remove the entries from the database. If not, see if any issues reflected in your Activity Log. Richard Sims
Re: Deleted DB2 backup still in TSM
Thanks Ken, I will get my DBA to run this. Ken Chamberlain [EMAIL PROTECTED] wrote: Perhaps it's a timing issue. For DB2 you have to issue db2adutl delete older than x days without prompting otherwise DB2 will keep backups forever. In TSM you run expire inventory. Both are necessary to remove all pieces of the db2 backup. Perhaps for this database you run the DB2 command AFTER the TSM one. This would allow a not so short period of time where you are able to display these expire immediate objects. Date: Sun, 7 Oct 2007 12:36:01 -0400 From: Daad Ali Subject: Re: Deleted DB2 backup still in TSM Thanks Richard, =20 Yes, I am running expire inventory daily. And I don't see anything in t= he activity log that would indicate that the expiration is not working. =20 DESCRIPTION: Daily Script to run Expiration process to remove expired d= ata COMMAND: expire inventory wait=3Dno PRIORITY: 5 STARTDATE: 2003-01-18 STARTTIME: 23:00:00 DURATION: 1 DURUNITS: HOURS PERIOD: 1 PERUNITS: DAYS DAYOFWEEK: ANY EXPIRATION: ACTIVE: YES CHG_TIME: 2003-07-25 08:43:52.00 CHG_ADMIN: BBROWN PROFILE: SCHED_STYLE: CLASSIC ENH_MONTH: DAYOFMONTH: WEEKOFMONTH: Richard Sims wrote: On Oct 6, 2007, at 7:30 AM, Daad Ali wrote: ... 1- Is there a way of restoring these database backups? If it's expired, it's beyond your retrieval capability: the only recourse is to restore your TSM system to some time in the past, which is unpalatable, if even possible to the point you may need. 2- Since they are deleted from the client , how do I remove it from showing up in TSM. Are you running Expire Inventory regularly, and allowing it to run to completion? I would expect that operation to remove the entries from the database. If not, see if any issues reflected in your Activity Log. Richard Sims - Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail
Re: Deleted DB2 backup still in TSM
Thanks Richard, Yes, I am running expire inventory daily. And I don't see anything in the activity log that would indicate that the expiration is not working. DESCRIPTION: Daily Script to run Expiration process to remove expired data COMMAND: expire inventory wait=no PRIORITY: 5 STARTDATE: 2003-01-18 STARTTIME: 23:00:00 DURATION: 1 DURUNITS: HOURS PERIOD: 1 PERUNITS: DAYS DAYOFWEEK: ANY EXPIRATION: ACTIVE: YES CHG_TIME: 2003-07-25 08:43:52.00 CHG_ADMIN: BBROWN PROFILE: SCHED_STYLE: CLASSIC ENH_MONTH: DAYOFMONTH: WEEKOFMONTH: Richard Sims [EMAIL PROTECTED] wrote: On Oct 6, 2007, at 7:30 AM, Daad Ali wrote: ... 1- Is there a way of restoring these database backups? If it's expired, it's beyond your retrieval capability: the only recourse is to restore your TSM system to some time in the past, which is unpalatable, if even possible to the point you may need. 2- Since they are deleted from the client , how do I remove it from showing up in TSM. Are you running Expire Inventory regularly, and allowing it to run to completion? I would expect that operation to remove the entries from the database. If not, see if any issues reflected in your Activity Log. Richard Sims - Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail
Deleted DB2 backup still in TSM
Hello TSMers, When I run the command show version intelsrv30db2 * in TSM. I get the following output. /SESSNA : \NODE\ FULL_BACKUP.20060128210004.1 (MC: DEFAULT) Inactive, Inserted 01/28/06 21:00:04, Deactivated ** EXPIRE IMMEDIATELY ** ObjId: 0.2643630069, GroupMap , objType 0x02 / SESSNA: \NODE\ FULL_BACKUP.20060129210009.1 (MC: DEFAULT) Inactive, Inserted 01/29/06 21:00:09, Deactivated ** EXPIRE IMMEDIATELY ** ObjId: 0.2648650369, GroupMap , objType 0x02 you noticed that both backups are inactive and expired immediately. My questions are: 1- Is there a way of restoring these database backups? 2- Since they are deleted from the client , how do I remove it from showing up in TSM. TSM Server 5.4.1 Platform: DB2/NT Client OS Level: 5.02 Client Version: Version 5, Release 3, Level 5.0 Thanks as always, Daad - All new Yahoo! Mail - - Get a sneak peak at messages with a handy reading pane.
Re: Deleted DB2 backup still in TSM
On Oct 6, 2007, at 7:30 AM, Daad Ali wrote: ... 1- Is there a way of restoring these database backups? If it's expired, it's beyond your retrieval capability: the only recourse is to restore your TSM system to some time in the past, which is unpalatable, if even possible to the point you may need. 2- Since they are deleted from the client , how do I remove it from showing up in TSM. Are you running Expire Inventory regularly, and allowing it to run to completion? I would expect that operation to remove the entries from the database. If not, see if any issues reflected in your Activity Log. Richard Sims
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.
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 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.
Help required with TSM DB2 backup
Hi all, When I enter the following command I get an error message :- C:\db2adutl query logs db icmnlsdb Query for database ICMNLSDB Retrieving LOG ARCHIVE information. Error: Unable to increase the fileIdentList structure to 396242000 bytes. What does the error mean ? and how do I fix it ! Thanks TSM server for Windows V5.3.4 Bill ** This electronic mail message, including any attachments, is a confidential communication exclusively between Babcock International Group PLC or its subsidiary company and the intended recipient(s) indicated as the addressee(s). It contains information which is private and may be proprietary or covered by legal professional privilege. If you receive this message in any form and you are not the intended recipient you must not review, use, disclose or disseminate it. We would be grateful if you could contact the sender upon receipt and in any event you should destroy this message without delay. Anything contained in this message that is not connected with the business of Babcock International Group PLC is neither endorsed by nor is the liability of this company. Babcock International Group PLC Company number 2342138 Registered in England 2 Cavendish Square London W1G 0PX Telephone: +44(0)20 7291 5000 Fax: +44(0)20 7291 5055 Website: www.babcock.co.uk **
Help required with TSM DB2 backup - UPDATE
Hi all, When I enter the following command I get an error message :- C:\db2adutl query logs db icmnlsdb Query for database ICMNLSDB Retrieving LOG ARCHIVE information. Error: Unable to increase the fileIdentList structure to 396242000 bytes. What does the error mean ? and how do I fix it ! Thanks Bill UPDATE:- I am able to get information directly from the TSM server :- SELECT * FROM ARCHIVES WHERE NODE_NAME='SECCM_DB2' C:\SEC.TXT I cannot delete logs from the client which is what I am after :- :\db2adutl delete logs between S0039219.log and S0039220.log DB ICMNLSD2 witho ut prompting Query for database ICMNLSD2 Retrieving LOG ARCHIVE information. No LOG ARCHIVE images found for ICMNLSD2 Can I delete them directlty from the TSM server and how ? Thanks Bill ** This electronic mail message, including any attachments, is a confidential communication exclusively between Babcock International Group PLC or its subsidiary company and the intended recipient(s) indicated as the addressee(s). It contains information which is private and may be proprietary or covered by legal professional privilege. If you receive this message in any form and you are not the intended recipient you must not review, use, disclose or disseminate it. We would be grateful if you could contact the sender upon receipt and in any event you should destroy this message without delay. Anything contained in this message that is not connected with the business of Babcock International Group PLC is neither endorsed by nor is the liability of this company. Babcock International Group PLC Company number 2342138 Registered in England 2 Cavendish Square London W1G 0PX Telephone: +44(0)20 7291 5000 Fax: +44(0)20 7291 5055 Website: www.babcock.co.uk **
TSM DB2 backup problems
TSM Server 5.2.7.2 on Solaris 2.9 - TSM Client API 5.3.4.0 on Windows 2003 Hi all, and a merry xmas/new year etc :-) I am wondering if anyone can point me in the direction of error code meanings for our DB2 backups. The errors we are getting look as follows :- The task ADMINISTRATOR.Backup_RMDB_Full with status Not successful ran on the DB2 Administrative Server on server name here and completed with return code -1371. The task started on server name here at 2006-12-27 23:00:19.0 and completed at 2006-12-27 23:00:30.0. The task lasted 11 seconds. I know nothing about DB2 and no one else here seems to either (very helpful), so I really want to find out what the code -1371 means. If I have to put in a call with TSM then so be it, but I would rather see what I can find out myself first. If anyone can help then I'd be very grateful. Many thanks Farren Minns John Wiley Sons Ltd -- 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: TSM DB2 backup problems
Farren, The return codes from a DB2 backup are those from the TSM API as the backup is done across the API. However the return code -1371 is not listed in there. Take a manual backup from the CLI, it looks to be a DOS prompt in your case: db2 backup db DB_ALIAS online use tsm include logs and see what output you get here. I've got no idea how to interprete the task from the DB2 administrative server since we don't use it. best regards, Kurt -Original Message- From: ADSM: Dist Stor Manager on behalf of Farren Minns Sent: Thu 12/28/2006 9:52 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM DB2 backup problems TSM Server 5.2.7.2 on Solaris 2.9 - TSM Client API 5.3.4.0 on Windows 2003 Hi all, and a merry xmas/new year etc :-) I am wondering if anyone can point me in the direction of error code meanings for our DB2 backups. The errors we are getting look as follows :- The task ADMINISTRATOR.Backup_RMDB_Full with status Not successful ran on the DB2 Administrative Server on server name here and completed with return code -1371. The task started on server name here at 2006-12-27 23:00:19.0 and completed at 2006-12-27 23:00:30.0. The task lasted 11 seconds. I know nothing about DB2 and no one else here seems to either (very helpful), so I really want to find out what the code -1371 means. If I have to put in a call with TSM then so be it, but I would rather see what I can find out myself first. If anyone can help then I'd be very grateful. Many thanks Farren Minns John Wiley Sons Ltd -- 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. -- *** Disclaimer *** Vlaamse Radio- en Televisieomroep Auguste Reyerslaan 52, 1043 Brussel nv van publiek recht BTW BE 0244.142.664 RPR Brussel http://www.vrt.be/disclaimer
Re: TSM DB2 backup problems
Hi Well I have just been doing some work with the sys admin for the server in question and it looks like there was a server related issue on the 19th (no idea what) and for some reason all but one of the dbs was still in a quiesced state. Very odd and slightly worrying but TSM is not at fault here and the backups are working again now. Many thanks Farren -- 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: TSM DB2 backup problems
On Dec 28, 2006, at 3:52 AM, Farren Minns wrote: TSM Server 5.2.7.2 on Solaris 2.9 - TSM Client API 5.3.4.0 on Windows 2003 Hi all, and a merry xmas/new year etc :-) I am wondering if anyone can point me in the direction of error code meanings for our DB2 backups. The errors we are getting look as follows :- The task ADMINISTRATOR.Backup_RMDB_Full with status Not successful ran on the DB2 Administrative Server on server name here and completed with return code -1371. The task started on server name here at 2006-12-27 23:00:19.0 and completed at 2006-12-27 23:00:30.0. The task lasted 11 seconds. Hi, Farren - In DB2 backup cases where the backup has not gotten as far as using TSM, and the message is from DB2 itself, talking of a DB2-specific issue, I believe that the negative return code value is the SQLCODE value from the DB2 Administrative API, and the number itself has a corresponding DB2 message. So, in this case, -1371 would correspond to message SQL1371N, which can be looked in in the DB2 references (and talks of an attempt to quiesce an instance or database which is already quiesced). Aren't cryptic messages fun? What else would we do with our valuable time? Richard Sims
Re: TSM DB2 backup problems
Thanks Richard, that's a great help. And you are right, we work between xmas and new year to troubleshoot with obscure codes! :-) Fun indeed. Regards Farren -- 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. --
DB2 backup - connection unstable ?
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: 01/24/06 12:57:21 ANR0406I Session 196229 started for node NODENAME (DB2) (Tcp/Ip ww.xx.yy.zz(19643)). (SESSION: 196229) 01/24/06 12:57:21 ANR0480W Session 196229 for node NODENAME_FRISKDB 2_DB2 (DB2) terminated - connection with client severed. (SESSION: 196229) 01/24/06 12:57:34 ANR0406I Session 196234 started for node NODENAME (DB2) (Tcp/Ip ww.xx.yy.zz(19645)). (SESSION: 196234) 01/24/06 12:57:34 ANR0480W Session 196234 for node NODENAME_FRISKDB 2_DB2 (DB2) terminated - connection with client severed. (SESSION: 196234) 01/24/06 12:57:46 ANR0406I Session 196236 started for node NODENAME (DB2) (Tcp/Ip ww.xx.yy.zz(19646)). (SESSION: 196236) 01/24/06 12:57:47 ANR0480W Session 196236 for node NODENAME_FRISKDB 2_DB2 (DB2) terminated - connection with client severed. (SESSION: 196236) 01/24/06 12:57:59 ANR0406I Session 196238 started for node NODENAME (DB2) (Tcp/Ip ww.xx.yy.zz(19649)). (SESSION: 196238) 01/24/06 12:58:00 ANR0480W Session 196238 for node NODENAME_FRISKDB 2_DB2 (DB2) terminated - connection with client severed. (SESSION: 196238) 01/24/06 12:58:12 ANR0406I Session 196240 started for node NODENAME (DB2) (Tcp/Ip ww.xx.yy.zz(19653)). (SESSION: 196240) 01/24/06 12:58:12 ANR0480W Session 196240 for node NODENAME_FRISKDB 2_DB2 (DB2) terminated - connection with client severed. (SESSION: 196240) What could be the cause of this ?? The DB2 is the only node having this problem - all other nodes runs without problems... Regards, /Brian
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. ***
DB2 Backup offline on Winnt
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
Re: checkout DB2 backup [Virus checked]
Well, if you problem is just getting them out of the 3484, all you have to do is mark them as OFFSITE and run the CHECKOUT command. Keeping track of them is another matter entirely. If this is something you plan to do regularly, look at a product called Autovault at www.coderelief.com. We use it here for vaulting with TSM. You would put your future DB2 backups into a DIFFERENT tape storage pool, and tell Autovault to manage the vaulting of that storage pool. DRM will do similar for copy pools, but not primary pools. -Original Message- From: Frank Mueller [mailto:[EMAIL PROTECTED] Sent: Monday, April 19, 2004 9:14 AM To: [EMAIL PROTECTED] Subject: checkout DB2 backup [Virus checked] Hi *, we want to check out a DB2-backup. We backup our DB2-DB over the DB2-api in the TSM. The data are stored in a 3494 library. Now we want to move the tapes in a other location (out of the library, for example a safe). What is the best way to move the data out of the library??? Best regards, Frank
checkout DB2 backup [Virus checked]
Hi *, we want to check out a DB2-backup. We backup our DB2-DB over the DB2-api in the TSM. The data are stored in a 3494 library. Now we want to move the tapes in a other location (out of the library, for example a safe). What is the best way to move the data out of the library??? Best regards, Frank
Re: checkout DB2 backup [Virus checked]
Hi Frank , Copy them to the copy storage pool and run move drmedia. Frank Mueller [EMAIL PROTECTED] Sent by: ADSM: Dist Stor To Manager[EMAIL PROTECTED] [EMAIL PROTECTED] cc Subject 19.04.2004 16:14checkout DB2 backup [Virus checked] Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] Hi *, we want to check out a DB2-backup. We backup our DB2-DB over the DB2-api in the TSM. The data are stored in a 3494 library. Now we want to move the tapes in a other location (out of the library, for example a safe). What is the best way to move the data out of the library??? Best regards, Frank inline: C6507223.gifinline: graycol.gifinline: pic28145.gifinline: ecblank.gif
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 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.
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
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] ___
micrsoft cluster and db2 backup problems
Hello, our environment: tsm server 5.1.1.6 tsm client 5.1.5.9 db2 version 7 , fixpack 8 api 5.1.5.9 we have some problems with implementing db2 on ms cluster in case of failover. First, we do not have only failover cluster, both cluster nodes have production db2 db's, some are cluster ressources, some not. Because DB2 only recognize start parameters like DSMI_CONFIG, DSMI_DIR and DSMI_LOG on start time, we could not implement for example dsm.opt on the shared cluster ressources, we had to implement dsm.opt local on both cluster nodes. (only one node has control of a shared cluster group (disks) in ms cluster) Normally on cluster ressources both dsm.opt files have to be equal, but this means in our especially environment, that 2 physical different nodes (ms cluster node 1 and 2) backup their db2 db's under one tsm node. Now my question: are there any restrictions to backup data (perhaps on the same time (e.g. logfiles) under one tsm node from 2 physical different servers? I think, that there could be a lot of confusion in tsm. Please let me know, if you have experiences or recommendations for me. Our workaround today is, to backup db2 data with two different tsm nodes (dsm.opt different on both cluster nodes), but this is making problems in case of failover. Then you have backups with the wrong TSM Nodename and confusion will be after switching to normal working mode, some logs and db backups under the wrong nodename makes restore and replication complicated. with best regards Stefan Savoric [EMAIL PROTECTED]
LAN-free DB2 backup : low performance
Hi everybody. I'm having a problem running a DB2 LAN-free backup : normally it takes 40 minutes to save about 65 GB, but sometimes it takes more than 1 hour. My TSM server is 4.2.1.11 (Win2K), my storage agent is 4.2.1.11 (AIX 4.3.3. ML9). The funny thing is that the problem disappears when I restart the TSM server. Could anyone suggest me a way to solve this problem ? TIA, Davide Giacomazzi System Engineer Gruppo Assicurativo Arca - Verona - Italy
DB2 backup problem
Hi guys and girls, we are running weekly offline backups of a DB2 database ver 7.1.0.65 EEE on AIX. The server is a NSM at 4.1.6.0 and the clients at 3.7.2.0. The last backup failed on one of the nodes showing lots of these entries in the dsmerror.log: sessInit: Starting communications initialization 01/19/03 17:59:29 sessInit: Transitioning: sInit state === sTRANSERR state Can someone explain to me what this means? I searched this list and found this question being asked a couple of times but there was never an answer to it. 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?? Thanks Lars
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
DB2 backup on AIX
Hi all, one of our customers wants to backup DB2 database on AIX system. I didn't find any TSM or TDP product to use it for online backup of DB2, but I want to be sure. Is any way to do it (except of file backup of stoped databse using basic AIX TSM client)? Do anybody have any experience with backup this stuff on AIX? Many thanks Tomas Hrouda
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
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: Tomás Hrouda [mailto:[EMAIL PROTECTED]] Inviato: mercoledì 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
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
DB2 backup problem
Hi guys and girls, hope there is some kind of DB2 guru reading in this list. When doing a DB2 backup we are getting the following messages in the appropriate DB2 diag log: 2002-12-08-18.00.35.226529 Instance:db2minst Node:001 PID:90534(db2agent (DB2MPROD) 1) Appid:C0A80196.046F.021207182454 base_sys_utilities sqleflsr Probe:3 Database:DB2MPROD DiagData 0150 ...P 2002-12-08-18.00.35.260127 Instance:db2minst Node:001 PID:90534(db2agent (DB2MPROD) 1) Appid:C0A80196.046F.021207182454 base_sys_utilities sqleflsr Probe:3 Database:DB2MPROD RIDS/sqleflsr MS/ABNOR_TERRM PRCS/3 0150 ...P 2002-12-08-18.00.35.270169 Instance:db2minst Node:001 PID:90534(db2agent (DB2MPROD) 1) Appid:C0A80196.046F.021207182454 base_sys_utilities sqleflsr Probe:4 Database:DB2MPROD DiagData 5351 4c43 4120 2020 0088 fb38 SQLCA ÿÿû8 2020 2020 2020 2020 2020 2020 2020 .. 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 5351 4c45 4941 4754 SQLEIAGT 0001 2020 2020 2020 2020 2020 2020 2020 2020 2002-12-08-18.00.35.293557 Instance:db2minst Node:001 PID:90534(db2agent (DB2MPROD) 1) Appid:C0A80196.046F.021207182454 base_sys_utilities sqleflsr Probe:4 Database:DB2MPROD RIDS/sqleflsr MS/ABNOR_TERRM PRCS/45351 4c43 4120 2020 0088 fb38 SQLCA ÿÿû8 2020 2020 2020 2020 2020 2020 2020 .. 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 5351 4c45 4941 4754 SQLEIAGT 0001 2020 2020 2020 2020 2020 2020 2020 2020 2002-12-08-18.00.51.894542 Instance:db2minst Node:001 PID:26964(db2agent (DB2MPROD) 1) Appid: base_sys_utilities sqleMergeSqlca Probe:20 Database:DB2MPROD Received sqlcode 1496 for request 801e from node number 2 Data Title:SQLCA PID:26964 Node:001 sqlcaid : SQLCA sqlcabc: 136 sqlcode: 1496 sqlerrml: 0 sqlerrmc: sqlerrp : SQLESRSU sqlerrd : (1) 0x (2) 0x (3) 0x (4) 0x (5) 0x (6) 0x0002 sqlwarn : (1) (2) (3) (4)(5) (6) (7) (8) (9) (10) (11) sqlstate: 2002-12-08-18.00.55.880949 Instance:db2minst Node:001 PID:102342(db2spmrm 1) Appid:none oper_system_services sqloopenp Probe:36 errno: 0011 2002-12-08-18.01.15.702362 Instance:db2minst Node:001 PID:95324(db2bp) Appid:*N1.db2minst.021208170115 database_utilities sqlubckp Probe:26 DiagData fbf5 ÿÿûõ 2002-12-08-18.01.18.341954 Instance:db2minst Node:002 PID:55850(db2bp) Appid:*N2.db2minst.021208170118 database_utilities sqlubckp Probe:26 DiagData fbf5 ÿÿûõ The database is running on AIX 4.3.3 and is backed up up offline after stopping it with a db2stop force and starting it with db2start. Your help is very much appreciated Cya Lars
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
DB2 Backup using different node names
I want to backup DB2 trough ADSM. I have defined 2 different nodes, and I want to backup a DB2 database using both of them. I have defined 2 different option files for each of them, and I also have defined the DSMI_LOG, DSMI_CONFIG and DSMI_DIR environment variables. But when I launch the backup with either of the nodes ADSM only takes one of them, skiping any definition for the second node. Does anyone know what could be happening here? Thanks in advance. ___ Yahoo! Messenger Nueva versisn: Webcam, voz, y mucho mas !Gratis! Descargalo ya desde http://messenger.yahoo.es
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
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
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: (Silly?) DB2 Backup question
Hi Bill, Yes you will be able to restore the database from online backup but before online db restore you must restore db logs that have been active during online backup into log_dir directory and after restore you must rollforward db to end of logs .for successful restore you need only logs than have been active during online backup if you want point in time recovery than you need all logs that you have taken after backup Main difference between online backup restore and offline backup restore is that you dont need logs during offline restore.DB2 specialist recommendet at least one offline backup per week. Bill Boyer bill.boyer@VERI To: [EMAIL PROTECTED] ZON.NET cc: Sent by: ADSM: Subject: Re: (Silly?) DB2 Backup question Dist Stor Manager [EMAIL PROTECTED] T.EDU 20.09.2002 21:18 Please respond to ADSM: Dist Stor Manager There is a redbook, Backing up DB2 Using TSM SG24-6247 that has sample scripts for different full/log backup retention using the DB2ADUTL utility. I have this running using only ONLINE backups plus the DB2 user exit supplied by TSM for transaction log archiving. My biggest question has been if I only take ONLINE backups with the LOGS will I be able to restore the database, or do I need to do occassional OFFLINE backups to be able to recover? I also believe that the ONLINE backup does backup the log records that have occurred during the backup.I remember reading something about this somewhere, but I can't find it again. So I won't say I'm 100% sure about this. I do know that after an ONLINE backup the DB2ADUTL shows me with additional LOG backups, too. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Levinson, Donald A. Sent: Friday, September 20, 2002 1:40 PM To: [EMAIL PROTECTED] Subject: Re: (Silly?) DB2 Backup question Log files are absolutely required if you are performing online backups. A. the database has to be in logretain mode to allow an online backup B. all transactions that occur during an online backup only go to log and won't be captured in the backup AFAIK. Otherwise logfile archiving is only necessary if you are interested in recovering the data that was committed after the last backup, if it is acceptable to lose all the data that is entered between backups then there is no need to archive log files. The practice I use is to perform offline backups every night (my outage window allows this) and log archives whenever a log is released, the log archives have a 30 day retention. Or you could hack together a script to backup the released logs and then delete them after the next successful offline DB2 backup so that TSM marks them as deleted. -Original Message- From: Lars Bebensee [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 2:18 AM To: [EMAIL PROTECTED] Subject: (Silly?) DB2 Backup question Hi guys and girls, this question is one of the general sort, so forgive me if it has been answered here or in some manual I haven't red yet. Probably, I just need a simpler description. AFAIK, there are three ways to backup a database: 1. Offline filesystem backup 2. Offline backup in the databases quiesced mode via some api 3. Online backup via api The first question I have is about the transaction log archiving. With which of the above does it make sense and why? The second one: does it make sense to run offline AND online backups in a backup cylce, or will one of them be save enough? I read through the TSM Redbook on DB2 UDB implementation. It just explains the ways RDBMS backups can be done not which combinations are useful. As far as I could extract, it is rather useless doing offline backups and log file archiving but no online backups, right?? Thanks in advance Lars This transmittal may contain confidential information intended solely for the addressee. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (collect at 907-564-1000) and ask to speak with the message sender. In addition, please immediately delete this message and all attachments. Thank you.
(Silly?) DB2 Backup question
Hi guys and girls, this question is one of the general sort, so forgive me if it has been answered here or in some manual I haven't red yet. Probably, I just need a simpler description. AFAIK, there are three ways to backup a database: 1. Offline filesystem backup 2. Offline backup in the databases quiesced mode via some api 3. Online backup via api The first question I have is about the transaction log archiving. With which of the above does it make sense and why? The second one: does it make sense to run offline AND online backups in a backup cylce, or will one of them be save enough? I read through the TSM Redbook on DB2 UDB implementation. It just explains the ways RDBMS backups can be done not which combinations are useful. As far as I could extract, it is rather useless doing offline backups and log file archiving but no online backups, right?? Thanks in advance Lars
Re: (Silly?) DB2 Backup question
Log files are absolutely required if you are performing online backups. A. the database has to be in logretain mode to allow an online backup B. all transactions that occur during an online backup only go to log and won't be captured in the backup AFAIK. Otherwise logfile archiving is only necessary if you are interested in recovering the data that was committed after the last backup, if it is acceptable to lose all the data that is entered between backups then there is no need to archive log files. The practice I use is to perform offline backups every night (my outage window allows this) and log archives whenever a log is released, the log archives have a 30 day retention. Or you could hack together a script to backup the released logs and then delete them after the next successful offline DB2 backup so that TSM marks them as deleted. -Original Message- From: Lars Bebensee [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 2:18 AM To: [EMAIL PROTECTED] Subject: (Silly?) DB2 Backup question Hi guys and girls, this question is one of the general sort, so forgive me if it has been answered here or in some manual I haven't red yet. Probably, I just need a simpler description. AFAIK, there are three ways to backup a database: 1. Offline filesystem backup 2. Offline backup in the databases quiesced mode via some api 3. Online backup via api The first question I have is about the transaction log archiving. With which of the above does it make sense and why? The second one: does it make sense to run offline AND online backups in a backup cylce, or will one of them be save enough? I read through the TSM Redbook on DB2 UDB implementation. It just explains the ways RDBMS backups can be done not which combinations are useful. As far as I could extract, it is rather useless doing offline backups and log file archiving but no online backups, right?? Thanks in advance Lars This transmittal may contain confidential information intended solely for the addressee. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (collect at 907-564-1000) and ask to speak with the message sender. In addition, please immediately delete this message and all attachments. Thank you.
Re: (Silly?) DB2 Backup question
There is a redbook, Backing up DB2 Using TSM SG24-6247 that has sample scripts for different full/log backup retention using the DB2ADUTL utility. I have this running using only ONLINE backups plus the DB2 user exit supplied by TSM for transaction log archiving. My biggest question has been if I only take ONLINE backups with the LOGS will I be able to restore the database, or do I need to do occassional OFFLINE backups to be able to recover? I also believe that the ONLINE backup does backup the log records that have occurred during the backup.I remember reading something about this somewhere, but I can't find it again. So I won't say I'm 100% sure about this. I do know that after an ONLINE backup the DB2ADUTL shows me with additional LOG backups, too. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Levinson, Donald A. Sent: Friday, September 20, 2002 1:40 PM To: [EMAIL PROTECTED] Subject: Re: (Silly?) DB2 Backup question Log files are absolutely required if you are performing online backups. A. the database has to be in logretain mode to allow an online backup B. all transactions that occur during an online backup only go to log and won't be captured in the backup AFAIK. Otherwise logfile archiving is only necessary if you are interested in recovering the data that was committed after the last backup, if it is acceptable to lose all the data that is entered between backups then there is no need to archive log files. The practice I use is to perform offline backups every night (my outage window allows this) and log archives whenever a log is released, the log archives have a 30 day retention. Or you could hack together a script to backup the released logs and then delete them after the next successful offline DB2 backup so that TSM marks them as deleted. -Original Message- From: Lars Bebensee [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 2:18 AM To: [EMAIL PROTECTED] Subject: (Silly?) DB2 Backup question Hi guys and girls, this question is one of the general sort, so forgive me if it has been answered here or in some manual I haven't red yet. Probably, I just need a simpler description. AFAIK, there are three ways to backup a database: 1. Offline filesystem backup 2. Offline backup in the databases quiesced mode via some api 3. Online backup via api The first question I have is about the transaction log archiving. With which of the above does it make sense and why? The second one: does it make sense to run offline AND online backups in a backup cylce, or will one of them be save enough? I read through the TSM Redbook on DB2 UDB implementation. It just explains the ways RDBMS backups can be done not which combinations are useful. As far as I could extract, it is rather useless doing offline backups and log file archiving but no online backups, right?? Thanks in advance Lars This transmittal may contain confidential information intended solely for the addressee. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (collect at 907-564-1000) and ask to speak with the message sender. In addition, please immediately delete this message and all attachments. Thank you.
DB2 backup problem..
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)
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.
DB2 backup problem
More info: In USEREXIT.ERR: Time of Error: Thu May 30 17:35:48 2002 Parameter Count: 9 Parameters Passed: ADSM password: fastdb Database name: DS50 Logfile name: S024.LOG Logfile path: /db2/db201/DS50/db2udb/NODE/SQL1/SQLOGDIR/ Node number: NODE Operating system: Solaris Release: SQL07020 Request: ARCHIVE Audit Log File:/opt/db2udb/sqllib/db2dump/ARCHIVE.LOG System Call Parms: Media Type:ADSM User Exit RC: 16 Error isolation: dsmEndTxn() returned 2302 Reason 11 According to TSM Messages 2302 means: 2302 I DSM_RC_CHECK_REASON_CODE Explanation: After a dsmEndTxn call, the transaction is aborted by either the server or client with a DSM_VOTE_ABORT and the reason is returned. System Action: The system returns to the calling procedure. User Response: Check the reason field for the code which explains why the transaction has been aborted. Ok not very useful info.. Reason 11 means what exactly? Regards, Gerald Wichmann Senior Systems Development Engineer Zantaz, Inc. 925.598.3099 (w)
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
DB2 backup RC=157
*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. ---
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.
Compression with DB2 Backup and TDP for Informix
Hi all, we are using TSM Server 3.7.5 on OS/390 We have Clients on Solaris 2.6/7 with the Backup Client V3.7.2 and TDP for Informix V4.1.2.0 We have even Clients on Win 2000 with the Backup Client V3.1.8 and DB2 V7.1 using the DB2 BACKUP Command with the Option USE TSM In the Option Files we set COMPRESSION to ON, but when using the TDP or Db2 Agent, the size of the data on the client is the same as the size of the data transferred to the server. So I guess the data is uncompressed because other tools can compress these databases. (I don't get any statistics about the compression) Am I missing something to really compress the data ? Regards Gerhard Wolkerstorfer
How to extract a db2-backup 64Gb
Hi, To restore our db2-db to another RS6000 (without TSM) I want to extract a DB2/TSM backup file from TSM to a filesystem, compress it, send to the other machine and restore it. With a backup to disk that works ok, because the db2 backup command splits up the file in parts of 64GB (an AIX-limit) but the db2adutl extract command tries to write beyoud the 64Gb-limit and then fails with the message 'File write failed'. Does anybody know how to handle this? DB2 v6.1 (FP8) TSM v4.1 AIX 4.3.3 Thanks Bert
AIX DB2 backup problem with 4.2.0 client
My AIX person wanted me to pass on the following error messages. We started getting these when we upgraded the client to 4.2.0 from 4.1.3 (this was done to resolve some other issue. Not sure what !). Any one see this one or have a clue what to do ? Did not see anything in the readme's about an xlC issue ? *** Client environment: AIX 4.3.3 TSM 4.2.0 DB2 5.2.0.50 xlC.aix43.rte 4.0.2.1 In db2diag.log: 2001-09-02-07.00.25.338591 Instance:db2padm Node:000 PID:36380(db2med.54700.0) Appid:none database_utilitiessqluMCInitBackupMC Probe:385 Media Controller -- sqluInitVendorDevice() ! vendor device initialization error 2001-09-02-07.00.25.449152 Instance:db2padm Node:000 PID:54700(db2agent (DB2PDWAR)) Appid:*LOCAL.db2padm.010902110017 database_utilitiessqlubMWResponse Probe:10 Database:DB2PDWAR DiagData f7e9 ÿÿ÷é 2001-09-02-07.00.28.081967 Instance:db2padm Node:000 PID:54700(db2agent (DB2PDWAR)) Appid:*LOCAL.db2padm.010902110017 database_utilitiessqlubcka Probe:0 Database:DB2PDWAR Backup terminated. $ db2adutl exec(): 0509-036 Cannot load program db2adutl because of the following errors: 0509-022 Cannot load module /usr/lib/libApiDS.a(dsmapish.o). 0509-150 Dependent module /usr/lpp/db2_05_00/.rtelib/libC.a(shr2.o) could not be loaded. 0509-152 Member shr2.o is not found in archive === Zoltan Forray Virginia Commonwealth University University Computing Center e-mail: [EMAIL PROTECTED] voice: 804-828-4807
Re: AIX DB2 backup problem with 4.2.0 client
Hi, I am not sure if TSM support DB2 version 5 and TSM API version 4.2. In any case TSM 4.2 can work with API 4.1.3. Then you need to uninstall the api and install the former version. Fran --- Zoltan Forray/AC/VCU [EMAIL PROTECTED] wrote: My AIX person wanted me to pass on the following error messages. We started getting these when we upgraded the client to 4.2.0 from 4.1.3 (this was done to resolve some other issue. Not sure what !). Any one see this one or have a clue what to do ? Did not see anything in the readme's about an xlC issue ? *** Client environment: AIX 4.3.3 TSM 4.2.0 DB2 5.2.0.50 xlC.aix43.rte 4.0.2.1 In db2diag.log: 2001-09-02-07.00.25.338591 Instance:db2padm Node:000 PID:36380(db2med.54700.0) Appid:none database_utilitiessqluMCInitBackupMC Probe:385 Media Controller -- sqluInitVendorDevice() ! vendor device initialization error 2001-09-02-07.00.25.449152 Instance:db2padm Node:000 PID:54700(db2agent (DB2PDWAR)) Appid:*LOCAL.db2padm.010902110017 database_utilitiessqlubMWResponse Probe:10 Database:DB2PDWAR DiagData f7e9 wi 2001-09-02-07.00.28.081967 Instance:db2padm Node:000 PID:54700(db2agent (DB2PDWAR)) Appid:*LOCAL.db2padm.010902110017 database_utilitiessqlubcka Probe:0 Database:DB2PDWAR Backup terminated. $ db2adutl exec(): 0509-036 Cannot load program db2adutl because of the following errors: 0509-022 Cannot load module /usr/lib/libApiDS.a(dsmapish.o). 0509-150 Dependent module /usr/lpp/db2_05_00/.rtelib/libC.a(shr2.o) could not be loaded. 0509-152 Member shr2.o is not found in archive === Zoltan Forray Virginia Commonwealth University University Computing Center e-mail: [EMAIL PROTECTED] voice: 804-828-4807 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com
Expire invetory doesn't work for DB2 backup set
I do manually backup on db2/6000 db whit command db2 backup db CITY use adsm. I do inactive the backup copy whit the command db2adutl delete, but when I do expire inventory the process doesn't cure of this and doesn't discard data on my Cassette. Why Davide Fanizzo Network and System Administrator Banca Akros S.p.A. tel +390243444040 mob +393488705668
db2 backup to tsm fails
Managed to fix the problem. We initially installed this system at TSM client API 4.1.2. However we were advised to backlevel to a previous version of the API. Apparently 4.1.2 was known not to work. We thought we had correctly deinstalled the TSM client but a file c:\winnt\system32\adsmv3.dll was left lying around. When we installed an earlier version of the TSM API this DLL did not get overwritten. Even though the whole client was at 4.1.0, just this one file was at 4.1.2. We manually deleted this file and reinstalled the TSM client. DB2 backups now working!!! Richard. Richard Bates Storage Specialist ITS - SB - Enterprise Consultancy Services == Voice : +44 (0) 1926 462298 (Hicom : 662298) IBM Mobile: +44 (0)775 386 8289 (Mobex : 270798) [EMAIL PROTECTED] -- Forwarded by Richard Bates/UK/IBM on 22-02-2001 22:07 --- Richard Bates 22-02-2001 00:02 To: [EMAIL PROTECTED] cc: From: Richard Bates/UK/IBM@ibmgb Subject: db2 backup to tsm fails This is a DB2/TSM backup question (and I have appended to those newsgroups too). Someone out there must have got this working. We are a site running DB2 UDB v7 fixpack2 on NT v4 (service pack 5). We are also running TSM v4.1.1 (client and api) and v4.1.2 (server) on the same NT server. We are trying to achieve a backup from DB2 through the API to TSM. We have setup all the necessary DSMI_* NT system variables via control panel-- system. We then rebooted so that they would take effect. DSMI_CONFIG=c\:progra~1\tivoli\tsm\api\dsm.opt DSMI_DIR=c\:progra~1\tivoli\tsm\api DSMI_LOG=c\:progra~1\tivoli\tsm\api We have configured the dsm.opt so that "passwordaccess generate" is specified. Therefore we have not configured the db2 variables TSM_* on the database we are trying to backup. We have set the password (in the registry) with dsmapipw. A "db2adutl query" starts a session with the TSM server and returns no objects backed up (as expected). I don't think there is anything else we have missed out. When we start the "db2 backup db dbname use tsm" command we immediately get a Dr Watson message on db2syscs.exe. A backup session does not start with the TSM server. Has anyone seen this before? We have tried all sorts of TSM clients with no joy. This is currently with the DB2 developers in Toronto. Has anyone done this before on these specific versions? Richard Bates Storage Specialist ITS - SB - Enterprise Consultancy Services == Voice : +44 (0) 1926 462298 (Hicom : 662298) IBM Mobile: +44 (0)775 386 8289 (Mobex : 270798) [EMAIL PROTECTED]
db2 backup to tsm fails
This is a DB2/TSM backup question (and I have appended to those newsgroups too). Someone out there must have got this working. We are a site running DB2 UDB v7 fixpack2 on NT v4 (service pack 5). We are also running TSM v4.1.1 (client and api) and v4.1.2 (server) on the same NT server. We are trying to achieve a backup from DB2 through the API to TSM. We have setup all the necessary DSMI_* NT system variables via control panel-- system. We then rebooted so that they would take effect. DSMI_CONFIG=c\:progra~1\tivoli\tsm\api\dsm.opt DSMI_DIR=c\:progra~1\tivoli\tsm\api DSMI_LOG=c\:progra~1\tivoli\tsm\api We have configured the dsm.opt so that "passwordaccess generate" is specified. Therefore we have not configured the db2 variables TSM_* on the database we are trying to backup. We have set the password (in the registry) with dsmapipw. A "db2adutl query" starts a session with the TSM server and returns no objects backed up (as expected). I don't think there is anything else we have missed out. When we start the "db2 backup db dbname use tsm" command we immediately get a Dr Watson message on db2syscs.exe. A backup session does not start with the TSM server. Has anyone seen this before? We have tried all sorts of TSM clients with no joy. This is currently with the DB2 developers in Toronto. Has anyone done this before on these specific versions? Richard Bates Storage Specialist ITS - SB - Enterprise Consultancy Services == Voice : +44 (0) 1926 462298 (Hicom : 662298) IBM Mobile: +44 (0)775 386 8289 (Mobex : 270798) [EMAIL PROTECTED]
what is the size and transfer rate of DB2 backup?
Hello all, The DB2 and ESSBASE backups are initiated at the client. I can not find a way of getting the same type of backup information (size, transfer rate) that is easily available for JFS backups that are initiated by the TSM scheduler. Does anyone know where this information can be obtained? Is there an SQL query that may have it? Matt
Re: inclexcl list for DB2 backup
On Tue, Jul 25, 2000 at 12:43:46PM +0800, Eric Tang wrote: I have config db2 backup by ADSM. In order to exclude db2 files from filesystem incremental backup, how can I get the list of directories/files to be coded in the exclude list. Eric, you did not mention the operating system etc. things we always like to know.. Neway. On *ix systems the database default location in the db2 instance's home directory, under instnce name. So if the instance is the default db2inst1, then it would be at /home/db2inst1/db2inst1. _But_ this is the default. The admin always can create the db on another path.. On non *ix systems generaly you put the db on a separate partiton. You should search for a directory like SQLDBDIR. For the logs it's easier. You can query the path by db2 list db cfg for yourdb | grep log Still the best to contact your DBA. -- bx "Using vim will surely improve ones computer skills."