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.com<mailto:sstackw...@icfi.com> | > > > > icfi.com<http://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 > > > >
