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