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 >