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 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 > > > >
